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

13150 N 71st Avenue
Mingo, IA 50168
Miranda Brockman with RE/MAX REAL ESTATE CENTER, original listing - 232-4663

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $175,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: RE/MAX REAL ESTATE CENTER
Agency Phone: 232-4663

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Your Dream Home Starts Here! Looking for the perfect place to build your dream home? Look no further than this 3.3-acre piece of land located at 13150 N 71st Ave NW, Mingo, IA. This beautiful property is just off a hard surface road, making it easy to access while still providing plenty of peace and quiet.With 3.3 acres, you'll have plenty of room to create the home you've always wanted, whether that's a cozy farmhouse, a spacious modern home, or something entirely unique. The land is open and ready for your ideas, offering the perfect canvas to design the home and outdoor space of your dreams.Imagine enjoying the beauty of the Iowa countryside every day, with plenty of space for a garden, a large yard, or even a small hobby farm. This land offers the freedom to build what you want, how you want it.Located in a great area, this property gives you the best of both worlds - the quiet of rural living with easy access to nearby towns and amenities. It's the perfect spot for those who want to enjoy the peace of the country while still being close to everything you need.Don't miss this chance to own a beautiful piece of land where you can create the home you've always dreamed of. Come see it today and start planning your future!
MlsNumber: --
ListingId: 65444


Listing Provided By: RE/MAX REAL ESTATE CENTER, original listing
Phone: (515) 231-8947
Office Phone: 232-4663
Agent Name: Miranda Brockman
Disclaimer: Copyright © 2024 Central Iowa Board of Realtors, 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