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

1640 N 1420 W Road
Linton, IN 47441

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $370,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2061
Agency: Century 21 Scheetz

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential
Year Built: 2000
Notes: Charming modern country home with so many amenities on close to 11 acres. This spacious home has 3 bedrooms, plus a large bonus room that has been used as an office but can easily be converted into a 4th bedroom. The Master Bedroom Suite is truly unique in that it offers a double-sided fireplace with a sitting area on the other side to relax and enjoy. Tray ceilings up above, a huge walk-in closet w/a nice vanity area. The Master Bath has a large walk-in tile shower w/ dual shower heads. The Kitchen is the show stopper with large solid wood custom cabinets, a large pantry, built in spice racks and wine rack. The kitchen has a beautiful large center island with solid surface Corian countertops and stain steel appliances. For even more storage there is a Butlers Pantry just off the kitchen. The open concept allows for a great space to entertain. The home has an abundance of windows to allow in lots of natural light. You will notice the unique flooring is actually stained concrete which has a beautiful finish and allows for easy clean up. Besides the one car attached garage there is a large two car detached garage with a work shop and an 800sq ft unfinished 1 bedroom / 1 bath apartment up above. The apartment is partially complete and just needs the living room and kitchen finished. Just outside the backdoor is an in ground storm shelter for bad weather. With all the acreage comes a barn w/ 4 stalls and feed room. Attached to the barn is a new green house and nearby you will find 4 deluxe chicken coops. Most of the 10.90 acres is fenced pasture with a small pond and a creek which runs through the property. There are several grape vines growing that should produce fruit this year. In addition to grapes you will find strawberries, blackberries, raspberries and pecan trees. This property has so much to offer, don't let it pass by.
MlsNumber: 202407580


Listing Provided By: Century 21 Scheetz, original listing
Name: Century 21 Scheetz
Phone: (317) 844-5111
Office Name: Century 21 Scheetz - Bloomington
Office Phone: (812) 336-2100
Agent Name: Tracy J. Young
Disclaimer: Copyright © 2024 Bloomington MLS, Inc. 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