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

1271 Deer Creek
Dubuque, IA 52003

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,140,000
Beds: 5
Baths: 5
Status: Active
SqFt: 3592
Agency: American Realty of Dubuque, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2017
Notes: This elegant 2-story home has been gently lived in and offers all the amenities you would expect in new construction. The light filled living room welcomes you with wide plank wood floors, soaring coffered ceilings, soothing wall color and white trim. Those wood floors run throughout the main floor, and there are built-ins everywhere! A well-planned kitchen boasts custom cabinets with rollouts everyway, professional level stainless appliances, including a warming drawer, and a butler's pantry with floor to ceiling built in cabinetry and a pocket door. An airy family room with fireplace and bar adjoins the kitchen and accesses a maintenance free deck with an outdoor gas fireplace. There's also a main floor primary bedroom with a fireplace and adjoining luxury bath and closet plus laundry facilities. You'll find a dedicated office space just off the entry foyer. The second floor presents 3 large bedrooms, and 2 full baths, both elegantly and timelessly tiled. A large craft room/sewing room adjoins a third bedroom. The upper level also contains a 10x8 laundry room with built in cabinetry. Moving to the lower level you will find a fifth bedroom with walk-in closet and another gorgeous bath, BIG family room, built in bar and light filled workout room that is multi-purpose. The .53-acre lot has a sprinkler system, and an attached 3 car garage will accommodate you and the family. Located on a quiet cul-de-sac, this elegant property is offered for sale at $1,140,000.
MlsNumber: 149007


Listing Provided By: American Realty of Dubuque, Inc., original listing
Name: American Realty of Dubuque, Inc.
Phone: (563) 599-0711
Office Name: American Realty of Dubuque, Inc.
Office Phone: (563) 556-4577
Agent Name: Jane O'Neill
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