$1,190,531
PENDING NEW CONSTRUCTION $51K PRICE INCREASE

2819 W 175th Terrace Overland Park, KS 66085

Estimated payment $7,660/month

Total Views 38,773
4 Beds
4.5 Baths
4,133 Sq Ft
$288 Price per Sq Ft

Highlights

  • Custom Closet System
  • Clubhouse
  • Hearth Room
  • Stilwell Elementary School Rated A-
  • Great Room with Fireplace
  • Traditional Architecture

About This Home

Incredible Value! Rodrock’s Most Popular 2 sty Estate Plan
Looking for a home that blends luxury, space, and functionality? The Coronado 2X2 is a stunning two-story estate plan designed for comfortable living and effortless entertaining—and it’s available NOW! With paint completed and only 75 days until move-in, this is your chance to secure a home that offers both exceptional design and incredible value. PHOTOS and VIDEO FLYTHROUGH IS OF FORMER MODEL HOME, FOR REFERENCE ONLY.

Designed for the Way You Live
This thoughtfully crafted 4-car garage home features an open-concept layout with exceptional flow. At its heart, a gourmet-equipped kitchen with a spacious walk-in pantry and breakfast nook invites gathering, while the nearby hearth room with a cozy fireplace provides the perfect space to relax.
Your Private Retreat Awaits
Upstairs, the generous master suite is designed for ultimate comfort, featuring spa-like amenities that make unwinding a daily luxury. Additional well-appointed bedrooms ensure that everyone in the household enjoys their own space.

Unmatched Amenities at Sundance Ridge
This home isn’t just about what’s inside—it's also about where you’ll live! Located in Sundance Ridge, this community offers:
The Village – A vibrant social hub
Clubhouse & Fitness Center – Now open!
Resort-Style Pool Complex – Opening Memorial Day Weekend!
Come see for yourself why so many buyers are choosing to call Sundance Ridge home—and why this Coronado 2X2 is the perfect place to start your next chapter.
Act Now—This Home Won’t Last!
With completion just around the corner, now is the time to schedule a tour and start planning your move. Contact us today!
Note: Photos shown are of a model/spec home and may include options and upgrades not included in the listed property. Sundance Ridge’s multi-million-dollar amenities center, dubbed “The Village,” will include a spacious, welcoming clubhouse and pool. CLUBHOUSE W/ FITNESS CENTER AND FIRST POOL OPEN NOW!!

Listing Agent

Sundance Team

Rodrock & Associates Realtors Listed on: 02/15/2023

Co-Listing Agent

Bruce Stout

Rodrock & Associates Realtors License #SP00047114

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $14,820

Year Built

  • Built in 2023 | Under Construction

Lot Details

  • 0.46 Acre Lot
  • Cul-De-Sac
  • Sprinkler System

HOA Fees

  • $113 Monthly HOA Fees

Parking

  • 4 Car Attached Garage
  • Front Facing Garage
  • Side Facing Garage

Home Design

  • Traditional Architecture
  • Composition Roof
  • Stone Trim

Interior Spaces

  • 4,133 Sq Ft Home
  • 2-Story Property
  • Gas Fireplace
  • Great Room with Fireplace
  • 2 Fireplaces
  • Formal Dining Room
  • Den
  • Fire and Smoke Detector

Kitchen

  • Hearth Room
  • Breakfast Room
  • Walk-In Pantry
  • Cooktop
  • Dishwasher
  • Kitchen Island
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Custom Closet System
  • Walk-In Closet

Laundry

  • Laundry Room
  • Laundry on upper level

Basement

  • Sump Pump
  • Natural lighting in basement

Schools

  • Stilwell Elementary School
  • Blue Valley High School

Utilities

  • Forced Air Heating and Cooling System
  • Satellite Dish

Listing and Financial Details

  • Assessor Parcel Number NPo4440000-0034
  • $127 special tax assessment

Community Details

Overview

  • Association fees include curbside recycling, management, trash
  • First Service Residential Association
  • Sundance Ridge Big Sky Subdivision, Coronado Floorplan

Amenities

  • Clubhouse

Recreation

  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$14,820

Year Built

Built in 2023 | Under Construction

Lot Details

0

HOA Fees

$113 per month

Parking

