Tucked away at the end of a quiet cul-de-sac, discover a hidden gem on 0.67ac. Great curb appeal! This 3 bedroom plus Bonus room (w/ closet used as a 4th bedroom), 2 &1/2 bath, 2 Level Farmhouse has been updated w/ fresh paint & some new appliances. Clean & Move in ready! Downstairs has laundry in 1/2 bath (w/ newer washer & dryer) plus downstairs primary bed & bath. 3 rooms & full bath upstairs. New pool liner for inground pool is gorgeous, fully fenced plus separate fenced yard for animals or garden. Public water & Sewer, OWNED SOLAR, generator (never used) , newer roof plus owned security system (never used). Newer front composite deck is a wonderful outdoor space to relax & enjoy the privacy and views. Minutes to shopping, hospital & amenities.
Property Sub Type
Single Family Residence
Year Built
1989
Levels
Two
Price Per Square Foot
$313
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: Beckwith.
Heating
Natural Gas, Forced Air
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Washer Included
Construction Materials
Wood Siding
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Bathrooms Half
1
Room Kitchen Features
Stone Counters, Butler's Pantry
Eating Area
Breakfast Counter / Bar, In Kitchen
Appliances Y/N
Yes
Flooring
Tile, Carpet, Laminate
Fireplace Y/N
Yes
Fireplace Features
Free Standing, Wood Burning
Pool Features
In Ground
Pool Private Y/N
No
Patio Y/N
Yes
Patio And Porch Features
Front Porch, 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, Cul-De-Sac, Back Yard
Lot Size Area
29185.0000
Lot Size Units
Square Feet
Parcel Number
044480013
Association Y/N
No
High School District
Sonora Union
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 569050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 628950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1662 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2162 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` = 1763310 OR `props-main`.`id` = 1717598 OR `props-main`.`id` = 1782511 OR `props-main`.`id` = 1728037 OR `props-main`.`id` = 1783408 OR `props-main`.`id` = 1783407 OR `props-main`.`id` = 1731062 OR `props-main`.`id` = 1740742 OR `props-main`.`id` = 1744912 OR `props-main`.`id` = 1753085 OR `props-main`.`id` = 1771412 OR `props-main`.`id` = 1729133 OR `props-main`.`id` = 1785318 OR `props-main`.`id` = 1747794 OR `props-main`.`id` = 1727435 OR `props-main`.`id` = 1778845 OR `props-main`.`id` = 1775033 OR `props-main`.`id` = 1750108 OR `props-main`.`id` = 1772221 OR `props-main`.`id` = 1790314 OR `props-main`.`id` = 1768946 OR `props-main`.`id` = 1763566 OR `props-main`.`id` = 1779615 OR `props-main`.`id` = 1779614 OR `props-main`.`id` = 1775305 OR `props-main`.`id` = 1754356 OR `props-main`.`id` = 1736468 OR `props-main`.`id` = 1746495 OR `props-main`.`id` = 1786152 OR `props-main`.`id` = 1753507 OR `props-main`.`id` = 1754281 OR `props-main`.`id` = 1771188 OR `props-main`.`id` = 1773888 OR `props-main`.`id` = 1762628 OR `props-main`.`id` = 1779931 OR `props-main`.`id` = 1789456 OR `props-main`.`id` = 1727440 OR `props-main`.`id` = 1760782 OR `props-main`.`id` = 1760781 OR `props-main`.`id` = 1782360 OR `props-main`.`id` = 1790598 OR `props-main`.`id` = 1748333 OR `props-main`.`id` = 1712458 OR `props-main`.`id` = 1764196 OR `props-main`.`id` = 1748645 OR `props-main`.`id` = 1781476 OR `props-main`.`id` = 1736639 OR `props-main`.`id` = 1729916 OR `props-main`.`id` = 1770142 OR `props-main`.`id` = 1767637 OR `props-main`.`id` = 1765871 OR `props-main`.`id` = 1747152 OR `props-main`.`id` = 1789249 OR `props-main`.`id` = 1730578 OR `props-main`.`id` = 1735352 OR `props-main`.`id` = 1779042 OR `props-main`.`id` = 1790158 OR `props-main`.`id` = 1740703 OR `props-main`.`id` = 1745937 OR `props-main`.`id` = 1754679 OR `props-main`.`id` = 1755272 OR `props-main`.`id` = 1758361 OR `props-main`.`id` = 1761804 OR `props-main`.`id` = 1772053 OR `props-main`.`id` = 1746698 OR `props-main`.`id` = 1729149 OR `props-main`.`id` = 1772163 OR `props-main`.`id` = 1687493 OR `props-main`.`id` = 1772962 OR `props-main`.`id` = 1780848)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls41151100' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-13' 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.
