Donna Pride559.642.8373dpride@londonproperties.comEmail Agent
Property Description
This remodeled log sided 4 bedroom, 3 bath home is the perfect second home or vacation rental. Close to many famous recreational activities, in the heart of California's Central Valley, with the Sierra Nevada Mountain Range in your backyard and just short drives to the southern gateway to Yosemite National Park, Mariposa Grove home to California's giant Sequoia Redwood trees, and to the incomparable Yosemite Valley where Yosemite Falls, Half Dome, and El Capitan are home to Yosemite Valley. Close to quaint resort towns such as downtown Oakhurst and Bass Lake. While outdoor adventures top travel itineraries, you'll always feel like you are on vacation. This property is also just steps away to Lewis Creek with its Red Rock and Cordelieu Falls just downstream from the trail head and also close by to Nelder Grove home to another Grove of an ancient Giant Redwood Sequoia trees! Successful vacation rental!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1959
Region
Rural
# of Stories
Two
Price Per Square Foot
$294
Days On London
8
Cumulative Days On London
405
County
Madera
Special Features
Isolated Bedroom, Isolated Bathroom, Built In Cabinets, Other/See Remarks
REO / Bank Owned
No
Cross Street Address
Buckeye
Directions
Road 222 to left on Buckeye to right on Shady Lane.
Unit Description
Ground Floor, Second Floor
Heating & Cooling
Central Heating, Central Cooling
Laundry
Inside
Roofing
Composition
Foundation
Both
Kitchen
Gas Appliances, Dishwasher, Microwave
Dining Room Features
Living Room/Area
Primary Bedroom Level
Upper
Bath Features
Tub/Shower
Extra Rooms
Game Room
Flooring
Carpet, Laminate, Tile
# of Fireplaces
1
Fireplace Type
Free Standing
Exterior
Log
Pool
No
Pool
No
Spa
Yes
Spa Type
Above Ground
Patio Features
Covered, Uncovered, Concrete, Wood Deck
Yard
Fenced
Gas & Electric
Public Utilities, Propane
Sewer / Water
Public Water, Septic Tank
Energy Efficiency
Dual Pane Windows
Solar
No
Parking Features
Uncovered
Site Amenities
Other
APN
057 360 022 000
Zoning
RMS
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
Conventional, Cash
72877
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 569050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 628950 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) >= 1790 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2290 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` = 1703754 OR `props-main`.`id` = 1702977 OR `props-main`.`id` = 1687534 OR `props-main`.`id` = 1702297 OR `props-main`.`id` = 1696418 OR `props-main`.`id` = 1696415 OR `props-main`.`id` = 1678407 OR `props-main`.`id` = 1687579 OR `props-main`.`id` = 1665912 OR `props-main`.`id` = 1704916 OR `props-main`.`id` = 1704867 OR `props-main`.`id` = 1704051 OR `props-main`.`id` = 1704043 OR `props-main`.`id` = 1657428 OR `props-main`.`id` = 1657431 OR `props-main`.`id` = 1703575 OR `props-main`.`id` = 1687261 OR `props-main`.`id` = 1637104 OR `props-main`.`id` = 1690329 OR `props-main`.`id` = 1690188 OR `props-main`.`id` = 1705108 OR `props-main`.`id` = 1705099 OR `props-main`.`id` = 1666303 OR `props-main`.`id` = 1693743 OR `props-main`.`id` = 1704810 OR `props-main`.`id` = 1694055 OR `props-main`.`id` = 1687624 OR `props-main`.`id` = 1690354 OR `props-main`.`id` = 1679336 OR `props-main`.`id` = 1694724 OR `props-main`.`id` = 1584048 OR `props-main`.`id` = 1559272 OR `props-main`.`id` = 230457)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno641945' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-03' 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 Rene Christenson, Century 21 Ditton Realty - r.christenson@c21ditton.com Last modified 4 days ago Fresno MLS last checked for updates 53 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.
