#202516734, Adam Ertel, Listing Office: Coldwell Banker Real Estate Group
1715 E Schug Rd Columbia City, IN 46725
Property details
About 1715 E Schug Rd
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!
Highlights
(Pending)
Summary
- Partial Bathrooms: 1
- Full Bathrooms: 3
- Flooring Type: Hardwood Floors, Carpet, Vinyl
- Fireplace: Family Rm, Living/Great Rm, Gas Log
- Total Bedroom Count: 5
- Garage Space: 5 spaces
- Attached Garage: Yes
- Parking: Concrete
- Waterfront: Lake Front
- Exterior: Brick, Cedar, Vinyl
- Heating: Natural Gas, Forced Air
- Cooling: Central Air
- List Price: $899,900
- Price/SqFt: $187
- Annual Tax Amount: $5,455
- Tax Year: 2023
- Lot: Lake/Pond
- Directions: GPS Friendly
- Year Built: 2007
- Lot Size: 0.47 Acres
- MLS Number: 202517791
- Office Name: Coldwell Banker Real Estate Group
- Office Phone: (260) 750-2120
- Listing Agent: Ben Ruhl
The data on this website relating to real estate for sale comes in part from the Internet Data Exchange (IDX) program of the Indiana Regional MLS (IRMLS). IDX information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed accurate by the MLS. ©2011-2025 Indiana Regional MLS. All rights reserved.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 6/1/2025, 2:20:27 AM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Get an agent. Get a mortgage. Save big.¹

$899,900
1715 E Schug Rd
$10,000
closing credit¹
Sell your home with Rocket and save even more!
Seller rebate
0.5% sale price²
Price information
Property sales
We're sorry, we currently don't have property sales data for this listing.
Tax history
Year | Assessment | Property Tax |
---|---|---|
2023 | $636,300 | $5,455 |
2022 | $562,100 | $5,151 |
2021 | $535,300 | $5,171 |
2020 | $526,600 | $8,473 |
2018 | $479,100 | $8,208 |
2017 | $459,600 | $7,993 |
History based on county public records data.
Nearby schools
5
Northern Heights Elementary School
Public District KG-5
2.1 mi
•5209 N State Road 109
4
Mary Raber Elementary School
Public District PK-5
6.8 mi
•700 E Jackson St
6
Churubusco Elementary School
Public District PK-5
7.2 mi
•3 Eagle Dr
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $58,145. Typical income of Columbia City, IN residents is between $35k-100k annually. Typical family type is married, no kids. The most common level of education of people living in this area is post secondary degree.
Similar homes for sale
Frequently asked questions
About 1715 E Schug Rd
The listing price of 1715 E Schug Rd property is $899,900.
The property 1715 E Schug Rd is a house located in Columbia City, Indiana, 46725.
Sale Pending: 1715 E Schug Rd is Sale Pending (Pending), which means that the seller has accepted an offer but the sale is not finalized.
The nearby schools for 1715 E Schug Rd are: Northern Heights Elementary School (GreatSchools Rating 5/10), Mary Raber Elementary School (GreatSchools Rating 4/10), Churubusco Elementary School (GreatSchools Rating 6/10), Indian Springs Middle School (GreatSchools Rating 4/10), West Noble Middle School (GreatSchools Rating 6/10), Carroll Middle School (GreatSchools Rating 5/10), Churubusco Jr-Sr High School (GreatSchools Rating 5/10), Columbia City High School (GreatSchools Rating 6/10), Central Noble Junior Senior High School (GreatSchools Rating 5/10).
According to the records, the last property tax for 2023 is $5,455 (source: MLS/based on county public records data).
The property at 1715 E Schug Rd has 5 bedrooms and 3 full and 1 half bathrooms.
The year of construction for 1715 E Schug Rd is 2007.
This home is located at 1715 E Schug Rd in Columbia City, IN and zip code 46725. This home, which was built in 2007, sits on a 0.47 acre lot. Features: 5 bedrooms, 4 bathrooms. It has been listed on Rocket Homes since May 15, 2025 and is currently priced at $899,900.
In April 2025 more than 3 listings in Columbia City, IN were sold above the asking price. During the same period more than 9 listings were sold at asking price, while more than 8 were sold below. In April 2025 in Columbia City, IN there were 15.2% more homes for sale than in March. In April 2025, listings were on the market for 92 days. During the same period, the median list price in this real estate market was $254,000.