NOT LISTED FOR SALE

1755 E Schug Rd Columbia City, IN 46725

Estimated Value: $815,981 - $964,000

4 Beds
4.5 Baths
4,432 Sq Ft
$202/Sq Ft Est. Value

Last Sold June 22, 2022

Last sale price $805,000 $182 Per Sq Ft

Est. 11% increase in value since last sale

Current estimated payment $5,414/month

11 Days on Market

Highlights

  • 100 Feet of Waterfront
  • Private Beach
  • Balcony
  • Pier or Dock
  • Lake Property
  • Built-in Bookshelves

About This Home

As of June 2022

Relax at the lake this summer in this gorgeous, one of a kind, completely updated and remodeled 4 bedroom, 4 ½ bath home. This beautiful 2 story sits on a full basement that walks out to 100’ of lake frontage on Big Cedar lake with THE nicest beach on the lake featuring 5,000 sf of swimming area lined with Geotex and topped with 8” of pea gravel spread over the entire area which makes it muck and weed free for your enjoyment! This beautifully designed home features custom built hickory cabinets, upgraded trim work throughout, fireplaces in living room, master bedroom and basement, a central vac system, concrete driveway all the way down to the lake, paved parking for 9 vehicles, lower level garage bay for lake toys, a whole house generator, split bedroom floor plan, and a wet bar in basement with a great space for entertaining your lake guests! There is truly nothing left to do here but add your own personal touches! Many custom amenities and upgrades including all brand new Pella Windows and sliding patio doors (most replaced) with internal blinds on the entire back of the home and sunroom, new top of the line carpeting, tile and laminate flooring throughout the entire home, fresh paint throughout, new outlets and switches, and new tile surround on fireplaces. Enjoy unspoiled views from the completely sanded and resealed deck off both the main and lower level with brand new sleek cable railing. Concerned about security? There will be no worries here with brand new Simplx cameras containing audio and updated alarm systems with water sensors, smoke. Carbon dioxide, glass break sensors, door and window tamper switches and automated garage door openers. This one won't last long!

Last Agent to Sell the Property

Jeremy Patton

RE/MAX Integrity Listed on: 05/03/2022

RE/MAX Integrity

Last Buyer's Agent

Susanne Rippey

Coldwell Banker Real Estate Group

Coldwell Banker Real Estate Group

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,175

Year Built

  • Built in 1999

Lot Details

  • 0.45 Acre Lot
  • Lot Dimensions are 100x197
  • 100 Feet of Waterfront
  • Lake Front
  • Private Beach
  • Sloped Lot

Parking

  • 3 Car Garage
  • Basement Garage
  • Driveway

Home Design

  • Brick Exterior Construction
  • Vinyl Construction Material

Interior Spaces

  • 2-Story Property
  • Central Vacuum
  • Built-in Bookshelves
  • Built-In Features
  • Bar
  • Living Room with Fireplace
  • Home Security System
  • Laminate Countertops

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet

Finished Basement

  • Walk-Out Basement
  • 2 Bathrooms in Basement
  • 2 Bedrooms in Basement

Outdoor Features

  • Waterski or Wakeboard
  • Lake Property
  • Lake, Pond or Stream
  • Balcony

Schools

  • Northern Heights Elementary School
  • Indian Springs Middle School
  • Columbia City High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Gas
  • Private Company Owned Well
  • Well
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 92-03-02-305-026.000-011

Community Details

Overview

  • Big Cedar Lake Subdivision

Recreation

  • Pier or Dock

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,175

Year Built

Built in 1999

Lot Details

0

Parking

3

Listing Details

  • Class: RESIDENTIAL
  • Property Sub Type: Site-Built Home
  • Waterfront: Yes
  • Year Built: 1999
  • Age: 23
  • Style: Two Story
  • Total Number of Rooms: 13
  • Total Number of Rooms Below Grade: 3
  • Bedrooms: 4
  • Number Above Grade Bedrooms: 2
  • Total Bathrooms: 5
  • Total Full Bathrooms: 4
  • Total Number of Half Bathrooms: 1
  • Legal Description: Lots 26 & 27 Cedar Lake Park Third Addition
  • Parcel Number ID: 92-03-02-305-026.000-011
  • Platted: Yes
  • Amenities: Alarm System-Security, Balcony, Bar, Built-In Speaker System, Built-In Bookcase, Cable Ready, Central Vacuum System, Closet(s) Walk-in, Countertops-Laminate
  • Cross Street: SR9
  • Number Below Grade Bedrooms: 2
  • Sp Lp Percent: 94.71
  • Year Taxes Payable: 2021
  • Special Features: None
  • Stories: 2

Interior Features

  • Total Sq Ft: 4432
  • Total Finished Sq Ft: 4432
  • Above Grade Finished Sq Ft: 1938
  • Below Grade Finished Sq Ft: 2494
  • Price Per Sq Ft: 415.38
  • Basement: Yes
  • Basement Foundation: Walk-Out Basement, Finished
  • Number Of Fireplaces: 1
  • Fireplace: Living/Great Rm
  • Fireplace: Yes
  • Living Great Room: Dimensions: 21x16, On Level: Main
  • Kitchen: Dimensions: 12x10, On Level: Main
  • Dining Room: Dimensions: 12x12, On Level: Main
  • Den: Dimensions: 11x10, On Level: Main
  • Recreation Room: Dimensions: 29x16, On Level: Lower
  • Bedroom 1: Dimensions: 16x14, On Level: Main
  • Bedroom 2: Dimensions: 12x10, On Level: Main
  • Bedroom 3: Dimensions: 16x14, On Level: Lower
  • Bedroom 4: Dimensions: 16x13, On Level: Lower
  • Number Below Grade Bathrooms: 2
  • Number of Below Grade Full Bathrooms: 2
  • Number of Main Level Full Bathrooms: 2
  • Number of Main Level Half Bathrooms: 1
  • Total Below Grade Sq Ft: 2494

