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','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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','txhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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','txhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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;

23 Red Tail Court
Copperopolis, CA 95228

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $896,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2085
Agency: RE/MAX GOLD - COPPEROPOLIS

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2022
Notes: Welcome to 23 Red Tail Ct., a custom home located on a cul-de-sac nestled within the picturesque Copper Valley Golf Community. This newly constructed home has been meticulously crafted with a focus on maximizing both the stunning natural surroundings and functionality. You will immediately notice the thoughtful design elements aimed at enhancing light. The house boasts a sub flooring foundation ensuring stability and durability. For the car enthusiast or outdoor adventurer, the expansive 4 car tandem garage awaits complete with a 11'high garage door and 40'depth.There is a convenient 50 AMP plug ideal for RV charging. Also a Generac Full house automated generator powered by propane. Security and peace of mind are evidenced by the 4 camera NVR wired system. Inside there are premium finishes with Quartzsite and Quartz countertops, GE Profile appliances, LVP Flooring and beautiful craftsman cabinetry. In addition there are 2 sun tubes illuminating the hallways, ceiling fans in all bedrooms and living room, extra interior wall insulation, tankless water heater, RO Water system in the kitchen.The primary bath has a no step walk in shower for easy accessibility. Step outside on the expansive deck to soak in the views. Plenty of space for your patio furniture, bbq equipment, spa and plants. With it's blend of upscale amenities, energy efficient features and unparalled views, this Copper Valley gem offers a lifestyle of tranquility and sophistication. The community offers a sports club and golf membership. There are events and clubs to explore. Only a short distance from Lake Tulloch to enjoy water sports. Wineries, shopping and small towns to explore through the foothills.
MlsNumber: 202400137


Listing Provided By: RE/MAX GOLD - COPPEROPOLIS, original listing
Name: RE/MAX GOLD - COPPEROPOLIS
Office Name: RE/MAX Gold - Copperopolis
Office Phone: (209) 753-0410
Agent Name: Cindy Neiman
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