Listing Agent: Carolyn Young, Christie's Intl RE Sereno
55+ Resort Style Living in Trilogy. Peaceful Portico Entrance to Garden Area. Light & Bright With Neutral Colors, Extensive Large Tile Floors & Wood Floor in Office/Den. Large Great Room with Plenty of Space for Your Furniture & a Large TV Hung on the Wall. Spacious Kitchen w/Quartz Counters & Full Tile Backsplash, 2 Walk-in Pantries & a Very Spacious Island. Lots of Storage in This Home. Formal Dining Room Overlooking the Backyard with Space for a Large Table & Buffet. Plenty of Room in the Primary Bedroom Overlooking the Backyard, Dual Sink Areas & Dual Walk-in Closets in the Bathroom. Guest Suite w/Bathroom. Closet with a Deeper Area for Storage. Laundry Room has Washer/Dryer, Upper/Lower Cabinets. Whole House Fan. Gorgeous Clubhouse, Cafe, Event Center, Indoor & Outdoor Pools, Spa & Gym Building, Off-Site & On-Site Activities and soooo much more
Property Sub Type
Single Family Residence
Year Built
2017
Levels
One
Price Per Square Foot
$450
Days On London
0
Cumulative Days On London
0
County Or Parish
Contra Costa
New Construction Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Cross Street: Zinfandel.
Builder Name
Shea
Architectural Style
Spanish
Builder Model
Mistelle
Room Type
Office
Heating
Natural Gas, Forced Air, Solar
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Washer Included, Dryer Included
Roof
Tile
Construction Materials
Stucco
Foundation Details
Slab
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Bathrooms Half
1
Room Kitchen Features
Kitchen Island, Butler's Pantry
Appliances Y/N
Yes
Appliances
Water Softener
Room Bathroom Features
Shower in Tub
Accessibility Features
None
Flooring
Tile, Carpet
Fireplace Y/N
No
Fireplace Features
None
Pool Features
None
Pool Private Y/N
No
Patio Y/N
Yes
Patio And Porch Features
Patio
Parking Y/N
Yes
Parking Total
3.00
Parking Features
Garage, Garage Door Opener
Attached Garage Y/N
Yes
Garage Spaces
3.00
Lot Features
Level with Street, Sprinklers Timer, Front Yard, Back Yard, Yard
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 878750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 971250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1804 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2304 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` = 1737401 OR `props-main`.`id` = 1737407 OR `props-main`.`id` = 1737402 OR `props-main`.`id` = 1720836 OR `props-main`.`id` = 1724743 OR `props-main`.`id` = 1713646 OR `props-main`.`id` = 1746169 OR `props-main`.`id` = 1742207 OR `props-main`.`id` = 1705772 OR `props-main`.`id` = 1722963 OR `props-main`.`id` = 1727863 OR `props-main`.`id` = 1741702 OR `props-main`.`id` = 1730228 OR `props-main`.`id` = 1749529 OR `props-main`.`id` = 1729448 OR `props-main`.`id` = 1710125 OR `props-main`.`id` = 1709940 OR `props-main`.`id` = 1727137 OR `props-main`.`id` = 1728470 OR `props-main`.`id` = 1748169 OR `props-main`.`id` = 1739179 OR `props-main`.`id` = 1736887 OR `props-main`.`id` = 1724479 OR `props-main`.`id` = 1749042 OR `props-main`.`id` = 1705803 OR `props-main`.`id` = 1728216 OR `props-main`.`id` = 1747802 OR `props-main`.`id` = 1734787 OR `props-main`.`id` = 1726090 OR `props-main`.`id` = 1742858 OR `props-main`.`id` = 1717483 OR `props-main`.`id` = 1749527 OR `props-main`.`id` = 1739368 OR `props-main`.`id` = 1746076 OR `props-main`.`id` = 1746075 OR `props-main`.`id` = 1721213 OR `props-main`.`id` = 1748759 OR `props-main`.`id` = 1741507 OR `props-main`.`id` = 1739069 OR `props-main`.`id` = 1721361 OR `props-main`.`id` = 1742276 OR `props-main`.`id` = 1735457 OR `props-main`.`id` = 1737360 OR `props-main`.`id` = 1724312 OR `props-main`.`id` = 1744690 OR `props-main`.`id` = 1725948 OR `props-main`.`id` = 1745453 OR `props-main`.`id` = 1743993 OR `props-main`.`id` = 1724155 OR `props-main`.`id` = 1744615 OR `props-main`.`id` = 1745565 OR `props-main`.`id` = 1720426 OR `props-main`.`id` = 1721629 OR `props-main`.`id` = 1733172 OR `props-main`.`id` = 1732236 OR `props-main`.`id` = 1742380 OR `props-main`.`id` = 1747349 OR `props-main`.`id` = 1748338 OR `props-main`.`id` = 1747407 OR `props-main`.`id` = 1742859)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls41141668' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-15' 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();
1
Similar Properties
$885,000
2
3
2,042
0.16
1512 Miwok Ct
Brentwood (CC), CA 94513
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.
