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

10906 N 300 E
Wheatfield, IN 46392
Emily Coffer with SCHUPP Real Estate, original listing - (219) 696-3596

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $774,900
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2144 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: 2019
Notes: Home built in 2019 with walkout basement, sitting on 10 acres, including a 46x72 FINISHED POLE BARN and 1.5 acre stocked pond is waiting for you to call it home! This is what everyone is looking for. Upon pulling up to the property, you will notice that the home is tucked away up on a hill hidden by a tree line. Perfect natural privacy fence. Property offering a total of 10 acres includes five in the front of the home and five behind. As you pull up to the home you'll notice the landscaping offering views of the barn along with the pond and tree line on back and side. As you enter the property under the covered porch, the open concept space welcomes you. Large great room includes gas fireplace, 9' ceilings throughout the main floor, views to the large eat in kitchen which includes granite counter tops and large island, dining area, along with access to the covered back porch, giving perfect view of the property and pond to enjoy the gorgeous sunsets. Split floor bedroom layout. Spare rooms are nice size, full spare bathroom offers two separate vanities and a separate space for toilet and shower. Primary bedroom offers his and her walk in closets, along with a HUGE bath which also includes a corner tub. Basement is already framed and ready to be finished, including another bedroom, full bath, large living space and extra storage. Heading out of the walk out basement, and into the ENORMOUS 46x72 Pole Barn which includes a 12x16 overhead door, 2 additional 10x10 overhead doors, and 2 service doors for easy access. You'll also notice the radiant heat source along the top, perfect for working year round, barn also has its own 200 AMP service, and also offers its own bathroom and is setup for a shower to be installed if you like. You can't beat what this property gives. If you are looking for privacy, acreage, gorgeous views, fishing in your own back yard, and a barn for all of your hobbies, this is for you!
MlsNumber: --
ListingId: 818639


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