NOT LISTED FOR SALE

Estimated Value: $897,088 - $1,198,000

4 Beds
3.5 Baths
3,700 Sq Ft
$288/Sq Ft Est. Value

Last Sold July 19, 2012

Current estimated payment $6,707/month

93 Days on Market

Highlights

  • Clubhouse
  • Living Room with Fireplace
  • Corner Lot
  • Timber Creek Elementary School Rated A
  • Traditional Architecture
  • Community Pool

About This Home

As of July 2012

THE CASTILLO BY COVENANT HOMES! The elegant curved stairs welcomes you as you enter this fabulous 2Sty. Open & inviting plan features designer kitchen w/granite island & brkfst area, formal dining, living rm, hrth rm & covered deck. Great pantry & office off kitchen. The luxury continues upstairs w/4 spacious bdrms. Mstr suite boasts spa-like bath. Master suite features bath w/double vanities, whirlpool, 2 headed shower, sitting room with fireplace & a huge walk-in closet that connects to upstairs laundry. This home is situated on a large corner lot which accommodates the huge 4 car garage. Still time to make selections.

Last Agent to Sell the Property

Mills Farm Team

BHG Kansas City Homes Listed on: 02/10/2012

BHG Kansas City Homes

Co-Listed By

Kerry Adam

BHG Kansas City Homes License #SP00231981

Last Buyer's Agent

Stacy Cohen

Compass Realty Group License #SP00226882

Compass Realty Group

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,200

Lot Details

  • Corner Lot
  • Sprinkler System

HOA Fees

  • $86 Monthly HOA Fees

Parking

  • 4 Car Attached Garage

Home Design

  • Home Under Construction
  • Traditional Architecture
  • Composition Roof
  • Stucco

Interior Spaces

  • 3,700 Sq Ft Home
  • Living Room with Fireplace
  • 3 Fireplaces
  • Formal Dining Room
  • Fire and Smoke Detector
  • Laundry on upper level

Kitchen

  • Breakfast Area or Nook
  • Kitchen Island
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet

Basement

  • Basement Fills Entire Space Under The House
  • Stubbed For A Bathroom

Schools

  • Timber Creek Elementary School
  • Blue Valley Southwest High School

Additional Features

  • Playground
  • City Lot
  • Forced Air Heating and Cooling System

Listing and Financial Details

  • Assessor Parcel Number NP43720000 0045

Community Details

Overview

  • Association fees include management, trash pick up
  • Mills Farm Subdivision, Castillo Floorplan

Amenities

  • Clubhouse

Recreation

  • Tennis Courts
  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,200

Lot Details

0

HOA Fees

$86 per month

Parking

4

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family
  • Property Condition: Under Construction
  • Age Description: 2 Years/Less
  • Legal Description: MEADOWS OF MILLS FARM SECOND PLAT LT 45
  • Warranty Description: Builder Warranty
  • Above Grade Finished Sq Ft: 1723.00
  • Senior Community: No
  • Architectural Style: Traditional
  • Builder Model: Castillo
  • Builder Name: Covenant Homes
  • Building Conversion: No
  • Co List Office Mls Id: PKC 01
  • Co List Office Name: Prudential Kansas City Realty
  • Co List Office Phone: 913-491-1550
  • Dining Area Features: Breakfast Area, Formal
  • Down Payment Deprecated: No
  • Exclude From Reports: No
  • Fireplaces: 3
  • Floor Plan Features: 2 Stories
  • Installation R Factor Ceiling: 30
  • Installation R Factor Wall: 15
  • Internet Address Display: Yes
  • Internet Automated Valuation Dis: No
  • Internet Consumer Comment: No
  • Internet Entire Listing Display: Yes
  • List Agent Full Name: Mills Farm Team
  • List Office Mls Id: PKC 01
  • List Office Name: Prudential Kansas City Realty
  • List Office Phone: 913-491-1550
  • Living Area: 3700.00
  • Maintenance Provided: No
  • Mls Status: Sold
  • Phone Other: 913-239-8799
  • Special Documents Required: Yes
  • Tax Special Amount: 135
  • Tax Total Amount: 6335
  • Value Range Pricing: No
  • Special Features: None

