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;

9207 E Ross Drive
Syracuse, IN 46567
Angela Racolta with Keller Williams Thrive North, original listing - (260) 222-6970

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,299,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1736 Square Feet
Agency: Keller Williams Thrive North
Agency Phone: (260) 222-6970

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1940
Notes: Ultra charming move-in ready upgraded 2-story boasting an amazing all seasons room, oversized patio & hard bottomed swimming area w/ 50’ of lakefront in bay that is one of the calmest spots on Lake Wawasee! Located at end of private drive, this 3 bedroom, 2 full bath home has tons of character & ideal yard w/ cement sea wall & tall shade trees where you can kick back & relax as you enjoy the cool breeze off the lake! There have been many updates & remodels over the years, some of the most recent: ground floors & fireplace redone 2018; new water heater & softener 2019; AC added 2020. Well maintained exterior has detailed landscaping, attached 1 car garage w/ another door opening lake side, cement parking apron w/ room for 7 vehicles & free standing 12x14 shed w/ attic & workbenches—a handy man’s dream come true! Main entrance opens to bright & welcoming atmosphere complemented by a neutral color palette & open concept layout. Generous eat-in kitchen has abundant custom cabinetry, warm cherry hardwood counters, SS appliances, farmhouse sink & central island w/ seating & wine rack. Wide entryway links to spacious main living/dining on gorgeous wood flooring featuring a formal dining zone perfect for entertaining beside a cozy living area w/ fantastic floor-to-ceiling stone gas log fireplace w/ TV insert, all w/ waterfront views! Adjoining Florida room stars panoramic lake scenes from every window & glass door to walk out patio, sure to be a popular gathering point no matter the weather! Main floor full bath w/ walk-in shower & pedestal sink as well as bonus storage nook underneath the stairs completes first level. Upstairs you’ll find all 3 good sized bedrooms (all carpeted w/ ceiling fans) & ample storage throughout. Sizable full bath also up w/ tub/shower combo & hidden laundry which makes putting clothes away a little easier! Step out onto the extended lakefront patio excellent for dining al fresco, grilling & chilling, or simply relaxing at the end of a long day w/ a cool drink & spectacular views! There’s even another side alcove beside the garage access w/ a privacy fence perfect for the hot tub & more seating! Lake Wawasee is an all sports lake w/ many boat-in & on water dining establishments in addition to popular annual events such as boat-in church, parades & fireworks to keep you busy. Whether you're looking for a year-round home, weekend getaway or rental property, look no further! Pier #336
MlsNumber: --
ListingId: 202426906


Listing Provided By: Keller Williams Thrive North, original listing
Phone: (317) 750-1600
Office Phone: (260) 222-6970
Agent Name: Angela Racolta
Disclaimer: Copyright © 2024 Kosciusko Board of Realtors MLS. 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 = 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;
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