NOT LISTED FOR SALE

4007 W 157th Terrace Overland Park, KS 66224

Estimated Value: $934,702 - $1,192,000

6 Beds
5 Baths
3,347 Sq Ft
$313/Sq Ft Est. Value

Last Sold July 08, 2020

Current estimated payment $6,938/month

252 Days on Market

Highlights

  • Custom Closet System
  • Clubhouse
  • Vaulted Ceiling
  • Sunrise Point Elementary School Rated A
  • Great Room with Fireplace
  • Traditional Architecture

About This Home

As of July 2020

RODROCK HOMES NEWEST 1.5 STORY THE "NEW HAVEN". . THE HOME FEATURES 6 BEDROOMS 5 BATHS PLUS A LOFT WITH A FINISHED BASEMENT. AN OPEN AND SPACIOUS PLAN WITH 2 BEDROOMS ON THE MAIN LEVEL. MASTER SUITE CONVENIENTLY LOCATED NEXT TO THE LAUNDRY. STUNNING GREAT ROOM WITH 2 STORY VAULTED CEILING. COZY HEARTH ROOM OFF THE KITCHEN. LARGE DINING AREA, OPEN KITCHEN WITH A LARGE PANTRY, ENAMELED KITCHEN SURROUND, RUSTIC OAK 2"3"4" RANDOM WIDTH HARDWOOD FLOORING AND 2 FIREPLACES. THIS HOME IS ON A DAYLIGHT LOT ELEVATION 2. STILL TIME TO MAKE ALL OF THE DECOR SELECTIONS. .THIS HOME IS ELEVATION 2. Mission Ranch is ideally located within the award winning Blue Valley Schools. Sunrise Point Elementary is located within the neighborhood. Future amenities will include resort style pool and clubhouse with exercise room. PLEASE CALL ANDREA FOR CONTRACT PACKET

Last Agent to Sell the Property

Andrea Sullivan

Rodrock & Associates Realtors License #2003026332 Listed on: 08/02/2019

Co-Listed By

Sandra J Green

Weichert, Realtors Welch & Com License #1999128096

Last Buyer's Agent

Ronda White

EXP Realty LLC License #SP00226294

EXP Realty LLC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,773

Year Built

  • 2018

Lot Details

  • 10,125 Sq Ft Lot
  • Cul-De-Sac
  • Sprinkler System

HOA Fees

  • $113 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Front Facing Garage

Home Design

  • Home Under Construction
  • Traditional Architecture
  • Blown-In Insulation
  • Composition Roof
  • Stone Trim

Interior Spaces

  • 3,347 Sq Ft Home
  • Wet Bar: Carpet, Ceramic Tiles, Hardwood
  • Built-In Features: Carpet, Ceramic Tiles, Hardwood
  • Vaulted Ceiling
  • Ceiling Fan: Carpet, Ceramic Tiles, Hardwood
  • Skylights
  • Gas Fireplace
  • Thermal Windows
  • Low Emissivity Windows
  • Shades
  • Plantation Shutters
  • Drapes & Rods
  • Great Room with Fireplace
  • 2 Fireplaces
  • Combination Kitchen and Dining Room
  • Loft

Kitchen

  • Eat-In Kitchen
  • Built-In Range
  • Recirculated Exhaust Fan
  • Dishwasher
  • Stainless Steel Appliances
  • 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

  • 6 Bedrooms
  • Primary Bedroom on Main
  • Custom Closet System
  • Cedar Closet: Carpet, Ceramic Tiles, Hardwood
  • Walk-In Closet: Carpet, Ceramic Tiles, Hardwood
  • 5 Full Bathrooms
  • Double Vanity
  • Bathtub with Shower

Laundry

  • Laundry Room
  • Laundry on main level

Basement

  • Stubbed For A Bathroom
  • Basement Window Egress

Outdoor Features

  • Enclosed patio or porch
  • Playground

Location

  • City Lot

Schools

  • Sunrise Point Elementary School
  • Blue Valley High School

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Heat Exchanger

Listing and Financial Details

  • Assessor Parcel Number NP47650000-0015

