Donna Pride559.642.8373dpride@londonproperties.comEmail Agent
Property Description
Wonderful Vacation Rental Property! You'll find this charming home near Yosemite, with Lewis Creek frontage and waterfalls offering beautiful surroundings! Currently used as a very successful vacation rental, this multi story 2015+/- sq. ft. home offers easy to maintain floors and gorgeous high vaulted ceilings. The great family/living room is designed as the perfect place to relax and soak in the views! All bedrooms are exceptionally spacious with plenty of beds for an extended family to vacation! The large deck is a great place to enjoy the views of huge trees and peaceful creek sounds! This house has Lewis Creek frontage so grab your fishing pole to catch rainbow or golden trout in the spring or summer seasons. This is a great turn key investment with most of the furnishings included, this home is currently used as a successful vacation rental (email agent for income and expense records). Not only is Lewis Creek a great location but this house is also just minutes to Bass Lake and Oakhurst and 15 minutes to Yosemite National Park! Average YTD STR monthly income $7,753.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1967
Region
Mountain
# of Stories
Multi/Split
Price Per Square Foot
$272
Price Per Acre
$613,957
Days On Market
39
Cumulative Days On Market
39
County
Madera
REO / Bank Owned
No
Cross Street Address
Road 222
Directions
Road 222 to Buckeye
Unit Description
Split Level
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Wood Subfloor
Primary Bedroom Level
Upper
# of Fireplaces
1
Fireplace Type
Zero Clearance
Exterior
Wood
Pool
No
Pool
No
Gas & Electric
Public Utilities, Propane
Sewer / Water
Public Water, Septic Tank
Solar
No
Site Amenities
River View, Water Front
APN
057 450 040 000
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
72877
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 521550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 576450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1765 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2265 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` = 1687547 OR `props-main`.`id` = 1677521 OR `props-main`.`id` = 1685286 OR `props-main`.`id` = 1685061 OR `props-main`.`id` = 1686201 OR `props-main`.`id` = 1687534 OR `props-main`.`id` = 1666298 OR `props-main`.`id` = 1685749 OR `props-main`.`id` = 1635838 OR `props-main`.`id` = 1635840 OR `props-main`.`id` = 1685734 OR `props-main`.`id` = 1669916 OR `props-main`.`id` = 1678407 OR `props-main`.`id` = 1687579 OR `props-main`.`id` = 1665912 OR `props-main`.`id` = 1676628 OR `props-main`.`id` = 1676642 OR `props-main`.`id` = 1662495 OR `props-main`.`id` = 1657428 OR `props-main`.`id` = 1657431 OR `props-main`.`id` = 1685943 OR `props-main`.`id` = 1685921 OR `props-main`.`id` = 1682709 OR `props-main`.`id` = 1687261 OR `props-main`.`id` = 1637104 OR `props-main`.`id` = 1690329 OR `props-main`.`id` = 1690188 OR `props-main`.`id` = 1627751 OR `props-main`.`id` = 1627748 OR `props-main`.`id` = 1641529 OR `props-main`.`id` = 1641389 OR `props-main`.`id` = 1670965 OR `props-main`.`id` = 1666303 OR `props-main`.`id` = 1683736 OR `props-main`.`id` = 1662319 OR `props-main`.`id` = 1687624 OR `props-main`.`id` = 1690354 OR `props-main`.`id` = 1679336 OR `props-main`.`id` = 1671544 OR `props-main`.`id` = 1671553 OR `props-main`.`id` = 1683721 OR `props-main`.`id` = 1584048 OR `props-main`.`id` = 1559272 OR `props-main`.`id` = 1686240 OR `props-main`.`id` = 230457)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno637514' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-11-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();
1
Similar Properties
$534,900
4
3
2,264
3.30
42275 Buckeye Rd
Oakhurst, CA 93644
Courtesy of Timothy Spate, Timothy Spate, Broker - tspate@aol.com Last modified 3 weeks ago Fresno MLS last checked for updates 21 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.
