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

112 E Main Street
Silver Lake, IN 46982

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $225,000
Beds: 4
Baths: 2
Status: Active
SqFt: 2688
Agency: Manchester Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1915
Notes: Tucked in Silver Lake with over 100 years of history with Craftsman architectural features of brick and stone, hand crafted details, and loads of character, this home has one of a kind design elements. The large covered and screened front porch leads into a timeless floor plan of over 2600 square feet. Throughout the home find numerous wall built-ins, original hardwood floors and trim, and stained glass accents plus a beautiful hand designed stone fireplace with an updated gas starter. A gorgeous staircase greets you through the front door and leads into the living room with lighted columns, glass front built in desks, and a storybook fireplace. In the formal dining room, show off the gorgeous buffet with stained glass windows and beveled mirrors to wow all of your guests. The bright and functional kitchen has a retro vibe as well as original features. Enjoy the historic and huge built in pantry. A spacious bedroom and closet with an adjoining half bathroom, with more built in storage, finish the main level. Step down into a bonus room built between the home and the garage that has the potential to be extra living space, a game room, or, perhaps, a home based office. On the second level of the home, find 3 bedrooms, all with great closets, and a full bathroom with a clawfoot tub/shower, additional built ins with beveled mirror and a laundry chute. The original stained woodwork and beautiful windows stand out through this entire home. A one car attached garage, great landscape, paver patio, and extra large lot give added use and value. Upgrades include roof, furnace, central air, ductwork, water heater, radon mitigation system, windows, vinyl siding, insulation, bath plumbing and more. Own a piece of Silver Lake history and charm!
MlsNumber: 202404725


Listing Provided By: Manchester Realty, original listing
Name: Manchester Realty
Phone: (260) 982-6168
Office Name: Manchester Realty
Office Phone: (260) 982-6168
Agent Name: Andrea Greer Markham
Disclaimer: Copyright © 2024 REALTORS Association of Central Indiana. 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