Turnkey Mountain Retreat Backing to Forest Land - ADU Potential! Location: Sierra Meadows community with 140 acres of meadows & 6 miles of hiking trails Privacy: Backs to BLM land - no neighbors or future construction behind you Home: 3,534 sq. ft. | 4 bedrooms + office | 3 bathrooms | Custom details throughout Living Spaces: Parlor, formal dining w/ tray ceiling, spacious living room w/ marble fireplace, large den w/ pool table, enclosed sunroom/patio w/ fire pit Kitchen: Expansive w/ eating area & butler's pantry Garages/Outbuildings: Attached 3-car garage + detached shop/boathouse w/ separate 5th room & porch (ideal ADU/guesthouse conversion!) Lot: 1.69 acres in a lush park-like setting, minutes to Oakhurst Updates: New roof (Oct. 2023) A rare blend of privacy, comfort, and opportunityschedule your showing today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1994
Region
Mountain
# of Stories
Two
Price Per Square Foot
$221
Price Per Acre
$461,420
Days On Market
504
Cumulative Days On Market
504
County
Madera
Leased Equipment
Propane
Special Features
Built In Cabinets, Skylight
REO / Bank Owned
No
Cross Street Address
Opah
Directions
49 to Harmony to Opah to Wallu
Heating & Cooling
Central Heat & Cool, Floor or Wall Unit
Laundry
Utility Room
Roofing
Composition
Foundation
Wood Subfloor
Detached Structures
Shop, Other/See Remarks
Kitchen
Built In Range/Oven, Gas Appliances, Dishwasher, Microwave, Trash Compactor, Eating Area, Pantry
Dining Room Features
Formal
Primary Bedroom Level
Upper
Flooring
Carpet, Laminate, Tile
# of Fireplaces
1
Fireplace Type
Gas Insert, Wood Insert
Exterior
Other
Pool
No
Pool
No
Spa
No
Patio Features
Enclosed, Wood Deck, Screened
Yard
Sprinklers Front, Sprinklers Back, Sprinklers Auto, Mature Landscape, Drip System
Gas & Electric
Public Utilities, Propane
Sewer / Water
Public Water, Septic Tank
Energy Efficiency
Dual Pane Windows, 13+ SEER A/C
Solar
No
Parking Features
Existing RV Parking, Work/Shop Area
Garage Type
Attached
Garage Spaces
4
Site Amenities
Other
APN
055 580 040 000
School District
Yosemite
School Type 1
High School
School Name 1
Yosemite
School Type 2
Junior High School
School Name 2
Yosemite
School Type 3
Grade School
School Name 3
Yosemite
Seller Will Consider
Government, Conventional, Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 740810 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 818790 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) >= 3284 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3784 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` = 1679341 OR `props-main`.`id` = 1611781 OR `props-main`.`id` = 1611780 OR `props-main`.`id` = 1696494 OR `props-main`.`id` = 1697435 OR `props-main`.`id` = 1699201 OR `props-main`.`id` = 1699153 OR `props-main`.`id` = 1678525 OR `props-main`.`id` = 1687678 OR `props-main`.`id` = 1687673 OR `props-main`.`id` = 1687672 OR `props-main`.`id` = 1695125 OR `props-main`.`id` = 1695174 OR `props-main`.`id` = 1694918 OR `props-main`.`id` = 1679666 OR `props-main`.`id` = 1678297 OR `props-main`.`id` = 1678304 OR `props-main`.`id` = 1611124 OR `props-main`.`id` = 1611151 OR `props-main`.`id` = 1697446 OR `props-main`.`id` = 1698992 OR `props-main`.`id` = 1696897 OR `props-main`.`id` = 1696877 OR `props-main`.`id` = 1698981 OR `props-main`.`id` = 1692282 OR `props-main`.`id` = 1666393 OR `props-main`.`id` = 1687675 OR `props-main`.`id` = 1677953)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno617300' 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 Gerald Brown, Century 21 Select Real Estate - [email protected] Last modified 4 months ago Fresno MLS last checked for updates 32 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.
