This is beautiful country living! Here is your chance to own three properties on almost 40 acres of gorgeous land! Enjoy breathtaking sunrise and sunset views from the deck and an Executive's view of the lay of the land. You will come through a gate, and travel the beautiful path, to the main home, which is perfectly placed to see down the nice country road, seasonal pond, and any incoming visitors. It is 1942 sq. ft. and has 2 bed/2 bath possibly 3rd bedroom, large great room with vaulted ceilings, a large size barn and 2 wells. The second property is approx. 1600 sq.ft. 3 bed/2 bath manufactured home with a large open floor plan and huge kitchen! There is a 3rd mobile on the property and storage as well. This property has everything your family could ask for, and is ready for you to fix it up as you please. There is a very large safe also included. Perfect multi-generational property to share with your family, this is the dream! A rare find this close to Fresno, do not miss out on this hidden gem. Please contact city of Madera to verify zoning and highest best use of this property/land. Call to schedule your visit today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1991
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$281
Price Per Acre
$25,254
Days On London
0
Cumulative Days On London
0
County
Madera
Leased Equipment
Propane
Special Features
Horses Allowed
REO / Bank Owned
No
Cross Street Address
Rd 406
Directions
Going North on Hwy 41, left on RD 209, In 5 miles turn left on Rd 406, then left on Oakwood Rd. Address on gate.
Style
Ranch
Heating & Cooling
Evaporative Cool, Floor or Wall Unit
Laundry
Inside
Roofing
Composition
Foundation
Both
Detached Structures
Barn, Other/See Remarks
Kitchen
Gas Appliances, Dishwasher
Primary Bedroom Level
Main
Bath Features
Shower
Extra Rooms
Great Room
# of Fireplaces
1
Exterior
Wood
Pool
No
Pool
No
Patio Features
Covered, Uncovered
Gas & Electric
Propane
Sewer / Water
Private Well
Solar
No
Are there garage spaces?
No
APN
050 280 004 000
Zoning
ARF
Association / Park Amenities
Lake/Pond
School District
Chawanakee
School Type 1
High School
School Name 1
Minarets
School Type 2
Junior High School
School Name 2
Spring Valley
School Type 3
Grade School
School Name 3
Spring Valley
Seller Will Consider
Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 945250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1044750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '6' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3292 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3792 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` = 1756551 OR `props-main`.`id` = 1754608)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno653063' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-02' 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 16 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.
