NOT LISTED FOR SALE

Estimated Value: $399,000 - $539,000

5 Beds
2.5 Baths
3,251 Sq Ft
$149/Sq Ft Est. Value

Last Sold June 10, 2024

Last sale price $510,000 $157 Per Sq Ft

Est. 5% decrease in value since last sale

Current estimated payment $3,414/month

18 Days on Market

Highlights

  • Views of Trees
  • Covered Patio or Porch
  • Landscaped
  • Lincoln Elementary School Rated A
  • 2 Car Attached Garage
  • Forced Air Heating and Cooling System

About This Home

As of June 2024

Welcome to your dream home in Cedar Lake's Mill Creek Subdivision boasting close proximity to local schools, shopping, dining, and other favorable amenities! This stunning two-story residence combines comfort, space, and style, offering everything you've been searching for and more. As you approach, you'll be greeted by the inviting covered porch, perfect for enjoying your morning coffee. Step inside and discover the seamless flow of the open-concept layout, where natural light pours in, creating a warm and welcoming ambiance throughout. The heart of the home lies in the expansive kitchen, featuring ample counter space, modern appliances, and an attached sunroom, making it ideal for both everyday living and entertaining guests. Adjacent to the kitchen, you'll find a formal dining room, providing the perfect setting for hosting dinner parties and creating lasting memories with loved ones. With five spacious bedrooms, there's plenty of room to spread out and unwind. Retreat to the main floor primary bedroom, complete with a private ensuite bathroom and massive walk-in closet offering a peaceful oasis to relax and recharge after a long day. But the beauty of this home doesn't end there. Step outside to the tranquil patio, overlooking the sprawling backyard, where endless possibilities await for outdoor gatherings, gardening, or simply enjoying the beauty of nature. For those in need of additional space, the full unfinished basement offers endless potential to customize and create the ultimate recreation area, home gym, or whatever your heart desires.Don't miss your chance to make this exceptional property your own and start living the life you've always dreamed of. Schedule your showing today and prepare to fall in love with your new forever home!

Last Agent to Sell the Property

Gina Guarino

McColly Real Estate License #RB14043690 Listed on: 04/16/2024

McColly Real Estate

Co-Listed By

Dominic Guarino

McColly Real Estate License #RB14050948

Last Buyer's Agent

Kelli Velasquez

New Chapter Real Estate License #RB22001744

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,662

Year Built

  • Built in 2019

Lot Details

  • 0.28 Acre Lot
  • Lot Dimensions are 80 x 150
  • Landscaped

HOA Fees

  • $31 Monthly HOA Fees

Parking

  • 2 Car Attached Garage

Property Views

  • Trees
  • Neighborhood

Home Design

  • Brick Foundation

Interior Spaces

  • 3,251 Sq Ft Home
  • 2-Story Property
  • Carpet
  • Basement

Kitchen

  • Oven
  • Microwave

Bedrooms and Bathrooms

  • 5 Bedrooms

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Outdoor Features

  • Covered Patio or Porch

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas

Community Details

  • First American Management Company Association, Phone Number (219) 464-3536
  • Mill Creek Subdivision

Listing and Financial Details

  • Assessor Parcel Number 45-15-10-151-010.000-015

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,662

Year Built

Built in 2019

Lot Details

0

HOA Fees

$31 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Year Built: 2019
  • Reso Property Sub Type: Single Family Residence
  • ResoLaundryFeatures: In Unit, Main Level
  • ResoLotFeatures: Back Yard, Rectangular Lot, Few Trees, Level, Landscaped
  • ResoPoolFeatures: None
  • Road Surface Type: Paved
  • Reso View: Neighborhood, Trees/Woods
  • ResoOtherEquipment: None
  • Reso Association Amenities: None
  • Reso Association Fee Includes: None
  • Co List Office Mls Id: NRA254
  • Subdivision Name: Mill Creek
  • Above Grade Finished Sq Ft: 3251
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: No
  • Reso Other Structures: None
  • Property Attached Yn: No
  • Financial Info Electric: 200+ Amp Service
  • AuctionYN: No
  • AboveGradeUnfinishedArea: 0.00
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Dryer, Refrigerator, Washer, Vented Exhaust Fan, Microwave, Oven, Gas Water Heater, Free-Standing Gas Range
  • Interior Amenities: Ceiling Fan(s), Walk-In Closet(s), Open Floorplan
  • Basement: Concrete, Sump Pump, Unfinished
  • Flooring: Carpet
  • Basement YN: Yes
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • ResoLivingAreaSource: Assessor

