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

1458 Cedar Trail
Dubuque, IA 52003

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,095,000
Beds: 5
Baths: 3
Status: Pending
SqFt: 2156
Agency: Ruhl & Ruhl Realtors

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2023
Notes: Modern meets rustic charm in this brand new construction farmhouse! Situated on a beautiful, wooded 0.67 acre lot in South Pointe near the end of a cul-de-sac, this home offers the perfect, peaceful setting! Built by Cedar Ridge Construction, this walkout ranch features several custom upgrades and offers 5 bedrooms, 3 bathrooms, and a 7 car garage- 3 car garage up and a 4 car capped garage below. This home is ahead of its time with a comprehensive Brilliant Smart Home System that allows you to control lighting, audio, thermostat, doorbell cameras, voice control & more from the touch of your smartphone. An open & inviting main floor plan that seamlessly blends modern sophistication with farmhouse warmth. Wooden ceiling beams, sleek, black windows & cabinetry, gas fireplace with a rustic mantle, and an abundance of windows that showcase the breathtaking views of the serene, wooded backyard! The luxurious eat-in kitchen is equipped with top-of-the-line stainless steel appliances, custom cabinetry, farmhouse sink, floating shelves, and best of all… a huge hidden pantry! The master suite is like your own private oasis with a tiled shower, dual vanities, great cabinet space, and a walk-in closet. Spend your time on the large, covered deck and bask in the mature trees and beautiful foliage. Other upgrades include landscaping, sodded yard, irrigation system, capped garage, 2 EV hookups in the garage, tons of storage, and a massive capped stoop that could make a perfect wine cellar! Soak in all the amenities of South Pointe- swim, kayak, or paddle board in the lake, and stroll along the walking paths! Don't miss your opportunity to make this modern farmhouse your forever home. With its upgraded features, smart technology, and timeless design, it's the epitome of luxury and comfort. Schedule a tour today and start living the life you've always dreamed of!
MlsNumber: 148147


Listing Provided By: Ruhl & Ruhl Realtors, original listing
Name: Ruhl & Ruhl Realtors
Phone: (563) 583-4550
Office Name: Ruhl & Ruhl Realtors
Office Phone: (563) 583-4550
Agent Name: Aaron Healey
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