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

200 Lane 530a Lake James
Fremont, IN 46737-9015
Scott Marker with Anchor Realty, original listing - (260) 402-0744

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,650,000
Beds: 6
Baths: Full: 6
Status: Active
SqFt: 7912 Square Feet
Agency: Anchor Realty
Agency Phone: (260) 402-0744

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1995
Notes: Start Showing Date: 5/24/2024 Welcome to your rare opportunity to own an incomparable Lee Deller Custom Built Lake Home in prestigious Phillips Bay on Lake James. This luxurious property boasts 6 bedrooms, 6 bathrooms, and nearly 8,000 square feet of finished living space. With 130 feet of pristine lake frontage, including a sandy beach and a 140-foot dock system, this home offers an unparalleled lakeside living experience. Upon entering, you're greeted by a grand staircase and expansive views of Lake James. The great room features a gas fireplace, soaring ceilings, and a wall of windows that flood the room with natural light and showcase the breathtaking lake views. The master suite, located in the South wing of the main floor, includes a tray ceiling with rope lights for added ambiance and magnificent lake views. The large en suite bathroom offers a dual vanity, tiled shower, and a relaxing soaking tub. The main floor kitchen is a chef’s dream with an abundance of custom built Orr cabinets and counter space, including an enormous breakfast bar and island that is great for gathering with the lake as your backdrop. The separate living room, formal dining room, and large private office round out the main floor living area. Upstairs, you’ll find 3 bedrooms including a giant bunk room, 2 full bathrooms, a hallway loft overlooking the great room, and another living area. The lower level features a second full kitchen, 2 more bedrooms, 2 full bathrooms, a second laundry room, and two large storage areas, including a lake toy storage room. This level also includes another living room, making it perfect for extended stays and entertaining. Other notable features include a 3-car heated garage with an oversized door for boat storage, heated driveway, backup generator, irrigation system, and surround sound to provide the perfect soundtrack for your lake memories. The home also includes 9 HVAC zones for customized comfort throughout. The outdoor lakeside paradise includes a large waterfront deck and a multi-level stamped concrete patio, perfect for entertaining guests. And you’re just across the lake from Pokagon State Park, ensuring you always have a beautiful backdrop for your summer activities. The Lake James chain offers over 1,800 acres of fishing, floating, and fun. This is more than just a lake house; it’s a lake lifestyle. Opportunities for a lifestyle like this are incredibly rare, and this home is ready for you to seize yours!
MlsNumber: --
ListingId: 202418205


Listing Provided By: Anchor Realty, original listing
Phone: (260) 402-0744
Office Phone: (260) 402-0744
Agent Name: Scott Marker
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