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;

2780 Chinook Way
Arnold, CA 95223
Chris Colvard with Calaveras Real Estate, original listing - (209) 206-6537

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $865,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2643 Square Feet
Agency: Calaveras Real Estate
Agency Phone: (209) 206-6537

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2021
Notes: Nestled among majestic pines and cedars, this stunning 2021 custom-built home perfectly fuses modern elegance with mountain tranquility in the heart of Big Trees Village. Featuring 3 bedrooms and 2.5 baths, this home sits on a spacious lot, offering ample room for outdoor activities and peaceful relaxation amidst nature's beauty. The gourmet kitchen is a true highlight, boasting custom cabinetry, a large center island, sleek stainless steel appliances, and beautiful granite slab countertopsperfect for both casual meals and entertaining. The open-concept great room, with unobstructed views through expansive windows, is designed for comfort, complete with luxury vinyl plank flooring and a cozy gas log fireplace, creating a warm, inviting atmosphere for gatherings. The master suite, conveniently located on the main floor, offers privacy and comfort, while all bathrooms are finished with elegant tile flooring, enhancing the home's luxurious feel. Upstairs, a spacious rec room provides additional space for entertainment, relaxation, or hobbies. Other features include an oversized attached garage for all your recreational toys, low-maintenance composite decking for easy outdoor living, and pre-wired hookups for the included generator. This home offers the perfect blend of luxury, comfort, and functionality in a serene mountain settingideal for those seeking both adventure and relaxation.
MlsNumber: --
ListingId: 202401902


Listing Provided By: Calaveras Real Estate, original listing
Phone: (209) 206-6537
Office Phone: (209) 206-6537
Agent Name: Chris Colvard
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