Listing Agent: Milly Barros, EQUITY FIRST REAL ESTATE
Experience the perfect blend of accessibility and seclusion. INCOME PRODUCING rare Working Ranch is ideally positioned on a main road for easy access, yet feels worlds away with its private, creek-adjacent boundary and canopy of mature trees. The interior offering modern elegance, upgraded kitchen with granite counters tops , bright open living space with vaulted ceilings, with two oversized bedrooms. Wake up to panoramic vistas of Mount Diablo and the rolling countryside. Designed for the multi-faceted lifestyle, the property is fully horse-zoned with stalls, a detached barn featuring bonus space, and a dedicated separate lot-perfect for a contractor's yard or extensive storage. This isn't just a house; it's your private sanctuary.
Property Sub Type
Single Family Residence
Year Built
1984
Levels
One
Price Per Square Foot
$764
Days On London
12
Cumulative Days On London
12
County Or Parish
Contra Costa
New Construction Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Marsh Creek Rd Cross Street: hwy 4.
Architectural Style
Ranch
Room Type
Bonus Room
Heating
Forced Air, Space Heater
Roof
Shingle
Construction Materials
Vinyl Siding
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Eating Area
Breakfast Counter / Bar
Appliances Y/N
Yes
Flooring
Vinyl, Carpet
Fireplace Y/N
Yes
Fireplace Features
Living Room
Pool Features
None
Pool Private Y/N
No
Patio Y/N
Yes
Parking Y/N
No
Parking Features
None, Other
Attached Garage Y/N
No
Lot Features
Level with Street, Horse Property, Back Yard
Lot Size Area
88470.0000
Lot Size Units
Square Feet
Parcel Number
0071400360
Subdivision Name
BRENTWOOD
Subdivision Name Other
BRENTWOOD
Association Y/N
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1045000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1155000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1190 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1690 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` = 1709840 OR `props-main`.`id` = 1708329 OR `props-main`.`id` = 1708372 OR `props-main`.`id` = 1707997 OR `props-main`.`id` = 1709739 OR `props-main`.`id` = 1708066 OR `props-main`.`id` = 1705772 OR `props-main`.`id` = 1705785 OR `props-main`.`id` = 1705788 OR `props-main`.`id` = 1710125 OR `props-main`.`id` = 1708445 OR `props-main`.`id` = 1711177 OR `props-main`.`id` = 1706102 OR `props-main`.`id` = 1705765 OR `props-main`.`id` = 1709902 OR `props-main`.`id` = 1705781 OR `props-main`.`id` = 1705947 OR `props-main`.`id` = 1706055 OR `props-main`.`id` = 1707133 OR `props-main`.`id` = 1711327 OR `props-main`.`id` = 1709441 OR `props-main`.`id` = 1711155)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls41124012' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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.
