Listing Agent: Marianne Freiwald, Century 21/Wildwood Properties
ACTIVE TWAIN HARTE LAKE MEMBERSHIP WITH TWO HOUSES ON ONE LOT!!! Both homes have their own meters for all utilities. Rear cabin offers 1680 sq,ft. with 4 bedrooms, 1.5 baths with a spacious front deck & a back private deck off from the kitchen. Cabiney feel has been preserved while finishing with upgrades. All new flooring throughout and kitchen has been completely remodeled with all new appliances. 3 new zone units for added comfort with heat and air. Laundry room with storage. Ample parking in the front and the side. Shop/ storage under the house. Property manager states possible rent at $2400.00 monthly. Front cabin is currently rented at $1500.00 a month and offers 800 sq.ft. with 2 bedrooms and 1 full bath. New flooring with a mini split unit and free standing pellet stove. Level parking in the front and an additional space in the back of the cabin. Prime location to town and all the amenities of Twain Harte. Multiple uses for full time or vacation rental as well.
Property Sub Type
Single Family Residence
Year Built
1950
Levels
Two
Price Per Square Foot
$476
Days On London
0
Cumulative Days On London
0
County Or Parish
Tuolumne
New Construction Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Cross Street: Black Oak.
Room Type
Workshop
Heating
Forced Air
Roof
Shingle
Construction Materials
Wood Siding
Other Structures
Storage
Bathrooms Full
1
Bathrooms Full And Three Quarter
1
Bathrooms Half
1
Room Kitchen Features
Remodeled Kitchen
Appliances Y/N
Yes
Flooring
Vinyl, Carpet
Fireplace Y/N
Yes
Fireplace Features
Free Standing, Pellet Stove
Pool Features
None
Pool Private Y/N
No
Patio Y/N
Yes
Patio And Porch Features
Deck
Parking Y/N
Yes
Parking Features
RV Access/Parking
Attached Garage Y/N
No
Lot Size Area
10912.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
Trees/Woods
Parcel Number
049162027000
Association Y/N
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 759050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 838950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1430 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1930 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` = 1727697 OR `props-main`.`id` = 1728093 OR `props-main`.`id` = 1748192 OR `props-main`.`id` = 1727621 OR `props-main`.`id` = 1737834 OR `props-main`.`id` = 1753084 OR `props-main`.`id` = 1727564 OR `props-main`.`id` = 1754571 OR `props-main`.`id` = 1729975 OR `props-main`.`id` = 1748527 OR `props-main`.`id` = 1738558 OR `props-main`.`id` = 1739086 OR `props-main`.`id` = 1759104 OR `props-main`.`id` = 1747277 OR `props-main`.`id` = 1727808 OR `props-main`.`id` = 1754132 OR `props-main`.`id` = 1731860 OR `props-main`.`id` = 1727525 OR `props-main`.`id` = 1757221 OR `props-main`.`id` = 1727658 OR `props-main`.`id` = 1701517 OR `props-main`.`id` = 1744538 OR `props-main`.`id` = 1738755 OR `props-main`.`id` = 1748339 OR `props-main`.`id` = 1728624 OR `props-main`.`id` = 1728094 OR `props-main`.`id` = 1735549 OR `props-main`.`id` = 1737858 OR `props-main`.`id` = 1751625 OR `props-main`.`id` = 1750694 OR `props-main`.`id` = 1728328 OR `props-main`.`id` = 1727478 OR `props-main`.`id` = 1757866 OR `props-main`.`id` = 1746700 OR `props-main`.`id` = 1746699 OR `props-main`.`id` = 1760134 OR `props-main`.`id` = 1760149 OR `props-main`.`id` = 1735350 OR `props-main`.`id` = 1752521 OR `props-main`.`id` = 1738987 OR `props-main`.`id` = 1734970 OR `props-main`.`id` = 1732563 OR `props-main`.`id` = 1718589 OR `props-main`.`id` = 1731071 OR `props-main`.`id` = 1759618 OR `props-main`.`id` = 1730772 OR `props-main`.`id` = 1751359 OR `props-main`.`id` = 1750751 OR `props-main`.`id` = 1742273 OR `props-main`.`id` = 1744374 OR `props-main`.`id` = 1738011 OR `props-main`.`id` = 1727334 OR `props-main`.`id` = 1696222 OR `props-main`.`id` = 1733371 OR `props-main`.`id` = 1729828 OR `props-main`.`id` = 1754880 OR `props-main`.`id` = 1733370 OR `props-main`.`id` = 1744270 OR `props-main`.`id` = 1741805 OR `props-main`.`id` = 1731950 OR `props-main`.`id` = 1738945 OR `props-main`.`id` = 1747168 OR `props-main`.`id` = 1735351 OR `props-main`.`id` = 1729047 OR `props-main`.`id` = 1750840 OR `props-main`.`id` = 1728463 OR `props-main`.`id` = 1730610 OR `props-main`.`id` = 1748609 OR `props-main`.`id` = 1729974 OR `props-main`.`id` = 1728038 OR `props-main`.`id` = 1728160 OR `props-main`.`id` = 1751381 OR `props-main`.`id` = 1755076 OR `props-main`.`id` = 1745252 OR `props-main`.`id` = 1750624 OR `props-main`.`id` = 1736561 OR `props-main`.`id` = 1739572 OR `props-main`.`id` = 1758511 OR `props-main`.`id` = 1731137 OR `props-main`.`id` = 1728114 OR `props-main`.`id` = 1736663 OR `props-main`.`id` = 1729084 OR `props-main`.`id` = 1734785 OR `props-main`.`id` = 1750749 OR `props-main`.`id` = 1730577 OR `props-main`.`id` = 1727368 OR `props-main`.`id` = 1749176 OR `props-main`.`id` = 1730775 OR `props-main`.`id` = 1728570)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls41144388' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-08' 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
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.
