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

911 South Zeno Way
Aurora, CO 80017

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $275,000
Beds: 2
Baths: 2
Status: Active
SqFt: 982
Agency: NextHome, Inc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1999
Notes: Home, sweet home! Modern living meets comfort and convenience in this charming 2-bed, 2-bath condo unit. The cozy front porch is not only for relaxing but also an ideal spot for grilling. Come inside to find a desirable open layout that seamlessly integrates the living area, adorned with a fireplace, creating a warm and inviting atmosphere. The kitchen boasts stainless steel appliances, track lighting, wood cabinetry, and a 2-tiered counter with a breakfast bar. Newer paint throughout the property adds a fresh & contemporary feel, complemented by the tile and wood-look flooring that extends across every room, ensuring a carpet-free environment for ease of maintenance. The primary bedroom provides a walk-in closet and a private full bathroom. The unit is equipped with a newer washer and dryer for enhanced practicality, simplifying your daily routines. Parking is a breeze with a detached 1-car garage (#113) and a reserved parking space (#27)! These features add valuable storage and parking options to this home. Residents of Foxdale Condominiums have access to an array of amenities! These include a clubhouse, guest parking, a pool, and a tennis court, all contributing to a vibrant & active lifestyle. With its proximity to major highways I-225 & E 470, the Aurora Mall, and Buckley Air Force Base, the location of this condo offers unparalleled convenience for shopping, commuting, & entertainment. Don't miss this great opportunity! Security First Financial, my preferred lender, is offering a 1 YEAR 1% RATE BUYDOWN to a qualified buyer with an acceptable offer and successful closing. For details, please contact Nick Barta by cell at 303-709-9625 or email at [email protected].
MlsNumber: 4784104


Listing Provided By: NextHome, Inc, original listing
Name: NextHome, Inc
Office Name: NextHome Front Range
Office Phone: (303) 356-9356 x3033356528
Agent Name: Kathryn Rau
Disclaimer: Copyright © 2024 NextHome, Inc. 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