NOT LISTED FOR SALE

9037 Mesquite St Shawnee, KS 66227

Estimated Value: $592,000 - $635,564

4 Beds
3 Baths
2,617 Sq Ft
$234/Sq Ft Est. Value

Last Sold December 22, 2022

Current estimated payment $4,188/month

277 Days on Market

Highlights

  • Custom Closet System
  • Clubhouse
  • Vaulted Ceiling
  • Canyon Creek Elementary School Rated A
  • Recreation Room
  • Ranch Style House

About This Home

As of December 2022

The award-winning Reverse 1.5 Story – The Fairfield! Spacious and open with soaring 10' ceilings and loads of natural light throughout. 4 bedroom/3 bath with main level Master Suite and 2nd bedroom/home office. Enjoy the finished lower level with large open rec room, 2 bedrooms + full bath. You will love the views out back from the massive picture windows in the great room! Extensive Designer options and neutral colors everywhere. Kitchen features 9' tall custom cabinets, oversized island & walk in pantry. Lots of prep space on the endless Quartz countertops! Wood flooring in the entry, great room, and kitchen. The master bathroom includes a deluxe zero entry shower, built-ins and large walk-in closet connecting to the laundry room! Well thought out extras included such as: High-end kitchen with built-in appliances and vented hood, upgraded trim package throughout, quartz counters, irrigation system and garage door openers already installed!

Don't miss out on the remaining lots in The Reserve's FINAL PHASE! The Reserve community features amazing amenities that include Clubhouse, swimming pool, 2 sports courts, playground, and walking trails. This desirable area is conveniently located close to the K-7/K-10 corridor and close to Lenexa City Center, which includes great shopping and dining options!

Last Agent to Sell the Property

Danny Watts

Loch Lloyd Residential RE License #2015038337 Listed on: 02/08/2022

Last Buyer's Agent

Kim Esposito

ReeceNichols - Leawood License #SP00222888

ReeceNichols - Leawood

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,266

Year Built

  • Built in 2022 | Under Construction

Lot Details

  • 10,465 Sq Ft Lot
  • Northeast Facing Home
  • Paved or Partially Paved Lot
  • Sprinkler System

HOA Fees

  • $35 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Front Facing Garage
  • Garage Door Opener

Home Design

  • Ranch Style House
  • Traditional Architecture
  • Frame Construction
  • Blown-In Insulation
  • Composition Roof
  • Wood Siding

Interior Spaces

  • Wet Bar: Ceramic Tiles, All Carpet, Wood Floor
  • Built-In Features: Ceramic Tiles, All Carpet, Wood Floor
  • Vaulted Ceiling
  • Ceiling Fan: Ceramic Tiles, All Carpet, Wood Floor
  • Skylights
  • Gas Fireplace
  • Thermal Windows
  • Low Emissivity Windows
  • Shades
  • Plantation Shutters
  • Drapes & Rods
  • Entryway
  • Great Room with Fireplace
  • Combination Kitchen and Dining Room
  • Recreation Room
  • Fire and Smoke Detector

Kitchen

  • Built-In Range
  • Recirculated Exhaust Fan
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Granite Countertops
  • Laminate Countertops
  • Disposal

Flooring

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

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Custom Closet System
  • Cedar Closet: Ceramic Tiles, All Carpet, Wood Floor
  • Walk-In Closet: Ceramic Tiles, All Carpet, Wood Floor
  • 3 Full Bathrooms
  • Double Vanity
  • Ceramic Tiles

Laundry

  • Laundry Room
  • Laundry on main level

Finished Basement

  • Sump Pump
  • Natural lighting in basement

Schools

  • Canyon Creek Elementary School
  • Olathe Northwest High School

Utilities

  • Forced Air Heating and Cooling System
  • Heat Exchanger

Additional Features

  • Enclosed patio or porch
  • City Lot

Listing and Financial Details

  • Assessor Parcel Number IP64340000-0460

Community Details

Overview

  • Association fees include all amenities
  • The Reserve Subdivision, Fairfield Farmhouse Floorplan

Amenities

  • Clubhouse

Recreation

  • Tennis Courts
  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,266

Year Built

Built in 2022 | Under Construction

Lot Details

0

HOA Fees

