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

201 W 4th Street
Lynnville, IN 47619-2079
Zach Holt with Whitetail Properties Real Estate, original listing - (217) 285-9000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $199,900
Beds: 4
Baths: Full: 1, ½: 1
Status: Active
SqFt: 1196 Square Feet
Agency: Whitetail Properties Real Estate
Agency Phone: (217) 285-9000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2001
Notes: Welcome to this delightful 4-bedroom, 1.5-bath ranch home nestled on a peaceful 0.25-acre lot in the perfectly located town of Lynnville. Built in 2001 and recently updated, this 1,196 sq. ft. property offers modern amenities with a touch of country charm. Step inside to discover an all-new eat-in kitchen featuring updated countertops, a sleek sink, and a new dishwasher, with a quaint screened pantry door adding a rustic touch. New luxury vinyl plank (LVT) flooring flows throughout the home, blending durability with style, while freshly painted rooms throughout and new installed toilets in both bathrooms provide a fresh, worry-free start. The home’s mechanics have been meticulously maintained, and the new metal roof promises decades of durability. A spacious crawlspace ensures easy access to all systems for your convenience. Outside, enjoy beautifully landscaped perennial plantings that enhance the home's curb appeal. Situated across from the Lynnville Cemetery, the location is both serene and convenient, with municipal water and sewer services from the town of Lynnville, electricity provided by Duke Energy, and Fiber internet from Mainstream. This property offers exceptional value, whether you're a first-time buyer or looking for a solid investment opportunity. Schedule your showing today and experience the charm of this Lynnville gem!
MlsNumber: --
ListingId: 202447681


Listing Provided By: Whitetail Properties Real Estate, original listing
Phone: (812) 887-2954
Office Phone: (217) 285-9000
Agent Name: Zach Holt
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