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

703 W 250 S
Hebron, IN 46341
John Schupp with SCHUPP Real Estate, original listing - (219) 696-3596

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $619,900
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2800 Square Feet
Agency: SCHUPP Real Estate
Agency Phone: (219) 696-3596

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1976
Notes: Serene country setting flanked by woods & wildlife - TOTALLY private yet seconds back to shopping and schools around the corner. LOADED w/Flora, detached FULLY FINISHED 2bay garage + shop + loft with extra guest parking. The curb appeal and exterior is 100% dialed in with a BRAND NEW Roof, 16k worth of top grade leaf guard gutters & down spouts. HVAC '12, HWH' 23, SEPTIC pumped '20&'25 Freshly painted Cedar siding and trim should last you another 5-7 years easy of no maintenance so you can spend the weekend projects customizing the decor to your personal flair. This Solid custom built home has a grand vaulted foyer and ALL ROOMS are BIG! Rec-Room to covered lanai also boasts a wood fireplace and room to enjoy the views feels like you're own private retreat. Super clean and VERY well maintained. Full poured finishable basement. Eat in Kitchen PLUS formal Dining (or office). 2nd front living room offers the all important buffer space every family needs and the bedrooms are super cool with architectural dormers accenting each and the Master Suite is staggering with its walk in closet plus 2nd/ 3rd, ensuite and sitting area. Vintage charm and character but mixed in with modern conveniences as well. 100% move in ready but again VINTAGE - immaculate condition and decor though wont fit everyone's pallet but that doesn't affect value it affects marketability & personal preference and those who CAN DO will see the equity when making it their own since priced to accommodate an easy 80k of updates and still be equity positive but really w/flooring, some fixtures/hardware changes & cabinets/counter-tops 40k is a more then ample budget. Solid wood trim/doors are fully paintable plus LOADS of neat features throughout to discover. Top of the line Kinetico softener PLUS Complimentary 1yr Warranty f/APHW. 7+ac 379x660 is a RARE find, Fenced rear and the garden shed since all of the xtra storage already would make a killer playhouse for the kids - Just wait till you see it! LOVE IT!
MlsNumber: --
ListingId: 817828


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


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 = 765 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