Please provide the following information and Salvador Garcia will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/agent/994/salvador-garcia/property/link/crmls/MC26083364/4240-Los-Olivos-Rd/Merced/https://www.londonproperties.com/images/props/crmls/full/MC26083364.jpgLondon Properties Merced Real Estate | 4240 Los Olivos Rd
Listing Agent: Kelly Pirtle, Century 21 Select Real Estate
Property is zoned for an easy 4-lot minor subdivision and goes through to Lake Rd. Perk tests are complete for septic. The home has a steel-and-wood frame with adobe block walls. One of the best locations in North Merced. Near UC. Approx 8.3 acres. 4 Bed 2 Bath 2561 sq ft home with a fully finished barn. Beautiful views of the Sierras. Luxury lot on the top of the hill is 2.27 acres approx. Pre-opened with Peg from Transcounty Title
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
1970
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
1
Levels
One
Number Of Units Total
1
Entry Level
1
Price Per Square Foot
$625
Days On London
15
Cumulative Days On London
15
County Or Parish
Merced
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Old Lake Road North, L on Cardella, Right on Los Olivos, Property on Right
Room Type
All Bedrooms Down
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Inside
Main Level Bedrooms
1
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Main Level Bathrooms
1
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Wood Burning, Wood Stove Insert
Pool Features
None
Pool Private Y/N
No
Water Source
Well
Sewer
Septic Type Unknown
Lot Features
6-10 Units/Acre
Lot Size Area
8.3000
Lot Size Units
Acres
View Y/N
Yes
View
Pasture, Mountain(s)
Common Interest
None
Parcel Number
060550011
Additional Parcels Y/N
No
Community Features
Urban
Senior Community Y/N
No
Association Y/N
No
High School District
Merced Union
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
None
72876
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1520000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1680000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2311 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2811 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` = 1724003 OR `props-main`.`id` = 1719717 OR `props-main`.`id` = 1719713 OR `props-main`.`id` = 1719725 OR `props-main`.`id` = 1637274 OR `props-main`.`id` = 1724333 OR `props-main`.`id` = 1724346 OR `props-main`.`id` = 1724452 OR `props-main`.`id` = 1704062 OR `props-main`.`id` = 1704601 OR `props-main`.`id` = 1716896 OR `props-main`.`id` = 1704063 OR `props-main`.`id` = 1710028 OR `props-main`.`id` = 1723563 OR `props-main`.`id` = 223289 OR `props-main`.`id` = 223288 OR `props-main`.`id` = 1715974 OR `props-main`.`id` = 1713681 OR `props-main`.`id` = 1716480 OR `props-main`.`id` = 1717378 OR `props-main`.`id` = 1721015 OR `props-main`.`id` = 1717151 OR `props-main`.`id` = 1722496 OR `props-main`.`id` = 1723191 OR `props-main`.`id` = 1723466 OR `props-main`.`id` = 1711272 OR `props-main`.`id` = 1724169 OR `props-main`.`id` = 1724945 OR `props-main`.`id` = 1715840 OR `props-main`.`id` = 1723538 OR `props-main`.`id` = 1723528 OR `props-main`.`id` = 1723533 OR `props-main`.`id` = 1721643 OR `props-main`.`id` = 206435 OR `props-main`.`id` = 1714091 OR `props-main`.`id` = 1723262 OR `props-main`.`id` = 1714581 OR `props-main`.`id` = 1721536 OR `props-main`.`id` = 1695702 OR `props-main`.`id` = 1695723 OR `props-main`.`id` = 360956 OR `props-main`.`id` = 1713342 OR `props-main`.`id` = 1717761 OR `props-main`.`id` = 1718112 OR `props-main`.`id` = 1706672 OR `props-main`.`id` = 1706679 OR `props-main`.`id` = 1721101 OR `props-main`.`id` = 1721326 OR `props-main`.`id` = 1713511 OR `props-main`.`id` = 1700902 OR `props-main`.`id` = 1700897 OR `props-main`.`id` = 1718096 OR `props-main`.`id` = 1716949 OR `props-main`.`id` = 1704849 OR `props-main`.`id` = 1705936 OR `props-main`.`id` = 1722386 OR `props-main`.`id` = 1723192 OR `props-main`.`id` = 1717610)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC26083364' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-03' 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
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.