Courtesy of Rene Christenson, Century 21 Ditton Realty - [email protected]
Escape to the peace and beauty of the countryside with this charming studio cabin situated on 2 picturesque acres. Thoughtfully designed for comfort, the cabin features a full bathroom, convenient laundry area, and an energy-efficient mini-split system providing year-round heating and air conditioning. Surrounded by mature oak trees and enjoying beautiful views of the surrounding landscape, this property offers the perfect setting for a weekend retreat, vacation getaway, or peaceful full-time escape. A large storage shed provides ample space for tools, equipment, or recreational gear. Whether you're looking for a cozy place to enjoy now or envision building your dream home in the future, this property offers endless possibilities. Live comfortably in the studio cabin while you design and construct your custom residence, or simply embrace the simplicity and serenity of this unique country retreat.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1989
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$365
Price Per Acre
$113,402
Days On London
0
Cumulative Days On London
0
County
Madera
REO / Bank Owned
No
Cross Street Address
Highway 41
Directions
Highway 41 to Road 415 to sign on right
Style
Cabin
Heating & Cooling
Ductless or Split
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Detached Structures
Shed
Kitchen
F/S Range/Oven, Refrigerator
Primary Bedroom Level
Main
Bath Features
Shower
Flooring
Tile
# of Fireplaces
1
Fireplace Type
Free Standing
Exterior
Wood
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Septic Tank, Private Well
Solar
No
Parking Features
Uncovered
Are there garage spaces?
No
APN
054 441 001 000
School District
Yosemite
School Type 1
High School
School Name 1
Yosemite
School Type 2
Junior High School
School Name 2
Rivergold
School Type 3
Grade School
School Name 3
Rivergold
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 209000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 231000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '1' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 353 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 853 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` = 1726382 OR `props-main`.`id` = 1726362 OR `props-main`.`id` = 1725794 OR `props-main`.`id` = 1725813 OR `props-main`.`id` = 1721416 OR `props-main`.`id` = 1732309 OR `props-main`.`id` = 1726490 OR `props-main`.`id` = 1748299 OR `props-main`.`id` = 1748292 OR `props-main`.`id` = 1728256 OR `props-main`.`id` = 1728260 OR `props-main`.`id` = 1744351 OR `props-main`.`id` = 1719794 OR `props-main`.`id` = 1719745 OR `props-main`.`id` = 1750020 OR `props-main`.`id` = 1750054 OR `props-main`.`id` = 1718679)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno652189' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-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
Last modified 2 hours ago Fresno MLS last checked for updates 20 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.