Exterior Features

  • Exterior Features: None
  • Acres: 0.2755
  • Waterfront: No
  • Construction Type: Brick, Vinyl Siding
  • Patio And Porch Features: Covered, Patio, Front Porch
  • Reso Roof: Shingle

Garage/Parking

  • Garage Spaces: 2
  • Parking Features: Attached

Utilities

  • Sewer: Public Sewer
  • Utilities: Cable Connected, Sewer Connected, Natural Gas Connected, Electricity Connected
  • Cooling: Central Air
  • Heating: Central, Natural Gas, Forced Air
  • Water Source: Public

Condo/Co-op/Association

  • Community Features: Curbs, Sidewalks
  • Association Fee: 374
  • Association Fee Frequency: Annually
  • Association Name: First American Management Company
  • Phone: 219-464-3536
  • Association: Yes

Lot Info

  • Lot Dimensions: 80 x 150
  • Lot Size Sq Ft: 12000.78
  • Parcel #: 45-15-10-151-010.000-015

Tax Info

  • Year: 2023
  • Tax Annual Amount: 4662

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 16, 2024
Closed on
Jun 13, 2024
Sold by
Deboer Jason
Bought by
Gallagher Kerry E
Seller's Agent
Gina Guarino
McColly Real Estate
Buyer's Agent
Kelli Velasquez
New Chapter Real Estate
List Price
$529,900
Sold Price
$510,000
Premium/Discount to List
-$19,900
-3.76%
Views
29
Current Estimated Value
$484,885

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$25,115
Avg. Annual Appreciation
-3.59%
Original Mortgage
$408,000
Outstanding Balance
$402,639
Interest Rate
7.22%
Mortgage Type
New Conventional
Estimated Equity
$82,246

Purchase Details

Listed on
Apr 16, 2024
Closed on
Jun 6, 2024
Sold by
Ramos Lynn C
Bought by
Hanlon Ryan and Hanlon Linda
Seller's Agent
Gina Guarino
McColly Real Estate
Buyer's Agent
Kelli Velasquez
New Chapter Real Estate
List Price
$529,900
Sold Price
$510,000
Premium/Discount to List
-$19,900
-3.76%
Views
29

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$408,000
Outstanding Balance
$402,639
Interest Rate
7.22%
Mortgage Type
New Conventional
Estimated Equity
$82,246

Purchase Details

Closed on
Aug 30, 2019
Sold by
Mill Creek Development Llc
Bought by
Ramos Lynn C
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
Gallagher Kerry E $510,000 Community Title Company
Hanlon Ryan $510,000 Community Title Company
Ramos Lynn C -- Fidelity National Title Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Hanlon Ryan $408,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
06/10/2024 06/10/24 Sold $510,000 -3.8% $157 / Sq Ft
04/17/2024 04/17/24 For Sale $529,900 -- $163 / Sq Ft
Source: Northwest Indiana Association of REALTORS®

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 $10,140 $440,400 $66,600 $373,800
2023 $4,662 $427,400 $66,600 $360,800
2022 $4,986 $411,500 $66,600 $344,900
2021 $4,696 $384,200 $50,200 $334,000
2020 $4,202 $337,500 $50,200 $287,300
2019 $7 $600 $600 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Northwest Indiana Association of REALTORS®

MLS Number: 802276

Northwest Indiana Association of REALTORS®

APN: 45-15-10-151-010.000-015