NOT LISTED FOR SALE

5821 Constance St Shawnee, KS 66216

Estimated Value: $602,000 - $798,000

5 Beds
5.5 Baths
4,533 Sq Ft
$163/Sq Ft Est. Value

Last Sold November 29, 2021

Current estimated payment $4,739/month

159 Days on Market

Highlights

  • Vaulted Ceiling
  • Traditional Architecture
  • Granite Countertops
  • Shawnee Mission Northwest High School Rated A
  • Loft
  • Screened Porch

About This Home

As of November 2021

Custom built by Don Julian, backing east at the end of a quiet cul-de-sac in Granite Falls and just Reduced $50,000.! Loaded w/upgrades including tile floors, screened-in porch, extensive trim detail, Pella windows, plantation shutters & solid wood doors! Awesome kitchen with island, barrel vault ceiling, huge walk-in pantry & spacious laundry rm. 3 bdrms. on the main flr., and a 2nd flr. loft that could be converted into a bedroom. Fin. walkout LL with Fam. rm., Rec. rm., Media rm., 2 bdrms. & 2 baths. Tile roof, metal fenced backyard, sprinkler system, zoned HVAC, 9,000 watt auxiliary gas generator & outdoor utility shed.

Last Agent to Sell the Property

Ken Rosberg

Rosberg Realty License #413501459 Listed on: 05/12/2021

Last Buyer's Agent

Jim Fussell Realtor

KW KANSAS CITY METRO

KW KANSAS CITY METRO

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,236

Year Built

  • Built in 2007

Lot Details

  • 0.43 Acre Lot
  • Lot Dimensions are 52x151x113x81x147
  • Cul-De-Sac
  • Aluminum or Metal Fence
  • Paved or Partially Paved Lot
  • Many Trees

HOA Fees

  • $75 Monthly HOA Fees

Parking

  • 3 Car Attached Garage

Home Design

  • Traditional Architecture
  • Wood Siding
  • Stucco

Interior Spaces

  • Wet Bar: Carpet, Ceiling Fan(s), Shower Over Tub, Walk-In Closet(s), Shower Only, Cathedral/Vaulted Ceiling, Ceramic Tiles, Separate Shower And Tub, Kitchen Island, Pantry, Built-in Features, Fireplace
  • Built-In Features: Carpet, Ceiling Fan(s), Shower Over Tub, Walk-In Closet(s), Shower Only, Cathedral/Vaulted Ceiling, Ceramic Tiles, Separate Shower And Tub, Kitchen Island, Pantry, Built-in Features, Fireplace
  • Vaulted Ceiling
  • Ceiling Fan: Carpet, Ceiling Fan(s), Shower Over Tub, Walk-In Closet(s), Shower Only, Cathedral/Vaulted Ceiling, Ceramic Tiles, Separate Shower And Tub, Kitchen Island, Pantry, Built-in Features, Fireplace
  • Skylights
  • Thermal Windows
  • Shades
  • Plantation Shutters
  • Drapes & Rods
  • Great Room with Fireplace
  • Formal Dining Room
  • Loft
  • Screened Porch
  • Home Security System
  • Laundry on main level

Kitchen

  • Breakfast Area or Nook
  • Electric Oven or Range
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Laminate Countertops
  • Disposal

Flooring

  • Wall to Wall Carpet
  • Linoleum
  • Laminate
  • Stone
  • Ceramic Tile
  • Luxury Vinyl Plank Tile
  • Luxury Vinyl Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Cedar Closet: Carpet, Ceiling Fan(s), Shower Over Tub, Walk-In Closet(s), Shower Only, Cathedral/Vaulted Ceiling, Ceramic Tiles, Separate Shower And Tub, Kitchen Island, Pantry, Built-in Features, Fireplace
  • Walk-In Closet: Carpet, Ceiling Fan(s), Shower Over Tub, Walk-In Closet(s), Shower Only, Cathedral/Vaulted Ceiling, Ceramic Tiles, Separate Shower And Tub, Kitchen Island, Pantry, Built-in Features, Fireplace
  • Double Vanity
  • Carpet

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Sub-Basement: Bedroom 5

Schools

  • Broken Arrow Elementary School
  • Sm Northwest High School

Utilities

  • Forced Air Zoned Heating and Cooling System

Community Details

  • Granite Falls Subdivision

Listing and Financial Details

  • Assessor Parcel Number QP23650000-0061

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,236

Year Built

Built in 2007

Lot Details

0

HOA Fees

$75 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family
  • Age Description: 11-15 Years
  • Legal Description: Granite Falls Lot # 61 SHC 212A 0061
  • Year Built: 2007
  • Above Grade Finished Sq Ft: 3026.00
  • Senior Community: No
  • Architectural Style: Traditional
  • Builder Name: Don Julian
  • Dining Area Features: Breakfast Area, Formal
  • Exclude From Reports: No
  • Fireplaces: 1
  • Floor Plan Features: 1.5 Stories, Reverse 1.5 Story
  • Internet Address Display: Yes
  • Internet Automated Valuation Dis: No
  • Internet Consumer Comment: No
  • Internet Entire Listing Display: Yes
  • List Agent Full Name: Ken Rosberg
  • List Office Mls Id: CCR
  • List Office Name: Cedar Creek Realty LLC
  • List Office Phone: 913-829-6500
  • List Office Phone Ext: 1
  • Living Area: 4533.00
  • Maintenance Provided: No
  • Mls Status: Sold
  • Other Room Features: Balcony/Loft
  • Special Documents Required: No
  • Tax Total Amount: 8236
  • Value Range Pricing: No
  • Special Features: None

