Skip main navigation
Active
  • Price cut: $8K (8/12)
    $489,000

    249 Joshua Loop, Pearl River, LA 70452

    4beds
    2,407sqft
    : 
    $3,111/mo
    Get pre-qualified
    Single Family Residence
    Built in 2018
    -- sqft lot
    $481,300 Zestimate®
    $203/sqft
    $33/mo HOA

    What's special

    Custom cabinetryMassive center islandPremium stainless steel appliancesSpacious primary suiteOversized walk-in showerFreestanding soaking tubSoaring ceilings
    Welcome to luxury living, North Shore High district, North of I12 and nearby Slidell. This is a desirable area. Situated on a spacious lot, this custom-built residence combines timeless elegance with thoughtful design and exceptional craftsmanship throughout. From the striking double iron front doors and soaring ceilings to the beautiful crown molding, polished concrete floors and abundant natural light, every detail makes a lasting impression. The heart of the home is an incredible chef's kitchen featuring a massive center island, premium stainless steel appliances, custom cabinetry and an oversized walk-in pantry with rustic sliding barn doors. The open-concept living room offers a cozy fireplace flanked by built-in shelving and seamlessly flows into the dining area and covered outdoor living space, creating the perfect setting for entertaining. The spacious primary suite is a true retreat with tray ceilings, a spa-inspired bath boasting dual vessel sinks, a freestanding soaking tub, oversized walk-in shower and an impressive custom walk-in closet. Additional bedrooms are generously sized, while the dedicated office provides an ideal work-from-home space. The mudroom features built-in storage, adding everyday convenience. Step outside to enjoy the expansive covered patio complete with an outdoor TV and ceiling fan, overlooking a private, tree-lined backyard with plenty of room to relax and play. This exceptional property offers the perfect blend of luxury, privacy and modern comfort in one of the most desirable settings in the heart of Pearl River!
    55 days
    415
    21

    Zillow last checked:

    Listing updated:

    Listed by:

    Amanda Campo 504-228-1860,

    Southern Real Estate Professionals, LLC 504-235-4931

    Source: GSREIN,MLS#: 2567897MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 3
      • Full bathrooms: 2
      • 1/2 bathrooms: 1
      Primary bedroom
      • Level: Lower
      • Dimensions: 13.7x14.3
      Bedroom
      • Level: Lower
      • Dimensions: 10.8x11.11
      Bedroom
      • Level: Lower
      • Dimensions: 10.9x11.11
      Bedroom
      • Level: Lower
      • Dimensions: 13.3x13.4
      Primary bathroom
      • Level: Lower
      • Dimensions: 8.3x7.8
      Bathroom
      • Level: Lower
      • Dimensions: 4.10x8
      Other
      • Level: Lower
      • Dimensions: 8.3x6.2
      Dining room
      • Level: Lower
      • Dimensions: 11.6x14.8
      Kitchen
      • Level: Lower
      • Dimensions: 11.9x14.8
      Laundry
      • Level: Lower
      • Dimensions: 9.8x6
      Living room
      • Level: Lower
      • Dimensions: 15.10x16.11
      Patio
      • Level: Lower
      • Dimensions: 5.4x18.8
      Porch
      • Level: Lower
      • Dimensions: 5x17.3
      Heating
      • Central, Multiple Heating Units
      Cooling
      • Central Air
      Appliances
      • Included: Dishwasher, Microwave, Oven, Range, Refrigerator
      Features
      • Tray Ceiling(s), Ceiling Fan(s), Vaulted Ceiling(s)
      • Has fireplace: Yes
      • Fireplace features: Wood Burning
      Interior area
      • Total structure area: 3,225
      • Total interior livable area: 2,407 sqft

      Property

      Parking
      • Total spaces: 3
      • Parking features: Three or more Spaces
      Features
      • Levels: One
      • Stories: 1
      • Patio & porch: Covered
      Lot
      • Dimensions: 64.50 x 221.6 x 209.9 x 131.2
      • Features: City Lot, Oversized Lot
      Details
      • Parcel number: 100466
      • Special conditions: None

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Traditional
      • Property subtype: Single Family Residence
      Materials
      • Brick
      • Foundation: Slab
      • Roof: Shingle
      Condition
      • Excellent
      • Year built: 2018

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public
      Green energy
      • Energy efficient items: Insulation, Lighting, Water Heater, Windows

      Community & HOA

      Community
      • Subdivision: Pittman Place
      HOA
      • Has HOA: Yes
      • HOA fee: $400 annually
      Location
      • Region: Pearl River

      Financial & listing details

      • Price per square foot: $203/sqft
      • Tax assessed value: $402,792
      • Annual tax amount: $4,156
      • Date on market: 7/20/2026

        Estimated market value

        $481,300

        $457,000 - $505,000

        $2,746/mo

        Price history

        DateEventPrice
        8/12/2026Price change$489,000-1.6%$203/sqft
        Source: GSREIN #2567897 Report a problem
        7/20/2026Listed for sale$497,000$206/sqft
        Source: GSREIN #2567897 Report a problem
        9/26/2016Sold--
        Source: GSREIN #2071325 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$4,156 -3.9%$40,279
        2024$4,326 +37.1%$40,279 +36.6%
        2023$3,156 $29,480
        2022$3,156 +0.1%$29,480
        2021$3,151 +1.9%$29,480 +1%
        2020$3,093 -26.8%$29,180 +2%
        2019$4,223 +453.4%$28,621 +450.4%
        2018$763 -0.7%$5,200
        2017$768 +84.3%$5,200 +88.7%
        2016$417 $2,756
        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.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 70452

        Getting around

        0 / 100
        Car-Dependent
        25 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • High: North Shore

        Source: GSREIN. 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.

        Browse local experts