Pending

$817,458

15837 Alhambra St, Overland Park, KS 66224

4beds

2,683sqft

$5,606/mo

Get pre-qualified

Villa

Built in 2026

8,315 Square Feet Lot

$-- Zestimate^®

$305/sqft

$284/mo HOA

What's special

SOLD BEFORE PROCESSING. The Hudson by Rodrock Homes will be underway for the new Mission Ranch homeowner. This is a well-designed home with and open floor plan. In addition to the Primary Suite located on the main floor, an additional bedroom is also available for convenience and accessibility. Lower level will feature two additional bedrooms and finished family room, along with a full bathroom. This one is sold! Don't miss the final remaining opportunities in this highly sought after Overland Park, Blue Valley school district community.

201 days

7

0

Facts & features

Interior

Bedrooms & bathrooms

Bedrooms: 4
Bathrooms: 3
Full bathrooms: 3

Primary bedroom

Level: Main

Bedroom 2

Level: Main

Bedroom 3

Level: Lower

Bedroom 4

Level: Lower

Primary bathroom

Level: Main

Bathroom 2

Level: Main

Bathroom 3

Level: Lower

Family room

Level: Lower

Great room

Level: Main

Kitchen

Level: Main

Heating

Forced Air

Cooling

Electric

Appliances

Included: Cooktop, Dishwasher, Disposal, Exhaust Fan, Humidifier, Microwave
Laundry: Bedroom Level, Laundry Room

Features

Custom Cabinets, Kitchen Island, Painted Cabinets, Pantry, Smart Thermostat, Stained Cabinets, Vaulted Ceiling(s), Walk-In Closet(s)
Flooring: Carpet, Tile, Wood
Windows: Thermal Windows
Basement: Basement BR,Finished,Walk-Out Access
Number of fireplaces: 1
Fireplace features: Gas, Great Room

Interior area

Total structure area: 2,683
Total interior livable area: 2,683 sqft
Finished area above ground: 1,776
Finished area below ground: 907

Property

Parking

Total spaces: 2
Parking features: Attached, Garage Faces Front
Attached garage spaces: 2

Features

Patio & porch: Patio
Exterior features: Sat Dish Allowed

Lot

Size: 8,315 Square Feet

Details

Parcel number: NP476700000111
Other equipment: Back Flow Device

Construction

Type & style

Home type: SingleFamily
Architectural style: Traditional
Property subtype: Villa

Materials

Stone Trim, Stucco & Frame
Roof: Composition

Condition

Under Construction
New construction: Yes
Year built: 2026

Details

Builder model: Hudson
Builder name: Rodrock Homes

Utilities & green energy

Sewer: Public Sewer
Water: Public

Green energy

Energy efficient items: Doors, Thermostat, Windows
Water conservation: Low-Flow Fixtures

Community & HOA

Community

Security: Smoke Detector(s)
Subdivision: Mission Ranch

HOA

Has HOA: Yes
Amenities included: Clubhouse, Exercise Room, Pickleball Court(s), Play Area, Pool, Trail(s)
Services included: All Amenities, Curbside Recycle, Maintenance Grounds, Management, Snow Removal, Trash
HOA fee: $284 monthly
HOA name: First Service Residential

Location

Region: Overland Park

Financial & listing details

Price per square foot: $305/sqft
Tax assessed value: $150,900
Annual tax amount: $11,425
Date on market: 1/6/2026
Listing terms: Cash,Conventional
Ownership: Private

Estimated market value

Not available

Estimated sales range

Not available

Price history

Date	Event	Price
1/6/2026	Pending sale	$817,458$305/sqft
Source: Heartland MLS as distributed by MLS GRID #2595143 Report a problem

Public tax history

Year	Property taxes	Tax assessment
2025	$2,018 +564.4%	$18,108 +970.8%
2024	$304	$1,691

Find assessor info on the county website

Monthly payment

Est. payment

Payment breakdown

Explore the cost of this home by adjusting the details. Changes won't be saved.

Principal & interest
$1,547
Mortgage insurance
$0
Property taxes
$170
Home insurance
$105
HOA fees
$0
Utilities
Not included

All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.

HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.

Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.

See how much you could borrow to make a competitive offer.

Get pre-qualified

Climate risks

Neighborhood: 66224

Getting around

9 / 100

Car-Dependent

0 / 100

No Nearby Transit

17 / 100

Somewhat Bikeable

Nearby schools

GreatSchools rating

9/10
Sunrise Point Elementary School
Grades: K-5Distance: 0.4 mi
9/10
Prairie Star Middle School
Grades: 6-8Distance: 2.1 mi
10/10
Blue Valley High School
Grades: 9-12Distance: 1.3 mi

Schools provided by the listing agent

Elementary: Sunrise Point
Middle: Prairie Star
High: Blue Valley

Source: Heartland MLS as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.