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

18263 Keswick Court
Parker, CO 80134

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $850,000
Beds: 4
Baths: 3
Status: Pending
SqFt: 3958
Agency: Keller Williams Realty DTC, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2013
Notes: Nestled in the heart of Parker, this stunning former model home is located on a cul-de-sac in the extremely desirable Horseshoe Ridge Community. Discover an enclave of design and comfort where the blend of luxury and homeliness creates a sanctuary for the senses. Picture warm, earth-toned hues greeting you as you traverse on the gleaming hardwood floor from the front entry through the living room to the kitchen. An entertainer's dream, the gourmet kitchen is adorned with upgraded slab granite countertops, a large island, a 5-burner gas cooktop, double ovens and stainless steel appliances. Some of the designer touches include coffered ceilings in the living room, dining room and primary bedroom. The primary bedroom is enveloped in soothing colors, that promise restful slumber. The ensuite 5-piece primary bathroom has a blend of elegance and function with its tasteful accents and a generous space walk-in closet. French doors off the hallway open into a dedicated office space, complete with built-in bookshelves, providing a quiet spot for work or study. Rounding out the main level is another bedroom and a full bath with dual vanities. The professionally finished basement has a spacious family room to watch movies or play board games. It also has 2 more bedrooms, a 3/4 bathroom and a storage area. The oversized 3-car garage is drywalled and provides ample room for vehicles, storage or even a workshop. A new hail-resistant roof and new exterior paint were just completed in 2023. Trails and parks surround the neighborhood providing the perfect Colorado lifestyle. Walking distance to Salisbury Sports & Equestrian Park and Cherry Creek trails. With easy access to Main Street in Downtown Parker, Reuter-Hess Reservoir, and I-25, this is home is ideally situated. Imagine your life in this sanctuary, where every day is a new opportunity to create lasting memories. This is not just a home; it's the next chapter in your story. We welcome you to experience the allure first-hand.
MlsNumber: 9380916


Listing Provided By: Keller Williams Realty DTC, LLC, original listing
Name: Keller Williams Realty DTC, LLC
Phone: (303) 771-7500
Office Name: Keller Williams DTC
Office Phone: (303) 771-7500
Agent Name: Kirk Wodell
Disclaimer: Copyright © 2024 REcolorado. 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 = 263 AND i.igate IN ('usahud','cohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cohud', 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 Cindy Rein
Cindy Rein
ASCIISherlock Holmes
Call Today!: (720) 272-4890

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App