NOT LISTED FOR SALE

54562 Columbia Bay Dr Osceola, IN 46561

Estimated Value: $615,000 - $719,681

5 Beds
3 Baths
3,538 Sq Ft
$189/Sq Ft Est. Value

Last Sold April 26, 2024

Last sale price $684,900 $194 Per Sq Ft

Est. 2% decrease in value since last sale

Current estimated payment $3,924/month

46 Days on Market

Highlights

  • Primary Bedroom Suite
  • Open Floorplan
  • Ranch Style House
  • Schmucker Middle School Rated A
  • Vaulted Ceiling
  • Backs to Open Ground

About This Home

As of April 2024

Welcome to 54562 Columbia Bay, a remarkable residence situated within the sought-after Northbridge Valley Reserve neighborhood with city water/sewer. This exquisite home is a testament to elegance and benefits from being part of the Penn Harris Madison school system. Nestled on a private lot that backs up to a tranquil wooded area, this home offers a perfect blend of comfort and sophistication. Step inside this thoughtfully designed residence, featuring 5 bedrooms and 3 bathrooms, with an open-concept layout that seamlessly connects the living spaces on the main floor. Soaring ceilings and oversized offer natural light, creating an inviting atmosphere. Upon entering through the front door, you're welcomed with direct access to the kitchen and living room spaces. To the left, discover a beautifully appointed office/bedroom with 12-foot ceilings and a custom accent wall. On the right, a small hallway leads to the third bedroom and a full bathroom boasting a fully tiled shower with a niche. The entry from the garage opens to a convenient drop zone/mudroom with storage, providing direct access to the laundry room. The laundry room is not only functional but also features ample folding space, hanging racks, and a built-in custom dog spa with cabinetry to discreetly hide food and water bowls. The carefully designed kitchen is a chef's haven, offering a walk-in pantry, dedicated drawers for organizing spices, and upgraded KitchenAid stainless appliances. The owner's suite serves as a private retreat, featuring an oversized sliding door to the backyard, a built-in wireless speaker system extending throughout the home, an oversized rain shower, dual vanities, a soaking tub, and a walk-in closet. The finished basement is an entertainer's delight, featuring a wet bar, beverage refrigerator, and generous entertainment space. Two bedrooms in the lower level, with one currently used as an exercise studio, come complete with large closets. A full hall bathroom with a tiled shower adds convenience to the lower level, which also provides over 800 sq feet of additional storage along with approximately 1300 sq feet of finished living space. Kline Custom Home-built in 2021 with premium upgrades, this home radiates beauty, fun, and convenience. Enjoy neutral, durable engineered hardwood flooring, upgraded kitchen appliances, a custom stove hood, epoxy finished garage floor, a dog spa, stone mailbox, and more.

Last Agent to Sell the Property

Aaron Cowham

Howard Hanna SB Real Estate Brokerage Phone: 574-207-7777 Listed on: 01/25/2024

Last Buyer's Agent

Lori Johnston

Cressy & Everett - South Bend

Cressy & Everett - South Bend

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,037

Year Built

  • Built in 2021

Lot Details

  • 10,454 Sq Ft Lot
  • Lot Dimensions are 81x130
  • Backs to Open Ground
  • Vinyl Fence
  • Landscaped
  • Level Lot
  • Irrigation

HOA Fees

  • $17 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Ranch Style House
  • Poured Concrete
  • Shingle Roof
  • Stone Exterior Construction
  • Vinyl Construction Material

Interior Spaces

  • Open Floorplan
  • Wet Bar
  • Built-in Bookshelves
  • Built-In Features
  • Bar
  • Beamed Ceilings
  • Vaulted Ceiling
  • Ceiling Fan
  • Gas Log Fireplace
  • Double Pane Windows
  • Entrance Foyer
  • Great Room
  • Living Room with Fireplace
  • Video Cameras

Kitchen

  • Breakfast Bar
  • Walk-In Pantry
  • Kitchen Island
  • Solid Surface Countertops
  • Built-In or Custom Kitchen Cabinets
  • Disposal

