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

11477 N 250 W
Sumava Resorts, IN 46379
Amanda McDonnell with Northwest Indiana Real Estate, original listing - (219) 696-9600

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $235,000
Beds: 7
Baths: Full: 2, ½: 2, ¾: 2
Status: Pending
SqFt: 5264 Square Feet
Agency: Northwest Indiana Real Estate
Agency Phone: (219) 696-9600

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1942
Notes: Here it is! The MULTI UNIT you've been waiting for! Nestled in the heart of Sumava Resorts is this FIVE unit building. The commercial storefront is currently rented to the USPS and the four residential units are ready for tenants! This property has been in the same family since it was built and is on the market for the first time! The post office is a basic commercial storefront with a 1/2 bath. The DOWNSTAIRS UNIT of the main house features a large eat-in kitchen, living room, 2 bedrooms, an office/bonus room, and an updated full bath. The UPSTAIRS UNIT offers a large eat-in kitchen, living room, 2 bedrooms, 3/4 bathroom, and both an exterior and a shared interior entrance. The SMALLER UNIT to the South hosts 1 large bedroom, an eat-in kitchen, 3/4 bathroom, and living room. The final unit (NORTH APT) is the larger of the two, and has many updates! It offers 2 spacious bedrooms, large living room, kitchen with plenty of cabinetry, designated dining area, 1/2 bath and a full bathroom. In the center of all the units is the community laundry room with an interior entrance for two of the units, and an exterior entrance for the other two. The building sits on just over a half acre and was recently surveyed. There are three septic systems and one well between all the units. Property taxes are just over 1k annually for both parcels! The possibilities are endless with this property whether you want to become a landlord or have a family compound. Come take a look!
MlsNumber: --
ListingId: 810422


Listing Provided By: Northwest Indiana Real Estate, original listing
Phone: (219) 696-9600
Office Phone: (219) 696-9600
Agent Name: Amanda McDonnell
Disclaimer: Copyright © 2025 Greater Northwest 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