This is a remarkable home that has a large open living area, high vaulted ceilings, 10 ft walls throughout, hand trowled cement floors, plenty of windows to enjoy the views of mountains and on the other side look enjoy looking out to the beautiful 10 x 45 infinity swimming pool and waterfall with the peace and serenity of natural beauty behind it. The kitchen is filled with beautiful tall cabinetry and plenty of counter space you're sure to adore. Large primary bedroom with walk-in closet and a primary bath with huge walk-in shower.. You can enjoy the pool and outdoors with all the extensive amount of concrete and massive covered porch perfect for entertaining and or relaxation. ( wired for speakers and fans ) The almost 6 acres of all useable land is like a park with small pole barn, dog kennels and several outbuildings. If gardening is in your future there is extensive plumbing around the grounds. The garage has lots of cabinets to store your goodies and get organized. The owner has maintained and prepared for move in ready for the new owner to call this home with freshly painted interior and exterior , new garage door and opener , and more !
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1999
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$296
Price Per Acre
$107,895
Days On Market
117
Cumulative Days On Market
117
County
Fresno
REO / Bank Owned
No
Cross Street Address
spreading oak/Frazier
Directions
Follow directions with your mapping app ....From Auberry Rd turn onto Frazier Rd, go approx .06 of a mile and turn right onto Spreading Oak, go approx .09 of a mile and turn left and property is on the left
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 584250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 645750 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) >= 1828 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2328 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` = 1694108 OR `props-main`.`id` = 1694113 OR `props-main`.`id` = 1676484 OR `props-main`.`id` = 1679163 OR `props-main`.`id` = 1701193 OR `props-main`.`id` = 1695546 OR `props-main`.`id` = 1668160)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno629098' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-02' 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 Corinne Cook, Realty Concepts - Prather - [email protected] Last modified 2 hours ago Fresno MLS last checked for updates 11 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.
