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/639776/49400-River-Park-Rd-55/Oakhurst/https://www.londonproperties.com/images/props/fresno/full/639776.jpgLondon Properties Oakhurst Real Estate | 49400 River Park Rd #55
Discover an affordable opportunity to own your own home in a great central mountain location- just minutes from downtown Oakhurst, Hwy 41, gateway to Yosemite and Bass Lake. Nestled in a gated community with manicured green spaces, covered parking, and a refreshing community pool. Central heating/air conditioning, 2 bedrooms, 1 full bathroom, the kitchen has plenty of counter space and cabinets, dishwasher, fireplace, laminate flooring and an abundance of natural light streaming through slider doors and windows.
Property Type
Residential
Property Subtype 1
Condominium
Property Subtype 2
Single Family Residence
Year Built
1989
Region
Rural
Unique Conditions
1031 Exchange
# of Stories
Single Story
Price Per Square Foot
$236
Price Per Acre
$11,250,000
Days On London
82
Cumulative Days On London
82
County
Madera
Reports Available
CC&Rs, Rules & Regulations
Special Features
Security Gate, Built In Cabinets, Wet/Dry Bar
REO / Bank Owned
No
Cross Street Address
Royal Oaks
Directions
Take Royal Oaks straight to entrance gates.
Unit Description
Ground Floor
Heating & Cooling
Central Heat & Cool
Laundry
Inside, In Closet
Roofing
Other
Foundation
Concrete
Primary Bedroom Level
Main
Bath Features
Tub/Shower
Basement
None
# of Fireplaces
1
Fireplace Type
Zero Clearance
Exterior
Stucco
Pool
Yes
Pool
Yes
Pool Type
In Ground
Gas & Electric
Public Utilities, Propane
Sewer / Water
Public Water, Public Sewer
Energy Efficiency
Dual Pane Windows
Solar
No
Parking Features
Carport
Carport Spaces
2
APN
066 384 009 000
Association / Park Amenities
Pool, Landscape Maint, Gated Community
HOA Dues
277.00
Frequency
monthly
School District
Bass Lake Joint Unio
School Type 1
High School
School Name 1
Yosemite
School Type 2
Junior High School
School Name 2
Oak Creek
School Type 3
Grade School
School Name 3
Oakhurst
Seller Will Consider
Government, Conventional, Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 213750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 236250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 702 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1202 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` = 1665957 OR `props-main`.`id` = 1687583 OR `props-main`.`id` = 1665948 OR `props-main`.`id` = 1687582 OR `props-main`.`id` = 1684949 OR `props-main`.`id` = 1684969 OR `props-main`.`id` = 1649455 OR `props-main`.`id` = 1649459 OR `props-main`.`id` = 1700854 OR `props-main`.`id` = 1652449 OR `props-main`.`id` = 1652455 OR `props-main`.`id` = 1673392 OR `props-main`.`id` = 1693731 OR `props-main`.`id` = 1702816 OR `props-main`.`id` = 1702819 OR `props-main`.`id` = 1703772 OR `props-main`.`id` = 1691994 OR `props-main`.`id` = 1692450 OR `props-main`.`id` = 1692558 OR `props-main`.`id` = 1697703 OR `props-main`.`id` = 1697697 OR `props-main`.`id` = 1694054 OR `props-main`.`id` = 1702958 OR `props-main`.`id` = 1706784 OR `props-main`.`id` = 1677160 OR `props-main`.`id` = 1710214 OR `props-main`.`id` = 1677211 OR `props-main`.`id` = 1704060 OR `props-main`.`id` = 1710217 OR `props-main`.`id` = 1704068 OR `props-main`.`id` = 1686607 OR `props-main`.`id` = 1709622 OR `props-main`.`id` = 1679722 OR `props-main`.`id` = 1694244 OR `props-main`.`id` = 1655023 OR `props-main`.`id` = 1703347 OR `props-main`.`id` = 1673677 OR `props-main`.`id` = 1671575 OR `props-main`.`id` = 1690785 OR `props-main`.`id` = 1694278 OR `props-main`.`id` = 1690800 OR `props-main`.`id` = 1691997 OR `props-main`.`id` = 1705939 OR `props-main`.`id` = 1705991 OR `props-main`.`id` = 1688570 OR `props-main`.`id` = 1688561 OR `props-main`.`id` = 1710047 OR `props-main`.`id` = 1710042 OR `props-main`.`id` = 1705248 OR `props-main`.`id` = 1693930 OR `props-main`.`id` = 1693922 OR `props-main`.`id` = 1697427 OR `props-main`.`id` = 1697412 OR `props-main`.`id` = 1711251 OR `props-main`.`id` = 1711254 OR `props-main`.`id` = 1702977)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno639776' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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 Delia Salazar, Bass Lake Realty Inc. - [email protected] Last modified 3 weeks ago Fresno MLS last checked for updates 19 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.