Flooring

  • Wood
  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Primary Bedroom Suite
  • Split Bedroom Floorplan
  • Walk-In Closet
  • Double Vanity
  • Bathtub With Separate Shower Stall

Laundry

  • Laundry on main level
  • Washer and Gas Dryer Hookup

Finished Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump
  • 1 Bathroom in Basement
  • 2 Bedrooms in Basement
  • Natural lighting in basement

Schools

  • Elsie Rogers Elementary School
  • Schmucker Middle School
  • Penn High School

Utilities

  • Forced Air Heating and Cooling System
  • High-Efficiency Furnace
  • Heating System Uses Gas

Additional Features

  • Covered Patio or Porch
  • Suburban Location

Community Details

  • Northbridge Valley Subdivision

Listing and Financial Details

  • Assessor Parcel Number 71-05-32-401-198.000-031

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,037

Year Built

Built in 2021

Lot Details

0

HOA Fees

$17 per month

Parking

3

Listing Details

  • Class: RESIDENTIAL
  • Property Sub Type: Site-Built Home
  • Year Built: 2021
  • Age: 3
  • Style: One Story
  • Architectural Style: Ranch
  • Total Number of Rooms: 12
  • Total Number of Rooms Below Grade: 5
  • Bedrooms: 5
  • Number Above Grade Bedrooms: 3
  • Total Bathrooms: 3
  • Total Full Bathrooms: 3
  • Legal Description: LOT 97 NORTHBRIDGE VALLEY SEC 5 & RP LOT 211 SEC 4 21/22 NP #2040 10/16/2020
  • Parcel Number ID: 71-05-32-401-198.000-031
  • Platted: Yes
  • Amenities: 1st Bdrm En Suite, Bar, Breakfast Bar, Built-In Speaker System, Built-In Bookcase, Ceiling-9+, Ceiling Fan(s), Ceilings-Beamed, Ceilings-Vaulted, Closet(s) Walk-in, Countertops-Solid Surf, Disposal, Dryer Hook Up Gas, Foyer Entry, Garage Door Opener, Irrigation System, Kitchen Island, Landscaped, Open Floor Plan, Pantry-Walk In, Patio Covered, Patio Open, Split Br Floor Plan, Twin Sink Vanity, Wet Bar, Alarm System-Sec. Cameras, Stand Up Shower, Tub and Separate Shower, Tub/Shower Combination, Main Level Bedroom Suite, Great Room, Main Floor Laundry, Sump Pump, Washer Hook-Up, Custom Cabinetry
  • Location: City/Town/Suburb
  • Number Below Grade Bedrooms: 2
  • Sp Lp Percent: 100
  • Year Taxes Payable: 2023
  • Special Features: None
  • Stories: 1

Interior Features

  • Total Sq Ft: 4348
  • Total Finished Sq Ft: 3538
  • Above Grade Finished Sq Ft: 2174
  • Below Grade Finished Sq Ft: 1364
  • Below Grade Sq Ft: 810
  • Price Per Sq Ft: 315.04
  • Basement: Yes
  • Basement Foundation: Daylight, Full Basement, Finished
  • Basement Material: Poured Concrete
  • Number Of Fireplaces: 1
  • Fireplace: Living/Great Rm, Gas Log
  • Fireplace: Yes
  • Flooring: Hardwood Floors, Tile, Vinyl
  • Living Great Room: Dimensions: 20x18, On Level: Main
  • Kitchen: Dimensions: 12x18, On Level: Main
  • Dining Room: Dimensions: 11x18, On Level: Main
  • Family Room: Dimensions: 40x15, On Level: Lower
  • Bedroom 1: Dimensions: 16x16, On Level: Main
  • Bedroom 2: Dimensions: 13x13, On Level: Main
  • Bedroom 3: Dimensions: 13x11, On Level: Main
  • Bedroom 4: Dimensions: 15x13, On Level: Lower
  • Bedroom 5: Dimensions: 18x15, On Level: Lower
  • Number Below Grade Bathrooms: 1
  • Number of Below Grade Full Bathrooms: 1
  • Number of Main Level Full Bathrooms: 2
  • Total Below Grade Sq Ft: 2174

