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 = 242 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 = 242 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 = 242 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;

23607 Porcina Way
Columbia, CA 95310
Avery Bryant with Coldwell Banker Twain Harte, original listing - (209) 586-5200

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $650,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2591 Square Feet
Agency: Coldwell Banker Twain Harte
Agency Phone: (209) 586-5200

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1978
Notes: Welcome to the hummingbird house! Move-in ready home with custom features. Set on a spacious 1.16-acre lot with an oversized detached two-car garage, this well-maintained 3-bedroom, 2.5-bathroom home offers 2,591 sq ft of living space and breathtaking views from the large composite deck perfect for enjoying stunning sunrises. Enter through a rod iron gate to find a charming courtyard with a porch swing, water fountain feature, and stamped concrete creating a relaxing oasis for you to enjoy. Notice the stained glass entry windows, gorgeous hardwood flooring that pairs nicely with open beam knotty pine ceilings, a custom remodeled kitchen with upgraded stainless steel appliances, a tiled kitchen island, a pantry with lighted glass cabinetry offering ample storage. Speaking of storage, you'll be delighted with the abundance of storage options throughout the home! The main-level primary bedroom has access to the deck, double walk-in closets, and more beautiful views. Additional features include a central heat/air system and a cozy wood stove with a custom stone hearth adds to the home's charm. A bonus room with a murphy bed and built-in desk and upgraded mini-split heat/air is perfect for guests or a home office with a separate entrance leading to the 2-car garage with plenty of space for a shop. The yard, lovingly maintained by a master gardener with a drip system, is sure to delight with its vibrant springtime blooms and an abundance of birds and butterflies. Rest easy knowing the roof and deck have both been recently replaced! Minutes away from the beloved Columbia Historic State Park with restaurants, shopping, and family fun! Come experience this home's warmth and charm for yourself!
MlsNumber: --
ListingId: 202500192


Listing Provided By: Coldwell Banker Twain Harte, original listing
Phone: (209) 586-5200
Office Phone: (209) 586-5200
Agent Name: Avery Bryant
Disclaimer: Copyright © 2025 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