NOT LISTED FOR SALE

2807 W 175th Terrace Stilwell, KS 66085

Estimated Value: $1,263,000 - $1,505,781

5 Beds
5.5 Baths
4,820 Sq Ft
$286/Sq Ft Est. Value

Last Sold February 19, 2021

Current estimated payment $8,626/month

1,038 Days on Market

Highlights

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

About This Home

As of February 2021

PREPARE FOR A "SUPER" GAME WITH THIS GEM! LARGE & IN CHARGE! Elegant curved staircase welcome you to the elegant & spacious main level w/frml dining feat. designer ceiling detail, open Grt Rm w/full height stone accent at FP & open truss wood beams, brkfst nook & secluded hearth rm ideal for a quiet getaway. Main level Owner Suite comp. w/sitting area & tasteful, private bath suite feat granite tops, jetted tub. Gourmet kitch. See community manager for comp. list of features. NEED SPACE, THIS ONE GIVES IT AND MORE! Intro. Rodrock Developments newest So. JoCo community!!! NEED ROOM TO GROW? Spacious and elegance combined!!! Compare size and pricing to others on the market, tough to beat the value!!! Priced waaaaay below reproduction pricing!!!
TAKE A LOOK AT THE VALUE OFFERED FOR THE PRICE AND SQUARE FOOTAGE!

Last Agent to Sell the Property

Bruce Stout

Rodrock & Associates Realtors License #SP00047114 Listed on: 03/22/2018

Co-Listed By

Bob Sloan

Rodrock & Associates Realtors License #BR00034814

Last Buyer's Agent

Betty Harris

Platinum Realty LLC License #SP00233410

Platinum Realty LLC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $15,125

Lot Details

  • 0.4 Acre Lot
  • Sprinkler System

HOA Fees

  • $63 Monthly HOA Fees

Parking

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

Home Design

  • Home Under Construction
  • Traditional Architecture
  • Composition Roof
  • Stone Trim

Interior Spaces

  • 4,820 Sq Ft Home
  • Wet Bar: Carpet, Walk-In Closet(s), Ceramic Tiles, Shower Over Tub, Shower Only, Granite Counters, Double Vanity, Whirlpool Tub, Cathedral/Vaulted Ceiling, Indirect Lighting, Hardwood, Kitchen Island, Other, Built-in Features
  • Built-In Features: Carpet, Walk-In Closet(s), Ceramic Tiles, Shower Over Tub, Shower Only, Granite Counters, Double Vanity, Whirlpool Tub, Cathedral/Vaulted Ceiling, Indirect Lighting, Hardwood, Kitchen Island, Other, Built-in Features
  • Vaulted Ceiling
  • Ceiling Fan: Carpet, Walk-In Closet(s), Ceramic Tiles, Shower Over Tub, Shower Only, Granite Counters, Double Vanity, Whirlpool Tub, Cathedral/Vaulted Ceiling, Indirect Lighting, Hardwood, Kitchen Island, Other, Built-in Features
  • Skylights
  • Gas Fireplace
  • Shades
  • Plantation Shutters
  • Drapes & Rods
  • Mud Room
  • Entryway
  • Great Room with Fireplace
  • 2 Fireplaces
  • Formal Dining Room
  • Loft
  • Fire and Smoke Detector
  • Laundry on main level

Kitchen

  • Breakfast Room
  • Eat-In Kitchen
  • Gas Oven or Range
  • Cooktop
  • Recirculated Exhaust Fan
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Granite Countertops
  • Laminate Countertops
  • Disposal

Flooring

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

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Primary Bedroom on Main
  • Custom Closet System
  • Cedar Closet: Carpet, Walk-In Closet(s), Ceramic Tiles, Shower Over Tub, Shower Only, Granite Counters, Double Vanity, Whirlpool Tub, Cathedral/Vaulted Ceiling, Indirect Lighting, Hardwood, Kitchen Island, Other, Built-in Features
  • Walk-In Closet: Carpet, Walk-In Closet(s), Ceramic Tiles, Shower Over Tub, Shower Only, Granite Counters, Double Vanity, Whirlpool Tub, Cathedral/Vaulted Ceiling, Indirect Lighting, Hardwood, Kitchen Island, Other, Built-in Features
  • Double Vanity
  • Whirlpool Bathtub
  • Carpet

Basement

  • Walk-Out Basement
  • Walk-Up Access
  • Sub-Basement: Bedroom 5, Bathroom 4, Bedroom 4

Schools

  • Stilwell Elementary School
  • Blue Valley High School

Additional Features

  • Enclosed Patio or Porch
  • City Lot
  • Forced Air Heating and Cooling System

Listing and Financial Details

  • Assessor Parcel Number NP04440000 0032

Community Details

Overview

  • Association fees include curbside recycling, management, trash pick up
  • Sundance Ridge Big Sky Subdivision, Olympus II Expanded Floorplan

