Courtesy of Leonard Sharp, eXp Realty of California, Inc. - [email protected]
Investor Setup near Yosemite two separate homes on one hilltop parcel, minutes from Yosemite's south gate, built for short-term and long-term rental income. The main house is a standout: a three-story stone-turreted castle with a conical tower, wraparound deck, and Sierra views distinctive enough to stand out and book solid as a vacation rental. A second, fully separate dwelling sits on its own foundation with private driveway access and a newer roof delivered vacant, ready for long-term income or on-site housing for your manager while you host the main home. Run the main as an STR, hold the second as an LTR, and let two streams carry the hill. Good bones, not a gut job newer HVAC and roofs a cosmetic value-add priced to move and to build in equity. Bring your vision and your paintbrush. Strong projected income ask for the rental analysis. Buyer to verify square footage and confirm the second dwelling's permitted use, rentability, and STR eligibility with Madera County.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1988
Region
Foothill
# of Stories
Multi/Split
Price Per Square Foot
$352
Price Per Acre
$236,316
Days On London
7
Cumulative Days On London
7
County
Madera
Special Features
Isolated Bedroom
REO / Bank Owned
No
Cross Street Address
Hwy 41
Directions
Highway 41 N to Snowline Ct, Left, stay left up the hill to the home
Style
Victorian
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Gas Hook Up, Electric Hook Up
Roofing
Composition
Foundation
Wood Subfloor
Kitchen
F/S Range/Oven, Gas Appliances, Electric Appliances, Disposal, Microwave, Eating Area, Refrigerator
Dining Room Features
Living Room/Area
Primary Bedroom Level
Upper
Bath Features
Shower
Basement
None
Flooring
Carpet, Laminate
# of Fireplaces
1
Fireplace Type
Free Standing
Exterior
Wood, Stone
Pool
No
Pool
No
Spa
No
Patio Features
Uncovered
Gas & Electric
Propane
Sewer / Water
Septic Tank, Private Well
Solar
No
Parking Features
Uncovered
Are there garage spaces?
No
Site Amenities
Bluff View
APN
057 580 035 000
School District
Yosemite
School Type 1
High School
School Name 1
Yosemite
School Type 2
Junior High School
School Name 2
Wasuma
School Type 3
Grade School
School Name 3
Wasuma
Seller Will Consider
Conventional, Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 426550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 471450 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) >= 1024 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1524 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` = 1736908 OR `props-main`.`id` = 1736936 OR `props-main`.`id` = 1731954 OR `props-main`.`id` = 1738691 OR `props-main`.`id` = 1703754 OR `props-main`.`id` = 1719504 OR `props-main`.`id` = 1719519 OR `props-main`.`id` = 1723308 OR `props-main`.`id` = 1749621 OR `props-main`.`id` = 1751538 OR `props-main`.`id` = 1746266 OR `props-main`.`id` = 1746238 OR `props-main`.`id` = 1687673 OR `props-main`.`id` = 1717569 OR `props-main`.`id` = 1717563 OR `props-main`.`id` = 1720583 OR `props-main`.`id` = 1687672 OR `props-main`.`id` = 1720584 OR `props-main`.`id` = 1752083 OR `props-main`.`id` = 1718198 OR `props-main`.`id` = 1718146 OR `props-main`.`id` = 1725890 OR `props-main`.`id` = 1724665 OR `props-main`.`id` = 1724676 OR `props-main`.`id` = 1729761 OR `props-main`.`id` = 1705108 OR `props-main`.`id` = 1705099 OR `props-main`.`id` = 1744349 OR `props-main`.`id` = 1743536 OR `props-main`.`id` = 1727959 OR `props-main`.`id` = 1724835 OR `props-main`.`id` = 1728008 OR `props-main`.`id` = 1738714 OR `props-main`.`id` = 1729150 OR `props-main`.`id` = 1729143 OR `props-main`.`id` = 1735412 OR `props-main`.`id` = 1735463 OR `props-main`.`id` = 1717111 OR `props-main`.`id` = 1717141 OR `props-main`.`id` = 1584048 OR `props-main`.`id` = 1559272 OR `props-main`.`id` = 1735462)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno652372' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-22' 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 1 day ago Fresno MLS last checked for updates 1 hour 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.
