Listing Agent: Brenda Ernst, Coldwell Banker Mother Lode RE
Charming Extravagant home in Christian Heights. main home plus a guest house. Main home has 4 bedrooms, 2 & 1/2 bathrooms. Huge kitchen that any chef would love. Large cook top, double ovens, oversized island that will sit six and store wine, lots of counter space and a pantry. This comfortable livingroom has a floor to ceiling rock fireplace with gas logs. Primary suite has entrance to the side yard and the primary bath has a handicap shower. This back yard has a infinity pool and hot tub. There are several entertainment areas around the pool and a outdoor shower. The guest house is one level and a small bedroom, full bathroom, kitchen and plenty of room to entertain also covered porch. This overlooks the pool and patio area. The property is beautifully landscaped with paths that meander through the garden areas, storage shed, pens for animals and several more areas to entertain. The property is totally private with wonderful views of the mountains while just minutes from shopping. You will have solar along with a Generack Generator.
Property Sub Type
Single Family Residence
Year Built
2000
Levels
One
Price Per Square Foot
$489
Days On London
27
Cumulative Days On London
39
County Or Parish
Tuolumne
New Construction Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Cross Street: Joshua Way.
Architectural Style
Ranch
Heating
Solar
Cooling
Central Air
Laundry Y/N
Yes
Roof
Shingle
Construction Materials
Wood Siding, Concrete
Other Structures
Guest House
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Bathrooms Half
1
Room Kitchen Features
Tile Counters, Kitchen Island, Butler's Pantry
Eating Area
Breakfast Counter / Bar
Appliances Y/N
Yes
Appliances
Solar Hot Water
Accessibility Features
Disability Features
Flooring
Tile, Carpet, Wood, Laminate
Fireplace Y/N
Yes
Fireplace Features
Living Room
Pool Features
In Ground, Pool Cover
Pool Private Y/N
No
Patio Y/N
Yes
Patio And Porch Features
Patio
Parking Y/N
Yes
Parking Total
3.00
Parking Features
Garage, Covered, Carport, Garage Door Opener
Attached Garage Y/N
Yes
Garage Spaces
3.00
Lot Features
Sloped Down, Sprinklers Timer, Front Yard, Garden, Back Yard, Secluded, Yard
Lot Size Area
87555.0000
Lot Size Units
Square Feet
Sprinklers Y/N
Yes
Parcel Number
056610027
Zoning
RE2
Association Y/N
No
High School District
Sonora Union
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1187500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1312500 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) >= 2304 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2804 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` = 1728644 OR `props-main`.`id` = 1727352 OR `props-main`.`id` = 1731222 OR `props-main`.`id` = 1717598 OR `props-main`.`id` = 1730774 OR `props-main`.`id` = 1735032 OR `props-main`.`id` = 1727339 OR `props-main`.`id` = 1730227 OR `props-main`.`id` = 1732906 OR `props-main`.`id` = 1728092 OR `props-main`.`id` = 1728616 OR `props-main`.`id` = 1734170 OR `props-main`.`id` = 1728635 OR `props-main`.`id` = 1730773 OR `props-main`.`id` = 1731062 OR `props-main`.`id` = 1730788 OR `props-main`.`id` = 1696230 OR `props-main`.`id` = 1732904 OR `props-main`.`id` = 1727435 OR `props-main`.`id` = 1729885 OR `props-main`.`id` = 1733217 OR `props-main`.`id` = 1730580 OR `props-main`.`id` = 1727431 OR `props-main`.`id` = 1712458 OR `props-main`.`id` = 1730578 OR `props-main`.`id` = 1731138 OR `props-main`.`id` = 1730789 OR `props-main`.`id` = 1729149 OR `props-main`.`id` = 1732370 OR `props-main`.`id` = 1729891)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls41133377' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-10' 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.
