This is the VIEW you have been waiting for!!! Long range, panoramic views of the Stanislaus River Canyon with perfect proximity to the Hwy for easy access year round. SINGLE STORY - LEVEL PARKING - ATTACHED 2 CAR GARAGE!!! This one is special! 4 BED/ 2 BATH ALL ON ONE LEVEL. Floor to ceiling windows in living room overlooking canyon views with stunning sunsets. Wake each morning staring out the window to spectacular scenery right from the comfort of your bedroom. AN ENTERTAINERS'S DELIGHT with spacious kitchen / living room combo. The open-concept kitchen and living room create the perfect gathering space, flowing onto expansive two-tiered decks where you'll enjoy outdoor dining, entertaining friends, or simply relaxing while taking in the peaceful surroundings. This home beautifully blends classic mountain cabin charm with modern comfort. Soaring ceilings of warm knotty pine in the living room add the perfect blend of cabin and modern with cozy wood burning stove for warm winter nights by the fire. Don't miss the generator & solar!!!! Central heat & air-conditioning. This is a must see! ACTIVE VACATION RENTAL - SHOWINGS ARE LIMITED
Property Sub Type
Single Family Residence
Year Built
1999
Levels
One
Price Per Square Foot
$301
Days On London
26
Cumulative Days On London
60
County Or Parish
Tuolumne
New Construction Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Cross Street: Leisure.
Architectural Style
Traditional
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Washer Included, Dryer Included
Construction Materials
Wood Siding
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Eating Area
Breakfast Counter / Bar, Breakfast Nook
Appliances Y/N
Yes
Flooring
Vinyl, Carpet, Laminate
Fireplace Y/N
Yes
Fireplace Features
Free Standing
Pool Features
None
Pool Private Y/N
No
Patio Y/N
Yes
Patio And Porch Features
Deck
Parking Y/N
Yes
Parking Total
2.00
Parking Features
Garage
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
Level with Street
Lot Size Area
15245.0000
Lot Size Units
Square Feet
Parcel Number
047050027000
Association Y/N
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 569715 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 629685 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) >= 1745 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2245 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` = 1727478 OR `props-main`.`id` = 1752521 OR `props-main`.`id` = 1781475 OR `props-main`.`id` = 1731071 OR `props-main`.`id` = 1759618 OR `props-main`.`id` = 1730772 OR `props-main`.`id` = 1771997 OR `props-main`.`id` = 1696222 OR `props-main`.`id` = 1733371 OR `props-main`.`id` = 1777869 OR `props-main`.`id` = 1729828 OR `props-main`.`id` = 1754880 OR `props-main`.`id` = 1733370 OR `props-main`.`id` = 1731950 OR `props-main`.`id` = 1735351 OR `props-main`.`id` = 1750840 OR `props-main`.`id` = 1728463 OR `props-main`.`id` = 1745252 OR `props-main`.`id` = 1729084 OR `props-main`.`id` = 1767620 OR `props-main`.`id` = 1750749 OR `props-main`.`id` = 1730577 OR `props-main`.`id` = 1782032 OR `props-main`.`id` = 1730775 OR `props-main`.`id` = 1727272 OR `props-main`.`id` = 1748927 OR `props-main`.`id` = 1747643 OR `props-main`.`id` = 1763201 OR `props-main`.`id` = 1784041 OR `props-main`.`id` = 1763194 OR `props-main`.`id` = 1730798)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls41147266' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-30' 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
$624,000
3
3
2,232
1.80
23615 Mount Elizabeth Rd
Twain Harte, CA 95383
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.
