NOT LISTED FOR SALE

2275 E Esterline Rd Columbia City, IN 46725

Estimated Value: $487,000 - $843,194

4 Beds
4 Baths
4,050 Sq Ft
$173/Sq Ft Est. Value

Last Sold June 23, 2023

Last sale price $794,868 $196 Per Sq Ft

Est. 12% decrease in value since last sale

Current estimated payment $4,018/month

1 Day on Market

Highlights

  • 50 Feet of Waterfront
  • Private Beach
  • Lake Property
  • Pier or Dock
  • Open Floorplan
  • Vaulted Ceiling

About This Home

As of June 2023

Luxury Lake Living… Beautiful and simply timeless, in design and décor, describes this 4086 square foot home. Hardwood floors, custom cabinetry, granite, quartz, gas fireplace and soaring ceilings with light flooding through the many windows, provides an upscale, casual and easy feel. Peaceful lake views are enjoyed from all 3 levels of the home, the quiet all-season sun porch, as well as from the 2 spacious and maintenance free, Zuri premium composite wood-look decks. The oversized level concrete driveway leads to a 3 car attached garage which has cabinets and countertops. A security system, central vac, 2 Trane HVAC systems with smart thermostats, circulating pump for immediate hot water at every faucet and energy efficient 6” exterior walls provide comfort and convenience. The expansive kitchen features abundant custom cabinetry from Miller Cabinet Company, stainless appliances, a large island, glass subway tile and efficient food prep centers making it a pleasure to entertain friends and family. This 4 bedroom/4 full bath home features a Master suite with a lake view. The new en suite offers marble flooring, custom double sink cabinet/quartz countertop, tiled heated shower and a dressing room/closet. Family and friends will enjoy the lower level entertainment area that opens to a tremendous outdoor living/dining space. Lounge on the cushioned bench while enjoying lake views with the ceiling fans’ gentle breeze. An outdoor staircase leads to a large, level lawn. Play yard games, build a castle on the beach or jump off the diving board into the clear, clean water. Straight out from the dock, Shriner Lake is 75’ deep. A small lakeside building includes a refrigerator for cold beverages, storage hooks for kayaks and provides storage that keeps lake toys, tools, boating and water sports equipment convenient. After a quiet, peaceful morning of kayaking or paddle boarding, rev up your boat engine and enjoy skiing and tubing from 1:00-4:00 p.m. Enjoy front row seats to an amazing July 4th fireworks display, walking distance to 2 restaurants, and only 6 minutes to Columbia City/30 to Fort Wayne! Your summer fun awaits!!!

Last Agent to Sell the Property

Adam Ertel

Coldwell Banker Real Estate Gr Listed on: 05/11/2023

Coldwell Banker Real Estate Gr

Last Buyer's Agent

Adam Ertel

Coldwell Banker Real Estate Gr Listed on: 05/11/2023

Coldwell Banker Real Estate Gr

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,066

Year Built

  • Built in 2002

Lot Details

  • 0.29 Acre Lot
  • Lot Dimensions are 50x250
  • 50 Feet of Waterfront
  • Lake Front
  • Private Beach
  • Backs to Open Ground
  • Rural Setting
  • Landscaped

Parking

  • 3 Car Attached Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Poured Concrete
  • Shingle Roof
  • Vinyl Construction Material

Interior Spaces

  • 2-Story Property
  • Open Floorplan
  • Central Vacuum
  • Vaulted Ceiling
  • Ceiling Fan
  • Gas Log Fireplace
  • Double Pane Windows
  • Insulated Windows
  • Insulated Doors
  • Entrance Foyer
  • Great Room
  • Living Room with Fireplace
  • Utility Room in Garage
  • Water Views

Kitchen

  • Eat-In Kitchen
  • Oven or Range
  • Kitchen Island
  • Stone Countertops
  • Built-In or Custom Kitchen Cabinets
  • Utility Sink
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile
  • Vinyl

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Split Bedroom Floorplan
  • En-Suite Primary Bedroom
  • Walk-In Closet
  • Double Vanity

Laundry

  • Laundry on main level
  • Washer and Gas Dryer Hookup

Finished Basement

  • Walk-Out Basement
  • 1 Bathroom in Basement
  • 2 Bedrooms in Basement

Home Security

  • Home Security System
  • Fire and Smoke Detector

