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;

Lot 16 E Rose Street
Kentland, IN 47951
John Schupp with SCHUPP Real Estate, original listing - (219) 696-3596

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $32,900
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: SCHUPP Real Estate
Agency Phone: (219) 696-3596

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Land-Unimproved Land
Year Built: --
Notes: Welcome HOME to the Eastmere Estates! One of the lots left available and OVER 1/2 ACRE!! ...200x123 tucked away on an expansive corner/Cul-de-sac lot with no prying eyes peeking in your back windows due to the in place foliage & berms yet all the perks of city services, sidewalks and a quiet small town community atmosphere that is adorned with new construction (Brand new going in next door now) with appealing designs and character all minutes from down town shopping, schools and parks and a SNAP onto US41/24 for commuters. ALL BUILDERS & HOMEOWNERS all welcome as well as those looking to build we have a builder who will purchase the lot for you and also have multiple plans and pricing to choose from for an ALL IN ONE package PLUS NO MONEY down 100% financing available thanks to your federal government. Info is FREE, Price is CHEAP but days and weather is limited...this is our last lot available at the reduced price with these options in Kentland where you ONLY need an end loan. Got CASH? You can call all the shots then and build your own as you want. Ask an agent for details and to request your 2024-2025 Brochure package link to view it online (signing before 12/15/24 gets you 2024 pricing and moved in by Summer 2025) Covenants are online as well as the recorded plat. Minimum Build footprints of 1200sf for a ranch, 1350sf for 1.5-2 stories so ALL budgets should be able to be accommodated and still protect your investment with Hard surface drives, 25% masonry front, 5/12 roof pitch and front yard sod or hydroseed options on final. FULL City services available [ Natural gas, Electric, Sewer & Water]
MlsNumber: --
ListingId: 812126


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