Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 187 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 187 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 187 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

20045 Jesus Maria Road
Mokelumne Hill, CA 95245
Rochelle Popovits with RE/MAX Grupe Gold, original listing - (209) 334-3855

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $495,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1433 Square Feet
Agency: RE/MAX Grupe Gold
Agency Phone: (209) 334-3855

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1968
Notes: Beautiful 5 Acre Charming Home Take In The Butte Views & Fresh Mountain Air Cute Country Kitchen W/Pantry Lots Of Cabinets Window Stay Warm By The Fire While You Enjoy The Cozy Living Room Primary Bedroom Has Walk In Closet Lots Of Storage Space Garage Converted Into Bedroom High End & Capacity Dual Water Heater 3 AC Units Pantry Wash Room 3 Separate Cross Fenced Pastures 3 Separate Pads Wide Hallway Screened In Patio Round Pen Separate Road In The Back For Possible Guest Entrance Separate Road To Get To The End Of The Property 2 2,500 Water Tank Animal Shelter Chicken Coop Such A Great Home & Property Bring Your Horses & Livestock To Create Your Country Lifestyle Located Just 20 Minutes From Hospital Shopping In San Andreas Great Location Fantastic Setting Privacy Small Town Life Don't Miss This Unique Piece Of Property In Beautiful Calaveras County Nestled Upon Usable Land Comfortable & Spacious Living Vast Acreage 100% Usable For Your Recreational Toys Endless Opportunities While Embracing Breathtaking Nature Essential Amenities Including Electrical Capacity Septic Tank & System W/Water Well Are All In Place Ensuring Your Visions Into Reality Don't Delay Seize The Chance To Make This Serene Versatile Property Yours Today Let Your Imagination Flourish On This Idyllic Canvas Of Property Perfect Place To Call Home Live Here Full Time Or Make It Your Vacation Retreat Comfortable Living Outdoor Enjoyment This Expansive Property is Plant Your Dream Garden Raise Livestock Or Build A Spacious Workshop For Your Home Based Business Warm & Inviting Bedrooms Are Thoughtfully Positioned Entertain Or Lounge Minutes From The Historical Town Of Mountain Ranch Situated In The Foothills Of Calaveras County The Topography Of The Land Varies Big Potential To Be Your Little Paradise
MlsNumber: --
ListingId: 202400942


Listing Provided By: RE/MAX Grupe Gold, original listing
Phone: (209) 334-3855
Office Phone: (209) 334-3855
Agent Name: Rochelle Popovits
Disclaimer: Copyright © 2024 Calaveras County Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App