Eco-Friendly Details

  • Energy-Efficient Appliances
  • Energy-Efficient Windows
  • Energy-Efficient HVAC
  • Energy-Efficient Lighting
  • Energy-Efficient Insulation
  • Energy-Efficient Doors
  • Energy-Efficient Thermostat

Outdoor Features

  • Sun Deck
  • Waterski or Wakeboard
  • Lake Property
  • Lake, Pond or Stream
  • Covered Patio or Porch

Schools

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

Utilities

  • Multiple cooling system units
  • Forced Air Heating and Cooling System
  • Multiple Heating Units
  • High-Efficiency Furnace
  • Heating System Uses Gas
  • Private Company Owned Well
  • Well
  • ENERGY STAR Qualified Water Heater
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 92-03-11-202-008.900-011

Community Details

Recreation

  • Pier or Dock

Additional Features

  • Esterlines Subdivision
  • Community Fire Pit

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,066

Year Built

Built in 2002

Lot Details

0

Parking

3

Listing Details

  • Class: RESIDENTIAL
  • Property Sub Type: Site-Built Home
  • Waterfront: Yes
  • Year Built: 2002
  • Age: 21
  • Style: Two Story
  • Total Number of Rooms: 9
  • Total Number of Rooms Below Grade: 3
  • Bedrooms: 4
  • Number Above Grade Bedrooms: 2
  • Total Bathrooms: 4
  • Total Full Bathrooms: 4
  • Legal Description: LOT 8 & LOT 7 EX W 20 FT FRANK & CHESTER ESTERLINES ADDITION TO TRI LAKE RESORT and FRL E2 SE4 S11 T32 R9 and land to the waters edge .173A and FRL PT SE4 S11 T32 R9 .01A
  • Parcel Number ID: 92-03-11-202-008.900-011
  • Platted: Yes
  • Amenities: 1st Bdrm En Suite, Alarm System-Security, Cable Available, Ceiling-9+, Ceiling Fan(s), Ceilings-Vaulted, Central Vacuum System, Closet(s) Walk-in, Countertops-Stone, Deck Open, Deck on Waterfront, Detector-Smoke, Disposal, Dryer Hook Up Gas/Elec, Eat-In Kitchen, Firepit, Foyer Entry, Garage Door Opener, Kitchen Island, Landscaped, Open Floor Plan, Patio Covered, Porch Covered, Range/Oven Hk Up Gas/Elec, Six Panel Doors, Split Br Floor Plan, Twin Sink Vanity, Utility Sink, Great Room, Main Floor Laundry, Washer Hook-Up, Custom Cabinetry, Garage Utilities
  • Location: Lake, Rural Subdivision
  • Number Below Grade Bedrooms: 2
  • Sp Lp Percent: 100.74
  • Year Taxes Payable: 2023
  • Special Features: None
  • Stories: 2

Interior Features

  • Total Sq Ft: 4086
  • Total Finished Sq Ft: 4050
  • Above Grade Finished Sq Ft: 2682
  • Below Grade Finished Sq Ft: 1368
  • Below Grade Sq Ft: 36
  • Price Per Sq Ft: 296.37
  • Basement: Yes
  • Basement Foundation: Walk-Out Basement, Finished
  • Basement Material: Poured Concrete
  • Number Of Fireplaces: 1
  • Fireplace: Living/Great Rm, Gas Log
  • Fireplace: Yes
  • Flooring: Hardwood Floors, Carpet, Vinyl, Ceramic Tile
  • Living Great Room: Dimensions: 22x27, On Level: Main
  • Kitchen: Dimensions: 14x16, On Level: Main
  • Dining Room: Dimensions: 12x14, On Level: Main
  • Family Room: Dimensions: 22x26, On Level: Basement
  • Extra Room: Sun Room, Dimensions: 18x9, On Level: Main
  • Bedroom 1: Dimensions: 16x17, On Level: Upper
  • Bedroom 2: Dimensions: 23x20, On Level: Upper
  • Bedroom 3: Dimensions: 11x14, On Level: Basement
  • Bedroom 4: Dimensions: 11x14, On Level: Basement
  • Number Below Grade Bathrooms: 1
  • Number of Below Grade Full Bathrooms: 1
  • Number of Main Level Full Bathrooms: 1
  • Total Below Grade Sq Ft: 1404

