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

14009 W 81st Avenue
Dyer, IN 46311
Starla Van Soest with BHHS Executive Realty, original listing - (219) 663-1986

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $639,000
Beds: 5
Baths: Full: 3, ½: 2
Status: Active
SqFt: 4524 Square Feet
Agency: BHHS Executive Realty
Agency Phone: (219) 663-1986

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1956
Notes: Perhaps you are tired of city life and wish to retire to a country setting! Tired of extreme taxation! Indiana offers LOW TAXES capped way below any you will find in IL and yet this home is located just 1 MILE FROM IL BORDER! Also, just 4 miles from all major freeways to Illinois! SO close to everything, YET SO MUCH PEACE AND TRANQUILITY! Owners have not left any part of this home unturned! NEW EVERYTHING! Yet providing an ambiance of elegance and classic living! Picture yourself on the extensive wrap-around deck with a drink in hand watching and experiencing nature in the shade of the elegance of a mature Oak Tree and all its grandeur! If a home with over 4500 FINISHED SQ FT on 3 levels with brand new flooring appeals to you, THIS HOME MAY BE FOR YOU!! Do you like vintage trim, crystal chandeliers and lighting with modern conveniences, this home may be just the one you are looking for! BRAND NEW KITCHEN WITH BEAUTIFUL GRANITE COUNTERTOPS, ISLAND, SOFT CLOSE CABINETS, NEW APPLIANCES AND A SPACIOUS DINING, this may be your perfect home! You NEED 4+bedrooms and 5 bathrooms? Yes, it's here! Unique to its time of construction, bedrooms offer BUILT-IN DRAWERS! Do you recall when homes were built and used every inch of the space? CLOSETS ARE ABUNDANT! You grow weary and need to soak, look no farther, relax in a walk- in bathtub or a jacuzzi bathtub!! Main level living is very efficient and allows for handicap accessibility with the ramp at the front entrance and a main floor master Suite and laundry.. all the additional space could be related living or for entertaining! A Fully finished lower level offers a wealth of opportunity! Looking for an at home gym, media room, home office or just simply an extra place to relax, THIS IS THE HOME FOR YOU! Outdoors is your thing? Certainly, the WALK-OUT BASEMENT to a beautiful brick patio will be the ideal focal point for the social barbeque! Be sure to put this one on your list to view! An amenity list is available!
MlsNumber: --
ListingId: 810276


Listing Provided By: BHHS Executive Realty, original listing
Phone: (219) 746-2693
Office Phone: (219) 663-1986
Agent Name: Starla Van Soest
Disclaimer: Copyright © 2024 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.


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 = 3310 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;
Real Estate Expert Photo for Sonia Diaz, #RB14038892
Sonia Diaz, #RB14038892
ASCIIElite Source Realty, Inc.
Call Today!: (219) 406-2396

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App