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

170 Sierra Colina Drive
Stateline, NV 89449

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,975,000
Beds: 3
Baths: 4
Status: Active
SqFt: 2208
Agency: Chase International South Tahoe Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2021
Notes: Modern Tahoe luxury! Beautifully appointed townhome where charm meets mountain elegance. This home is ready for you to move in as it comes fully furnished. Let the exterior greet you with the warmth of full shear paneling and cedar lap siding. As you enter in on the lower level you will be greeted by the large tiled foyer. As you continue on the first floor, you will find two spacious guest bedrooms with tufted wool carpeting, great closet space, a linen closet in the hall and the lower-level bath offering a bath/shower combo with elegant tile and silestone countertops.As you ascend to the upper living area you will feel the openness of the magnificent 19ft cathedral arched ceilings over the kitchen and dining area, highlighted by the large custom wood framed windows, taking full advantage of the natural light. Enjoy sitting by the welcoming floor to ceiling rock encased gas fireplace to cozy up next to on those chilly Tahoe nights. The great room, kitchen and upstairs hall floors are adorned with Laguna hard wood oak flooring. Relax on the picturesque deck to enjoy forested views and world renown Tahoe sunsets. The deck features plumbed in gas for your BBQ and a hot tub is ready to be installed as there are already hot tub hook ups in place. The kitchen is a true chef's delight. Surrounded by plenty of custom maple cabinetry and Silestone quartz countertops with elegant finishes. The large pantry is adorned with a custom barn door across from the island. Top of the line kitchen appliances include a Wolf dual fan gas range and wall hood, Wolf microwave drawer, Cove stainless steel dishwasher and a beautiful Subzero stainless steel French door refrigerator. All of this and more allows you to entertain your family and friends with delicious delights.The capacious primary bedroom also located on the main floor features cathedral ceilings, tufted wool carpeting and a generous walk-in closet to keep all your seasonal Tahoe clothing and as the living room, this room is also highlighted by stunning window placement. The primary suite bathroom offers heated tile flooring, a stunning freestanding soaking tub, stall shower also highlighted by custom tile, a dual sink vanity embellished with a quartz counter top, and a private enclosed toilet water closet. Also, on the second level you will find a very spacious full laundry room with its own sink as well as ample shelving and cabinetry. Adjacent to the laundry room includes an elegant powder room with artistic tiled wall impression.Additionally, this is an end unit so you have the privacy of one side of the residence with no neighbor next to you. All utilities are underground as to not block forest views. The two-car garage also include an additional storage closet for all of your Tahoe toys.Sierra Colina is a magnificent new planned unit development offering modern opulence!
MlsNumber: 140157


Listing Provided By: Chase International South Tahoe Realty, original listing
Name: Chase International South Tahoe Realty
Phone: (530) 544-2121
Office Name: Chase International - South Lake Tahoe
Office Phone: (530) 544-2121
Agent Name: Alora Reynolds
Disclaimer: Copyright © 2024 South Tahoe 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.


Local Real Estate Expert

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 = 1754 AND i.igate IN ('usahud','nvhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nvhud', 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;
Real Estate Expert Photo for Laura Moline
Laura Moline
ASCIIRE/MAX Gold
Call Today!: (775) 691-1126

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App