Very nice mountain cabin with a smart comfortable floor plan and an expansive deck which wraps around two sides of the cabin with views of the meadow. 2 bedroom 1 full bathroom. Granite countertops in kitchen & bath. New stove, lighting fixtures, and fresh interior paint and new carpets. Parking off Chipmunk lane behind the cabin. Basement access under the covered portion of the deck has storage and laundry area.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1969
Region
Mountain
# of Stories
Single Story
Price Per Square Foot
$235
Price Per Acre
$1,829,429
Days On Market
243
Cumulative Days On Market
243
County
Fresno
Reports Available
NHD
REO / Bank Owned
No
Cross Street Address
Alva Snow
Directions
168 to PineRidge left on Alva Snow then left. Home at the end. Keep going after GPS says you arrived.
Style
Cabin
Heating & Cooling
Floor or Wall Unit
Laundry
On Lower Level
Roofing
Metal
Foundation
Wood Subfloor
Kitchen
F/S Range/Oven, Electric Appliances, Disposal, Dishwasher, Microwave, Pantry, Refrigerator
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 237405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 262395 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) >= 814 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1314 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` = 1666149 OR `props-main`.`id` = 1691752 OR `props-main`.`id` = 1694166 OR `props-main`.`id` = 1693426 OR `props-main`.`id` = 1647083 OR `props-main`.`id` = 1678082 OR `props-main`.`id` = 1690840 OR `props-main`.`id` = 1690781 OR `props-main`.`id` = 1696811 OR `props-main`.`id` = 1691705 OR `props-main`.`id` = 1642848 OR `props-main`.`id` = 1696174 OR `props-main`.`id` = 1696393 OR `props-main`.`id` = 1674789 OR `props-main`.`id` = 1687818 OR `props-main`.`id` = 1674008 OR `props-main`.`id` = 1665813 OR `props-main`.`id` = 612485)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno625809' 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();
1
Similar Properties
$249,000
2
1
1,184
0.13
41835 Corlew Ln
Auberry, CA 93602
Courtesy of Miriam Carter, Real Broker - [email protected] Last modified 3 weeks ago Fresno MLS last checked for updates 28 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.