Amenities

  • Clubhouse

Recreation

  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$15,125

Lot Details

0

HOA Fees

$63 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: Big Sky at Sundance Ridge, 1st Plat, Lot 32
  • Warranty Description: Builder Warranty
  • Above Grade Finished Sq Ft: 4820.00
  • Architectural Style: Traditional
  • Builder Model: Olympus II Expanded
  • Builder Name: Pyramid Homes
  • Co List Office Mls Id: RODR
  • Co List Office Name: Rodrock & Associates Realtors
  • Co List Office Phone: 913-681-5111
  • Dining Area Features: Breakfast Area, Eat-In Kitchen, Formal
  • Exclude From Reports: No
  • Fireplaces: 2
  • Floor Plan Features: 1.5 Stories
  • Installation R Factor Ceiling: 49
  • Installation R Factor Other: 19
  • 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: Bruce Stout
  • List Office Mls Id: RODR
  • List Office Name: Rodrock & Associates Realtors
  • List Office Phone: 913-681-5111
  • Living Area: 4820.00
  • Maintenance Provided: No
  • Mls Status: Sold
  • Other Room Features: Balcony/Loft, Breakfast Room, Entry, Great Room, Main Floor BR, Main Floor Master, Mud Room
  • Phone Other: 913-991-8095
  • Phone Other Type: Phone
  • Special Documents Required: No
  • Tax Total Amount: 15125
  • Value Range Pricing: No
  • Special Features: None

Interior Features

  • Interior Amenities: Ceiling Fan(s), Custom Cabinets, Kitchen Island, Painted Cabinets, Pantry, Vaulted Ceiling, Walk-In Closet, Whirlpool Tub
  • Fireplace Features: Gas, Great Room, Other
  • Basement: Concrete, Walk Out, Walk Up
  • Above Grade Finished Area Units: Square Feet
  • Appliances: Cooktop, Dishwasher, Disposal, Hood/Fan, Humidifier, Microwave, Rng/Oven- Gas, Stainless Appliances
  • Basement: Yes
  • Fireplace: Yes
  • Laundry Features: Main Level, Second Level

Beds/Baths

  • Full Bathrooms: 5
  • Half Bathrooms: 1
  • Bedrooms: 5

Exterior Features

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

Garage/Parking

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

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, Swimming Pool
  • Association Fee: 750
  • Association Fee Frequency: Annually
  • Association Fee Includes: Curbside Recycle, Management, Trash Pick Up

Schools

  • Middle/Junior School: Blue Valley

Lot Info

  • In Floodplain: No
  • Lot Features: City Lot, Sprinkler-In Ground
  • Lot Size Area Units: Square Feet
  • Lot Size Sq Ft: 17610.00
  • Parcel Number: NP04440000 0032
  • Property Attached: No
  • Subdivision Name: Sundance Ridge- Big Sky

Tax Info

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

MLS Schools

  • Elementary School: Stilwell
  • School District: Blue Valley
  • High School: Blue Valley

Matterport 3D Tour

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Aug 24, 2023
Sold by
Ramos Andrew
Bought by
Ramos Family Trust
Current Estimated Value
$1,378,945

Purchase Details

Listed on
Mar 22, 2018
Closed on
Feb 17, 2021
Sold by
Pyramid Homes Llc
Bought by
Ramos Andrew
Seller's Agent
Bruce Stout
Rodrock & Associates Realtors
Buyer's Agent
Betty Harris
Platinum Realty LLC
List Price
$1,132,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
4.96%
Original Mortgage
$1,124,277
Interest Rate
2.65%
Mortgage Type
VA

Purchase Details

Closed on
Jul 11, 2017
Sold by
Sundance Ridge Partners Llc
Bought by
Pyramid 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
$784,000
Interest Rate
3.91%
Mortgage Type
Construction
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
Ramos Family Trust -- None Listed On Document
Ramos Andrew -- Security 1St Title Llc
Pyramid Homes Llc -- Chicago Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Ramos Andrew $1,124,277
Previous Owner Pyramid Homes Llc $784,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
02/19/2021 02/19/21 Sold -- -- --
01/23/2021 01/23/21 Pending -- -- --
11/06/2019 11/06/19 Price Changed $1,099,999 -2.8% $228 / Sq Ft
03/22/2018 03/22/18 For Sale $1,132,000 -- $235 / 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 $15,710 $150,282 $25,758 $124,524
2023 $14,779 $140,081 $23,407 $116,674
2022 $13,583 $126,385 $21,254 $105,131
2021 $13,583 $125,718 $21,254 $104,464
2020 $14,308 $125,971 $21,254 $104,717
2019 $16,473 $123,797 $20,226 $103,571
2018 $9,221 $68,379 $20,224 $48,155
2017 $1,094 $0 $0 $0
2016 $1 $9 $9 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Heartland MLS

MLS Number: 2095817

Heartland MLS

APN: NP04440000-0032