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

36700 S Hwy 52
Bellevue, IA 52031

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $389,900
Beds: 4
Baths: 3
Status: Active
SqFt: 1904
Agency: Duggan/Iowa Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential
Year Built: 1979
Notes: Charming Property St Donatus: 4-Bedroom, 3-Bathroom Home with Breathtaking Views, 4.33 Acres, Stone 2-Sided Hanselman Fireplace, and Detached 4-Car Garage. Welcome to living at its finest! Situated just south of St Donatus, this remarkable property offers everything you've been searching for and more. From stunning views, this is a place you'll be proud to call home. Property Features: • Captivating Views: Enjoy panoramic vistas of the surrounding countryside from the comfort of your own home. Whether you're relaxing on the deck or lounging by the fireplace, the views are sure to take your breath away. • Spacious Land: Spread out and make the most of 4.33 acres of lush, manicured land. Whether you're looking to indulge your green thumb with a garden oasis or simply enjoy the open space, the possibilities are endless. • Stone 2-Sided Hanselman Fireplace: Gather family and friends around the cozy warmth of the fireplace and enjoy its rustic charm. With its unique design and impressive craftsmanship, it's sure to be a focal point of your living space. • Luxurious Home: Step inside to discover a thoughtfully designed 4-bedroom, 3-bathroom home. From the Large kitchen to the spacious bathrooms, no detail has been overlooked. • Detached 4-Car Garage with Bath: Perfect for car enthusiasts or hobbyists, the detached garage offers ample space for parking, storage, or even a workshop, it's as convenient as it is practical. • Tranquil Setting: Escape the hustle and bustle of city life and immerse yourself in the peace and serenity of country living. Here, you'll find privacy, tranquility, and the perfect backdrop for making lasting memories. This is more than just a home—it's a lifestyle. Don't miss your chance to experience the epitome of luxury living in a picturesque setting. 2 Laundry areas, 1 up 1 down. Laundry up could be dinning room/bedroom.
MlsNumber: 149329


Listing Provided By: Duggan/Iowa Realty, original listing
Name: Duggan/Iowa Realty
Phone: (563) 556-2525
Office Name: Duggan/Iowa Realty
Office Phone: (563) 556-2525
Agent Name: Ronald Craff
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.


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 = 842 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;
Sarah Smith
ASCIIGeneric Real Estate
Cell: (241) 555-1812
Office: (241) 555-1776

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App