Exterior Features

  • Exterior: Brick, Vinyl
  • Outbuilding1: None
  • Lake Type: Ski Lake
  • Water Features: Pier/Dock Available, Private Beach
  • Water Frontage: 100
  • Water Name: Big Cedar Lake

Garage/Parking

  • Driveway: Concrete
  • Garage Type: Basement
  • Garage Number Of Cars: 3
  • Garage Size: Dimensions: 34x23
  • Garage Sq Ft: 782
  • Garage: Yes

Utilities

  • Cooling: Central Air
  • Heating Fuel: Gas, Forced Air
  • Sewer: Public
  • Water Utilities: Well
  • Laundry: Dimensions: Mainx5, On Level: 8
  • Water Type: Lake
  • Well Type: Private

Schools

  • School District: Whitley CO Cons Schools
  • Elementary School: Northern Heights
  • Middle School: Indian Springs
  • High School: Columbia City
  • Elementary School: Northern Heights

Lot Info

  • Lot Description: Slope, Lake, Waterfront-Medium Bank
  • Lot Dimensions: 100x197
  • Estimated Lot Sq Ft: 19602
  • Estimated Lot Size Acres: 0.45
  • Lot Number: 26

Tax Info

  • Annual Taxes: 5175.34
  • Exemptions: Homestead

Multi Family

  • Water Access: Lakefront

MLS Schools

  • High School: Columbia City
  • Middle School: Indian Springs
  • School District: Whitley CO Cons Schools

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 3, 2022
Closed on
May 5, 2022
Sold by
Mary Stanley Living Trust
Bought by
Ashley Amanda
Seller's Agent
Jeremy Patton
RE/MAX Integrity
Buyer's Agent
Susanne Rippey
Coldwell Banker Real Estate Group
List Price
$884,900
Sold Price
$805,000
Premium/Discount to List
-$79,900
-9.03%
Total Days on Market
11
Current Estimated Value
$894,327

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$89,327
Avg. Annual Appreciation
3.61%

Purchase Details

Listed on
Aug 19, 2020
Closed on
Sep 16, 2020
Sold by
Majewski Thomas C
Bought by
Stanley Ashley
Seller's Agent
Staci Beverly
ERA Crossroads
Buyer's Agent
Jeremy Patton
RE/MAX Integrity
List Price
$550,000
Sold Price
$550,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
24.16%
Interest Rate
2.86%
Source: Public Records

Similar Homes in Columbia City, IN

  • 1095 E 600 N, Columbia City, IN 46725

    $760,000

    • 5 Beds
    • 5.5 Baths
    • 6,508 Sq Ft
    • 1095 E 600 N
    • Columbia City, IN

    Impressive 6,500+ square foot home perched on a hill overlooking 3.5 acres. With 5 large size bedrooms, 5.5 bathrooms, and a full basement equipped for a mother-in-law suite, this home is perfect for multigenerational living, hosting guests, or everyday living, all while experiencing country living. From the moment you walk in you’re greeted with a 2 story foyer, decorative archways, wood beams,

    Stacie Bellam-Fillman Orizon Real Estate, Inc.

    Section Image
  • 804 Wexford Ct, Columbia City, IN 46725

    $749,000

    • 4 Beds
    • 4 Baths
    • 5,225 Sq Ft
    • 804 Wexford Ct
    • Columbia City, IN

    Beautiful stucco home with circle drive on 3 acres with a shared pond. The custom home has 4 bedrooms and 4 baths. The office comes with a built-in desk and bookshelf. Custom kitchen with quartz countertops. Large 3 season room and a pergola with hanging lights above the large deck. The yard has a full irrigation system. The finished basement is very open with a wet bar. The large storage area in

    Eric Anderson Orizon Real Estate, Inc.

    Section Image

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Ashley Amanda -- New Title Company Name
Stanley Ashley $550,000 --
Stanley Ashley $550,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Stanley Ashley --
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/22/2022 06/22/22 Sold $805,000 -5.3% $182 / Sq Ft
05/18/2022 05/18/22 Pending -- -- --
05/14/2022 05/14/22 Price Changed $849,999 -3.9% $192 / Sq Ft
05/07/2022 05/07/22 For Sale $884,900 +60.9% $200 / Sq Ft
09/16/2020 09/16/20 Sold $550,000 0.0% $116 / Sq Ft
08/19/2020 08/19/20 Pending -- -- --
08/19/2020 08/19/20 For Sale $550,000 -- $116 / Sq Ft
Source: Indiana Regional MLS

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $4,951 $787,100 $109,800 $677,300
2023 $6,184 $706,300 $105,600 $600,700
2022 $5,387 $600,700 $100,700 $500,000
2021 $5,537 $567,400 $100,700 $466,700
2020 $5,441 $551,700 $99,000 $452,700
2019 $5,228 $539,600 $99,000 $440,600
2018 $5,138 $490,200 $99,500 $390,700
2017 $4,951 $465,400 $99,500 $365,900
2016 $4,596 $466,500 $99,500 $367,000
2014 $4,143 $449,900 $99,500 $350,400
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Indiana Regional MLS

MLS Number: 202216227

Indiana Regional MLS

APN: 92-03-02-305-026.000-011