Price Reduction - Eco Friendly
Address
249 Joshua Loop, Pearl River, LA
Price
$ 489,000
Property Attributes
  • MLS#2567897
  • TypeSingle Family
  • Listing Status Active
  • CountyST TAMMANY
  • CityPearl River
  • NeighborhoodPittman Place
  • Zip70452
  • StyleTraditional
  • Year Built2018
  • Price$ 489,000
  • Bedrooms4
  • Full Bathrooms2
  • Half Bathrooms1
  • Sqr Footage2407
Data Source:
Gulf South Real Estate Information Network
Property Description

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!

High School
North Shore High School
Price History
7/20/2026 Listed $497,000
8/12/2026 2$489,000

General Features

Sewer Public Sewer
Heating Central,Multiple Heating Units
Cooling Central Air
Roof Shingle
Appliances Dishwasher,Microwave,Oven,Range,Refrigerator
HOA Fee 400
Patio/Porch Features Covered
Architectural Style Traditional
Construction Materials Brick
Year Built 2018
Stories Count 1
Levels One
Property Subtype Detached
Assoc Fee Paid Per Annually
County St Tammany
Property Type Residential
HOA Yes
Energy Efficient Insulation,Lighting,Water Heater,Windows
Subdivision Name Pittman Place
Total Rooms 13
Full Baths 2
Status Active
High School North Shore
City Pearl River
Property Condition Excellent
Standard Status Active
Tax Lot 5
Property Sub Type Additional Detached,Single Family Residence
PostalCity Pearl River
Legal Description LOT 5 PITTMAN PLACE SUB INST NO 1085122 INST NO 14...

Interior Features

Interior Amenities Tray Ceiling(s),Ceiling Fan(s),Vaulted Ceiling(s)
Fireplace Features Wood Burning
Air Conditioning Y/N Yes
Heating Y/N Yes
Fireplace Y/N Yes
Half Baths 1
Total Bedrooms 4
LivingAreaSource Measured

Exterior Features

Parking Features Three or more Spaces
Lot Features City Lot,Oversized Lot
Water Source Public
Foundation Details Slab
Building Area Total 3225
Lot Dimensions 64.50x221.6x209.9x131.2

Room Details

Room Dimensions Level Flooring Details
Bathroom Lower
Bedroom Lower
Bedroom Lower
Bedroom Lower
Dining Room Lower
Kitchen Lower
Laundry Lower
Living Room Lower
Patio Lower
Porch Lower
Primary Bathroom Lower
Primary Bedroom Lower

Amenities

  • Foreclosure
  • Views
  • Short Sale
  • New Construction
  • Adult 55+
  • Lease To Own
  • No HOA Fees
  • Furnished
  • Primary On Main
  • Air Conditioning
  • Seller Finance
  • Green
  • Fixer Upper
  • Horse
  • Golf
  • Fireplace
  • Deck
  • Garage
  • Basement
  • Pool

Property vs Single Family Average in 70452

Price
AVG $310K
$490K
Year Built
AVG 1995
2018
Visits
AVG 87
26
Data Provided by Inside Real Estate®

Looking for a more comfortable experience?

Download our mobile app for a personalized browsing experience.

Your Agent

Quianna Jackson

Broker/Owner | Quianna & Company Realty Firm

504-208-8484

Listed By
Amanda Campo with Southern Real Estate Professionals, LLC - (504) 235-4931

Areas We Cover