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/crmls/ML82017684/46347-Opah-Dr/Ahwahnee/https://www.londonproperties.com/images/props/crmls/full/ML82017684.jpgLondon Properties Ahwahnee Real Estate | 46347 Opah Dr
Listing Agent: Sandra Vega, Intero Real Estate Services
Enjoy all four seasons in this executive home located in Sierra Meadows. This 4-bedroom, 3 full bath home sits on over 2 acres surrounded by majestic mountains and ponds in a town with over a century of history. Fully landscaped with multiple patio areas and flagstone walkways, youll never get tired of the views. With 2,622 square feet of living space with tile and luxury plank wood flooring, formal living and dining room, separate living space with an open kitchen floor plan. Youll enjoy the vas local amenities from wine trails, golf, hiking, fishing, horseback riding, and a short drive to Yosemite National Park, or enjoy an evening out at Chukchansi Resort & Casino.
Property Sub Type
Single Family Residence
Year Built
2004
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
1
Price Per Square Foot
$215
Days On Market
493
County Or Parish
Madera
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Cross Street: Lulniu Lane
Heating
Central
Cooling
Central Air
Roof
Composition
Foundation Details
Slab
Bathrooms Full
3
Bathrooms Full And Three Quarter
3
Eating Area
Breakfast Nook, In Living Room
Appliances Y/N
No
Flooring
Tile
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Family Room
Water Source
Public
Parking Total
3.00
Attached Garage Y/N
Yes
Garage Spaces
3.00
Lot Size Area
91912.0000
Lot Size Units
Square Feet
View Y/N
No
Parcel Number
055580010
Zoning
RRS-2
Association Y/N
No
High School District
Yosemite Unified
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 536750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 593250 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) >= 2372 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2872 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` = 1683786 OR `props-main`.`id` = 1696865 OR `props-main`.`id` = 1685769 OR `props-main`.`id` = 1689913 OR `props-main`.`id` = 1679341 OR `props-main`.`id` = 1611781 OR `props-main`.`id` = 1611780 OR `props-main`.`id` = 1696494 OR `props-main`.`id` = 1691099 OR `props-main`.`id` = 1691097 OR `props-main`.`id` = 1697435 OR `props-main`.`id` = 1653133 OR `props-main`.`id` = 1682052 OR `props-main`.`id` = 1678525 OR `props-main`.`id` = 1687678 OR `props-main`.`id` = 1692343 OR `props-main`.`id` = 1691040 OR `props-main`.`id` = 1687673 OR `props-main`.`id` = 1687672 OR `props-main`.`id` = 1676472 OR `props-main`.`id` = 1695125 OR `props-main`.`id` = 1695174 OR `props-main`.`id` = 1676474 OR `props-main`.`id` = 1694918 OR `props-main`.`id` = 1679666 OR `props-main`.`id` = 1679602 OR `props-main`.`id` = 1679606 OR `props-main`.`id` = 1687666 OR `props-main`.`id` = 1674063 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` = 1693385 OR `props-main`.`id` = 1692639 OR `props-main`.`id` = 1696897 OR `props-main`.`id` = 1696877 OR `props-main`.`id` = 1691569 OR `props-main`.`id` = 1692282 OR `props-main`.`id` = 1666393)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML82017684' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-16' 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
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.