$35 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: RESERVE SEVENTH PLAT, Lot 460
  • Warranty Description: 10 Year Warranty, Builder-1 yr
  • Year Built: 2022
  • Above Grade Finished Sq Ft: 1637.00
  • Architectural Style: Traditional
  • Builder Model: Fairfield - Farmhouse
  • Builder Name: Inspired Homes
  • Dining Area Features: Kit/Dining Combo
  • Direction Faces: Northeast
  • Exclude From Reports: No
  • Fireplaces: 1
  • Floor Plan Features: Ranch, Reverse 1.5 Story
  • Green Energy Efficient: Insulation - Blown, Low Emittance Doors/Windows
  • Installation R Factor Ceiling: 49
  • 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: Danny Watts
  • Listing Service: Full Service
  • List Office Mls Id: NHS
  • List Office Name: New Home Star
  • List Office Phone: 913-832-7065
  • Living Area: 2617.00
  • Maintenance Provided: No
  • Mls Status: Sold
  • Other Room Features: Entry, Great Room, Main Floor BR, Main Floor Master, Recreation Room
  • Special Documents Required: No
  • Tax Special Amount: 109
  • Tax Total Amount: 6375
  • Value Range Pricing: No
  • Special Features: NewHome

Interior Features

  • Interior Amenities: Ceiling Fan(s), Custom Cabinets, Kitchen Island, Painted Cabinets, Pantry, Walk-In Closet
  • Fireplace Features: Gas, Great Room, Heat Circulator
  • Basement: Concrete, Daylight, Finished, Sump Pump
  • Appliances: Cooktop, Dishwasher, Disposal, Hood/Fan, Humidifier, Microwave, Rng/Oven- Built In, Stainless Appliances
  • Basement: Yes
  • Below Grade Sq Ft: 980.00
  • Fireplace: Yes
  • Flooring: Carpeted Floors, Ceramic Floor, Wood Floors
  • Laundry Features: Laundry Room, Main Level
  • Window Features: Thermal Windows

Beds/Baths

  • Full Bathrooms: 3
  • Bedrooms: 4

Exterior Features

  • Exclusions: No
  • Roof: Composition
  • Construction Materials: Frame, Wood Siding
  • Patio And Porch Features: Deck- Covered, Patio
  • Road Surface Type: Paved

Garage/Parking

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

Utilities

  • Cooling: Central Electric
  • Heating: Forced Air Gas
  • Sewer: City/Public
  • Telecommunications: Cable - Available, Fiber - Available, High Speed Internet - Available
  • Cooling: Yes
  • Security Features: Smoke Detector
  • Water Source: City/Public

Condo/Co-op/Association

  • Association Amenities: Club House, Other, Swimming Pool, Tennis Courts
  • Association Fee: 425
  • Association Fee Frequency: Annually
  • Association Fee Includes: All Amenities

Association/Amenities

  • Association: Yes

Schools

  • School District: Olathe
  • Elementary School: Canyon Creek
  • Middle School: Prairie Trail
  • High School: Olathe Northwest
  • Middle/Junior School: Prairie Trail

Lot Info

  • In Floodplain: No
  • Lot Features: City Lot, Sprinkler-In Ground
  • Lot Size Area: 10465.35
  • Lot Size Area Units: Square Feet
  • Lot Size Sq Ft: 10465.35
  • Parcel Number: IP64340000-0460
  • Property Attached: No
  • Subdivision Name: The Reserve

Tax Info

  • Tax Abatement: No
  • Tax Annual Amount: 6266.00

MLS Schools

  • Elementary School: Canyon Creek
  • School District: Olathe
  • High School: Olathe Northwest

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Feb 8, 2022
Closed on
Dec 20, 2022
Sold by
Inspired Homes Llc
Bought by
Gilbert Suzanne D and Kreutzer Max A
Seller's Agent
Danny Watts
Loch Lloyd Residential RE
Buyer's Agent
Kim Esposito
ReeceNichols - Leawood
List Price
$625,000
Views
1
Current Estimated Value
$627,121

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
2.84%
Original Mortgage
$460,000
Outstanding Balance
$448,186
Interest Rate
6.61%
Mortgage Type
New Conventional
Estimated Equity
$170,634
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
Gilbert Suzanne D -- Kansas City Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Gilbert Suzanne D $460,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/22/2022 12/22/22 Sold -- -- --
11/12/2022 11/12/22 Pending -- -- --
10/04/2022 10/04/22 Price Changed $575,000 -8.0% $220 / Sq Ft
02/08/2022 02/08/22 For Sale $625,000 -- $239 / 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 $8,281 $67,310 $13,231 $54,079
2023 $7,552 $60,329 $11,022 $49,307
2022 $2,163 $16,761 $9,585 $7,176
2021 $977 $6,366 $6,366 $0
2020 $986 $6,370 $6,370 $0
2019 $728 $4,427 $4,427 $0
2018 $733 $4,427 $4,427 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Heartland MLS

MLS Number: 2364255

Heartland MLS

APN: IP64340000-0460