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

2088 Legacy Heights
Durango, IA 52039

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $799,900
Beds: 4
Baths: 4
Status: Pending
SqFt: 3656
Agency: Remax Advantage Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2019
Notes: Spacious and luxurious are the perfect words to describe this breathtaking two-story home built in 2019, boasting over 5,000 square feet of meticulously finished living space, nestled on a generous 1.2-acre lot. The property showcases four bedrooms, three full bathrooms, plus a powder room, alongside a fully finished basement that offers direct access to a beautiful level backyard. It's equipped with a three-car garage at the main level and an additional three-car capped garage with a single-stall door at the lower level, presenting a perfect setup for a workshop, home fitness center, or storage for recreational vehicles. The heart of the home on the main floor features an open-plan kitchen and living space with an abundance of natural light, inviting beautiful countryside views. The kitchen is a chef's dream, with dual ovens, a gas cooktop, and a spacious island that caters to all your culinary and entertaining needs, complemented by a cozy breakfast/coffee nook and a hidden walk-in pantry. Walking up to the second floor, you'll discover three generous sized bedrooms, including a magnificent owner's suite that offers stunning views and ample room to relax and rejuvenate. The lower level features a newly completed basement designed for entertaining and connects seamlessly to the outdoor area for versatile indoor-outdoor gatherings. This space consists of a custom bar/kitchenette area, spacious family room, fourth bedroom, fifth non-conforming bedroom currently serving the purpose of a playroom and offers a practical storage solution in the three-car capped garage. Seize the opportunity to make this splendid home yours by contacting your real estate agent promptly. *This home is conveniently located across the street from Sundown Mountain, is a few short minutes from Meadows Golf Course, is serviced by city of Asbury utilities and is located within Dubuque Community School District.
MlsNumber: 149017


Listing Provided By: Remax Advantage Realty, original listing
Name: Remax Advantage Realty
Phone: (563) 588-3078
Office Name: Remax Advantage
Office Phone: (563) 588-3078
Agent Name: Jamie Blake
Disclaimer: Copyright © 2024 East Central Iowa 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