4

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Property Condition: Under Construction
  • Year Built: 2023
  • Above Grade Finished Sq Ft: 4133
  • Architectural Style: Traditional
  • Builder Model: Coronado
  • Builder Name: Rodrock Homes
  • Co List Office Mls Id: HMSRODR
  • Co List Office Name: Rodrock & Associates Realtors
  • Co List Office Phone: 913-681-5111
  • Fireplaces: 2
  • Internet Address Display: Yes
  • Internet Consumer Comment: No
  • List Agent Full Name: Sundance Team
  • List Office Mls Id: HMSRODR
  • List Office Name: Rodrock & Associates Realtors
  • List Office Phone: 913-681-5111
  • Living Area: 4133
  • Mls Status: Pending
  • Ownership: Private
  • Age Description: 2 Years/Less
  • Floor Plan Features: 2 Stories
  • Tax Special Amount: 127
  • Tax Total Amount: 14947
  • Value Range Pricing YN: 0
  • Dining Area Features: Breakfast Area,Formal
  • Maintenance Provided YN: 0
  • Other Room Features: Breakfast Room,Den/Study,Great Room
  • Special Documents Required YN: 0
  • Installation R Factor Ceiling: 50
  • Installation R Factor Wall: 15
  • Warranty Description: Builder Warranty
  • Phone Other: 913-991-8095
  • Phone Other Type: Phone
  • Special Features: 4098

Interior Features

  • Interior Amenities: Custom Cabinets, Kitchen Island, Pantry, Vaulted Ceiling(s), Walk-In Closet(s)
  • Fireplace Features: Gas, Great Room, Hearth Room
  • Basement: Daylight, Sump Pump
  • Appliances: Cooktop, Dishwasher, Disposal, Microwave
  • Basement: Yes
  • Fireplace: Yes
  • Laundry Features: Bedroom Level, Upper Level

Beds/Baths

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

Exterior Features

  • Exterior Features: Sat Dish Allowed
  • Roof: Composition
  • Construction Materials: Stone Trim, Stucco & Frame
  • Patio And Porch Features: Covered
  • Exclusions YN: 0

Garage/Parking

  • Garage Spaces: 4
  • Garage: Yes
  • Parking Features: Attached, Garage Faces Front, Garage Faces Side

Utilities

  • Cooling: Electric
  • Heating: Forced Air
  • Sewer: Public Sewer
  • Cooling: Yes
  • Security Features: Smoke Detector(s)
  • Water Source: Public

Condo/Co-op/Association

  • Association Amenities: Clubhouse, Exercise Room, Pool
  • Association Fee: 1350
  • Association Fee Frequency: Annually
  • Association Fee Includes: Curbside Recycle, Management, Trash

Association/Amenities

  • Association Name: First Service Residential
  • Association: Yes

Fee Information

  • Deposit: builder

Schools

  • Middle/Junior School: Blue Valley
  • Junior High Dist: Blue Valley

Lot Info

  • Lot Features: Cul-De-Sac, Sprinkler-In Ground
  • Lot Size Area: 20125
  • Lot Size Sq Ft: 20125
  • Parcel Number: NPo4440000-0034
  • Property Attached: No
  • Subdivision Name: Sundance Ridge- Big Sky
  • In Flood Plain: No

Tax Info

  • Tax Annual Amount: 14820
  • Tax Abatement YN: 0

MLS Schools

  • Elementary School: Stilwell
  • High School: Blue Valley

Map

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

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,355 $109,360 $26,815 $82,545
2023 $3,301 $32,081 $24,364 $7,717
2022 $129 $16,158 $16,158 $0
2021 $1,949 $16,158 $16,158 $0
2020 $1,964 $16,158 $16,158 $0
2019 $2,174 $15,377 $15,377 $0
2018 $2,209 $15,376 $15,376 $0
2017 $1,134 $0 $0 $0
2016 $54 $456 $456 $0
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
08/09/2025 08/09/25 Pending -- -- --
08/01/2025 08/01/25 Price Changed $1,190,531 +7.1% $288 / Sq Ft
04/30/2025 04/30/25 Price Changed $1,111,223 -0.2% $269 / Sq Ft
10/10/2024 10/10/24 Price Changed $1,113,923 -2.8% $270 / Sq Ft
03/01/2024 03/01/24 Price Changed $1,145,672 +0.5% $277 / Sq Ft
01/02/2024 01/02/24 Price Changed $1,140,282 +0.1% $276 / Sq Ft
10/03/2023 10/03/23 Price Changed $1,138,753 -0.6% $276 / Sq Ft
07/29/2023 07/29/23 Price Changed $1,146,013 -0.9% $277 / Sq Ft
04/24/2023 04/24/23 Price Changed $1,156,913 +0.4% $280 / Sq Ft
04/20/2023 04/20/23 Price Changed $1,152,416 -0.1% $279 / Sq Ft
03/09/2023 03/09/23 Price Changed $1,153,493 +0.9% $279 / Sq Ft
03/05/2023 03/05/23 Price Changed $1,143,493 +0.3% $277 / Sq Ft
02/15/2023 02/15/23 For Sale $1,139,993 -- $276 / Sq Ft
Source: Heartland MLS

Purchase History

Date Type Sale Price Title Company
Warranty Deed -- First American Title
Source: Public Records

Source: Heartland MLS

MLS Number: 2421627

Heartland MLS

APN: NP04440000-0034