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/651926/35995-Sierra-Linda-Dr/Wishon/https://www.londonproperties.com/images/props/fresno/full/651926.jpgLondon Properties Wishon Real Estate | 35995 Sierra Linda Dr
Wishon cabin just minutes from the public boat launch at Bass Lake. This home is ready for it's new owner to bring it back to life with new charm and a little bit of elbow grease. Flat and useable property situated on just over a half acre. Three bedrooms, a bonus room and two bathrooms all showcase the desirable cabin-feel with tongue & groove wood ceilings and walls. Snuggle up by the fireplace with a good book in winter or head out to your backyard for gardening or summer fun! A rare find in Wishon, this cabin also has a 2 car detached garage. The best part about this property is the gorgeous views of Peckinpah Ridge. Just a bit of tree trimming would really open up the views from the home, but they are beautiful as they are. So bring your imagination and turn this home into your Bass Lake/Yosemite getaway or the ideal investment property.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1954
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$167
Price Per Acre
$480,769
Days On London
0
Cumulative Days On London
0
County
Madera
Special Features
Skylight
REO / Bank Owned
No
Cross Street Address
Road 222
Directions
HWY 41 to Road 200 Left on 221, R on Sierra Linda, Property on R
Style
Cabin
Heating & Cooling
Floor or Wall Unit
Laundry
Inside
Roofing
Metal
Foundation
Wood Subfloor
Primary Bedroom Level
Main
Bath Features
Shower
Flooring
Carpet, Laminate
# of Fireplaces
1
Fireplace Type
Wood Insert
Exterior
Wood
Pool
No
Pool
No
Patio Features
Covered
Gas & Electric
Public Utilities, Propane
Sewer / Water
Public Water, Septic Tank
Energy Efficiency
Dual Pane Windows
Solar
No
Are there garage spaces?
Yes
Garage Type
Detached
Garage Spaces
2
APN
061 030 022 000
School District
Chawanakee
School Type 1
High School
School Name 1
Minarets
School Type 2
Junior High School
School Name 2
North Fork
School Type 3
Grade School
School Name 3
North Fork
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 237500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 262500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1250 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1750 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` = 1747339 OR `props-main`.`id` = 1747169 OR `props-main`.`id` = 1747167 OR `props-main`.`id` = 1711363 OR `props-main`.`id` = 1725341 OR `props-main`.`id` = 1725343 OR `props-main`.`id` = 1725392 OR `props-main`.`id` = 1723755 OR `props-main`.`id` = 1717843 OR `props-main`.`id` = 1744636 OR `props-main`.`id` = 1702346 OR `props-main`.`id` = 1680745 OR `props-main`.`id` = 1680749 OR `props-main`.`id` = 1724189 OR `props-main`.`id` = 1714004 OR `props-main`.`id` = 1714014 OR `props-main`.`id` = 1729185 OR `props-main`.`id` = 1729623 OR `props-main`.`id` = 1747127 OR `props-main`.`id` = 1747132 OR `props-main`.`id` = 1748184 OR `props-main`.`id` = 1748194 OR `props-main`.`id` = 1717891 OR `props-main`.`id` = 1722301 OR `props-main`.`id` = 1725068 OR `props-main`.`id` = 1724933 OR `props-main`.`id` = 1730943 OR `props-main`.`id` = 1728613 OR `props-main`.`id` = 1741730 OR `props-main`.`id` = 1741742 OR `props-main`.`id` = 1728442 OR `props-main`.`id` = 1729249 OR `props-main`.`id` = 1723145 OR `props-main`.`id` = 1690435 OR `props-main`.`id` = 1690452 OR `props-main`.`id` = 1716752 OR `props-main`.`id` = 1720936)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno651926' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-11' 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 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.
