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

516 S Ninth Avenue
Haubstadt, IN 47639
John Czoer with FIRST CLASS REALTY, original listing - (812) 475-2000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $249,888
Beds: 3
Baths: Full: 2
Status: Pending
SqFt: 1424 Square Feet
Agency: FIRST CLASS REALTY
Agency Phone: (812) 475-2000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Condominium
Year Built: 2010
Notes: Welcome to this fantastic 3-bedroom, 2-bath condo in the desirable Haubstadt area. Spacious living room features a vaulted ceiling and beautiful hardwood floors, seamlessly flowing into the kitchen and dining area. The kitchen offers plenty of cabinet storage and countertop space, along with a large breakfast bar that’s perfect for casual meals or gathering with friends. Just off the kitchen, you’ll find a convenient pantry and a laundry room located just steps from the attached 2-car garage. The layout includes two bedrooms at the front of the home, separated by a full hall bath—perfect for guests or an office. The primary bedroom features its own full bath with a spacious vanity, tile flooring, and a walk-in shower for easy access. One of the highlights of this condo is the heated and cooled all-seasons room, providing extra living space year-round. It’s the perfect spot to relax with a book, enjoy a cup of coffee, or take in the peaceful views of the open farmland behind the home. With no neighbors directly behind you, the setting feels private and serene. The driveway offers plenty of parking, and the location is within walking distance of grocery stores, banks, and retail shopping, with great restaurants nearby. This low-maintenance home includes an HOA fee of $120 per month, plus an additional $23.39 per month for the reserve fund, totaling $143.39. This covers exterior maintenance, snow removal, lawn care, and exterior insurance, making life a little easier. Well-maintained, spacious, and perfectly situated, this condo offers a lifestyle of comfort and convenience in Haubstadt.
MlsNumber: --
ListingId: 202510732


Listing Provided By: FIRST CLASS REALTY, original listing
Phone: (812) 457-1432
Office Phone: (812) 475-2000
Agent Name: John Czoer
Disclaimer: Copyright © 2025 Southwest Indiana 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