NOT LISTED FOR SALE

5703 Constance St Shawnee, KS 66216

Estimated Value: $617,000 - $642,001

4 Beds
3.5 Baths
-- Sq Ft
0.32 Acres

Last Sold December 02, 2013

Current estimated payment $4,192/month

Highlights

  • Vaulted Ceiling
  • Traditional Architecture
  • Main Floor Primary Bedroom
  • Shawnee Mission Northwest High School Rated A
  • Wood Flooring
  • Great Room with Fireplace

About This Home

As of December 2013

Sold before processed. Welcome to our newest Granite Falls homeowner! Lambie Custom Homes is custom building this new home on a gorgeous cul-de-sac home site. This Reverse 1.5 Story home features 4 Bedrooms and 3.5 baths. A covered patio creates a perfect location to take in the scenic views & sunsets in the treed backyard.

Last Agent to Sell the Property

Krissy Kempinger

Weichert, Realtors Welch & Com License #SP00217983 Listed on: 03/10/2013

Weichert, Realtors Welch & Com

Co-Listed By

Cory Stewart

Weichert, Realtors Welch & Com License #SP00216801

Weichert, Realtors Welch & Com

Last Buyer's Agent

Cory Stewart

Weichert, Realtors Welch & Com License #SP00216801

Weichert, Realtors Welch & Com

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,400

Year Built

  • Built in 2013 | Under Construction

Lot Details

  • Side Green Space
  • Cul-De-Sac
  • Sprinkler System

HOA Fees

  • $50 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Front Facing Garage

Home Design

  • Traditional Architecture
  • Composition Roof
  • Stucco

Interior Spaces

  • Vaulted Ceiling
  • Great Room with Fireplace
  • Family Room
  • Wood Flooring
  • Laundry on main level

Kitchen

  • Breakfast Room
  • Gas Oven or Range
  • Dishwasher
  • Kitchen Island
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bedroom on Main
  • Walk-In Closet

Finished Basement

  • Sump Pump
  • Bedroom in Basement

Schools

  • Broken Arrow Elementary School
  • Sm Northwest High School

Utilities

  • Forced Air Heating and Cooling System
  • Grinder Pump

Listing and Financial Details

  • Assessor Parcel Number QP23650000 0038

Community Details

Overview

  • Association fees include curbside recycling, trash pick up
  • Granite Falls Subdivision, Tuscan Floorplan

Recreation

  • Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,400

Year Built

Built in 2013 | Under Construction

Lot Details

0

HOA Fees

$50 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family
  • Property Condition: Under Construction
  • Age Description: 2 Years/Less
  • Legal Description: GRANITE FALLS LT 38 SHC 207 1 38
  • Warranty Description: Builder-1 yr
  • Year Built: 2013
  • Architectural Style: Traditional
  • Builder Model: Tuscan
  • Builder Name: Lambie Custom Homes
  • Co List Office Mls Id: GWA01
  • Co List Office Name: Weichert Realtors Graham Welch
  • Co List Office Phone: 913-647-5700
  • Dining Area Features: Breakfast Area
  • Down Payment Deprecated: No
  • Exclude From Reports: No
  • Fireplaces: 1
  • Floor Plan Features: Reverse 1.5 Story
  • Installation R Factor Ceiling: 38
  • Installation R Factor Wall: 13
  • Internet Address Display: Yes
  • Internet Automated Valuation Dis: No
  • Internet Consumer Comment: No
  • Internet Entire Listing Display: Yes
  • List Agent Full Name: Krissy Kempinger
  • List Office Mls Id: GWA01
  • List Office Name: Weichert Realtors Graham Welch
  • List Office Phone: 913-647-5700
  • Maintenance Provided: No
  • Mls Status: Sold
  • Other Room Features: Breakfast Room, Family Room, Great Room, Main Floor BR, Main Floor Master
  • Phone Other: 913-268-4407
  • Special Documents Required: No
  • Tax Special Amount: 149
  • Tax Total Amount: 5549
  • Value Range Pricing: No
  • Special Features: None

Interior Features

  • Interior Amenities: Kitchen Island, Pantry, Vaulted Ceiling, Walk-In Closet
  • Fireplace Features: Great Room
  • Basement: Basement BR, Finished, Sump Pump
  • Appliances: Dishwasher, Disposal, Microwave, Rng/Oven- Gas
  • Basement: Yes
  • Fireplace: Yes
  • Flooring: Wood Floors
  • Laundry Features: Main Level

