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/642182/45483-Sand-Creek-Rd/Yokuts-Valley/https://www.londonproperties.com/images/props/fresno/full/642182.jpgLondon Properties Yokuts Valley Real Estate | 45483 Sand Creek Rd
Ultra-private custom ranch estate on 50 acres. This totally secluded 50 acre estate is highlighted by a 3727sf plantation style designer home centered on the property and overlooking a private pond. This property is the epitome of privacy. From the road, you have a security gated entrance and a 900 foot paved drive through a park-like setting to the home. On the way you pass by the 4 stall horse barn and a unique climbing wall. This one of a kind home features custom wrap around covered redwood decks that overlook the pond which is fed by a solar well pump and the outdoor entertainment center with double BBQ's, a gorgeous pavillion, and a massive inlaid tile patio. In back you have a covered patio with a gorgeous free form pool and glass block outdoor shower.The home is oustanding. off the entry is a sitting parlor with fireplace and then on to the stepdown living room with a corner rock fireplace, full wall theater, exit to the back yard, and step up access to the gourmet country kitchen. The kitchen is amazing with a center island cooktop and food prep center w/ vegetable sink, built-in oven and microwave, and Sub-Zero wood faced refrigrator/freezer. There is a large breakfast bar and direct pass thrus to the living room and the formal dining room plus a huge pantry. Finally, you have the kitchen dining area with access to the deck, the pool. and the garage. The home has a tasteful design with a hall leading to a office/study room, beautiful guest bath and then 2 bedrooms with Jack n Jill -bath, large builtin linen and storage cabinents, laundry and linen center, and the primary suite. The huge primary suite has a corner fireplace and access to the pool plus a primary bath with spa tub, walk in shower, and large wardrobe. Adjacent to the master is a separate office with access to the deck.The land is amazing with roads and trails throughout. There is a wide variety of terrain and all in a parklike setting with a great mixture of mature trees, meadows, hills, rock formations, views, and more. And, this place is oh so private. Most people on the mountain don't even know it's here.The entire property is fenced and crossfenced. The well is 35gpm with 10,000 gallons of w/elevate storage tanks for gravity flow.This is truly a country estate. A lot has been done to insure your comfort, but it is ready for you to add your own personality to it. Showings are by appointment to buyers who have shown capacity to purchase. This property isn't perfect but it's close.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1996
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$341
Price Per Acre
$25,109
Days On London
143
Cumulative Days On London
143
County
Fresno
Special Features
Isolated Bedroom, Security System, Security Gate, Built In Cabinets, Central Vac, Wet/Dry Bar, Other/See Remarks, Horses Allowed, Horse Setup
REO / Bank Owned
No
Cross Street Address
Chuckwagon
Directions
Hwy 180 to Dunlap road, east to Ruth Hill, south Sands Baker, south to Sand Creek, then west 1/2 mile to property (no sign).
Unit Description
Ground Floor, Second Floor
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Utility Room, Gas Hook Up, Electric Hook Up
Roofing
Composition
Foundation
Wood Subfloor
Detached Structures
Barn, Other/See Remarks
Kitchen
Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Breakfast Bar, Pantry, Refrigerator, Other
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1206500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1333500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3477 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3977 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` = 1707939 OR `props-main`.`id` = 1707944 OR `props-main`.`id` = 1707955 OR `props-main`.`id` = 1708397 OR `props-main`.`id` = 1668487 OR `props-main`.`id` = 1732521 OR `props-main`.`id` = 1732494 OR `props-main`.`id` = 1732469 OR `props-main`.`id` = 1729397 OR `props-main`.`id` = 1718930 OR `props-main`.`id` = 1690268 OR `props-main`.`id` = 1719978 OR `props-main`.`id` = 1690256 OR `props-main`.`id` = 1719203 OR `props-main`.`id` = 1702883 OR `props-main`.`id` = 1702274 OR `props-main`.`id` = 1665869 OR `props-main`.`id` = 1719898 OR `props-main`.`id` = 1720642)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno642182' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-05' 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 4 months ago Fresno MLS last checked for updates 48 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.