Skip main navigation
Pending
  • $791,927

    15840 Alhambra St, Overland Park, KS 66224

    4beds
    2,757sqft
    : 
    $5,576/mo
    Get pre-qualified
    Villa
    Built in 2026
    8,138 Square Feet Lot
    $-- Zestimate®
    $287/sqft
    $268/mo HOA

    What's special

    This one is SOLD before processing. A stunning Jackson Plan by Rodrock Homes will be underway in Mission Ranch. Featuring 2 bedrooms on the main floor and 2 additional bedrooms in the lower level. Open floor plan with large dining area, spacious pantry and stunning fireplace in great room. Don't miss final opportunities to live in one of the most highly sought after new home communities in the Blue Valley, Overland Park location.
    271 days
    |
    4
    |
    0
    |

    Zillow last checked:

    Listing updated:

    Listed 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#: 2583785MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 3
      • Full bathrooms: 3
      Dining room
      • Description: Kit/Dining Combo
      Heating
      • Forced Air
      Cooling
      • Electric
      Appliances
      • Included: Cooktop, Dishwasher, Disposal, Double Oven, Exhaust Fan, Humidifier, Microwave, Built-In Oven
      • Laundry: Laundry Room, Main Level
      Features
      • Custom Cabinets, Kitchen Island, Painted Cabinets, Pantry, Smart Thermostat, Stained Cabinets, Vaulted Ceiling(s)
      • Flooring: Carpet, Wood
      • Windows: Thermal Windows
      • Basement: Basement BR,Finished,Full,Sump Pump
      • Number of fireplaces: 2
      • Fireplace features: Gas, Great Room, Other
      Interior area
      • Total structure area: 2,757
      • Total interior livable area: 2,757 sqft
      • Finished area above ground: 1,783
      • Finished area below ground: 974

      Property

      Parking
      • Total spaces: 2
      • Parking features: Attached, Garage Door Opener, Garage Faces Front
      • Attached garage spaces: 2
      Features
      • Patio & porch: Patio, Covered
      • Exterior features: Sat Dish Allowed
      • Fencing: Metal
      Lot
      • Size: 8,138 Square Feet
      • Features: City Lot
      Details
      • Parcel number: NP47670000 0151
      • Other equipment: Back Flow Device

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Traditional
      • Property subtype: Villa
      Materials
      • Stone Veneer, Stucco & Frame, Wood Siding
      • Roof: Composition
      Condition
      • Under Construction
      • New construction: Yes
      • Year built: 2026
      Details
      • Builder model: Jackson
      • Builder name: Rodrock Homes

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public

      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: $268 monthly
      • HOA name: First Service Residential
      Location
      • Region: Overland Park

      Financial & listing details

      • Price per square foot: $287/sqft
      • Tax assessed value: $150,360
      • Annual tax amount: $12,955
      • Date on market: 10/25/2025
      • Listing terms: Cash,Conventional
      • Ownership: Private
      • Road surface type: Paved

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        10/25/2025Pending sale$791,927$287/sqft
        Source: Heartland MLS as distributed by MLS GRID #2583785 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$2,012 +570.5%$18,043 +990.2%
        2024$300 $1,655
        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.
        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.

        Climate risks

        Neighborhood: 66224

        Getting around

        9 / 100
        Car-Dependent
        0 / 100
        No Nearby Transit
        17 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        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.

        A local agent can set up tours, give advice and negotiate with sellers.

        A local lender can help you make sure your offer is ready when you are.

        Browse local experts

        Similar homes