NOT LISTED FOR SALE

51371 Colleen Ct Granger, IN 46530

Estimated Value: $1,001,000 - $1,128,012

4 Beds
4.5 Baths
6,192 Sq Ft
$174/Sq Ft Est. Value

Last Sold May 25, 2017

Last sale price $832,300 $134 Per Sq Ft

Est. 29% increase in value since last sale

Current estimated payment $6,859/month

59 Days on Market

Highlights

  • In Ground Pool
  • 1.26 Acre Lot
  • Vaulted Ceiling
  • Gated Community
  • Open Floorplan
  • Partially Wooded Lot

About This Home

As of May 2017

Entertainers Dream House. Recently remodeled home by a former New York Designer in prestigious Shamrock Hills located in Granger. Privately gated subdivision just minutes to Notre Dame University, restaurants, shopping & hospitals. Spacious floor plan perfectly designed for entertaining and relaxing by the pool & jacuzzi. This elegant property includes 4 bedrooms, 2 bonus rooms along with 4.5 baths. Gourmet kitchen w/granite counter tops, cherry cabinets, new high end stainless steel appliances (Sub Zero Refrigerator and Wolfe Stove) opens to the dramatic two story great room. Exquisite master en- suite on the second floor allows separate step-in spa shower, jetted tub and walk in closet. Second floor also has en- suite with attached bonus room, and 2 bedrooms with Jack and Jill bathroom. Finished walkout lower level includes rec room, family room with daylight windows and media area that will endlessly entertain you. A coriander wetbar with refrigerator, dishwasher, full bathroom and bonus room with laundry room complete lower level entertainment. Spectacular outdoor spaces with pool, jacuzzi and two fenced in yard areas on a large 1.26 acre lot. Additional features include central vacuum system for easy cleaning, LED lighting throughout home and large 833 sq. ft. attached three- car garage. Everything for those who want a unique lifestyle. Call for a private showing today!

Last Agent to Sell the Property

Jan Lazzara

RE/MAX 100 Listed on: 02/28/2017

RE/MAX 100

Last Buyer's Agent

Jan Lazzara

RE/MAX 100 Listed on: 02/28/2017

RE/MAX 100

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,814

Year Built

  • Built in 1999

Lot Details

  • 1.26 Acre Lot
  • Lot Dimensions are 311x211
  • Backs to Open Ground
  • Cul-De-Sac
  • Decorative Fence
  • Landscaped
  • Level Lot
  • Irrigation
  • Partially Wooded Lot

HOA Fees

  • $167 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Asphalt Roof

Interior Spaces

  • 2-Story Property
  • Open Floorplan
  • Wet Bar
  • Central Vacuum
  • Built-in Bookshelves
  • Built-In Features
  • Vaulted Ceiling
  • Ceiling Fan
  • Skylights
  • Gas Log Fireplace
  • Pocket Doors
  • Entrance Foyer
  • Living Room with Fireplace
  • Formal Dining Room

Kitchen

  • Kitchenette
  • Eat-In Kitchen
  • Gas Oven or Range
  • Kitchen Island
  • Stone Countertops
  • Utility Sink
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • Jack-and-Jill Bathroom
  • Double Vanity
  • Whirlpool Bathtub
  • Separate Shower

Laundry

  • Laundry on main level
  • Gas Dryer Hookup

Finished Basement

  • Walk-Out Basement
  • Sump Pump
  • 1 Bathroom in Basement
  • Natural lighting in basement

Home Security

  • Home Security System
  • Fire and Smoke Detector

Pool

  • In Ground Pool
  • Spa

Utilities

  • Forced Air Heating and Cooling System
  • Private Company Owned Well
  • Well
  • Septic System
  • Cable TV Available

Additional Features

  • Patio
  • Suburban Location

Listing and Financial Details

  • Home warranty included in the sale of the property
  • Assessor Parcel Number 71-04-17-255-005.000-003

Community Details

Recreation

  • Community Pool

Additional Features

  • Community Fire Pit
  • Gated Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,814

Year Built

