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

1850 North Shore Drive
Rome City, IN 46784
Christina Koher with RE/MAX Results - Angola office, original listing - (260) 665-2414

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $599,900
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2206 Square Feet
Agency: RE/MAX Results - Angola office
Agency Phone: (260) 665-2414

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1930
Notes: Welcome to your year-round dream lakefront retreat on Sylvan Lake, a stunning 669-acre man-made lake renowned for its all-season skiing and exceptional fishing. This beautifully maintained year-round tri-level home is perfect for both relaxation and entertainment. The most gorgeous sunrises will greet you every morning as you sit and relax on the expansive stamped concrete lakefront patio, complete with a new 14’ x 18’ pavilion including ceiling fans, USB charging ports, and electricity for your convenience. The concrete seawall and solid dock, equipped with a socket system and muck plates, make it easy to take in and out for the seasons. The open-concept main level is designed for entertaining, showcasing a formal dining area, a bright lakefront breakfast nook, and a spacious kitchen equipped with plentiful white cabinetry, ample counter space, and newer stainless-steel appliances. The living room has multiple seating areas, and every window has an amazing view of the water. An electric fireplace ensures cozy evenings when your family and friends gather at the end of the day. The secluded primary suite is a true sanctuary located on the upper level, featuring double closets and a luxurious ensuite bathroom complete with a deep jetted tub, separate shower, double vanity, and generous built-in storage cabinets including a seated makeup vanity area. Two additional bedrooms can be found on the lower level and are large enough for multiple beds for when you host extra guests! The oversized 2-car attached heated garage boasts a modern finish with epoxy floors, freshly painted drywall, slatwall for tool organization, LED lighting, and a charming planked-wood ceiling. With a Lifestyle garage screen, this area can easily transform into an extra entertaining space or workshop, and a second refrigerator gives you space to keep beverages well stocked. Just off the garage is a finished 25 x 8 vaulted recreation room, ideal for game nights or as a cozy bunk room for guests. Just off this space, a newly added half-bath adds convenience. The concrete block basement offers additional storage and recreation options. Recent updates include a furnace and air conditioner installed in 2017, and a water heater replaced in 2015. A new roof was installed in 2017, ensuring peace of mind. With wonderful neighbors and impeccable maintenance throughout, this lakefront home is ready for you to create lasting memories. Don’t miss this rare opportunity to own a piece of paradise!
MlsNumber: --
ListingId: 202510258


Listing Provided By: RE/MAX Results - Angola office, original listing
Phone: (260) 668-9235
Office Phone: (260) 665-2414
Agent Name: Christina Koher
Disclaimer: Copyright © 2025 Northeastern Indiana Association 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.


Local Real Estate Expert

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 = 758 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;
Keegan Pressler
ASCIIRe/Max Partners
Call Today!: (574) 536-4104

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App