Beds/Baths

  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Bedrooms: 4

Exterior Features

  • Exclusions: No
  • Roof: Composition
  • Construction Materials: Stucco

Garage/Parking

  • Garage Spaces: 3
  • Garage: Yes
  • Parking Features: Attached, Garage Faces Front

Utilities

  • Cooling: Central Electric
  • Heating: Forced Air Gas
  • Sewer: City/Public, Grinder Pump
  • Cooling: Yes
  • Water Source: City/Public

Condo/Co-op/Association

  • Association Amenities: Trails
  • Association Fee: 600
  • Association Fee Frequency: Annually
  • Association Fee Includes: Curbside Recycle, Trash Pick Up

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: Adjoin Greenspace, Cul-De-Sac, Sprinkler-In Ground
  • Parcel Number: QP23650000 0038
  • Property Attached: No
  • Subdivision Name: Granite Falls

Tax Info

  • Tax Comment: EST
  • Tax Abatement: No
  • Tax Annual Amount: 5400.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

Closed on
Nov 14, 2022
Sold by
Lemos James M and Lemos Kathleen A
Bought by
Lemos-Byard Trust
Total Days on Market
0
Current Estimated Value
$632,500

Purchase Details

Listed on
Mar 10, 2013
Closed on
Nov 25, 2013
Sold by
Lambie Custom Homes Inc
Bought by
Lemos James M and Byard Kathleen A
Seller's Agent
Krissy Kempinger
Weichert, Realtors Welch & Com
Buyer's Agent
Cory Stewart
Weichert, Realtors Welch & Com
List Price
$387,704
Sold Price
$423,057
Premium/Discount to List
$35,353
9.12%

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.53%
Original Mortgage
$397,000
Interest Rate
4.29%
Mortgage Type
New Conventional

Purchase Details

Closed on
May 2, 2013
Sold by
Cb Other Holdings Ii Inc
Bought by
Lambie Custom Homes Inc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$285,350
Interest Rate
3.45%
Mortgage Type
Construction
Source: Public Records

