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

545 S Nelson Street
Lakewood, CO 80226

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,500,000
Beds: 4
Baths: 4
Status: Active
SqFt: 4200
Agency: Keller Williams Advantage Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1972
Notes: Seller offering 2/1 buydown concession to Buyer, potentially saving up to $1500 a month 1st year of payments, ask agent for more info. Welcome to Your Dream Home in Coveted Glennon Heights, Lakewood! Escape the ordinary and embrace luxury living in this semi-custom ranch home nestled in the heart of Lakewood. With a six-car garage plus RV/boat parking, this home is a haven for car enthusiasts & outdoor adventurers alike. Step into a world of elegance & comfort as you explore the meticulously maintained half-acre yard w/ breathtaking views of downtown Denver. Entertain guests effortlessly in the open & inviting main floor plan, perfect for gatherings. Indulge your inner chef in the gourmet kitchen boasting custom cherrywood cabinetry, a 48" Dacor dual fuel range with a steamer, Bosch dishwasher, Electrolux stainless refrigerator, & stunning granite countertops. French doors lead to the back patio oasis, complete w/ a tranquil water feature & expansive Timber Tek deck pre-wired for speakers, TV, & an outdoor kitchen, offering the ultimate Colorado outdoor living experience. Experience unparalleled relaxation in not one, but two primary bedroom suites—one on the main floor & another in the basement. The basement retreat features a secluded master suite connected to a private reading sun-soaked room. Pamper yourself in the attached spa-like primary bathroom w/ radiant floor heating, custom shower, & jacuzzi tub. Need versatility? Transform the space into a Jack & Jill bedroom setup, utilizing the adjacent office room. Entertainment knows no bounds in the basement, where a game room, wet bar, & fully custom theater room await. Immerse yourself in cinematic magic with padded walls, surround sound system, 120" movie screen w/ projector, & plush seating. Convenience is key with proximity to Glennon Heights pool & park, biking & hiking trails. Enjoy easy access to 6th Avenue, I-70, and C-470, putting downtown Denver & the majestic Foothills & Mountains just minutes away.
MlsNumber: 4510355


Listing Provided By: Keller Williams Advantage Realty, original listing
Name: Keller Williams Advantage Realty
Phone: (303) 986-4300
Office Name: Keller Williams Advantage Realty LLC
Office Phone: (303) 986-4300
Agent Name: Mikelle Smith
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 = 275 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;
Chris Thompson
ASCII5281 Exclusive Homes Realty
Call Today!: (720) 364-8686

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App