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','pahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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','pahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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','pahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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;

15 Ems T52a
North Webster, IN 46555
Angela Racolta with Keller Williams Thrive North, original listing - (260) 222-6970

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $975,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Keller Williams Thrive North
Agency Phone: (260) 222-6970

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Rare Opportunity for Lakefront Living on Lake Tippecanoe! Welcome to The Oaks—a premier new neighborhood designed to blend lakeside luxury with natural beauty and historic charm. Now offering 75 feet of pristine lake frontage in The Waterfront section, these expansive, deep lots (300’!) are a rare find on Lake Tippecanoe, Indiana’s deepest natural, all-sports lake. Lots 3 and 5 are still available. Enjoy private access to Shelter Cove, a protected inlet perfect for swimming, paddleboarding, or launching your boat. These level building sites offer panoramic lake views, a sandy beach, and plenty of room to build your dream lake home, carriage house, pickleball court, or additional garage. The Oaks is thoughtfully designed to honor the past while embracing modern living. Once home to a historic Baptist camp, the community is now a serene retreat where nature leads, history lingers, and a true sense of belonging takes root. The neighborhood includes three distinct areas: The Waterfront: Premier lakefront sites with incredible views and direct lake access. The Overlook: Elevated lots with sweeping hilltop vistas and majestic, mature oaks and dedicated dock space. Conservancy Park: A protected natural haven where a tranquil creek winds through woodlands and ravines. Explore the Pawpaw Trail leading to Bluebird Meadow, a peaceful escape for nature lovers. The Oaks offers a one-of-a-kind opportunity to build a home that connects you to nature, community, and the unmatched beauty of Lake Tippecanoe and offers a once-in-a-generation opportunity to build your dream home on beautiful Lake Tippecanoe. Start your lake life today!
MlsNumber: --
ListingId: 202519510


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


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App