NOT LISTED FOR SALE

454 Old Hearthstone Cir N Collierville, TN 38017

Estimated Value: $718,095 - $779,000

5 Beds
3.5 Baths
4,000-4,499 Sq Ft
$168/Sq Ft Est. Value

Last Sold December 19, 2019

Last sale price $553,500 $123 Per Sq Ft

Est. 37% increase in value since last sale

Current estimated payment $4,471/month

Highlights

  • Updated Kitchen
  • Landscaped Professionally
  • Traditional Architecture
  • Sycamore Elementary School Rated A
  • Vaulted Ceiling
  • Wood Flooring

About This Home

As of December 2019

Better than new construction! Attention to detail! Beautiful 5 bedroom; 3.5 bath home! Two bedrooms downstairs! Keystone floor plan full of upgrades including oversized King Spa Shower, hardwood floors, gourmet kitchen, butler's pantry, convenient friend's entry, built-ins, bonus room, room sized loft and more! 3 car side load garage. Covered patio and spacious backyard! Convenient to Collierville's new high school!

Last Agent to Sell the Property

Maureen Fraser

John Green & Co., REALTORS License #302741 Listed on: 11/04/2019

Last Buyer's Agent

Virginia Sharp

Ware Jones, REALTORS License #267532

Ware Jones, REALTORS

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,888

Year Built

  • Built in 2017

Lot Details

  • Lot Dimensions are 103.17 x 157.05
  • Landscaped Professionally
  • Level Lot
  • Few Trees

HOA Fees

  • $30 Monthly HOA Fees

Home Design

  • Traditional Architecture
  • Slab Foundation
  • Composition Shingle Roof

Interior Spaces

  • 4,000-4,499 Sq Ft Home
  • 4,158 Sq Ft Home
  • 2-Story Property
  • Smooth Ceilings
  • Vaulted Ceiling
  • Ceiling Fan
  • Some Wood Windows
  • Two Story Entrance Foyer
  • Great Room
  • Breakfast Room
  • Dining Room
  • Den with Fireplace
  • Loft
  • Bonus Room
  • Attic Access Panel

Kitchen

  • Updated Kitchen
  • Breakfast Bar
  • Double Oven
  • Gas Cooktop
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Wood
  • Partially Carpeted
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms | 2 Main Level Bedrooms
  • Primary Bedroom on Main
  • Split Bedroom Floorplan
  • En-Suite Bathroom
  • Walk-In Closet
  • Remodeled Bathroom
  • Primary Bathroom is a Full Bathroom
  • Dual Vanity Sinks in Primary Bathroom
  • Whirlpool Bathtub
  • Bathtub With Separate Shower Stall

Laundry

  • Laundry Room
  • Washer and Dryer Hookup

Home Security

  • Fire and Smoke Detector
  • Termite Clearance

Parking

  • 3 Car Attached Garage
  • Side Facing Garage
  • Garage Door Opener
  • Driveway

Additional Features

  • Covered Patio or Porch
  • Central Heating and Cooling System

Community Details

  • Estanaula Trails Ph 6 Sec C Hearthstone Subdivision
  • Mandatory home owners association

Listing and Financial Details

  • Assessor Parcel Number C0258R C00024

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,888

Year Built

Built in 2017

Lot Details

0

HOA Fees

$30 per month

Listing Details

  • Class: Residential
  • Type: Detached Single Family
  • Style: Traditional
  • Detached Unit Type: General Residential
  • Cross Street: E OLD HEARTHSTONE CIRCLE
  • MLS Map #: 876B
  • MAAR Subdivision Name: Estanaula Trails Ph 6 Sec C Hearthstone
  • List Price Per Sq Ft: 138
  • Number Of Stories: 2
  • Price Per Sq Ft: 133.12
  • Prop Construction Status: Existing Property
  • Estimated Sq Ft: 4158
  • Termite Contract: Yes
  • Year Built: 2017
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • First Story Floor Plan: Dining Room, Den/Great Room, Kitchen, Primary Bedroom, 2nd Bedroom, 2 or More Baths, Laundry Room, Breakfast Room
  • Second Story Floor Plan: 3rd Bedroom, 4th or More Bedrooms, 1 Bath, Bonus Room
  • Additional Bedroom Bathroom Info: 1 or More BR Down, Primary Down, Vaulted/Coffered Primary, Split Bedroom Plan, Renovated Bathroom, Luxury Primary Bath, Double Vanity Bath, Whirlpool(s), Separate Tub & Shower, Full Bath Down, Half Bath Down
  • Estimated Heated Sq Ft Range: 4000-4499
  • Bedroom 2 Description: Level 1, Private Full Bath, Smooth Ceiling, Carpet
  • Bedroom 3 Description: Level 2, Shared Bath, Carpet
  • Bedroom 4 Description: Level 2, Shared Bath, Carpet
  • Bedroom 5 Description: Level 2, Shared Bath, Carpet
  • Bedrooms: 5
  • Bedrooms Down: 2
  • Fireplace: In Den/Great Room
  • Floors/Ceilings: Part Hardwood, Part Carpet, Tile, Smooth Ceiling, 9 or more Ft. Ceiling, Vaulted/Coff/Tray Ceiling, Two Story Foyer
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Equipment: Double Oven, Cooktop, Gas Cooking, Disposal, Dishwasher, Microwave
  • Living Dining Kitchen: Separate Dining Room, Great Room, Updated/Renovated Kitchen, Breakfast Bar, Separate Breakfast Room, Pantry, Island In Kitchen, Washer/Dryer Connections
  • Misc Interior: Walk-In Closet(s), Attic Access, Walk-In Attic, Smoke Detector(s)
  • Number Of Fireplaces: 1
  • Other Rooms: Laundry Room, Bonus Room, Entry Hall, Loft/Balcony, Attic
  • Total Bathrooms: 3.1
  • Primary Bathroom Description: Double Sinks, Whirlpool Tub, Separate Shower, Vaulted/Coffered Ceiling, Smooth Ceiling, Tile Floor
  • P R I M A R Y B E D R O O M: Level 1, Walk-In Closet, Full Bath, Vaulted/Coffered Ceiling, Smooth Ceiling, Carpet

