15837 Alhambra Street | MLS #2595143 | RE/MAX Kansas-Missouri

Listing provided courtesy of Rodrock & Associates RealtorsGreater Heartland Region MLSMLS# 2595143

Contact Information: 913-708-5743

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.

Source: Greater Heartland Region MLS, MLS#: 2595143

Love this property?

Create a profile so you can receive updates on this property as soon as they happen!

Property Type

Residential
Lot

0.19 acres

General

Association/HOA

Association Amenities: Clubhouse,Exercise Room,Pickleball Court(s),Play Area,Pool,Trail(s)
Association Fee: 284
Association Fee Frequency: Monthly
Association Fee Includes: All Amenities,Curbside Recycle,Lawn Service,Management,Snow Removal,Trash
Association Name: First Service Residential
Association: Yes

School Information

School District: Blue Valley
Elementary School: Sunrise Point
Middle Or Junior School: Prairie Star
High School: Blue Valley

Green Features

Green Water Conservation: Low-Flow Fixtures
Green Energy Efficient: Doors,Thermostat,Windows

Building Information

Builder Model: Hudson
Builder Name: Rodrock Homes
Year Built: 2026

Location/Region

County Or Parish: Johnson, KS
MLS Area Major: 345 - N=135th;S=Co Ln;E=State Ln;W=Pflumm
Subdivision Name: Mission Ranch

General Information

Listing Terms: Cash,Conventional
Ownership: Private
Parcel Number: NP47670000-0111
Property Condition: Under Construction
Property Sub Type: Villa
Property Type: Residential
Senior Community: No

Interior

Parking Information

Garage Spaces: 2
Garage: Yes

Beds/Baths

Bathrooms Full: 3
Bathrooms Half: 0
Bathrooms Total: 3
Bedrooms Total: 4

Building Interior

Above Grade Finished Area: 1776
Below Grade Finished Area: 907

General Information

Appliances: Cooktop,Dishwasher,Disposal,Exhaust Fan,Humidifier,Microwave
Fireplace Features: Gas,Great Room
Fireplace: Yes
Fireplaces Total: 1
Flooring: Carpet,Tile,Wood
Heating: Forced Air
Interior Features: Custom Cabinets,Kitchen Island,Painted Cabinets,Pantry,Smart Thermostat,Stained Cabinets,Vaulted Ceiling(s),Walk-In Closet(s)
Laundry Features: Bedroom Level,Laundry Room
Living Area: 2683
Other Equipment: Back Flow Device
Rooms Total: 10
Security Features: Smoke Detector(s)
Window Features: Thermal Windows

Exterior

Parking Information

Parking Features: Attached,Garage Faces Front

Lot Information

Lot Size Area: 8315.92
Lot Size Square Feet: 8315.92
Lot Size Units: Square Feet
Road Responsibility: Public Maintenance
Water Source: Public

Building Exterior/Construction

Architectural Style: Traditional
Construction Materials: Stone Trim,Stucco & Frame
Patio And Porch Features: Deck- Covered,Patio
Roof: Composition

General Information

Exterior Features: Sat Dish Allowed
Sewer: Public Sewer

Room Information

Room: Bathroom 3

Level: Lower

Room: Bedroom 3

Level: Lower

Room: Bedroom 4

Level: Lower

Room: Family Room

Level: Lower

Room: Bathroom 2

Level: Main

Room: Bedroom 2

Level: Main

Room: Great Room

Level: Main

Room: Kitchen

Level: Main

Room: Primary Bathroom

Level: Main

Room: Primary Bedroom

Level: Main

Get in Contact

Would you like to know more about this property? We're here to help! Let's connect and find what you're looking for.

Carrie Cowan Holder
Associate
RE/MAX State Line
Mobile Phone 816-308-8833
Client Ratings:

Owning this Home

Estimated Monthly Cost

Price

Down Payment

$ %

Loan Length (years)

Interest Rate

* All calculations are estimates and provided by Reliance Network, for informational purposes only. Actual amounts may vary. ** Assumes 6.50% APR, 20% down payment, and conventional 30-year fixed rate first mortgage. Rates cited are for instructional purposes only; current rates are subject to change at any time without notice. You should not make any decisions based simply on the information provided. Additional required amounts such as taxes, insurance, homeowner association dues, assessments, mortgage insurance premiums, flood insurance or other such required payments should also be considered. Contact your mortgage company for current rates and additional information. Any mortgage broker or insurance agent that may appear is independent and is not affiliated with, endorsed by, or provided by the MLS.

Life at 15837 Alhambra Street

Schools

School data courtesy of LiveBy, Inc.

Ratings are based on a scale of 1-5, with 5 being the highest rating and 1 being the lowest rating. The schools displayed on this website are for informational purposes only and may not represent a complete or up-to-date list. School assignments are subject to change and should be verified directly with the local school district. Please contact the appropriate school district to confirm school zoning and enrollment eligibility for this property.

History

Date	Event	Value	Agent
1/6/2026Source: Greater Heartland Region MLS	Added to Database	January 06, 2026

Get in Contact

Success

Owning this Home

Life at 15837 Alhambra Street

Schools

History