This almost one acre property has been in the same family since it was custom built in 1988. Please see descriptions with each picture for more information. Listing agent is related to seller.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Custom, Detached
Year Built
1988
Year Built Source
Assessor Agent-Fill
Remodeled/Updated
Yes
Remodeled/Updated Desc
Other-Rmks 0-5YR
Stories
1
Levels
One
Home Warranty
No
Directions to Property
Franklin to Lobo to B&B Blvd.
Cross Street
Lobo
County
Merced
Special Listing Conditions
Offer As Is
Main Level
Bedroom(s), Living Room, Dining Room, Primary Bedroom, Full Bath(s), Garage, Kitchen
Architectural Style
Contemporary
Construction Materials
Stucco, Wood
Foundation
Raised
Roof
Composition
Heating
Central, Fireplace(s)
Cooling
Ceiling Fan(s), Central
Laundry Features
Cabinets, Sink, Electric, Gas Hook-Up, Inside Room
Other Structures
Workshop
Interior Features
Cathedral Ceiling
Full Bathrooms
3
Bath Features
Double Sinks, Jetted Tub
Possible Bedrooms
5
# of Fireplaces
1
Fireplace Features
Brick, Living Room, Raised Hearth, Stone
Flooring
Carpet, Laminate, Tile, Wood
Appliances
Gas Cook Top, Dishwasher, Microwave
Kitchen Features
Ceramic Counter, Pantry Closet, Tile Counter
Dining Room Features
Formal Area
Living Room Features
Open Beam Ceiling
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Cable Connected, Sewer Connected, Electric, Natural Gas Available
Electric
220 Volts,220 Volts in Laundry
Irrigation
None
Water Source
Storage Tank, Well
Sewer
Septic System
Parking Features
24'+ Deep Garage,Attached,RV Garage Detached,Detached,RV Storage,Garage Door Opener,Uncovered Parking Spaces 2+,Workshop in Garage
Garage Spaces
2.00
Lot Features
Auto Sprinkler F&R, Corner
APN
056 450 028 000
Land Use
Livestock
Topography
Level
Driveway/Sidewalks
Paved Driveway
Fencing
Back Yard, Fenced
Horse Property
No
Zoning Description
AG1
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Merced
Elementary School District
Merced City
Middle or Junior School District
Merced City
Senior High School District
Merced Union High
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 664999.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 734998.95 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2071 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2571 AND ((`props-main`.`PropertyType` = 'Residential' AND (
`props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR
`props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR
`props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR
`props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR
`props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR
`props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR
`props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1696651 OR `props-main`.`id` = 1700752 OR `props-main`.`id` = 1689315 OR `props-main`.`id` = 1701066 OR `props-main`.`id` = 1695615 OR `props-main`.`id` = 1642555 OR `props-main`.`id` = 1688095 OR `props-main`.`id` = 1680215 OR `props-main`.`id` = 1693749 OR `props-main`.`id` = 1693818 OR `props-main`.`id` = 1646767 OR `props-main`.`id` = 1700256 OR `props-main`.`id` = 302141 OR `props-main`.`id` = 1697488 OR `props-main`.`id` = 1698910 OR `props-main`.`id` = 1697930 OR `props-main`.`id` = 1690931 OR `props-main`.`id` = 1064604 OR `props-main`.`id` = 342849 OR `props-main`.`id` = 1693840 OR `props-main`.`id` = 1696012 OR `props-main`.`id` = 1695048 OR `props-main`.`id` = 1700779 OR `props-main`.`id` = 1698404 OR `props-main`.`id` = 1690469 OR `props-main`.`id` = 1700654 OR `props-main`.`id` = 1690474)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225151728' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-04' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();
0
Courtesy of Les Azevedo, Powerhouse Realty IDX provided by Reliance Marketing
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.
