BRAND NEW TO MARKET! Open House Sunday, July 5th from 1-3PM. ACTIVE LAKE MEMBERSHIP! This is a rare find near downtown Twain Harte and just a short stroll to our beloved Twain Harte Lake. Immaculate home nestled on Fireside Drive... one of Twain Harte's most coveted locations and boasting over 2300 SF with all the conveniences one could hope for... LEVEL PARKING * EASY ACCESS WITH FEW STAIRS FOR ENTRY * OVERSIZED KITCHEN / DINING / LIVING ROOM - perfect for entertainers and multiple families * PRIMARY SUITE on main floor with walk in closet and spacious bathroom * AMPLE SIZED ATTACHED GARAGE * CENTRAL HEAT / AIR CONDITIONING / PELLET STOVE PLUS GENERATOR! You will be hard pressed to find these amenities in ''The Golden Triangle.'' Charming setting with traditional front porch connecting neighbors with neighbors for that yesteryear feel. Backyard patio is private and surrounded by natural landscape - very tranquil and serene backing to open space. LOCATION... LOCATION... LOCATION...! Interior photos coming soon.
Property Sub Type
Single Family Residence
Year Built
1994
Levels
Two
Price Per Square Foot
$345
Days On London
1
Cumulative Days On London
1
County Or Parish
Tuolumne
New Construction Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Cross Street: Golf Club Drive.
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
Bathrooms Half
1
Appliances Y/N
Yes
Flooring
Vinyl, Carpet
Fireplace Y/N
Yes
Fireplace Features
Pellet Stove
Pool Features
None
Pool Private Y/N
No
Patio Y/N
Yes
Patio And Porch Features
Front Porch
Parking Y/N
Yes
Parking Total
2.00
Parking Features
Garage Door Opener
Attached Garage Y/N
No
Garage Spaces
2.00
Lot Features
Level with Street
Lot Size Area
9147.0000
Lot Size Units
Square Feet
Parcel Number
050031033000
Association Y/N
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 759715 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 839685 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) >= 2066 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2566 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` = 1743341 OR `props-main`.`id` = 1727432 OR `props-main`.`id` = 1727697 OR `props-main`.`id` = 1742179 OR `props-main`.`id` = 1740649 OR `props-main`.`id` = 1738634 OR `props-main`.`id` = 1728651 OR `props-main`.`id` = 1732278 OR `props-main`.`id` = 1728093 OR `props-main`.`id` = 1728566 OR `props-main`.`id` = 1727621 OR `props-main`.`id` = 1736878 OR `props-main`.`id` = 1737834 OR `props-main`.`id` = 1733416 OR `props-main`.`id` = 1727564 OR `props-main`.`id` = 1729975 OR `props-main`.`id` = 1738558 OR `props-main`.`id` = 1739086 OR `props-main`.`id` = 1729082 OR `props-main`.`id` = 1727725 OR `props-main`.`id` = 1727808 OR `props-main`.`id` = 1731860 OR `props-main`.`id` = 1727525 OR `props-main`.`id` = 1727658 OR `props-main`.`id` = 1701517 OR `props-main`.`id` = 1744538 OR `props-main`.`id` = 1740466 OR `props-main`.`id` = 1738755 OR `props-main`.`id` = 1728624 OR `props-main`.`id` = 1728094 OR `props-main`.`id` = 1735549 OR `props-main`.`id` = 1737827 OR `props-main`.`id` = 1737858 OR `props-main`.`id` = 1728257 OR `props-main`.`id` = 1728328 OR `props-main`.`id` = 1727478 OR `props-main`.`id` = 1735350 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` = 1730772 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` = 1733370 OR `props-main`.`id` = 1727817 OR `props-main`.`id` = 1744270 OR `props-main`.`id` = 1741805 OR `props-main`.`id` = 1731950 OR `props-main`.`id` = 1738945 OR `props-main`.`id` = 1735351 OR `props-main`.`id` = 1729047 OR `props-main`.`id` = 1728463 OR `props-main`.`id` = 1730610 OR `props-main`.`id` = 1729974 OR `props-main`.`id` = 1728038 OR `props-main`.`id` = 1728160 OR `props-main`.`id` = 1727788 OR `props-main`.`id` = 1742749 OR `props-main`.`id` = 1736457 OR `props-main`.`id` = 1736561 OR `props-main`.`id` = 1739572 OR `props-main`.`id` = 1731137 OR `props-main`.`id` = 1736768 OR `props-main`.`id` = 1728114 OR `props-main`.`id` = 1736663 OR `props-main`.`id` = 1736877 OR `props-main`.`id` = 1729084 OR `props-main`.`id` = 1734785 OR `props-main`.`id` = 1727368 OR `props-main`.`id` = 1730775)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls41140140' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-01' 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.
