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;

4953 W 1050 N
Lake Village, IN 46349
John Schupp with SCHUPP Real Estate, original listing - (219) 696-3596

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $549,900
Beds: 4
Baths: Full: 1, ¾: 1
Status: Active
SqFt: 2298 Square Feet
Agency: SCHUPP Real Estate
Agency Phone: (219) 696-3596

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1967
Notes: 2,298sf sprawling Ranch went through a full remodel and a BRAND new 546Ssf Master Suite addition w/a stellar walk-in closet, custom shower and bath and amazing knotty pine ceiling and barn door accents for the country flair this home deserves & exudes. Multiple outbuildings let alone TONS of space - 10.93Acres! But, the sellers are having to relocate so this expansive wooded wildlife estate is a clean slate to build your future. Great condition, Formal DR or 2nd LR + Basically ALL NEW custom kitchen w/granite tops, under cabinet lighting, crown, B/I secretary. in the last 10-12yrs basically ALL WAS DONE; Metal Roof, siding, electric, 2018 crawl insulation and damp proofing with mold treatment and transferable 20yr warranty, HVAC, windows plus FULL finished Laundry + Mechanical with added pantry cabinets and extra storage. High Speed Internet by SURFNET Now Available! AWESOME location across f/ Preserve +FAST access back to main roads / State Line & US 41 corridor to I65 for commuters. Rear patio overlooks the land. 2.93w/house + 8ac has SR 10 frontage is a home site of its own since on 2 parcels already - Looking for that lot to build a barn that counties wont allow on its own? Call for details and requirements but you can Build a Barn on the 8acres and in time sell the house and other off and keep the barn for yourself or plan another future homestead for family & friends. HORSES welcome and rear barn with dirt/stone floor is ideal for animals as well as water and electric at edge of the current sunflower field for future hot wire fencing and turn out pens galore. HUGE shop/garage is insulated and was heated. BONUS: GENERAC whole house Generator included + 2 Propane tanks stay and are owned so no rental $ there. A complimentary 1yr Warranty f/APHW is included too. Ready? Homes like this are FAR & FEW to come by let alone in a setting like this flanked by State Game Preserve + steps across to trails, river & hunting/trapping as well on your own estate!
MlsNumber: --
ListingId: 807405


Listing Provided By: SCHUPP Real Estate, original listing
Phone: (219) 696-3596
Office Phone: (219) 696-3596
Agent Name: John Schupp
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App