Exterior Features

  • Exterior: Vinyl
  • Roof Material: Dimensional Shingles
  • Outbuilding1: Shed, Dimensions: 10x12
  • Lake Type: Ski Lake
  • Water Features: Pier/Dock, Private Beach
  • Water Frontage: 50
  • Water Name: Shriner Lake

Garage/Parking

  • Driveway: Concrete
  • Garage Type: Attached
  • Garage Number Of Cars: 3
  • Garage Size: Dimensions: 24x32
  • Garage Sq Ft: 768
  • Garage: Yes

Utilities

  • Cooling: Central Air, Multiple Cooling Units
  • Heating Fuel: Gas, Forced Air, Multiple Heating Systems
  • Sewer: Public
  • Water Utilities: Well
  • Electric Company: AEP/I&M
  • Gas Company: NIPSCO
  • Cable Company: Mediacom
  • Hvac: Ceiling Fan, High Efficiency Furnace
  • Laundry: Dimensions: Mainx9, 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: Waterfront, Lake, Water View
  • Lot Dimensions: 50X250
  • Estimated Lot Sq Ft: 12502
  • Estimated Lot Size Acres: 0.287

Green Features

  • Energy Efficient: Appliances, Doors, Electrical/Lighting, HVAC, Insulation, Thermostat/Controllers, Water Heater, Windows
  • Energy Efficient Windows/Doors: Double Pane Windows, Insulated Doors, Insulated Glass Windows

Tax Info

  • Annual Taxes: 5066.28
  • Exemptions: Homestead, Mortgage

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 11, 2023
Closed on
Jun 23, 2023
Sold by
Bible R Douglas R and Bible Jacqueline S
Bought by
Troy A Moon And Gretchen Gd Moon Revocable Tr
Seller's Agent
Adam Ertel
Coldwell Banker Real Estate Gr
Buyer's Agent
Adam Ertel
Coldwell Banker Real Estate Gr
List Price
$789,000
Sold Price
$794,868
Premium/Discount to List
$5,868
0.74%
Views
11
Current Estimated Value
$699,299

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$95,569
Avg. Annual Appreciation
-5.42%
Original Mortgage
$519,800
Outstanding Balance
$507,122
Interest Rate
6.67%
Estimated Equity
$192,177

Purchase Details

Listed on
Aug 10, 2013
Closed on
Jan 8, 2014
Sold by
Lawrence W Lengacher
Bought by
R Douglas Bible
Seller's Agent
Wayne Kreiger
Coldwell Banker Real Estate Gr
Buyer's Agent
Timothy Brower
Orizon Real Estate, Inc.
List Price
$389,900
Sold Price
$350,000
Premium/Discount to List
-$39,900
-10.23%

Home Financials for this Owner

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

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
Troy A Moon And Gretchen Gd Moon Revocable Tr $794,868 None Listed On Document
R Douglas Bible $350,000 Lawyers Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Troy A Moon And Gretchen Gd Moon Revocable Tr $519,800
Closed Troy A Moon And Gretchen Gd Moon Revocable Tr $519,800
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
06/23/2023 06/23/23 Sold $794,868 +0.7% $196 / Sq Ft
05/12/2023 05/12/23 Pending -- -- --
05/11/2023 05/11/23 For Sale $789,000 +125.4% $195 / Sq Ft
01/08/2014 01/08/14 Sold $350,000 -10.2% $86 / Sq Ft View Prior Sale
11/25/2013 11/25/13 Pending -- -- --
08/10/2013 08/10/13 For Sale $389,900 -- $95 / 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 $3,556 $634,100 $45,900 $588,200
2023 $4,944 $580,000 $44,200 $535,800
2022 $4,977 $558,100 $43,500 $514,600
2021 $4,408 $459,600 $43,500 $416,100
2020 $4,098 $431,000 $41,400 $389,600
2019 $3,762 $403,800 $41,400 $362,400
2018 $3,631 $381,500 $41,400 $340,100
2017 $3,556 $368,700 $41,400 $327,300
2016 $3,284 $368,500 $41,400 $327,100
2014 $5,347 $352,400 $41,400 $311,000
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Indiana Regional MLS

MLS Number: 202315323

Indiana Regional MLS

APN: 92-03-11-202-008.900-011