Community Details

Overview

  • Association fees include curbside recycling, trash pick up
  • Mission Ranch Subdivision, New Haven Floorplan

Amenities

  • Clubhouse
  • Party Room

Recreation

  • Community Pool
  • Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,773

Year Built

2018

Lot Details

0

HOA Fees

$113 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: MISSION RANCH 1ST PLAT LOT 15
  • Warranty Description: Builder-1 yr
  • Above Grade Finished Sq Ft: 3347.00
  • Architectural Style: Traditional
  • Builder Model: NEW HAVEN
  • Builder Name: RODROCK HOMES
  • Co List Office Mls Id: RODR
  • Co List Office Name: Rodrock & Associates Realtors
  • Co List Office Phone: 913-681-5111
  • Dining Area Features: Eat-In Kitchen, Kit/Dining Combo
  • Exclude From Reports: No
  • Fireplaces: 2
  • Floor Plan Features: 1.5 Stories
  • Green Energy Efficient: Insulation - Blown, Low Emittance Doors/Windows
  • Installation R Factor Ceiling: 50
  • Installation R Factor Wall: 19
  • Internet Address Display: Yes
  • Internet Automated Valuation Dis: No
  • Internet Consumer Comment: No
  • Internet Entire Listing Display: Yes
  • List Agent Full Name: Andrea Sullivan
  • List Office Mls Id: RODR
  • List Office Name: Rodrock & Associates Realtors
  • List Office Phone: 913-681-5111
  • Living Area: 3347.00
  • Maintenance Provided: No
  • Mls Status: Sold
  • Other Room Features: Balcony/Loft, Great Room, Main Floor BR, Main Floor Master
  • Special Documents Required: No
  • Tax Special Amount: 150
  • Tax Total Amount: 8923
  • Value Range Pricing: No
  • Special Features: None
  • Year Built: 2018

Interior Features

  • Interior Amenities: Custom Cabinets, Pantry, Vaulted Ceiling, Walk-In Closet
  • Fireplace Features: Gas, Great Room, Heat Circulator
  • Basement: Daylight, Egress Window, Stubbed for Bath
  • Above Grade Finished Area Units: Square Feet
  • Appliances: Cooktop, Dishwasher, Disposal, Hood/Fan, Humidifier, Microwave, Rng/Oven- Built In, Stainless Appliances
  • Basement: Yes
  • Fireplace: Yes
  • Flooring: Carpeted Floors, Wood Floors
  • Laundry Features: Laundry Room, Main Level
  • Window Features: Thermal Windows

Beds/Baths

  • Full Bathrooms: 5
  • Bedrooms: 6

Exterior Features

  • Exclusions: No
  • Roof: Composition
  • Construction Materials: Stone Trim, Stucco & Frame
  • Patio And Porch Features: Deck- Covered

Garage/Parking

  • Garage Spaces: 3
  • Garage: Yes
  • Parking Features: Built-In, Garage Faces Front

Utilities

  • Cooling: Central Electric, Zoned
  • Heating: Central Gas, Zoned
  • Sewer: City/Public
  • Cooling: Yes
  • Water Source: City/Public

Condo/Co-op/Association

  • Association Amenities: Club House, Exercise Room, Party Room, Play Area, Swimming Pool, Trails
  • Association Fee: 1350
  • Association Fee Frequency: Annually
  • Association Fee Includes: Curbside Recycle, Trash Pick Up

Schools

  • School District: Blue Valley
  • Elementary School: Sunrise Point
  • Middle School: Prairie Star
  • High School: Blue Valley
  • Middle/Junior School: Prairie Star

Lot Info

  • In Floodplain: No
  • Lot Features: City Lot, Cul-De-Sac, Sprinkler-In Ground
  • Lot Size Area: 10125.00
  • Lot Size Area Units: Square Feet
  • Lot Size Sq Ft: 10125.00
  • Parcel Number: NP47650000-0015
  • Property Attached: No
  • Subdivision Name: Mission Ranch

Green Features

  • Green Water Conservation: Low Flow Fixtures

