NOT LISTED FOR SALE

1588 Sheffield Ave Dyer, IN 46311

Estimated Value: $360,000 - $379,000

3 Beds
2.5 Baths
1,820 Sq Ft
$204/Sq Ft Est. Value

Last Sold September 22, 2023

Last sale price $357,000 $196 Per Sq Ft

Est. 4% increase in value since last sale

Current estimated payment $2,086/month

79 Days on Market

Highlights

  • 2 Car Attached Garage
  • Patio
  • Carpet
  • Protsman Elementary School Rated A
  • Forced Air Heating and Cooling System

About This Home

As of September 2023

Final phase of 1500 North! The Finely features a main floor primary bedroom with en suite and main floor laundry. Open concept floor plan featuring a spacious kitchen with island, quartz counters, stainless steel appliances included and a dining room. Spacious living room with glass doors overlooking the patio all with luxury vinyl plan flooring. Main floor primary bedroom with walk in closet and en suite bathroom with custom tiled shower. Upstairs includes two additional bedrooms both with walk in closets, full bathroom and a storage room! Outside enjoy the back patio, courtyard and oversized 2 car attached garage. Completely maintenance free living! Expected to be completed by end of August.

Last Agent to Sell the Property

Heather Bult

Haven Realty License #RB15000997 Listed on: 05/03/2023

Last Buyer's Agent

Stephani Nydam

Realty Executives Premier License #RB19001139

Realty Executives Premier

Property Details

Home Type

  • Multi-Family

Est. Annual Taxes

  • $476

Year Built

  • Built in 2023

Lot Details

  • 0.55

Parking

  • 2 Car Attached Garage
  • Garage Door Opener

Home Design

  • Property Attached
  • Stone

Interior Spaces

  • 1,820 Sq Ft Home
  • 1.5-Story Property

Kitchen

  • <<microwave>>
  • Dishwasher
  • Disposal

Flooring

  • Carpet
  • Vinyl

Bedrooms and Bathrooms

  • 3 Bedrooms

Utilities

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

Additional Features

  • Patio
  • Lot Dimensions are 50x33

Community Details

  • Property has a Home Owners Association
  • Built by Distinctive Homes of Indiana
  • 1500 North Subdivision

Listing and Financial Details

  • Assessor Parcel Number NEW OR UNDER CONSTRUCTION

Property Details

Home Type

Multi-Family

Est. Annual Taxes

$476

Year Built

Built in 2023

Lot Details

0

Parking

2

Listing Details

  • Property Type: Residential
  • Year Built: 2023
  • Reso Property Sub Type: Townhouse
  • ResoLaundryFeatures: Main Level
  • ResoLotFeatures: Landscaped, Paved, Sprinklers In Front, Sprinklers In Rear
  • Road Surface Type: Paved
  • Co List Office Mls Id: NRA2114
  • Subdivision Name: 1500 North
  • Above Grade Finished Sq Ft: 1820
  • Architectural Style: Other
  • Garage Yn: Yes
  • Unit Levels: One and One Half
  • Property Attached Yn: Yes
  • Special Features: NewHome
  • Property Sub Type: MultiFamily

Interior Features

  • Appliances: Built-In Gas Range, Dishwasher, Disposal, Microwave, Refrigerator
  • Interior Amenities: Primary Downstairs
  • Flooring: Carpet, Ceramic Tile, Vinyl
  • Basement YN: No
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • ResoLivingAreaSource: Builder

Exterior Features

  • Builder Name: Distinctive Homes of Indiana
  • Construction Type: Stone, Vinyl Siding
  • Foundation Details: Slab
  • Patio And Porch Features: Patio

Garage/Parking

  • Garage Spaces: 2
  • Parking Features: Attached, Garage Door Opener

Utilities

  • Cooling: Central Air
  • Heating: Forced Air, Humidity Control, Natural Gas
  • Water Source: Public

Condo/Co-op/Association

  • Association Fee: 125
  • Association Name: TBD
  • Phone: TBD
  • Association: Yes

Lot Info

  • Lot Dimensions: 50x33
  • Parcel #: NEW OR UNDER CONSTRUCTION

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 3, 2023
Closed on
Sep 20, 2023
Sold by
1500 North Llc
Bought by
Johnsen Stephanie
Seller's Agent
Heather Bult
Haven Realty
Buyer's Agent
Stephani Nydam
Realty Executives Premier
List Price
$350,000
Sold Price
$357,000
Premium/Discount to List
$7,000
2%
Views
7
Current Estimated Value
$370,375

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$13,375
Avg. Annual Appreciation
-2.35%
Original Mortgage
$285,600
Outstanding Balance
$275,333
Interest Rate
7.09%
Mortgage Type
New Conventional
Estimated Equity
$66,551
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
Johnsen Stephanie $357,000 Fidelity National Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Johnsen Stephanie $285,600
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
09/22/2023 09/22/23 Sold $357,000 +2.0% $196 / Sq Ft
07/21/2023 07/21/23 Pending -- -- --
05/03/2023 05/03/23 For Sale $350,000 -- $192 / 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 $476 $352,800 $75,000 $277,800
2023 $407 $18,700 $18,700 --
2022 $426 $18,700 $18,700 $0
Source: Public Records

Agents Affiliated with this Home

  • H

    Seller's Agent in 2023

    Heather Bult

    Haven Realty

  • Stephani Nydam

    Buyer's Agent in 2023

    Stephani Nydam

    Realty Executives

    (708) 601-2874

    6 in this area

    208 Total Sales

    Stephani Nydam
    Section Image
See All Agents

Map

Source: Northwest Indiana Association of REALTORS®

MLS Number: 529763

Northwest Indiana Association of REALTORS®

APN: 45-10-12-181-009.000-034

Indiana Lake County Dyer 46311

1588 Sheffield Ave, Dyer, IN

This home is located at 1588 Sheffield Ave, Dyer, IN 46311 since 03 May 2023 and is currently estimated at $370,375, approximately $203 per square foot. This property was built in 2023. 1588 Sheffield Ave is a home located in Lake County with nearby schools including Protsman Elementary School, Kahler Middle School, and Lake Central High School.

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Northwest Indiana Association of REALTORS® Copyright 2025 MuItiple Listing Service of the Northwest Indiana Realtors Association Multiple Listing Service (NIRA MLS). All rights reserved. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

Nearby Homes