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;

509 Clutter Road
Lynnville, IN 47619
Joshua Vida with Paradigm Realty Solutions, original listing - (574) 485-2348

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $625,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2778 Square Feet
Agency: Paradigm Realty Solutions
Agency Phone: (574) 485-2348

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: 4 bedroom/ 3 bath/ 2778 sq ft with 1050 sq ft unfinished basement with poured concrete walls, and a built in storm shelter. Basement walks out to a beautiful aggregate patio. House sits on 5 beautiful acres. Large aggregate front porch with swing and 2 ceiling fans. Large kitchen with Maple cabinets, 7ft Amish built island and French doors leading to an elevated deck. Living room has a beautiful brick fireplace with a vented gas (propane) insert. Upstairs has 3 bedrooms and 2 full baths. Master bedroom has a walk- in closet, master bath has a 9ft double vanity, gardentub/ shower, and a window seat. Bonus room (4th bdr) has a separate staircase at the other end of the house. Large laundry room. Garage has an oversized door. Two large sheds and a new carport. The woods have open trails for walking or riding. Recent updates per seller: walls and ceilings have been painted, refrigerator and range, 2" blinds throughout house, vented gas fireplace insert, replaced cracked concrete chimeny cap with a stainless steel chimney cap, new hardwood floors in livingroom, replaced one heat pump, added insulation to attic, new carport, new roof in 2020, Radon Mitigation system installed 2020. Average utility bill $200 a month and water $40 to $50 a month.
MlsNumber: --
ListingId: 202441358


Listing Provided By: Paradigm Realty Solutions, original listing
Phone: (574) 361-3933
Office Phone: (574) 485-2348
Agent Name: Joshua Vida
Disclaimer: Copyright © 2024 Elkhart County Board 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