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/649683/39603-Road-810/Raymond/https://www.londonproperties.com/images/props/fresno/full/649683.jpgLondon Properties Raymond Real Estate | 39603 Road 810
Courtesy of Leonard Sharp, eXp Realty of California, Inc. - [email protected]
220 acres. 2022 home. 45 minutes to Yosemite. Williamson Act tax shelter. Three separate parcels totaling 220.89 acres, anchored by a 4-bed, 3-bath luxury home built in 2022 a rare Sierra Nevada retreat with scale, modern construction, and tax-sheltered land, within a Saturday drive of the Bay Area and a manageable drive from LA.The 2,458 sqft home offers high-end finishes throughout with zero deferred maintenance, built to current California fire-resistance standards. The oversized metal shop includes its own full bathroom and is pre-plumbed for ADU conversion strong future income potential.Solar system plus a backup generator deliver true off-grid capability. Miles of private hiking trails and large hot tub. Panoramic Sierra Nevada foothill views from every angle.The three-parcel structure is the strategic advantage: 86.06-acre improved parcel with house and shop, plus two adjoining vacant parcels at 72.81 and 62.02 acres. Hold all three, sell separately, or carve out a private compound across distinct building sites. Cattle grazing currently in place.Williamson Act contract conveys for ongoing tax shelter. STR requires Madera County review buyer to confirm compatibility, nonrenewal, or cancellation path (cancellation is discretionary entitlement).Suitable as a primary residence, mountain retreat, equestrian property, or phased development. 45 min to Yosemite's south gate; 2.5 hrs from Bay Area.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2022
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$671
Price Per Acre
$7,470
Days On London
31
Cumulative Days On London
31
County
Madera
Special Features
Isolated Bedroom, Security Gate, Built In Cabinets, Horses Allowed
REO / Bank Owned
No
Cross Street Address
Rd 600
Directions
Hwy 49 from Oakhurst, left on Rd 600, right on Rd 810, property on right
Unit Description
Ground Floor
Style
Contemporary
Heating & Cooling
Ductless or Split
Laundry
Inside, Utility Room
Roofing
Composition
Foundation
Concrete
Detached Structures
Shop
Kitchen
Built In Range/Oven, Gas Appliances, Electric Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry, Refrigerator
Dining Room Features
Living Room/Area
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower, Tub
Flooring
Other
# of Fireplaces
1
Fireplace Type
Gas Insert
Exterior
Other
Pool
No
Pool
No
Spa
Yes
Spa Type
Above Ground
Patio Features
Covered, Uncovered, Concrete
Gas & Electric
Public Utilities, Propane, Generator
Sewer / Water
Septic Tank, Private Well
Energy Efficiency
Dual Pane Windows, Tankless Water Heater
Solar
Yes
Solar Type
Owned, Owned Free and Clear
Parking Features
Potential RV Parking, Work/Shop Area
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
Site Amenities
Bluff View
APN
055 200 079 000
School District
Raymond Knowles
School Type 1
High School
School Name 1
Yosemite
School Type 2
Junior High School
School Name 2
Raymond Knowles
School Type 3
Grade School
School Name 3
Raymond Knowles
Seller Will Consider
Conventional, Cash
1st Loan Type
Non-Assumable
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1567500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1732500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2208 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2708 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` = 1725965 OR `props-main`.`id` = 1664559 OR `props-main`.`id` = 1666414 OR `props-main`.`id` = 1730680 OR `props-main`.`id` = 1685126)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno649683' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-30' 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 2 hours ago Fresno MLS last checked for updates 44 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.