Exterior Features

  • Exterior: Stone, Vinyl
  • Roof Material: Dimensional Shingles
  • Outbuilding1: None
  • Fence: Vinyl

Garage/Parking

  • Driveway: Concrete
  • Garage Type: Attached
  • Garage Number Of Cars: 3
  • Garage Size: Dimensions: 22x29
  • Garage Sq Ft: 638
  • Garage: Yes

Utilities

  • Cooling: Central Air
  • Heating Fuel: Gas, Forced Air
  • Sewer: City
  • Water Utilities: City
  • Electric Company: AEP/I&M
  • Gas Company: NIPSCO
  • Water Company: Mishawaka Utility
  • Hvac: High Efficiency Furnace
  • Laundry: Dimensions: Mainx6, On Level: 10

Condo/Co-op/Association

  • Association Restrictions: Yes
  • Association Fees: 200
  • Association Fees Frequency: Annually
  • Common Amenities: Sidewalks

Schools

  • School District: Penn-Harris-Madison School Corp.
  • Elementary School: Elsie Rogers
  • Middle School: Schmucker
  • High School: Penn
  • Elementary School: Elsie Rogers

Lot Info

  • Lot Description: Level, 0-2.9999
  • Lot Dimensions: 81X130
  • Estimated Lot Sq Ft: 10454
  • Estimated Lot Size Acres: 0.24
  • Lot Number: 97

Green Features

  • Energy Efficient Windows/Doors: Double Pane Windows

Tax Info

  • Annual Taxes: 5037

MLS Schools

  • High School: Penn
  • Middle School: Schmucker
  • School District: Penn-Harris-Madison School Corp.

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 25, 2024
Closed on
Apr 26, 2024
Sold by
Baum Stacy M and Baum Nathan E
Bought by
Schroeder Nikki L
Seller's Agent
Aaron Cowham
Howard Hanna SB Real Estate
Buyer's Agent
Lori Johnston
Cressy & Everett - South Bend
List Price
$689,900
Sold Price
$684,900
Premium/Discount to List
-$5,000
-0.72%
Views
93
Current Estimated Value
$667,920

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$16,980
Avg. Annual Appreciation
-1.78%

Purchase Details

Listed on
Jan 25, 2024
Closed on
Apr 23, 2024
Sold by
Baum Stacy M and Baum Nathan E
Bought by
Schroeder Nikki L
Seller's Agent
Aaron Cowham
Howard Hanna SB Real Estate
Buyer's Agent
Lori Johnston
Cressy & Everett - South Bend
List Price
$689,900
Sold Price
$684,900
Premium/Discount to List
-$5,000
-0.72%
Views
93

Purchase Details

Closed on
Oct 8, 2021
Sold by
Kline Custom Homes Inc
Bought by
Baum Stacy M and Baum Nathan E

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$548,250
Interest Rate
2.8%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jan 15, 2021
Sold by
Northbridge Valley Llc
Bought by
Kline Custom Homes Inc
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
Schroeder Nikki L -- Meridian Title
Schroeder Nikki L $756,900 Meridian Title
Baum Stacy M -- Drake Andrew R
Kline Custom Homes Inc -- None Listed On Document
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Baum Stacy M $548,250
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
04/26/2024 04/26/24 Sold $684,900 0.0% $194 / Sq Ft
03/11/2024 03/11/24 Pending -- -- --
02/23/2024 02/23/24 Price Changed $684,900 -0.7% $194 / Sq Ft
02/09/2024 02/09/24 For Sale $689,900 +0.7% $195 / Sq Ft
02/05/2024 02/05/24 Off Market $684,900 -- --
01/25/2024 01/25/24 For Sale $689,900 -- $195 / 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,561 $589,000 $66,900 $522,100
2023 $4,518 $499,300 $66,900 $432,400
2022 $5,080 $503,700 $66,900 $436,800
2021 $12 $700 $700 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Indiana Regional MLS

MLS Number: 202402463

Indiana Regional MLS

APN: 71-05-32-401-198.000-031