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

1715 E Schug Road
Columbia City, IN 46725
Ben Ruhl with Coldwell Banker Real Estate Group, original listing - (260) 489-2000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $899,900
Beds: 5
Baths: Full: 3, ½: 1
Status: Pending
SqFt: 4807 Square Feet
Agency: Coldwell Banker Real Estate Group
Agency Phone: (260) 432-0531

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: Discover this elegant custom-built home nestled on 100 feet of sandy Big Cedar Lake shoreline. Designed for comfort and style, it features 10-foot ceilings across three levels and a vaulted living room with expansive Andersen windows that frame stunning lake views. The main-floor primary suite offers a tranquil retreat with a bay window, tray ceilings, and a walk-in closet equipped with custom organizers. The updated en-suite bath boasts a double vanity with quartz vanity, newly tiled walk-in shower, and a generous soaking tub. Culinary enthusiasts will appreciate the updated kitchen, with new granite countertops, new fixtures, complete with solid wood cabinetry, soft-close drawers, under-cabinet lighting, and modern appliances—all included. Enjoy meals with a view in the eat-in kitchen or relax in the adjacent four-season room, which opens to multiple outdoor living spaces. If you get hot, step inside to cool down thanks to a newly installed A/C unit. The two lower levels feature large family rooms, one with a gas fireplace, wet bar, screened in porch, two additional bedrooms and an updated full bath. The lake level bedroom, currently staged as a vintage diner, offers direct exterior access and an en-suite bath with storage closet. On this same level is your very own, moody speakeasy that has access to the lake level. An egress window was added to finish off the second level with an additional living space and 5th bedroom. Outdoor living is taken to the next level with two open air decks, a covered deck, screened in porch, and a large concrete patio with overhead garage door at lake level. This home is a perfect blend of luxury and lakefront charm. Don't miss the opportunity to make this serene lakefront property your own. Schedule a private tour today!
MlsNumber: --
ListingId: 202517791


Listing Provided By: Coldwell Banker Real Estate Group, original listing
Phone: (260) 750-2120
Office Phone: (260) 489-2000
Agent Name: Ben Ruhl
Disclaimer: Copyright © 2025 Upstate Alliance of REALTORS® Multiple Listing Service, Inc. 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