NOT LISTED FOR SALE

2615 Queens Ln Dyer, IN 46311

Estimated Value: $509,000 - $512,000

4 Beds
3.5 Baths
3,563 Sq Ft
$143/Sq Ft Est. Value

Last Sold December 08, 2014

Last sale price $310,000 $87 Per Sq Ft

Est. 60% increase in value since last sale

Current estimated payment $3,545/month

82 Days on Market

Highlights

  • Above Ground Pool
  • Lake View
  • Wooded Lot
  • Kahler Middle School Rated A-
  • Deck
  • Covered Patio or Porch

About This Home

As of December 2014

LOCATION... LOCATION... LOCATION... THIS HOME OWNS IT AND MUCH MORE!!!!!! SITUATED IN CASTLEWOOD SUBDVISION JUST MINUTES FROM THE ILLINOIS BORDER IS THIS WELL DESIGNED IMMACULATE, ALL BRICK, 4 BEDROOM, 3.5 BATH, TWO STORY HOME. The efficient kitchen offers ceramic flooring, breakfast bar and stainless steel appliances. The spacious formal dining room and grand living room combo displays 9 ft ceilings, gleaming hardwood flooring, and light filled windows. Enjoy the cozy fireplace in the spacious family room open to the kitchen. The Elaborate Master Suite boasts a stately arched entrance, private bath with double sinks, full wall of closets and private staircase. The finished basement includes a dry bar, pool table room, great room, separate play area/office and even allows for storage space. Enjoy your summers on the Large Deck and cool off in the above ground pool. All this and more = SIMPLY WON'T LAST LONG!!! Call today for a private tour!

Last Agent to Sell the Property

Gina Guarino

McColly Real Estate License #RB14043690 Listed on: 09/04/2014

McColly Real Estate

Last Buyer's Agent

Carol Biel

BHHS Executive Realty License #RB14045310

BHHS Executive Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,668

Year Built

  • Built in 1984

Lot Details

  • 0.4 Acre Lot
  • Lot Dimensions are 137 x 130
  • Landscaped
  • Sloped Lot
  • Wooded Lot

Parking

  • 2.5 Car Attached Garage
  • Garage Door Opener

Home Design

  • Brick Foundation

Interior Spaces

  • 2-Story Property
  • Great Room with Fireplace
  • Living Room with Fireplace
  • Lake Views
  • Home Security System
  • Basement

Kitchen

  • Gas Range
  • Microwave
  • Freezer
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Outdoor Features

  • Above Ground Pool
  • Deck
  • Covered Patio or Porch

Utilities

  • Central Air
  • Hot Water Heating System
  • Radiant Heating System

Community Details

  • Property has a Home Owners Association
  • Christine Mcculloch Association, Phone Number (219) 614-3448
  • Castlewood Subdivision

Listing and Financial Details

  • Assessor Parcel Number 451118403001000034

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,668

Year Built

Built in 1984

Lot Details

0

Parking

2

Listing Details

  • Property Type: Residential
  • Year Built: 1984
  • Reso Property Sub Type: Single Family Residence
  • ResoLaundryFeatures: Main Level
  • ResoLotFeatures: Landscaped, Paved, Sloped, Wooded
  • ResoPoolFeatures: Above Ground
  • Road Surface Type: Paved
  • Reso View: Lake
  • ResoSecurityFeatures: Security System
  • Co List Office Mls Id: NRA254
  • Subdivision Name: Castlewood
  • Above Grade Finished Sq Ft: 2741
  • Garage Yn: Yes
  • Unit Levels: Two
  • Reso Other Structures: Gazebo
  • Property Attached Yn: No
  • AuctionYN: No
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Dishwasher, Disposal, Dryer, Exhaust Fan, Freezer, Gas Range, Microwave, Washer
  • Basement: Interior Entry, Sump Pump
  • Basement YN: Yes
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 822
  • Fireplace Features: Great Room, Living Room
  • Fireplaces: 1
  • ResoLivingAreaSource: Assessor

Exterior Features

  • Exterior Features: Lighting
  • Acres: 0.4
  • Construction Type: Brick
  • Patio And Porch Features: Covered, Deck, Porch

Garage/Parking

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

Utilities

  • Utilities: Cable Available
  • Cooling: Central Air, Whole House Fan
  • Heating: Hot Water, Humidity Control, Radiant
  • Water Source: Public

Condo/Co-op/Association

  • Community Features: Curbs, Sidewalks
  • Association Fee: 290
  • Association Name: Christine McCulloch
  • Phone: 219-614-3448
  • Association: Yes

Schools

  • Junior High Dist: Lake Central

Lot Info

  • Lot Dimensions: 137 x 130
  • Lot Size Sq Ft: 17424
  • Parcel #: 451118403001000034

Tax Info

  • Year: 2013
  • Tax Annual Amount: 3668

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 4, 2014
Closed on
Dec 5, 2014
Sold by
Gerlach David and Gerlach Mary
Bought by
Martinez John A and Martinez Griselda
Seller's Agent
Gina Guarino
McColly Real Estate
Buyer's Agent
Carol Biel
BHHS Executive Realty
List Price
$310,000
Sold Price
$310,000
Current Estimated Value
$496,949

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$186,949
Avg. Annual Appreciation
4.61%
Original Mortgage
$279,000
Outstanding Balance
$214,106
Interest Rate
3.97%
Mortgage Type
New Conventional
Estimated Equity
$295,983
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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
Martinez John A -- Chicago Title Co Llc
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Martinez John A $279,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
12/08/2014 12/08/14 Sold $310,000 0.0% $87 / Sq Ft
11/25/2014 11/25/14 Pending -- -- --
09/04/2014 09/04/14 For Sale $310,000 -- $87 / 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 $11,200 $456,100 $111,900 $344,200
2023 $5,254 $440,400 $111,900 $328,500
2022 $5,254 $430,100 $111,900 $318,200
2021 $4,301 $361,200 $91,800 $269,400
2020 $4,179 $347,000 $78,400 $268,600
2019 $4,349 $347,900 $73,100 $274,800
2018 $4,287 $335,300 $73,100 $262,200
2017 $3,918 $330,200 $73,100 $257,100
2016 $3,713 $311,200 $73,100 $238,100
2014 $3,718 $326,900 $73,100 $253,800
2013 $3,668 $319,100 $73,100 $246,000
Source: Public Records

Agents Affiliated with this Home

  • Gina Guarino

    Seller's Agent in 2014

    Gina Guarino

    McColly Real Estate

    (219) 765-6698

    11 in this area

    277 Total Sales

    Gina Guarino
    Section Image
  • Carol Biel

    Buyer's Agent in 2014

    Carol Biel

    BHHS Executive Realty

    (219) 688-9515

    9 in this area

    334 Total Sales

    Carol Biel
    Section Image
See All Agents

Map

Source: Northwest Indiana Association of REALTORS®

MLS Number: 357884

Northwest Indiana Association of REALTORS®

APN: 45-11-18-403-001.000-034

Indiana Lake County Dyer 46311

2615 Queens Ln, Dyer, IN

Not Listed for Sale

Detached

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