NOT LISTED FOR SALE

2615 Queens Ln Dyer, IN 46311

Estimated Value: $485,000 - $519,000

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

Last Sold December 08, 2014

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

Est. 62% increase in value since last sale

Current estimated payment $3,721/month

82 Days on Market

Highlights

  • Deck
  • Covered patio or porch
  • Central Air
  • Kahler Middle School Rated A-
  • 2.5 Car Attached Garage
  • Hot Water Heating System

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

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
  • Basement

Kitchen

  • Gas Range
  • Microwave
  • Freezer
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms

Laundry

  • Dryer
  • Washer

Outdoor Features

  • 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
  • Road Surface Type: Paved
  • Co List Office Mls Id: NRA254
  • Subdivision Name: Castlewood
  • Above Grade Finished Sq Ft: 2741
  • Garage Yn: Yes
  • Unit Levels: Two
  • Property Attached Yn: 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
$502,357

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$192,357
Avg. Annual Appreciation
4.68%
Original Mortgage
$279,000
Interest Rate
3.97%
Mortgage Type
New Conventional
Source: Public Records

Similar Homes in Dyer, IN

  • 2966 Hawthorne Ln, Dyer, IN 46311

    $439,000

    • 5 Beds
    • 3 Baths
    • 2,994 Sq Ft
    • 2966 Hawthorne Ln
    • Dyer, IN

    Welcome to this spacious and beautifully maintained bi-level home in the heart of Dyer! The main level features a large living room with vaulted ceilings, a cozy gas fireplace, and plenty of space for a formal dining table--perfect for entertaining. The eat-in kitchen offers an abundance of cabinetry, a built-in desk, pantry, and sliding doors that lead to a large screened porch overlooking the

    Shawn Smead @properties/Christie's Intl RE

    Section Image
  • 1602 Lake St, Dyer, IN 46311

    $389,900

    • 5 Beds
    • 3 Baths
    • 2,743 Sq Ft
    • 1602 Lake St
    • Dyer, IN

    Welcome to 1602 Lake St an immaculately maintained bi-level in one of Dyer's most desirable neighborhoods! With 5 spacious bedrooms, 3 full bathrooms, and over 2,700 square feet of flexible living space, this home offers the perfect blend of comfort, function, and style.Step inside and you'll immediately notice the grand arched window flooding the living room with natural light and highlighting

    Debra Hull Brokerworks Group

    Section Image
  • 2500 Castlewood Dr, Dyer, IN 46311

    $479,900

    • 5 Beds
    • 3 Baths
    • 3,802 Sq Ft
    • 2500 Castlewood Dr
    • Dyer, IN

    Welcome home to this large 5 bed, 3 bath ranch. It will be hard to pass up on this open concept home with a remodeled master bath, kitchen and several unique features to be admired. The back yard gives you a wonderfully large deck with gazebo along with beautiful foliage including a plum tree. This home gives you the square footage that you need along with neighborhood private park and lake

    Blaine Wieneke Banga Realty, LLC

    Section Image
  • 2746 Camelot Dr, Dyer, IN 46311

    $424,900

    • 4 Beds
    • 3 Baths
    • 2,292 Sq Ft
    • 2746 Camelot Dr
    • Dyer, IN

    Welcome Home to this beautiful and spacious 4-bedroom 3 bath residence that is turnkey and has been very well cared for and maintained. Upon entering, the inviting foyer has a vaulted ceiling and leads into the large living room and kitchen, perfect for entertaining. The living room has newer carpet and vaulted ceilings, the kitchen offers stainless appliances, vaulted ceiling, plenty of

    Brian E Rossi Listing Leaders Northwest

    Section Image
  • 2513 Hickory Dr, Dyer, IN 46311

    $485,000

    • 4 Beds
    • 3 Baths
    • 2,640 Sq Ft
    • 2513 Hickory Dr
    • Dyer, IN

    Check out this beautifully updated split level home on a third acre lot in the gorgeous Schilling Subdivision of Dyer! Choose your destination... this home is Just minutes away from US30, I-394 and public transportation. Enter into the large foyer and be greeted by gleaming hardwood floors throughout the upper level living room, bedrooms and hallway. Completely updated kitchen has vaulted

    Dawn Veness McColly Real Estate

    Section Image
  • 924 Quinn Place, Dyer, IN 46311

    $424,000

    • 4 Beds
    • 3 Baths
    • 2,472 Sq Ft
    • 924 Quinn Place
    • Dyer, IN

    You're going to want to check this out! This home is brimming with updates just for you. Picture this: a beautifully remodeled kitchen and bathrooms, fresh new flooring throughout, and a newer furnace and water heater. And here's the hidden gem - behind the drywall, you'll also find updated electrical and plumbing. Modern living, reimagined!

    Mary Beals JRD Realty

    Section Image
  • 919 Francis Place, Dyer, IN 46311

    $498,750

    • 3 Beds
    • 3 Baths
    • 2,760 Sq Ft
    • 919 Francis Place
    • Dyer, IN

    I can't say enough about this transformation. Nearly everything has been touched w/ just a few select original nuances remaining allowing the new owner to move in & enjoy the beauty & nostalgia this home has to offer. This 3 bedroom 3 bath ranch is a RARE FIND in sought after Schilling subdivision tucked away on dead end street just minutes from the IL state line IDEAL for commuters. Nestled on a

    Christine Benko SCHUPP Real Estate

    Section Image
  • 7951 Tapper St, Dyer, IN 46311

    $409,900

    • 4 Beds
    • 3 Baths
    • 2,668 Sq Ft
    • 7951 Tapper St
    • Dyer, IN

    Home is located in a country type setting yet close to all types of amenities, services, etc. Large bi-level style home sits on just shy of 1 acre (0.83) on a well-manicured lot. Beautiful setting. Rather quiet with very limited traffic in this area. Home is rather large with all 4 generous sized bedrooms on the upper level. Lower level, cozy family room is rather large with fireplace.

    Robert O'Hara RE/MAX 10 Schererville

    Section Image
  • 3461 Prairie Dr, Dyer, IN 46311

    $547,700

    • 4 Beds
    • 3.5 Baths
    • 3,521 Sq Ft
    • 3461 Prairie Dr
    • Dyer, IN

    Wonderful Home Back on the Market...Seller had allowed a Sale Contingency and Buyer's Home did not close...You Will Be Impressed with the Space and Condition of this CUSTOM Built Home. Tired of the Same Lay-Outs and Styles of Homes You Have Been Viewing....This Home is Truly Unique and Owner/Family Member Transfer to Family Allowed for Even More Adding of Finished Square Footage Including an

    Wendy Embry McColly Real Estate

    Section Image

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
Martinez John A -- Chicago Title Co Llc
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Martinez John A $272,205
Closed Martinez John A $279,000
Previous Owner Gerlach David $215,000
Previous Owner Gerlach David A $99,983
Previous Owner Gerlach David A $125,000
Previous Owner Gerlach David $179,000
Previous Owner Gerlach David $50,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
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

  • Section Image
  • 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