Step into your own private paradise through a secure, automatic gate and discover a 4,843 sq. ft. home showcasing breathtaking views of the surrounding countryside. A gated courtyard with a charming fountain sets the tone for the elegance within. Enter through grand arched double doors into a spacious family room featuring soaring ceilings, a cozy fireplace, and an accordion-style door that seamlessly blends indoor and outdoor living.This stunning residence offers 4 generously sized bedrooms, each with its own en-suite bathroom, plus 2 additional half baths. A dedicated office and a versatile bonus room provide flexible space for both work and leisure. Upstairs, you'll find 2 guest bedrooms, a half bath, and another bonus roomeach with private balconies to enjoy the views.Step outside to your own personal oasis, complete with a sparkling pool, relaxing hot tub, and an expansive deck perfect for soaking in the scenery. Additional features include owned solar, a 4-car garage, a tile roof, and full fencing for added privacy and security. This home blends timeless style with modern comfort.This home includes the adjacent parcel of 10.17 acres in the sale for a total of over 20 acres combined in the 2 APNs.Don't miss the chance to make this extraordinary property your own.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2017
Region
Rural
# of Stories
Two
Price Per Square Foot
$506
Price Per Acre
$120,039
Days On London
152
Cumulative Days On London
409
County
Fresno
Special Features
Isolated Bedroom, Isolated Bathroom, Security Gate, Built In Cabinets, Wet/Dry Bar, Horses Allowed
REO / Bank Owned
No
Cross Street Address
Auberry / Millerton
Directions
From Auberry Road and Millerton Road, head east on Millerton Road. Turn right onto Rusty Spur Lane. Continue through the first white gate and follow the road up the hill. At the top, you'll reach a second electric gate proceed to top.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 2327500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 2572500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '6' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 4593 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 5093 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` = 1701917 OR `props-main`.`id` = 1718387)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno641892' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-09' 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
Last modified 5 months ago Fresno MLS last checked for updates 31 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.
