Title Page Background
DEBUG FN args: Array ( [0] => 242 [1] => [2] => [3] => agent ) BEFORE: Site: 242 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 242 Igate: njhud LocID: 242 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 242 AND i.igate IN ('cahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 242 [1] => [2] => [3] => lender ) BEFORE: Site: 242 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 242 Igate: njhud LocID: 242 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 242 AND i.igate IN ('cahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 242 [1] => [2] => [3] => other ) BEFORE: Site: 242 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 242 Igate: njhud LocID: 242 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 242 AND i.igate IN ('cahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

12590 Covington Rd
Sonora, CA 95370

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $569,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 1856 Square Feet
Agency: KW Sierra Foothills

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1985
Notes: PRICE IMPROVED! Columbia single level home + cottage on private 8.25 acres. The main house which has all been updated like new & spacious inside, with 1856 Sq.Ft., open floor plan with great room living, 3 bedrooms, 2 full baths, 980 Sq.Ft. 2 car garage/shop, & carport for 3 cars. The great room featuring huge area for living/dining/kitchen with soaring knotty pine ceilings & wood beam accents. There are many sliding glass doors, bringing in the great outdoors, to access all of the sprawling decks, & a cozy brick hearth with a pellet stove. White kitchen cabinets, are topped with beautiful natural quartzsite stone counters, Stainless appliances, & an Island for breakfast bar seating. Down the hall you will find the primary suite with sliding glass door leading out to the covered porch & the "Wow Factor" bathroom, featuring double sink marble vanity, freestanding tub, separate shower, & tile floors. The 2 guest bedrooms are large & inviting, & the guest bath features a marble vanity, tub/shower combo, & tile floors. Laundry hookups are located close to the bedrooms in the hallway. Central heat/air complete the picture along with public TUD water, PG&E power, propane, & 2 septic tanks. The cottage/studio is approximately a 400 Sq.Ft., all updated & was recently rented at $1,000 per mo. The main home sits on top of the hill, somewhat in the middle of the property with views of Phoenix Lake from the wrap around porch with many deck areas for entertaining and enjoying the views, & the peaceful, quiet times for morning coffee or an evening glass of wine. The Land is rolling & steep and offers a remote feeling but is only 10 mins. to downtown Sonora for shopping, restaurants, & Hwy 108 for an easy commute to the Central Valley or SF Bay Area. Columbia has a lot to offer with Columbia Junior College, Columbia Airport, The old gold mining town, Columbia State Park, & New Melones Lake for boating. Head up the Hill to Twain Harte, Pinecrest Lake, or Dodge Ridge for all Season Activies that Tuolumne County has to offer. Yosemite National Park is about 1 1/2 hours away.
MlsNumber: --


Listing Provided By: KW Sierra Foothills, original listing
Phone: (209) 588-6291
Office Phone: (209) 694-8077
Agent Name: Pam Holly
Disclaimer: Copyright © 2024 Tuolumne 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