Exterior Features

  • Misc Exterior: Porch, Covered Patio
  • Exterior Windows: Brick Veneer, Wood/Composition
  • Foundation: Slab
  • Roof: Composition Shingles

Garage/Parking

  • Attached Detached Parking: Attached
  • Carport Garage: Garage
  • Number Covered Parking Spaces: 3
  • Parking Display: G3A
  • Parking Storage: Driveway/Pad, Garage Door Opener(s), Side-Load Garage

Utilities

  • Cooling: Central, Ceiling Fan(s)
  • Heating: Central
  • Security: Smoke Detector(s), Dead Bolt Lock(s)
  • Water Sewer: Public Water, Public Sewer

Association/Amenities

  • Annual Association Fee: 365
  • Neighborhood Association: Mandatory

Lot Info

  • Lot Description: Some Trees, Level, Professionally Landscaped
  • Lot Number: 453
  • Keeping Hearth Dimension: 11X10
  • Lot Size: 103.17 x 157.05

Multi Family

  • Number Of Rooms: 12

Tax Info

  • Assessor Parcel Number: C0258R C00024

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Nov 4, 2019
Closed on
Dec 19, 2019
Sold by
Huffman Lawrence and Huffman Jessica
Bought by
Bijou Ashil and Bijou Levashni
Seller's Agent
Maureen Fraser
John Green & Co., REALTORS
Buyer's Agent
Virginia Sharp
Ware Jones, REALTORS
List Price
$574,750
Sold Price
$553,500
Premium/Discount to List
-$21,250
-3.7%
Current Estimated Value
$758,024

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$204,524
Avg. Annual Appreciation
5.57%
Original Mortgage
$442,800
Outstanding Balance
$391,155
Interest Rate
3.7%
Mortgage Type
New Conventional
Estimated Equity
$366,869

Purchase Details

Listed on
Feb 3, 2017
Closed on
Apr 19, 2017
Sold by
Keith And David Grant Homes Llc
Bought by
Huffman Lawrence E and Huffman Jessica
Seller's Agent
Evette Reaves
Grant & Co., REALTORS
Buyer's Agent
Evette Reaves
Grant & Co., REALTORS
List Price
$440,440
Sold Price
$453,954
Premium/Discount to List
$13,514
3.07%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
7.71%
Original Mortgage
$454,276
Interest Rate
4.3%
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
Bijou Ashil $553,500 Delta Title Services Llc
Huffman Lawrence E $453,954 None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Bijou Ashil $442,800
Previous Owner Huffman Lawrence E $454,276
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
12/19/2019 12/19/19 Sold $553,500 -3.7% $138 / Sq Ft
11/21/2019 11/21/19 Pending -- -- --
11/04/2019 11/04/19 For Sale $574,750 +26.6% $144 / Sq Ft
04/19/2017 04/19/17 Sold $453,954 +3.1% $113 / Sq Ft View Prior Sale
02/03/2017 02/03/17 Pending -- -- --
02/03/2017 02/03/17 For Sale $440,440 -- $110 / Sq Ft
Source: Memphis Area 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
2025 $4,888 $184,275 $34,750 $149,525
2024 $4,888 $144,200 $22,500 $121,700
2023 $7,542 $144,200 $22,500 $121,700
2022 $7,369 $144,200 $22,500 $121,700
2021 $8,652 $144,200 $22,500 $121,700
2020 $6,615 $112,500 $21,150 $91,350
2019 $4,556 $112,500 $21,150 $91,350
2018 $4,556 $112,500 $21,150 $91,350
2017 $2,249 $39,175 $21,150 $18,025
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Memphis Area Association of REALTORS®

MLS Number: 10065294

Memphis Area Association of REALTORS®

APN: C0-258R-C0-0024