Interior Features

  • Interior Amenities: Kitchen Island, Pantry, Prt Window Cover, Vaulted Ceiling, Walk-In Closet
  • Fireplace Features: Great Room
  • Basement: Finished, Full, Walk Out
  • Appliances: Dishwasher, Disposal, Humidifier, Microwave, Refrigerator, Rng/Oven- Electric
  • Basement: Yes
  • Below Grade Sq Ft: 1507.00
  • Fireplace: Yes
  • Flooring: Carpeted Floors, Tile Floors
  • Laundry Features: Main Level, Off The Kitchen
  • Window Features: Thermal Windows

Beds/Baths

  • Full Bathrooms: 5
  • Half Bathrooms: 1
  • Bedrooms: 5

Exterior Features

  • Exclusions: No
  • Roof: Tile
  • Construction Materials: Stucco, Wood Siding
  • Fencing: Metal
  • Patio And Porch Features: Patio, Screen Porch/Patio
  • Road Surface Type: Paved

Garage/Parking

  • Garage Spaces: 3
  • Garage: Yes
  • Parking Features: Attached

Utilities

  • Cooling: Central Electric, Zoned
  • Heating: Forced Air Gas, Zoned
  • Sewer: City/Public
  • Telecommunications: Cable - Available
  • Cooling: Yes
  • Security Features: Security System
  • Water Source: City/Public

Condo/Co-op/Association

  • Association Fee: 895
  • Association Fee Frequency: Annually

Association/Amenities

  • Association: Yes

Schools

  • School District: Shawnee Mission
  • Elementary School: Broken Arrow
  • Middle School: Trailridge
  • High School: SM Northwest
  • Middle/Junior School: Trailridge

Lot Info

  • In Floodplain: No
  • Lot Features: Cul-De-Sac, Treed
  • Lot Size Area: 18544.00
  • Lot Size Area Units: Square Feet
  • Lot Dimensions: 52x151x113x81x147
  • Lot Size Sq Ft: 18544.00
  • Parcel Number: QP23650000-0061
  • Property Attached: No
  • Subdivision Name: Granite Falls

Tax Info

  • Tax Abatement: No
  • Tax Annual Amount: 8236.00

MLS Schools

  • Elementary School: Broken Arrow
  • School District: Shawnee Mission
  • High School: SM Northwest

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 12, 2021
Closed on
Nov 17, 2021
Sold by
Heinrich Elmer G and Heinrich Shirley A
Bought by
Barlett Daniel Vincent and Barlett Christi Leigh
Seller's Agent
Ken Rosberg
Rosberg Realty
Buyer's Agent
Jim Fussell Realtor
KW KANSAS CITY METRO
List Price
$795,000
Current Estimated Value
$737,366

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.98%
Original Mortgage
$520,000
Outstanding Balance
$483,030
Interest Rate
3.09%
Mortgage Type
New Conventional
Estimated Equity
$271,605

Purchase Details

Listed on
Oct 21, 2011
Closed on
Feb 2, 2012
Sold by
Amos Gregg E and Amos Brenda L
Bought by
Heinrich Elmer G and Heinrich Shirley A
Seller's Agent
Bob Thomas
ReeceNichols - Overland Park
Buyer's Agent
Ken Rosberg
Rosberg Realty
List Price
$649,000

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.17%
Original Mortgage
$280,000
Interest Rate
3.27%
Mortgage Type
New Conventional

Purchase Details

Closed on
Apr 14, 2008
Sold by
Don Julian Builders Inc
Bought by
Amos Gregg E and Amos Brenda L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$150,000
Interest Rate
6%
Mortgage Type
Credit Line Revolving

Purchase Details

Closed on
Aug 8, 2007
Sold by
Great Plains Investment Llc
Bought by
Don Julian Builders Inc
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
Barlett Daniel Vincent -- Security 1St Title Llc
Heinrich Elmer G -- Kansas City Title Inc
Amos Gregg E -- Kansas Secured Title
Don Julian Builders Inc -- Chicago Title Ins Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Heinrich Elmer G $280,000
Previous Owner Amos Gregg E $150,000
Previous Owner Amos Gregg E $417,000
Previous Owner Amos Gregg E $150,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
11/29/2021 11/29/21 Sold -- -- --
10/18/2021 10/18/21 Pending -- -- --
06/28/2021 06/28/21 Price Changed $699,500 -6.7% $154 / Sq Ft
06/17/2021 06/17/21 Price Changed $750,000 -5.7% $165 / Sq Ft
05/12/2021 05/12/21 For Sale $795,000 +22.5% $175 / Sq Ft
02/02/2012 02/02/12 Sold -- -- --
01/20/2012 01/20/12 Pending -- -- --
10/22/2011 10/22/11 For Sale $649,000 -- $139 / Sq Ft
Source: Heartland 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 $9,243 $86,250 $12,676 $73,574
2023 $8,311 $77,280 $12,676 $64,604
2022 $8,065 $74,750 $12,676 $62,074
2021 $8,329 $72,933 $11,018 $61,915
2020 $8,236 $71,185 $11,018 $60,167
2019 $8,087 $69,851 $11,018 $58,833
2018 $8,072 $69,471 $11,019 $58,452
2017 $8,114 $68,758 $10,023 $58,735
2016 $8,119 $67,930 $10,023 $57,907
2015 $7,785 $67,102 $10,023 $57,079
2013 -- $66,700 $10,068 $56,632
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Heartland MLS

MLS Number: 2320965

Heartland MLS

APN: QP23650000-0061