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

15 Lane 130b Lk George
Fremont, IN 46737
Mark Pontecorvo with RE/MAX Results - Angola office, original listing - (260) 665-2414

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,495,000
Beds: --
Baths: Full: 2
Status: Active
SqFt: --
Agency: RE/MAX Results - Angola office
Agency Phone: (260) 665-2414

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Commercial Sale-Other
Year Built: 1982
Notes: This exceptional marina property, spanning 2.27 acres across two parcels, offers a rare opportunity for lake enthusiasts and business visionaries alike. This marina boasts three distinctive buildings, providing an expansive and versatile space to meet various needs. The main building, a captivating lakefront structure, spans 5,952 square feet and offers breathtaking panoramic views of Lake George and features a spacious 50x60 showroom, an office with a full bath, and a generous 40x60 shop equipped with heat and water. Adjacent to the main building, the second lakefront structure, spanning over 5,000 square feet, is ideal for additional boat storage. This space is thoughtfully designed with sliding doors for easy access, and a strategically positioned ramp between the lakefront buildings for seamless in and out for boats. The third building, a substantial 14,000 square feet, offers unparalleled storage capacity with power and gas connections. Boasting a 16x16 overhead door, this expansive facility provides a secure and spacious environment for additional storage needs. This Lake George marina property is not just a real estate investment; it's an opportunity to be part of a lakeside community, offering a unique blend of business potential and natural beauty. Don't miss the chance to own a piece of this waterfront haven! These 2 parcels are currently zoned lake residential with a special exception. *There are an additional 3 parcels on a full acre including a 10,000 square foot building available. Please see MLS 202403300 for details on the listing that includes all 5 parcels.
MlsNumber: --
ListingId: 202403298


Listing Provided By: RE/MAX Results - Angola office, original listing
Phone: (260) 905-6909
Office Phone: (260) 665-2414
Agent Name: Mark Pontecorvo
Disclaimer: Copyright © 2024 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App