Stunning 3.28-acre estate in the desirable Del Rio Country Club neighborhood with a chic, updated Spanish-style 4-bedroom, 3-bathroom home. Beautifully upgraded residence with designer finishes throughout and a completed basement. This expansive property also includes a horse and equestrian area featuring dedicated horse stalls, a specialized tack room, and a convenient wash station. The 3.28-acre lot provides optimal privacy while also offering the benefits of the Del Rio community. Updated in 2022 with gorgeous stone, European reclaimed wood floors, and a designer kitchen featuring Sub-Zero and Wolf appliances. New HVAC and roof. A beautiful, lush yard features a large, durable PebbleTec swimming pool and spa, complete with a luxurious waterfall. The Grover-installed landscape creates a serene, oasis-like atmosphere with ample space for entertaining and gardening. Do not miss the 8-car garage with abundant storage. Main level: 3,140 sq. ft., finished basement: 308 sq. ft. A must-see!
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 2090000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 2310000 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) >= 3198 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3698 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` = 1722394 OR `props-main`.`id` = 1714506 OR `props-main`.`id` = 1715566 OR `props-main`.`id` = 1723008 OR `props-main`.`id` = 1713376 OR `props-main`.`id` = 1717260 OR `props-main`.`id` = 1690230)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226028297' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-22' 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 Shari Arakelian, PMZ Real Estate 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.
