Skip main navigation
Closed
  • $505,000

    1897 E Bair Rd, Columbia City, IN 46725

    4beds
    3,360sqft
    Single Family Residence
    Built in 2008
    8,276.4 Square Feet Lot
    $519,900 Zestimate®
    $--/sqft
    $2,586 Estimated rent

    Home value

    $519,900

    $395,000 - $686,000

    $2,586/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $2,586/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $2,586/mo

    Rent Zestimate®

    Refinance and save

    $3,010/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $3,010/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Sandy beachLakefront livingWalk-out basementWide composite pierWraparound deckNatural woodworkStainless appliances
    Experience lakefront living at its finest on beautiful Shriner Lake with a nice sandy beach! This great home with two full sized kitchens features a wraparound deck and gorgeous stamped concrete patio with built-in firepit, both offering breathtaking views of the ski/boating/fishing lake and perfect for entertaining! As you enter the main level, you will enjoy the brand new vinyl plank flooring throughout, along with the 2 sets of sliding doors overlooking the picturesque lake. This level features your lakefront living room along with dining area, eat-up bar and well appointed kitchen with stainless appliances. The primary bedroom set on the main level includes a walk-in closet, en suite bathroom with a double vanity and a ceramic tiled shower with dual showerheads. You will also find a half bath on the main level along with laundry area. The upper level boasts two large additional bedrooms, one of which overlooks the lake along with a full sized bathroom and lots of storage! Enjoy natural woodwork, six-panel doors, and an open floor plan that complements the home's modern comforts, including a built-in whole-house generator, high-efficiency furnace, and central air, all maintained under regular service agreements. In the walk-out basement, you will find a completely separate living area. This area is set with an additional full sized kitchen with full sized stainless appliances, additional full sized washer/dryer and full bath with ceramic tiled shower. Also includes additional bedroom with ingress/egress, living room and covered patio. For convenience, this property has access to Mediacom Hi Speed Internet, natural gas and a Sewer System! In addition, includes a Shorestation Boat Lift with canopy and solar powered winch and nice wide composite pier! Floor plans can be viewed in the picture roll.

    Zillow last checked:

    Listing updated:

    Listed by:

    Adam Ertel Cell:260-417-1132,

    Coldwell Banker Real Estate Gr

    Bought with:

    Sierra Potts, RB21002021

    North Eastern Group Realty

    Source: IRMLS,MLS#: 202516734MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 4
    • Full bathrooms: 3
    • 1/2 bathrooms: 1
    • Main level bedrooms: 1
    Bedroom 1
    • Level: Main
    Bedroom 2
    • Level: Upper
    Dining room
    • Level: Main
    • Area: 143
    • Dimensions: 11 x 13
    Family room
    • Level: Lower
    • Area: 221
    • Dimensions: 13 x 17
    Kitchen
    • Level: Main
    • Area: 110
    • Dimensions: 11 x 10
    Living room
    • Level: Main
    • Area: 195
    • Dimensions: 13 x 15
    Heating
    • Natural Gas, Forced Air, High Efficiency Furnace
    Cooling
    • Central Air, Ceiling Fan(s)
    Appliances
    • Included: Range/Oven Hk Up Gas/Elec, Dishwasher, Microwave, Refrigerator, Washer, Dryer-Electric, Humidifier, Ice Maker, Washer/Dryer Stacked, Electric Range, Trash Compactor, Gas Water Heater, Water Softener Owned, Wine Cooler
    • Laundry: Dryer Hook Up Gas/Elec, Main Level, Washer Hookup
    Features
    • Ceiling Fan(s), Walk-In Closet(s), Laminate Counters, Eat-in Kitchen, Guest Quarters, Natural Woodwork, Open Floorplan, Split Br Floor Plan, Double Vanity, Kitchenette, Tub and Separate Shower, Main Level Bedroom Suite
    • Flooring: Carpet, Laminate, Vinyl, Ceramic Tile
    • Doors: Pocket Doors, Six Panel Doors, Storm Door(s)
    • Windows: Window Treatments
    • Basement: Full,Walk-Out Access,Finished,Concrete,Sump Pump
    • Has fireplace: No
    • Fireplace features: None
    Interior area
    • Total structure area: 3,360
    • Total interior livable area: 3,360 sqft
    • Finished area above ground: 2,240
    • Finished area below ground: 1,120

    Property

    Parking
    • Total spaces: 2
    • Parking features: Detached, Garage Door Opener, Garage Utilities, Concrete
    • Garage spaces: 2
    • Has uncovered spaces: Yes
    Features
    • Levels: Two
    • Stories: 2
    • Patio & porch: Deck Covered, Patio, Porch Covered
    • Exterior features: Fire Pit, Boat Lift-Covered, Boat Lift-Temporary
    • Fencing: None
    • Has view: Yes
    • Waterfront features: Waterfront, Lake, Waterfront-Medium Bank, Pier/Dock, Private Beach, Lake Front, Ski Lake
    • Body of water: Shriner Lake
    • Frontage length: Channel/Canal Frontage(0),Water Frontage(46)
    Lot
    • Size: 8,276 sqft
    • Dimensions: 46X180
    • Features: Sloped, Lake, Rural Subdivision
    Details
    • Additional structures: Shed
    • Parcel number: 920311401018.000011
    • Other equipment: Generator Built-In, Generator-Whole House, Sump Pump

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Other
    • Property subtype: Single Family Residence
    Materials
    • Vinyl Siding
    • Roof: Dimensional Shingles
    Condition
    • New construction: No
    • Year built: 2008

    Utilities & green energy

    • Gas: NIPSCO
    • Sewer: Regional
    • Water: Well
    • Utilities for property: Cable Available
    Green energy
    • Energy efficient items: Appliances, Doors, Lighting, HVAC, Insulation, Windows

    Community & neighborhood

    Security
    • Security features: Security System, Smoke Detector(s)
    Community
    • Community features: None
    Location
    • Region: Columbia City
    • Subdivision: Elmer Bairs

    Other

    Other facts
    • Listing terms: Cash,Conventional,VA Loan
    • Road surface type: Asphalt

    Price history

    DateEventPrice
    7/17/2025Sold$505,000-8.2%
    Source: IRMLS #202516734 Report a problem
    6/21/2025Pending sale$549,900
    Source: IRMLS #202516734 Report a problem
    6/14/2025Price change$549,900-8.3%
    Source: IRMLS #202516734 Report a problem
    6/4/2025Price change$599,900-4%
    Source: IRMLS #202516734 Report a problem
    5/23/2025Price change$624,900-1.6%
    Source: IRMLS #202516734 Report a problem
    3/28/2025Price change$634,900-0.8%
    Source: IRMLS #202447790 Report a problem
    2/2/2025Price change$639,900-1.5%
    Source: IRMLS #202447790 Report a problem
    12/21/2024Listed for sale$649,900+91.2%
    Source: IRMLS #202447790 Report a problem
    8/5/2018Listing removed$339,900$101/sqft
    Source: Minear Real Estate #201831827 Report a problem
    7/19/2018Listed for sale$339,900$101/sqft
    Source: Minear Real Estate #201831827 Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$3,485 +4.9%$463,600 +6.2%
    2024$3,323 -0.1%$436,700 +6.2%
    2023$3,326 +14.7%$411,300 +4.7%
    2022$2,900 +5.1%$392,700 +20.5%
    2021$2,761 +10.1%$325,900 +6.3%
    2020$2,507 +1.5%$306,700 +6.1%
    2019$2,471 +2.7%$289,200 +5.5%
    2018$2,406 +8%$274,000 +3.7%
    2017$2,228 +3.8%$264,200 0%
    2016$2,147 +9.4%$264,300 +4.2%
    2014$1,962 +5.1%$253,700 +6.5%
    2013$1,867 +9.9%$238,200 +7.3%
    2012$1,699 $222,000 -2.2%
    2011-- $227,000 +6.1%
    2010$1,612 +12.2%$214,000
    2009$1,438 +27.2%$214,000 +177.6%
    2006$1,130 $77,100 +24.4%
    2005-- $62,000

    Find assessor info on the county website

    Neighborhood: 46725

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: Northern Heights
    • Middle: Indian Springs
    • High: Columbia City
    • District: Whitley CO Cons Schools

    Source: IRMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get pre-qualified for a loan
    At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.

    An equal housing lender. NMLS #10287.

    Sell for more on Zillow
    Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
    $519,900
    2% more
    +$10,398
    With Zillow Showcase(estimated)
    $530,298