Courtesy of John Bortz, Century 21 Ditton Realty - [email protected]
Beautifully Remodeled Dual-Residence Estate on 46+ AcresEnjoy this beautifully remodeled property featuring a 1-bedroom, 1-bath main home with granite kitchen countertops and a covered patio complete with an outdoor showerperfect for relaxing or entertaining under the open sky.A second dwelling offers an additional 1 bedroom, 1 bath, plus a loft, making it ideal for rental income, guest accommodations, or extended family living.The property is rich with improvements, including a large greenhouse, an orchard with drip irrigation, a garden area with mature berry plants, and a charming waterfall feeding a peaceful pondcreating a truly serene setting.Situated on 6.17 acres (APN: 055-023-040), this offering also includes an adjoining 40-acre parcel (APN: 055-043-001). This highly desirable acreage features rolling hills, breathtaking views, established roadways throughout, and an additional scenic pond.Additional highlights include:40' x 50' pole barnTwo Conex (shipping) containers with power Fully enclosed room with water accessideal for a workshop, studio, or storageBoth parcels are equipped with their own solar systems and battery backups, as well as separate wells, offering excellent off-grid or hybrid living potential
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1985
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$573
Price Per Acre
$15,326
Days On London
42
Cumulative Days On London
42
County
Madera
REO / Bank Owned
No
Cross Street Address
Highway 49
Directions
Highway 49 to Gold Chain Lane to first driveway on the left
Heating & Cooling
Ductless or Split
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Primary Bedroom Level
Main
Bath Features
Shower
Flooring
Laminate, Tile
# of Fireplaces
1
Exterior
Stucco
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Septic Tank, Private Well
Solar
Yes
Solar Type
Owned
Are there garage spaces?
No
APN
055 023 040 000
School District
Yosemite
School Type 1
High School
School Name 1
Yosemite
School Type 2
Junior High School
School Name 2
Wasuma
School Type 3
Grade School
School Name 3
Wasuma
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 669750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 740250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 980 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1480 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` = 1705902 OR `props-main`.`id` = 1705887 OR `props-main`.`id` = 1731459 OR `props-main`.`id` = 1726581 OR `props-main`.`id` = 1726566 OR `props-main`.`id` = 1723664 OR `props-main`.`id` = 1731635 OR `props-main`.`id` = 1723658 OR `props-main`.`id` = 1715530 OR `props-main`.`id` = 1731510 OR `props-main`.`id` = 1697446 OR `props-main`.`id` = 1731400 OR `props-main`.`id` = 1729079 OR `props-main`.`id` = 1729091 OR `props-main`.`id` = 1705691 OR `props-main`.`id` = 1706718 OR `props-main`.`id` = 1716004 OR `props-main`.`id` = 1714989 OR `props-main`.`id` = 1725485 OR `props-main`.`id` = 1728503 OR `props-main`.`id` = 1727923 OR `props-main`.`id` = 1666393 OR `props-main`.`id` = 1731684 OR `props-main`.`id` = 1725626 OR `props-main`.`id` = 1724382 OR `props-main`.`id` = 1724451 OR `props-main`.`id` = 968705 OR `props-main`.`id` = 1722667 OR `props-main`.`id` = 1731654 OR `props-main`.`id` = 1726012 OR `props-main`.`id` = 1726015 OR `props-main`.`id` = 1731685)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno648323' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-15' 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 days ago Fresno MLS last checked for updates 5 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.