Built in 1999

Lot Details

0

HOA Fees

$167 per month

Parking

3

Listing Details

  • Class: RESIDENTIAL
  • Property Sub Type: Site-Built Home
  • Year Built: 1999
  • Age: 18
  • Style: Two Story
  • Architectural Style: Traditional
  • Total Number of Rooms: 10
  • Total Number of Rooms Below Grade: 2
  • Bedrooms: 4
  • Number Above Grade Bedrooms: 4
  • Total Bathrooms: 5
  • Total Full Bathrooms: 4
  • Total Number of Half Bathrooms: 1
  • Legal Description: SHAMROCK HILLS PHASE TWO SEC ONE LOT 29
  • Parcel Number ID: 71-04-17-255-005.000-003
  • Platted: Yes
  • Amenities: Hot Tub/Spa, Alarm System-Security, Built-In Speaker System, Built-In Bookcase, Built-In Entertainment Ct, Cable Ready, Ceiling-9+, Ceiling Fan(s), Ceilings-Vaulted, Central Vacuum System, Closet(s) Walk-in, Countertops-Stone, Detector-Smoke, Disposal, Dryer Hook Up Gas, Eat-In Kitchen, Firepit, Foyer Entry, Garage Door Opener, Jet Tub, Home Warranty Included, Irrigation System, Kitchen Island, Landscaped, Open Floor Plan, Patio Open, Pocket Doors, Range/Oven Hook Up Gas, Skylight(s), Twin Sink Vanity, Utility Sink, Wet Bar, Alarm System-Sec. Cameras, Kitchenette, Stand Up Shower, Formal Dining Room, Main Floor Laundry, Sump Pump, Jack & Jill Bath
  • Cross Street: Shamrock Hills Dr.
  • Improvmnts In Last5 Yrs: Yes
  • Location: City/Town/Suburb, Gated Community
  • Road Access: County
  • Road Surface: Paved
  • Section Number: SEC ONE
  • Sp Lp Percent: 95.12
  • Special Features: None

Interior Features

  • Total Sq Ft: 6442
  • Total Finished Sq Ft: 6192
  • Above Grade Finished Sq Ft: 4192
  • Below Grade Finished Sq Ft: 2000
  • Below Grade Sq Ft: 250
  • Basement: Yes
  • Basement Foundation: Daylight, Walk-Out Basement, Finished
  • Basement Material: Poured Concrete
  • Number Of Fireplaces: 1
  • Fireplace: Living/Great Rm, Gas Log
  • Flooring: Hardwood Floors, Carpet, Tile, Ceramic Tile
  • Living Great Room: Dimensions: 12x14, On Level: Main
  • Kitchen: Dimensions: 26x14, On Level: Main
  • Dining Room: Dimensions: 16x13, On Level: Main
  • Family Room: Dimensions: 27x18, On Level: Main
  • Den: Dimensions: 17x19, On Level: Main
  • Recreation Room: Dimensions: 36x43, On Level: Lower
  • Extra Room: sunroom, Dimensions: 12x13, On Level: Main
  • Bedroom 1: Dimensions: 13x20, On Level: Upper
  • Bedroom 2: Dimensions: 15x13, On Level: Upper
  • Bedroom 3: Dimensions: 15x13, On Level: Upper
  • Bedroom 4: Dimensions: 5x12, On Level: Upper
  • Bedroom 5: Dimensions: 13x14, On Level: Upper
  • Other Room1: Lower level family room, Dimensions: 26x22, On Level: Lower
  • Number Below Grade Bathrooms: 1
  • Number of Below Grade Full Bathrooms: 1
  • Number of Main Level Half Bathrooms: 1
  • Total Below Grade Sq Ft: 2250

Exterior Features

  • Exterior: Brick
  • Roof Material: Asphalt
  • Outbuilding1: None
  • Pool: Below Ground
  • Pool: Yes
  • Fence: Decorative

Garage/Parking

  • Driveway: Concrete
  • Garage Type: Attached
  • Garage Number Of Cars: 3
  • Garage Size: Dimensions: 35x24
  • Garage Sq Ft: 840

