SOLD BEFORE PROCESSING. The Tahoe by Rodrock Homes will begin construction in the Mission Ranch Villa location. Great floor plan design. Dedicated office space, three bedrooms and 2 1/2 bathrooms, finished lower level. Open layout with kitchen, dining area and great room. Final opportunities to live in one of the most highly desired new home communities within the Blue Valley school district. Amenities include a resort style pool with waterfall feature and water slide. Stunning clubhouse which can be rented for the residents to entertain family and friends. A cardio center is attached to the clubhouse. Sport court that includes Pickleball and Basketball. Bocce ball, picnic area and playground. All centrally located within the community. Sunrise Point Elementary school is located within Mission Ranch.
Pending
$765,871
15852 Alhambra St, Overland Park, KS 66224
3beds
2,814sqft
Est.:
Villa
Built in 2025
0.31 Acres Lot
$-- Zestimate®
$272/sqft
$260/mo HOA
What's special
Dedicated office spaceFinished lower levelOpen layout
- 304 days
- on Zillow |
- 3 |
- 0 |
Zillow last checked: 7 hours ago
Listing updated: October 15, 2024 at 10:27am
Listing Provided by:
Angela Fitzgerald 913-708-5743,
Rodrock & Associates Realtors,
Andrea Sullivan 913-908-4942,
Rodrock & Associates Realtors
Source: Heartland MLS as distributed by MLS GRID,MLS#: 2515370

Travel times
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Primary bedroom
- Level: Main
Bedroom 2
- Level: Lower
Bedroom 3
- Level: Lower
Primary bathroom
- Level: Main
Bathroom 2
- Level: Lower
Family room
- Level: Lower
Great room
- Level: Main
Half bath
- Level: Main
Kitchen
- Level: Main
Laundry
- Level: Main
Heating
- Forced Air
Cooling
- Electric
Appliances
- Included: Cooktop, Microwave, Built-In Electric Oven
- Laundry: Laundry Room, Main Level
Features
- Custom Cabinets, Kitchen Island, Pantry, Smart Thermostat, Vaulted Ceiling(s), Walk-In Closet(s)
- Flooring: Carpet, Tile, Wood
- Windows: Thermal Windows
- Basement: Finished,Sump Pump
- Number of fireplaces: 1
- Fireplace features: Gas, Great Room
Interior area
- Total structure area: 2,814
- Total interior livable area: 2,814 sqft
- Finished area above ground: 1,700
- Finished area below ground: 1,114
Property
Parking
- Total spaces: 3
- Parking features: Attached, Garage Door Opener, Garage Faces Front
- Attached garage spaces: 3
Features
- Patio & porch: Screened
- Exterior features: Sat Dish Allowed
Lot
- Size: 0.31 Acres
- Features: Corner Lot
Details
- Parcel number: NP47670000 0148
- Other equipment: Back Flow Device
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Villa
Materials
- Stone Veneer, Stucco & Frame
- Roof: Composition
Condition
- Under Construction
- New construction: Yes
- Year built: 2025
Details
- Builder model: Tahoe
- Builder name: Rodrock Homes
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Green energy
- Energy efficient items: Doors, Thermostat, Windows
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: $260 monthly
- HOA name: First Service Residential
Location
- Region: Overland Park
Financial & listing details
- Price per square foot: $272/sqft
- Tax assessed value: $23,140
- Annual tax amount: $10,707
- Date on market: 10/15/2024
- Listing terms: Cash,Conventional,FHA
- Ownership: Private
- Road surface type: Paved
- Loading