Please provide the following information and Edgar Gomez will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/agent/16820/edgar-gomez/property/link/fresno/638717/28755-Burrough-Valley-Rd/Tollhouse/https://www.londonproperties.com/images/props/fresno/full/638717.jpgLondon Properties Tollhouse Real Estate | 28755 Burrough Valley Rd
Nestled in the serene foothills of Tollhouse, this beautiful 3-bedroom, 2-bathroom home is a horse lovers dream offering a perfect blend of comfort, style, and functionality for both you and your horses. The property boasts stunning panoramic views of the surrounding countryside, creating a tranquil escape from the hustle and bustle of everyday life. Enjoy three generously sized bedrooms, providing plenty of space for relaxation and comfort. The heart of the home is the kitchen featuring sleek granite countertops, modern cabinetry, and top-of-the-line appliancesideal for preparing delicious meals for family and friends. The property is fully equipped for equestrian enthusiasts, featuring a barn and a solar-lit horse arena. Whether you're riding at dawn or dusk, you'll always have the perfect lighting for training or leisure riding. The peaceful surroundings and quiet atmosphere offer the ideal setting for anyone looking to live the country dream.This property is truly a rare gem, combining modern comforts with country charm, and is perfect for those who want to live the equestrian lifestyle without compromising on style or convenience. Don't miss the chance to make this stunning property your forever home!
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 441750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 488250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1250 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1750 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` = 1690549 OR `props-main`.`id` = 1686926 OR `props-main`.`id` = 1686923 OR `props-main`.`id` = 1687998 OR `props-main`.`id` = 1695629 OR `props-main`.`id` = 1693894 OR `props-main`.`id` = 1678945 OR `props-main`.`id` = 1647271 OR `props-main`.`id` = 1647365 OR `props-main`.`id` = 1690482 OR `props-main`.`id` = 1680337 OR `props-main`.`id` = 1684054 OR `props-main`.`id` = 1697184 OR `props-main`.`id` = 1678078 OR `props-main`.`id` = 1684057 OR `props-main`.`id` = 1635069 OR `props-main`.`id` = 1685601 OR `props-main`.`id` = 1665998 OR `props-main`.`id` = 1689511)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno638717' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-11' 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 Sarah Clark, Real Broker - [email protected] Last modified 1 month ago Fresno MLS last checked for updates 50 minutes ago
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.
