15848 Alhambra Street
Overland Park, KS 66224
- 4 beds
- 3.5 baths
- 2,918 sqft
- 10,783 sqft lot
- $306 per sqft
- – on site
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.
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Mar 28, 2025
•
MLS# 2536963 —
The Building
-
Year Built:2026
-
Age Description:2 Years/Less
-
Builder Name:Rodrock Homes
-
Builder Model:Denali
-
Architectural Style:Traditional
-
Construction Materials:Stone Trim, Stucco & Frame, Wood Siding
-
Roof:Composition
-
Basement:Egress Window(s), Full, Stubbed for Bath, Sump Pump
-
Basement:true
-
Exterior Features:Sat Dish Allowed
-
Window Features:Thermal Windows
-
Patio And Porch Features:Covered Patio
-
Green Energy Efficient:Thermostat
-
Installation R Factor:R-19
-
Installation R Factor Wall:R-15
-
Installation R Factor Ceiling:R-50
-
Above Grade Finished Area:2918
Interior
-
Interior Features:Custom Cabinets, Kitchen Island, Painted Cabinets, Pantry, Smart Thermostat, Stained Cabinets, Vaulted Ceiling, Walk-In Closet(s)
-
Flooring:Tile, Wood
-
Fireplace:true
-
Fireplaces Total:1
-
Dining Area Features:Kit/Dining Combo
-
Floor Plan Features:1.5 Stories
-
Laundry Features:Laundry Room, Main Level
-
Fireplace Features:Gas, Great Room
-
Other Room Features:Balcony/Loft,Den/Study,Great Room,Main Floor Master,Mud Room
Room Dimensions
-
Living Area:2918
Financial & Terms
-
Listing Terms:Cash, Conventional
-
Possession:Funding
-
Ownership:Private
-
Warranty Description:Builder-1 yr
-
Home Warranty Company:Builder
Location
-
Directions:159th Street and Mission Road entrance off 159th Street along with 157th Street and Mission Road.
The Property
-
Property Type:Residential
-
Property Subtype:Villa
-
Property Condition:Under Construction
-
Parcel Number:NP47670000 0149
-
Lot Features:City Limits, City Lot, Sprinkler-In Ground
-
Lot Size SqFt:10783.3
-
Lot Size Area:10783.3
-
Lot Size Units:Square Feet
-
Road Responsibility:Public Maintenance
-
Road Surface Type:Paved
-
Fencing:Metal
-
In Flood Plain:Unknown
Listing Agent
- Contact info:
- Agent phone:
- (913) 708-5743
- Office phone:
- (913) 681-5111
Taxes
-
Tax Total Amount:12487
Beds
-
Bedrooms Total:4
Baths
-
Full Baths:3
-
Half Baths:1
-
Total Baths:3.10
Heating & Cooling
-
Cooling:Electric
-
Cooling:true
-
Heating:Natural Gas
Utilities
-
Sewer:City/Public
-
Water Source:Public
-
Telecom:Cable - Available,High Speed Internet - Available
Appliances
-
Appliances:Cooktop, Dishwasher, Disposal, Exhaust Hood, Humidifier, Microwave, Built-In Oven, Built-In Electric Oven
-
Other Equipment:Back Flow Device
Schools
-
Elementary School:Sunrise Point
-
Middle Or Junior School:Prairie Star
-
High School:Blue Valley
-
High School District:Blue Valley
The Community
-
Subdivision Name:Mission Ranch
-
Association Name:First Service Residential
-
Association:true
-
Association Amenities:Clubhouse, Exercise Room, Pickleball Court(s), Play Area, Pool, Trail(s)
-
Association Fee:238
-
Association Fee Includes:All Amenities, Curbside Recycle, Management, Snow Removal, Trash
-
Association Fee Frequency:Monthly
-
Maintenance Provided:1
-
Maintenance Description:Lawn,Snow Removal
Parking
-
Garage:true
-
Garage Spaces:3
-
Parking Features:Attached, Garage Door Opener, Garage Faces Front
Monthly cost estimate

Asking price
$893,607
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$4,784
|
Taxes | $1,040 |
Insurance | $245 |
HOA fees | $238 |
Utilities | N/A |
Total | $6,307/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Transit Score®
Provided by WalkScore® Inc.
Transit Score measures a location's access to public transit. It is based on nearby transit routes frequency, type of route (bus, rail, etc.), and distance to the nearest stop on the route. Transit Scores range from 0 (Minimal Transit) to 100 (Rider’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
3/19/25
Mar 19, 2025
|
Pending | HMLS | $893,607 |