Interior Features

  • Interior Amenities: Kitchen Island, Walk-In Closet
  • Fireplace Features: Hearth Room, Living Room, Master Bedroom
  • Basement: Concrete, Full, Stubbed for Bath
  • Above Grade Finished Area Units: Square Feet
  • Appliances: Disposal
  • Basement: Yes
  • Fireplace: Yes
  • Laundry Features: Second Level

Beds/Baths

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

Exterior Features

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

Garage/Parking

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

Utilities

  • Cooling: Central Electric
  • Heating: Forced Air Gas
  • Sewer: City/Public
  • Cooling: Yes
  • Security Features: Smoke Detector
  • Water Source: City/Public

Condo/Co-op/Association

  • Association Amenities: Club House, Exercise Room, Play Area, Swimming Pool, Tennis Courts
  • Association Fee: 1035
  • Association Fee Frequency: Annually
  • Association Fee Includes: Management, Trash Pick Up

Schools

  • School District: Blue Valley
  • Elementary School: Timber Creek
  • Middle School: Aubry Bend
  • High School: Blue Valley Southwest
  • Middle/Junior School: Aubry Bend

Lot Info

  • In Floodplain: No
  • Lot Features: City Lot, Corner Lot, Sprinkler-In Ground
  • Parcel Number: NP43720000 0045
  • Property Attached: No
  • Subdivision Name: Mills Farm

Tax Info

  • Tax Comment: Est
  • Tax Abatement: No
  • Tax Annual Amount: 6200.00

MLS Schools

  • Elementary School: Timber Creek
  • School District: Blue Valley
  • High School: Blue Valley Southwest

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Sep 17, 2018
Sold by
Hulsey Jennifer M
Bought by
Guo Kai and Weng Vivian W
Current Estimated Value
$1,064,272

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$508,250
Interest Rate
4.5%
Mortgage Type
New Conventional

Purchase Details

Listed on
Feb 10, 2012
Closed on
Jul 12, 2012
Sold by
Covenant Homes Llc
Bought by
Hulsey Jennifer M
Seller's Agent
Mills Farm Team
BHG Kansas City Homes
Buyer's Agent
Stacy Cohen
Compass Realty Group
List Price
$495,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
5.51%
Original Mortgage
$417,000
Interest Rate
3.68%
Mortgage Type
New Conventional

Purchase Details

Closed on
Oct 15, 2011
Sold by
Pam Lenexa Llc
Bought by
Covenant Homes Llc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$225,000
Interest Rate
3.99%
Mortgage Type
Unknown

Purchase Details

Closed on
Aug 30, 2011
Sold by
Mills Farm Development Llc
Bought by
Pam Lenexa Llc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$225,000
Interest Rate
3.99%
Mortgage Type
Unknown
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
Guo Kai -- Clear Title
Hulsey Jennifer M -- Chicago Title
Covenant Homes Llc -- None Available
Pam Lenexa Llc -- First American Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Guo Kai $480,000
Closed Guo Kai $484,350
Closed Guo Kai $508,250
Previous Owner Hulsey Jennifer M $466,000
Previous Owner Hulsey Jennifer M $417,000
Previous Owner Covenant Homes Llc $225,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/19/2012 07/19/12 Sold -- -- --
05/13/2012 05/13/12 Pending -- -- --
02/10/2012 02/10/12 For Sale $495,000 -- $134 / 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,871 $95,496 $20,478 $75,018
2023 $8,852 $84,675 $18,430 $66,245
2022 $7,719 $72,554 $18,430 $54,124
2021 $7,461 $66,746 $14,735 $52,011
2020 $7,165 $63,652 $12,804 $50,848
2019 $7,205 $62,652 $11,133 $51,519
2018 $8,233 $70,150 $12,371 $57,779
2017 $8,248 $69,023 $12,371 $56,652
2016 $8,012 $66,988 $12,371 $54,617
2015 $7,799 $64,906 $11,092 $53,814
2013 -- $61,192 $11,092 $50,100
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Heartland MLS

MLS Number: 1764712

Heartland MLS

APN: NP43720000-0045