Utilities

  • Cooling: Central Air
  • Heating Fuel: Forced Air
  • Sewer: Septic
  • Water Utilities: Well
  • Electric Company: AEP/I&M
  • Gas Company: NIPSCO
  • Cable Company: Comcast
  • Hvac: Ceiling Fan
  • Laundry: Dimensions: 15xMain, On Level: 11
  • Well Size: 4 Inches
  • Well Type: Private

Condo/Co-op/Association

  • Association Restrictions: Yes
  • Association Fees: 2000
  • Association Fees Frequency: Annually

Schools

  • School District: Clay Community Schools
  • Elementary School: Swanson
  • Middle School: Clay City
  • High School: Clay

Lot Info

  • Lot Description: Cul-De-Sac, Level, Partially Wooded
  • Lot Dimensions: 311x211
  • Estimated Lot Sq Ft: 54711
  • Estimated Lot Size Acres: 1.256
  • Lot Number: 29
  • Zoning: A Single Family Residential

Tax Info

  • Annual Taxes: 7814
  • Total Assessed Value: 547600
  • Exemptions: Homestead, Mortgage
  • Tax Code: Tax Code 02-Clay

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Mar 4, 2022
Sold by
Tapper Christopher S and Tapper Anastasia S
Bought by
Tapper Anastasia S
Current Estimated Value
$1,077,671

Purchase Details

Listed on
Feb 28, 2017
Closed on
May 25, 2017
Sold by
Tapper Christopher S
Bought by
Tapper Christopher S and Tapper Anastasia S
Seller's Agent
Jan Lazzara
RE/MAX 100
Buyer's Agent
Jan Lazzara
RE/MAX 100
List Price
$895,000
Sold Price
$832,300
Premium/Discount to List
-$62,700
-7.01%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
3.14%
Original Mortgage
$665,840
Interest Rate
3.97%
Mortgage Type
New Conventional

Purchase Details

Listed on
Feb 26, 2015
Closed on
Jun 12, 2015
Sold by
Wade Robert A and Wade Anita J
Bought by
Lally Terence and Lally Bettina L
Seller's Agent
Bobbie Vanosdal
Weichert Rltrs-J.Dunfee&Assoc.
Buyer's Agent
Jan Lazzara
RE/MAX 100
List Price
$849,500
Sold Price
$810,000
Premium/Discount to List
-$39,500
-4.65%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
1.40%
Original Mortgage
$648,000
Interest Rate
0.78%
Mortgage Type
New Conventional
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
Tapper Anastasia S -- Drake Andrew R
Tapper Christopher S -- --
Tapper Christopher S -- --
Lally Terence -- Meridian Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Tapper Christopher S $665,840
Previous Owner Lally Terence $648,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/25/2017 05/25/17 Sold $832,300 -7.0% $134 / Sq Ft
04/28/2017 04/28/17 Pending -- -- --
02/28/2017 02/28/17 For Sale $895,000 +10.5% $145 / Sq Ft
06/12/2015 06/12/15 Sold $810,000 -4.6% $131 / Sq Ft
04/01/2015 04/01/15 Pending -- -- --
02/26/2015 02/26/15 For Sale $849,500 -- $137 / 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 $11,745 $914,600 $248,500 $666,100
2023 $11,697 $927,500 $248,500 $679,000
2022 $11,964 $927,600 $248,500 $679,100
2021 $10,109 $771,700 $39,600 $732,100
2020 $7,955 $605,600 $36,300 $569,300
2019 $6,697 $625,400 $36,500 $588,900
2018 $8,241 $637,400 $36,500 $600,900
2017 $8,883 $628,500 $36,500 $592,000
2016 $9,143 $637,800 $39,300 $598,500
2014 $6,635 $465,900 $28,300 $437,600
2013 $5,010 $362,300 $21,500 $340,800
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Indiana Regional MLS

MLS Number: 201708073

Indiana Regional MLS

APN: 71-04-17-255-005.000-003