Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/fresno/641842/51410-Wildmint-Ln/Yokuts-Valley/https://www.londonproperties.com/images/props/fresno/full/641842.jpgLondon Properties Yokuts Valley Real Estate | 51410 Wildmint Ln
Custom Mountain Retreat in Upper Squaw Valley - Peaceful Living on Usable Acreage
Welcome to your serene escape in upper Squaw Valley! This beautifully crafted custom home offers the perfect blend of comfort and natural beauty, featuring 3 spacious bedrooms, 2 full bathrooms, and a charming loft ideal for a home office, reading nook, or creative space.
Situated on just under 5 fully usable acres, this property is a nature lover's dream. Relax on the covered front porch as you take in the peaceful sounds of birdsong or spot deer wandering through the trees. Mature landscaping, low-maintenance flower beds, and a lovely vineyard create a truly tranquil setting.
Enjoy the convenience of three versatile outbuildingsperfect for storing equipment, toys, or creating your own hobby or workshop space. With mild snowfall in the winter and cool summer breezes, this is year-round comfort at its finest.
Don't miss your chance to own this one-of-a-kind mountain havencome experience it for yourself!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1996
Region
Foothill
# of Stories
Two
Price Per Square Foot
$259
Price Per Acre
$85,065
Days On Market
3
Cumulative Days On Market
599
County
Fresno
Leased Equipment
Propane
Special Features
Skylight, Horses Allowed
REO / Bank Owned
No
Cross Street Address
Greenhill
Directions
Highway 180 to Dunlap Rd, Dunlap Rd to Sundew Rd, left on Chuckwagon to Sesame Lane, follow Sesame which turns into Wildmint, to property on the right.
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Detached Structures
Shed
Kitchen
F/S Range/Oven, Gas Appliances, Disposal, Dishwasher
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 373350 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 412650 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1268 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1768 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` = 1680050 OR `props-main`.`id` = 1701726 OR `props-main`.`id` = 1689726 OR `props-main`.`id` = 1683784 OR `props-main`.`id` = 1701396 OR `props-main`.`id` = 1701375 OR `props-main`.`id` = 1701481 OR `props-main`.`id` = 1701189 OR `props-main`.`id` = 1685946 OR `props-main`.`id` = 1690268 OR `props-main`.`id` = 1690259 OR `props-main`.`id` = 1690256 OR `props-main`.`id` = 1684129 OR `props-main`.`id` = 1691450 OR `props-main`.`id` = 1691455 OR `props-main`.`id` = 1691456)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno641842' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-08' 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 Cheyenne Mullins, Prospect Realty - [email protected] Last modified 1 day ago Fresno MLS last checked for updates 12 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.