Tax Info

  • Tax Comment: EST
  • Tax Abatement: No
  • Tax Annual Amount: 8773.00

MLS Schools

  • Elementary School: Sunrise Point
  • School District: Blue Valley
  • High School: Blue Valley

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 2, 2019
Closed on
Jul 7, 2020
Sold by
Rodrock Homes Of Johnson County Llc
Bought by
Oyiengo Dennis O and Kamuren Jane
Seller's Agent
Andrea Sullivan
Rodrock & Associates Realtors
Buyer's Agent
Ronda White
EXP Realty LLC
List Price
$628,000
Sold Price
$744,950
Premium/Discount to List
$116,950
18.62%
Total Days on Market
252
Current Estimated Value
$1,048,926

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$303,976
Avg. Annual Appreciation
7.57%
Original Mortgage
$535,000
Interest Rate
3.1%
Mortgage Type
New Conventional

Purchase Details

Closed on
Mar 20, 2019
Sold by
Mission Road Partners Llc
Bought by
Rodrock Homes Of Johnson County Llc

Home Financials for this Owner

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

Similar Homes in the area

  • 10654 W 168th Ct, Overland Park, KS 66221

    $1,015,000

    • 5 Beds
    • 5.5 Baths
    • 5,755 Sq Ft
    • 10654 W 168th Ct
    • Overland Park, KS

    Step into elegance with this breathtaking 5-bedroom, 5.5-bath home, nearly 5,800 sq. ft. Located in South Overland Park, this home is designed for both comfort and sophistication. It boasts an inviting open floor plan with soaring ceilings, abundant natural light, and freshly updated paint. The main-level primary suite is a true retreat, featuring a spacious primary closet designed for ultimate

    Trenton Gallagher ReeceNichols - Leawood

    Section Image
  • 16817 Goddard St, Overland Park, KS 66221

    $845,000

    • 6 Beds
    • 5 Baths
    • 4,433 Sq Ft
    • 16817 Goddard St
    • Overland Park, KS

    True 1.5-Story | Walkout Lower Level | Screened-In Deck | Blue Valley Schools - Beyond the headline features, this home offers moments that matter most.Morning light filters through the two-story great room, illuminating newly refinished hardwoods and setting a calm, inviting tone. At the heart of the home, the kitchen opens to a breakfast nook and out to the screened-in deck - ideal for casual

    Scott Strevell Keller Williams Realty Partner

    Section Image
  • 8221 Beverly Dr, Prairie Village, KS 66208

    $990,000

    • 5 Beds
    • 4 Baths
    • 4,403 Sq Ft
    • 8221 Beverly Dr
    • Prairie Village, KS

    HOT NEW PRICE On just about 1/2 lot ($110k free equity on recent 1.1M appraisal!) this is the perfect blend of luxury, comfort, and modern amenities in Prairie Village! TOO many upgrades to mention, but here goes: Better than NEW! With over $450k in recent improvements, this property has been thoughtfully designed for both style and functionality. Key highlights of this home include a spacious

    Jeff Yacos Real Broker, LLC

    Section Image
  • 4112 W 156th St, Overland Park, KS 66224

    $1,228,000

    • 4 Beds
    • 4.5 Baths
    • 4,485 Sq Ft
    • 4112 W 156th St
    • Overland Park, KS

    LUXURY LIVING with GOLF COURSE VIEWS! Experience elevated living in this EXQUISITE 1.5-story home, ideally located between Leawood and Overland Park in the prestigious Mission Ranch community—part of the award-winning BLUE VALLEY School District. Built in 2023, this BETTER-THAN-NEW home blends refined elegance, thoughtful design, and amenities ideal for modern family life. From the moment you

    Brooke Miller ReeceNichols - Country Club Plaza

    Section Image
  • 3714 W 158th Terrace, Overland Park, KS 66224

    $950,000

    • 4 Beds
    • 4.5 Baths
    • 4,523 Sq Ft
    • 3714 W 158th Terrace
    • Overland Park, KS

    Bright, open, beautiful home on quiet cul de sac. Welcoming front porch & double doors open to warm, spacious home. Wide plank, natural wood floors through main level, high ceilings, brushed brass fixtures, white stone fireplace offer a comfortable, upscale place for entertaining or cozy family time. 8' front doors, and 8' doors throughout main level adds to the custom/luxury feel of this home.

    Denise Sanker ReeceNichols - Lees Summit

    Section Image
  • 18456 Pawnee Ln, Overland Park, KS 66224

    $795,565

    • 5 Beds
    • 4 Baths
    • 3,274 Sq Ft
    • 18456 Pawnee Ln
    • Overland Park, KS

    Be the first to own this stunning 2-story, 3,274 sq ft home (The Delano by Inspired Homes) which has been thoughtfully designed for modern living. Set for completion in October/November 2025, this home sits on lot 107 in Southern Meadows and offers a perfect blend of luxury, functionality, and space—with an oversized 3-car garage and an unfinished daylight basement ready for your customization.

    Liz Zimmerman Weichert, Realtors Welch & Com

    Section Image
  • 4600 157th St, Overland Park, KS 66224

    $1,189,950

    • 4 Beds
    • 4.5 Baths
    • 4,122 Sq Ft
    • 4600 157th St
    • Overland Park, KS

    The "Rebecca" by award-winning builder New Mark Homes, nearing completion in Grand Reserve Mission Ranch. Exciting new floor plan located on a full walkout home site. Main Floor is well-designed and offers a stunning Primary Suite with a hard-to-find deluxe primary closet! This plan checks all the boxes for a spacious main floor living design. The kitchen will feature a generous appliance

    Angela Fitzgerald Rodrock & Associates Realtors

    Section Image
  • 18464 Windsor St, Overland Park, KS 66224

    $799,699

    • 5 Beds
    • 4 Baths
    • 3,359 Sq Ft
    • 18464 Windsor St
    • Overland Park, KS

    Introducing The Opus II by Inspired Homes. This stunning new two-story home featuring 5 bedrooms, 4 bathrooms, and an oversized 3-car garage, spanning 3,359 sq ft sits on lot 118 in Southern Meadows. This thoughtfully designed layout offers 18-foot ceilings in the great room and foyer for a grand first impression. The main floor includes a private guest suite, a spacious home office off the

    Liz Zimmerman Weichert, Realtors Welch & Com

    Section Image
  • 15601 Windsor St, Overland Park, KS 66224

    $935,000

    • 5 Beds
    • 5.5 Baths
    • 4,813 Sq Ft
    • 15601 Windsor St
    • Overland Park, KS

    Beautifully maintained, spacious 5 bdrm/5.5 bath lux home located in the highly sought-after WatersEdge community. The main level offers a huge amount of space for comfort along with a dedicated home office and a private guest suite with its own full bath—ideal for multi-generational living or visiting guests.The stunning chef’s kitchen features stainless steel appliances, a gas range, walk-in

    Ben Olney Realty One Group Encompass

    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
Oyiengo Dennis O -- First American Title
Rodrock Homes Of Johnson County Llc -- First American Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Oyiengo Dennis O $548,250
Closed Oyiengo Dennis O $535,000
Previous Owner Rodrock Homes Of Johnson County Llc $506,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/08/2020 07/08/20 Sold -- -- --
04/10/2020 04/10/20 Pending -- -- --
02/08/2020 02/08/20 Price Changed $633,500 +0.6% $189 / Sq Ft
10/15/2019 10/15/19 Price Changed $629,500 +0.2% $188 / Sq Ft
08/02/2019 08/02/19 For Sale $628,000 -- $188 / 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 $11,240 $108,572 $18,844 $89,728
2023 $10,539 $100,706 $18,844 $81,862
2022 $9,476 $88,953 $18,844 $70,109
2021 $9,574 $85,618 $17,119 $68,499
2020 $6,651 $59,386 $14,888 $44,498
2019 $1,413 $11,166 $11,166 $44,498
2018 $495 $3,144 $3,144 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Heartland MLS

MLS Number: 2181586

Heartland MLS

APN: NP47650000-0015