LKV Realty
Logo
$489,000
$2,400Reward *
249 JOSHUA Loop, Pearl River, LA 70452Listing ID 2567897

249 JOSHUA Loop, Pearl River, LA 70452

Active
Pittman Place
Time on site: 26 daysLast updated: 1 day ago
Property Type
Property Type
Residential
Property Sub Type
Property Sub Type
Detached
Bedrooms
Bedrooms
4
Bathrooms
Bathrooms
3
Square Feet
Square Feet
3,225
Days on Site
Days on Site
26
Cooling
Cooling
Central Air
Heating
Heating
Central, Multiple Heating Units
Year Built
Year Built
2018
Stories
Stories
1
Parking
Parking
Three or more Spaces

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!

Property Information

Property Details

Location

Address
249 JOSHUA Loop
County
St Tammany
City
Pearl River
Zip Code
70452
Subdivision
Pittman Place
High School
North Shore

Interior Features

Beds and Baths

Bedrooms
4
Full Bathrooms
2
Half Bathrooms
1

Building

Building Information

Square Feet
3,225
Year Built
2018
Stories
1
Construction
Brick
Foundation
Slab
Roof
Shingle
Condition
Excellent

Financial

Special Conditions
None

Homeowner Association

HOA Fee
$400
HOA Fee Frequency
Annually
Southern Real Estate Professionals, LLC, (504) 235-4931

Market Report for 70452

* The market data shown is based on available information from Multiple Listing Service (MLS) and/or public records. Data provided is for informational and educational purposes only and may not represent the full housing market. For more accurate information, consumers should consult a certified appraiser or licensed real estate agent.

*Average of $2,150 in rewards is calculated based on the purchase or sale of a home between $400,000 to $449,000. The median home price for all housing types is in the United States is $405,400 as of 2025 as reported by the National Association of Realtors® (NAR). The actual reward amount may vary depending on the purchase or sales price of the home. Please see the Lakeview Home Rewards program terms and conditions for more details. The National Association of Realtors® is a registered trademark of the National Association of Realtors®.

Source: ROAM MLS, LLC
ROAM MLS, LLC logo

IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information Deemed Reliable But Not Guaranteed

For corrections to this data please contact Brytecore MLS Support.

CAMAMAND