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

10458 N 100 E
Roanoke, IN 46783

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $650,000
Beds: 4
Baths: 5
Status: Active
SqFt: 4210
Agency: North Eastern Group Realty, Inc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential
Year Built: 2006
Notes: This "Peppermill" home combines the warmth of a grand farmhouse with front + back porches, symmetrical gables, spanning over 5000 square feet holding 4 bedrooms, 4 bathrooms on 4.94 acres with geothermal system. FIRST floor - living room features 2 story ceiling + wood burning fireplace flanked with wall of windows/door; family room, dining room, kitchen Maytag products - refrigerator, double ovens (convection + electric), microwave, dishwasher, Jenn-Air cooktop - bay/bow windowed eating area; owner's suite with his + hers walk in closets, private bathroom with NEW porcelain shower (full bodied 6 jets, temperature gauges) + jetted tub + personal entrance to back covered patio; laundry room includes washer + dryer with pedestals, abundance of cabinets, utility sink, hanging clothes space. SECOND floor has 3 bedrooms with walk-in closets + BONUS room (15'x14"), 2 full bathrooms + large walk in attic space. Daylight BASEMENT has 4 rooms (possible recreation + workout + office + storage room) + FULL bathroom + utility room. Garage has 8'x4' bump out. Notables - TWO hot water heaters (80+62 gal), water pressure tank, geothermal system, backup sump pump. Above ground rectangle shape swimming pool with deck, gazebo, equipment, winter + solar cover, vacuum, filter/pump, heater, cross net game included. Shed measuring 32'x16'.
MlsNumber: 202414012


Listing Provided By: North Eastern Group Realty, Inc, original listing
Name: North Eastern Group Realty, Inc
Phone: (260) 437-9844
Office Name: North Eastern Group Realty
Office Phone: (260) 489-7095
Agent Name: Denise Smothermon
Disclaimer: Copyright © 2024 Upstate Alliance of REALTORS® Multiple Listing Service, 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