$893,607
PENDING

15848 Alhambra St Overland Park, KS 66224

Estimated payment $6,027/month

4 Beds
3.5 Baths
2,918 Sq Ft
$306 Price per Sq Ft

Highlights

  • Custom Closet System
  • Clubhouse
  • Traditional Architecture
  • Sunrise Point Elementary School Rated A
  • Vaulted Ceiling
  • Wood Flooring

About This Home

This one is SOLD before processing. The Denali floor plan by Rodrock Homes is underway for our newest homeowner in the Mission Ranch Villa community. Mission Ranch offers a luxurious lifestyle with excellent proximity to the finest shopping and dining experiences. Convenience is key to this location for everyday living. Within the Blue Valley school district, Sunrise Point Elementary is located within the community of Mission Ranch. Students attend Blue Vally High. A resort style pool, clubhouse with cardio center attached, playground, picnic area, sport court and bocce ball add to this highly desired Rodrock community.

Listing Agent

Angela Fitzgerald

Rodrock & Associates Realtors Brokerage Phone: 913-708-5743 License #SP00223751 Listed on: 03/18/2025

Co-Listing Agent

Andrea Sullivan

Rodrock & Associates Realtors Brokerage Phone: 913-708-5743 License #2003026332

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $12,337

Year Built

  • Home Under Construction

Lot Details

  • 10,783 Sq Ft Lot
  • Aluminum or Metal Fence
  • Paved or Partially Paved Lot
  • Sprinkler System

HOA Fees

  • $238 Monthly HOA Fees

Parking

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

Home Design

  • Traditional Architecture
  • Villa
  • Composition Roof
  • Wood Siding
  • Stone Trim

Interior Spaces

  • 2,918 Sq Ft Home
  • 1.5-Story Property
  • Vaulted Ceiling
  • Gas Fireplace
  • Thermal Windows
  • Mud Room
  • Great Room with Fireplace
  • Combination Kitchen and Dining Room
  • Den
  • Loft
  • Smart Thermostat

Kitchen

  • Built-In Electric Oven
  • Built-In Oven
  • Cooktop
  • Recirculated Exhaust Fan
  • Dishwasher
  • Kitchen Island
  • Wood Stained Kitchen Cabinets
  • Disposal

Flooring

  • Wood
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bedroom on Main
  • Custom Closet System
  • Walk-In Closet

Laundry

  • Laundry Room
  • Laundry on main level

Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump
  • Stubbed For A Bathroom
  • Basement Window Egress

Outdoor Features

  • Covered Patio or Porch
  • Playground

Schools

  • Sunrise Point Elementary School
  • Blue Valley High School

Utilities

  • Central Air
  • Heating System Uses Natural Gas
  • Satellite Dish

Additional Features

  • Energy-Efficient Thermostat
  • City Lot

Listing and Financial Details

  • Assessor Parcel Number NP47670000 0149
  • $150 special tax assessment

Community Details

Overview

  • Association fees include all amenities, curbside recycling, management, snow removal, trash
  • First Service Residential Association
  • Mission Ranch Subdivision, Denali Floorplan

Amenities

  • Clubhouse

Recreation

  • Community Pool
  • Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$12,337

Year Built

Home Under Construction

Lot Details

0

HOA Fees

$238 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Villa
  • Property Condition: Under Construction
  • Year Built: 2026
  • Above Grade Finished Sq Ft: 2918
  • Architectural Style: Traditional
  • Builder Model: Denali
  • 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: 1
  • Green Energy Efficient: Thermostat
  • Internet Address Display: Yes
  • Internet Consumer Comment: No
  • List Agent Full Name: Angela Fitzgerald
  • List Office Mls Id: HMSRODR
  • List Office Name: Rodrock & Associates Realtors
  • List Office Phone: 913-681-5111
  • Living Area: 2918
  • Mls Status: Pending
  • Other Equipment: Back Flow Device
  • Ownership: Private
  • Age Description: 2 Years/Less
  • Floor Plan Features: 1.5 Stories
  • Tax Special Amount: 150
  • Tax Total Amount: 12487
  • Value Range Pricing YN: 0
  • Dining Area Features: Kit/Dining Combo
  • Maintenance Provided YN: 1
  • Other Room Features: Balcony/Loft,Den/Study,Great Room,Main Floor Master,Mud Room
  • Special Documents Required YN: 0
  • Building Conversion YN: 0
  • Installation R Factor Ceiling: R-50
  • Installation R Factor Wall: R-15
  • Maintenance Description: Lawn,Snow Removal
  • Warranty Description: Builder-1 yr
  • Installation R Factor Other: R-19
  • Phone Other: 913-300-1435
  • Attribution Contact: 913-708-5743
  • Special Features: NewHome

Interior Features

  • Interior Amenities: Custom Cabinets, Kitchen Island, Painted Cabinets, Pantry, Smart Thermostat, Stained Cabinets, Vaulted Ceiling, Walk-In Closet(s)
  • Fireplace Features: Gas, Great Room
  • Basement: Egress Window(s), Full, Stubbed for Bath, Sump Pump
  • Appliances: Cooktop, Dishwasher, Disposal, Exhaust Hood, Humidifier, Microwave, Built-In Oven, Built-In Electric Oven
  • Basement: Yes
  • Fireplace: Yes
  • Flooring: Tile, Wood
  • Laundry Features: Laundry Room, Main Level
  • Window Features: Thermal Windows

Beds/Baths

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

Exterior Features

  • Exterior Features: Sat Dish Allowed
  • Roof: Composition
  • Construction Materials: Stone Trim, Stucco & Frame, Wood Siding
  • Fencing: Metal
  • Patio And Porch Features: Covered Patio
  • Road Surface Type: Paved
  • Exclusions YN: 0
  • Inside City Limits: Yes

Garage/Parking

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

Utilities

  • Cooling: Electric
  • Heating: Natural Gas
  • Sewer: City/Public
  • Cooling: Yes
  • Water Source: Public
  • Telecom: Cable - Available,High Speed Internet - Available

Condo/Co-op/Association

  • Association Amenities: Clubhouse, Exercise Room, Pickleball Court(s), Play Area, Pool, Trail(s)
  • Association Fee: 238
  • Association Fee Frequency: Monthly
  • Association Fee Includes: All Amenities, Curbside Recycle, Management, Snow Removal, Trash

Association/Amenities

  • Association Name: First Service Residential
  • Association: Yes

Fee Information

  • Deposit: Builder

Schools

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

Lot Info

  • Lot Features: City Limits, City Lot, Sprinkler-In Ground
  • Lot Size Area: 10783.3
  • Lot Size Sq Ft: 10783.3
  • Parcel Number: NP47670000 0149
  • Property Attached: No
  • Subdivision Name: Mission Ranch
  • ResoLotSizeUnits: SquareFeet
  • In Flood Plain: Unknown

Tax Info

  • Tax Annual Amount: 12337
  • Tax Abatement YN: 0
  • Tax Comment: est

MLS Schools

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

Map

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

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 $355 $2,183 $2,183 --
2023 $356 $2,183 $2,183 --
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/18/2025 03/18/25 Pending -- -- --
03/18/2025 03/18/25 For Sale $893,607 -- $306 / Sq Ft
Source: Heartland MLS

Purchase History

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

Mortgage History

Date Status Loan Amount Loan Type
Open $714,850 Construction
Closed $714,850 Construction
Source: Public Records

Source: Heartland MLS

MLS Number: 2536963

Heartland MLS

APN: NP47670000-0149