Skip main navigation
Active
    • $849,900

    14259 87th Pl, Saint John, IN 46373

    4beds
    2,932sqft
    : 
    $5,753/mo
    Get pre-qualified
    Single Family Residence
    Built in 2025
    -- sqft lot
    $840,300 Zestimate®
    $290/sqft
    $-- HOA

    What's special

    Beautifully built two-story homeOpen great roomCovered front porchThree additional bedroomsCovered patioLarger lot sizesSpacious backyard
    Welcome to Castle Rock-where quality craftsmanship, thoughtful design, and larger lot sizes create a refined yet approachable custom-home experience. This beautifully built two-story home offers elevated finishes and everyday livability in a desirable St. John location. Inside, you'll find hardwood floors, a gas fireplace with brick surround and wood mantel, and a home office just off the foyer. The open great room flows into the breakfast area with sliding doors to a covered patio and spacious backyard-an uncommon feature in today's market. The kitchen blends style and function with quartz countertops, a large island, tile backsplash, stainless steel appliances, and a large walk-in pantry. Upstairs, the primary suite features a soaking tub, custom-tiled walk-in shower with glass enclosure, and generous his-and-hers walk-in closet spaces. Three additional bedrooms, a full bath, and a second-floor laundry with washer, dryer, and sink complete the level. Additional highlights include a mudroom with built-in bench and storage, oak staircase with custom railing, and a full unfinished basement plumbed for a future bath. This unique home includes a fully brick and stone exterior, covered front porch, professional landscaping, concrete driveway, and dual garages (2.5-car plus 1-car) with epoxy floors, gas heater, and extra storage. No HOA, close to parks, shopping, dining, and just minutes from the Illinois border.
    --
    on Zillow
    |
    308
    views
    |
    12
    saves
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Jeffrey Fryzel 219-322-5508,

    McColly Real Estate,

    Lori Bierlein 219-776-8083,

    McColly Real Estate

    Source: MRED as distributed by MLS GRID,MLS#: 12553361MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 3
      • Full bathrooms: 2
      • 1/2 bathrooms: 1
      Rooms
      • Room types: Den, Bonus Room, Foyer, Mud Room, Pantry
      Primary bedroom
      • Features: Bathroom (Full, Double Sink, Tub & Separate Shwr)
      • Level: Second
      • Area: 240 Square Feet
      • Dimensions: 16X15
      Bedroom 2
      • Level: Second
      • Area: 182 Square Feet
      • Dimensions: 14X13
      Bedroom 3
      • Level: Second
      • Area: 156 Square Feet
      • Dimensions: 13X12
      Bedroom 4
      • Level: Second
      • Area: 120 Square Feet
      • Dimensions: 12X10
      Bonus room
      • Level: Second
      • Area: 80 Square Feet
      • Dimensions: 10X8
      Den
      • Level: Main
      • Area: 168 Square Feet
      • Dimensions: 14X12
      Dining room
      • Level: Main
      • Area: 216 Square Feet
      • Dimensions: 18X12
      Foyer
      • Level: Main
      • Area: 64 Square Feet
      • Dimensions: 8X8
      Kitchen
      • Level: Main
      • Area: 210 Square Feet
      • Dimensions: 15X14
      Laundry
      • Level: Main
      • Area: 72 Square Feet
      • Dimensions: 9X8
      Living room
      • Level: Main
      • Area: 357 Square Feet
      • Dimensions: 21X17
      Mud room
      • Level: Main
      • Area: 72 Square Feet
      • Dimensions: 12X6
      Pantry
      • Level: Main
      • Area: 54 Square Feet
      • Dimensions: 9X6
      Heating
      • Natural Gas
      Cooling
      • Central Air
      Appliances
      • Included: Range, Microwave, Dishwasher, Refrigerator, Washer, Dryer
      • Laundry: Upper Level, Gas Dryer Hookup, Sink
      Features
      • Walk-In Closet(s), Pantry, Quartz Counters
      • Flooring: Hardwood, Carpet
      • Basement: Unfinished,Bath/Stubbed,Full
      • Number of fireplaces: 1
      • Fireplace features: Gas Log, Living Room
      Interior area
      • Total structure area: 4,292
      • Total interior livable area: 2,932 sqft
      Video & virtual tour

      Property

      Parking
      • Total spaces: 3.5
      • Parking features: Concrete, Garage Door Opener, Yes, Garage Owned, Attached, Garage
      • Attached garage spaces: 3.5
      • Has uncovered spaces: Yes
      Accessibility
      • Accessibility features: No Disability Access
      Features
      • Stories: 2
      • Patio & porch: Patio
      Lot
      • Dimensions: 107x150x96x150
      Details
      • Parcel number: 451130184002000035
      • Special conditions: None

      Construction

      Type & style
      • Home type: SingleFamily
      • Property subtype: Single Family Residence
      Materials
      • Brick, Stone
      Condition
      • New Construction
      • New construction: Yes
      • Year built: 2025

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public

      Community & HOA

      HOA
      • Services included: None
      Location
      • Region: Saint John

      Financial & listing details

      • Price per square foot: $290/sqft
      • Tax assessed value: $600
      • Annual tax amount: $10
      • Date on market: 1/23/2026
      • Ownership: Fee Simple

        Estimated market value

        $840,300

        $798,000 - $882,000

        $3,668/mo

        Price history

        DateEventPrice
        3/23/2026Listed for sale$849,900$290/sqft
        Source: MRED as distributed by MLS GRID #12553361 Report a problem
        3/1/2026Pending sale$849,900$290/sqft
        Source: NIRA as distributed by MLS GRID #833145 Report a problem
        1/23/2026Listed for sale$849,900$290/sqft
        Source: MRED as distributed by MLS GRID #12553361 Report a problem
        12/17/2025Listing removed$849,900$290/sqft
        Source: MRED as distributed by MLS GRID #12513390 Report a problem
        11/7/2025Listed for sale$849,900$290/sqft
        Source: NIRA as distributed by MLS GRID #830482 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$10 -4.4%$600
        2024$10 -4.7%$600
        2023$11 +1.9%$600
        2022$11 -2.4%$600
        2021$11 -6.7%$600
        2020$12 $600
        2019-- $600
        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.
        Get pre-qualified

        Climate risks

        Neighborhood: 46373

        Getting around

        59 / 100
        Somewhat Walkable
        41 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

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

        Browse local experts

        Similar homes

              Nearby cities

              Nearby zip codes

              Other Saint John Topics

                Search
                Updates
                Favorites
                Plan
                Inbox