Similar Homes in the area

  • 4712 Park St, Shawnee, KS 66216

    $599,000

    • 5 Beds
    • 4.5 Baths
    • 5,400 Sq Ft
    • 4712 Park St
    • Shawnee, KS

    Come see this larger-than-life home! Very unique area in Shawnee for a very unique home! No cookie cutters here. The entire neighborhood has very unique homes & this one is JEWELL! A grand entrance with dual staircases going to second floor & one extra-large one going to the main level sets the tone for what you will see! Boasting dual owner suites: one on the main level with entry from the

    Dina Blackmore Platinum Realty LLC

    Section Image
  • 6415 Hillside St, Shawnee, KS 66218

    $750,000

    • 4 Beds
    • 4.5 Baths
    • 4,065 Sq Ft
    • 6415 Hillside St
    • Shawnee, KS

    Why wait on a build job when you can have this 1.5 Story home on beautiful 1.5 acre m/l cul de sac lot with tons of mature trees and privacy! Make the cosmetic changes to your tastes and this will be an incredible investment in this area. Great bones and so many extras! Over 4000 sq. ft. so plenty of room to roam. Home features main floor master plus office. Upstairs has 3 bedrooms and 2 full

    Tim Seibold Coldwell Banker Regan Realtors

    Section Image
  • 20806 W 61st St, Shawnee, KS 66218

    $550,000

    • 4 Beds
    • 3 Baths
    • 2,880 Sq Ft
    • 20806 W 61st St
    • Shawnee, KS

    Welcome to this beautifully updated home nestled in a peaceful cul-de-sac in the sought-after DeSoto School District. This spacious completely remodeled from top to bottom, 4-bedroom, 3-bathroom residence offers the perfect blend of style, comfort, and functionality. Step inside to find an inviting sitting room with stunning soaring ceilings and eye catching new lighting plus a cozy hearth room

    Sanctuary Real Estate Team KW KANSAS CITY METRO

    Section Image
  • 21009 W 81st Terrace, Lenexa, KS 66220

    $672,500

    • 5 Beds
    • 4.5 Baths
    • 4,985 Sq Ft
    • 21009 W 81st Terrace
    • Lenexa, KS

    Stunning 5-Bedroom Home on a Beautiful Corner Lot in Lenexa!Welcome to your dream home! This expansive 5-bedroom, 4.5-bathroom residence offers 4,985 sq ft of total living space, perfectly situated on a gorgeous corner lot in a sought-after Lenexa neighborhood. The main floor features an open, light-filled layout with soaring ceilings, walls of windows, and high-end finishes throughout. Enjoy a

    Tim Ray HomeSmart Legacy

    Section Image
  • 8004 Payne St, Shawnee, KS 66218

    $659,001

    • 4 Beds
    • 3.5 Baths
    • 2,764 Sq Ft
    • 8004 Payne St
    • Shawnee, KS

    SOLD BEFORE PROCESSING. 2-story home with 4 Bedrooms, 3.5 Bathrooms, 1st Floor Office and covered patio, this home checks all the boxes...not to mention the walk-in pantry, large kitchen island, bedroom level laundry room and loft, and lots of quality details that finish this brand new home with style! The Popular Modello by Pauli Homes on lot 60 in the Manors at Bristol Highlands! This build

    Heather Brulez Weichert, Realtors Welch & Com

    Section Image
  • 8000 Brockway St, Shawnee, KS 66218

    $723,524

    • 4 Beds
    • 3.5 Baths
    • 2,771 Sq Ft
    • 8000 Brockway St
    • Shawnee, KS

    SOLD BEFORE PROCESSED!!! Custom Drees Built Home in the Manors on lot 53.

    Heather Brulez Weichert, Realtors Welch & Com

    Section Image
  • 8009 Round Prairie St, Shawnee, KS 66218

    $721,650

    • 4 Beds
    • 3.5 Baths
    • 2,667 Sq Ft
    • 8009 Round Prairie St
    • Shawnee, KS

    If you've been waiting for a sign to live your best life in a NEW home—this is it. Welcome to Bristol Highlands, Shawnee’s best-kept secret (but not for long). The Redland 2-story home by SAB Homes sits on Lot 64, a level lot with a covered deck that’s begging for a string of café lights and a fall BBQ. This home is currently under construction—you can still choose some colors and pretend you

    Heather Brulez Weichert, Realtors Welch & Com

    Section Image
  • 22109 W 80th Terrace, Lenexa, KS 66220

    $710,000

    • 4 Beds
    • 3 Baths
    • 2,663 Sq Ft
    • 22109 W 80th Terrace
    • Lenexa, KS

    Welcome to the Ashwood II by Chris George Homes, located on Lot 39, blending modern sophistication with timeless charm. The stunning board-and-batten exterior with natural stone accents sets the stage for the beauty inside and MOVE-IN READY!Step into an open-concept living space with soaring vaulted ceilings and a floor-to-ceiling stone fireplace, creating a warm and inviting atmosphere.

    Heather Brulez Weichert, Realtors Welch & Com

    Section Image
  • 24914 W 76th St, Shawnee, KS 66227

    $775,000

    • 5 Beds
    • 3 Baths
    • 3,430 Sq Ft
    • 24914 W 76th St
    • Shawnee, KS

    Huge Price Improvement down to $775,000 as of 6-27-25.Ask your agent for drone fly through and fly over video. Own year round freeze protect spa and 20’x40’ pool by grabbing this 5 bedroom Ranch with fenced yard. View drone flyover and fly through this listing on unbranded link. New interior paint, all new never used ranch level SHARP kitchen stainless steel appliances (refrigerator, gas stove,

    Rob Lang At Home Kansas

    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
Lemos-Byard Trust -- --
Lemos James M -- First American Title
Lambie Custom Homes Inc -- First American Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Lemos James N $369,000
Previous Owner Lemos James M $364,550
Previous Owner Lemos James M $391,000
Previous Owner Lemos James M $397,000
Previous Owner Lambie Custom Homes Inc $285,350
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/02/2013 12/02/13 Sold -- -- --
03/10/2013 03/10/13 Pending -- -- --
03/10/2013 03/10/13 For Sale $387,704 -- --
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 $7,581 $70,910 $14,939 $55,971
2023 $7,033 $65,436 $14,939 $50,497
2022 $6,727 $62,377 $14,939 $47,438
2021 $6,483 $56,718 $12,987 $43,731
2020 $6,455 $55,741 $12,987 $42,754
2019 $6,456 $55,718 $12,987 $42,731
2018 $6,031 $54,694 $12,989 $41,705
2017 $6,166 $52,199 $11,814 $40,385
2016 $6,109 $51,060 $11,814 $39,246
2015 $5,701 $49,163 $11,812 $37,351
2013 -- $3 $3 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Heartland MLS

MLS Number: 1819368

Heartland MLS

APN: QP23650000-0038