We Purchase, Trade, Consult & Market Residential & Commercial Real Estate

  • About
  • Contact
  • Careers
  • 337-984-4345
Guidry and Company Real EstateGuidry and Company Real EstateGuidry and Company Real EstateGuidry and Company Real Estate
  • 337-984-4345
  • Home
  • Buyers
    • Looking to Buy?
    • Featured Listings
    • Homes for Sale
    • COMMERCIAL LISTINGS: Business Opportunity, Industrial, Office, Restaurant/Lounge, Shopping Center, Hotel/Motel, Medical/Dental or Retail
    • LAND LISTINGS: Commercial, Industrial, Residential, Farm or Timberland
    • Buyers Guidebook
    • Choose Your Realtor
    • Why Choose Us
  • Sellers
    • Why Choose Us
  • Services
    • Consultation Services
    • Inherited Land
  • Who’s Your REALTOR®?
  • Success Coaching
  • Blog
  • Reviews

Agent on Call

agent

Candice Scriber, REALTOR® Sales Associate
337-277-6503


$1,495,000
537 DELTA QUEEN Court
Covington, LA 70433
MLS# NO2579152
Status: Pending
6 beds  |  6.2 baths  |  6294 sqft


Photo 1
  1 / 50  
Photo 1 Photo 2 Photo 3 Photo 4 Photo 5 Photo 6 Photo 7 Photo 8 Photo 9 Photo 10 Photo 11 Photo 12 Photo 13 Photo 14 Photo 15 Photo 16 Photo 17 Photo 18 Photo 19 Photo 20 Photo 21 Photo 22 Photo 23 Photo 24 Photo 25 Photo 26 Photo 27 Photo 28 Photo 29 Photo 30 Photo 31 Photo 32 Photo 33 Photo 34 Photo 35 Photo 36 Photo 37 Photo 38 Photo 39 Photo 40 Photo 41 Photo 42 Photo 43 Photo 44 Photo 45 Photo 46 Photo 47 Photo 48 Photo 49 Photo 50

Property Description
Luxurious residence in Covington's gated Natchez Trace community. Refined architectural details, soaring ceilings, generous spaces, and a private outdoor oasis define this impressive residence. An enclosed drainage culvert enhances the front grounds, while striking 10-foot steel-and-glass entry doors framed by gas lanterns create a memorable arrival. The spacious interior features 12-foot ceilings throughout, with the great room rising to 16-foot beamed ceilings with coffered detailing. This open living space showcases a gas fireplace, custom built-ins, travertine marble, and expansive windows. The chef-inspired kitchen is designed for entertaining with an oversized three-slab mother-of-pearl quartzite island, Thermador six-burner gas range with grill and double ovens, pot filler, full-size refrigerator and freezer, wine cooler, and floor-to-ceiling custom cabinetry. A formal dining room connects to the butler's pantry, while the breakfast area enjoys abundant natural light overlooking the pool area. The generous primary suite features a spa-like bath with dual vanities, soaking tub, oversized multi-head shower with bench, and large custom closet. Every bedroom with elegant wood floors offers a large closet and en-suite bath. A second-floor media/game room provides flexibility as a possible sixth bedroom. Outdoors, enjoy a heated and cooled pool with water feature and fire features; cabana with TV, outdoor storage area, and a half bath; covered patio with fireplace and outdoor kitchen; and privacy-fenced yard. Additional amenities include a whole-house generator, whole-house water filtration system, iWave air purification system, security system with cameras, two-car garage with adjoining mudroom, automatic irrigation system, and a 1-Year Home Shield Warranty which covers the the HVAC, kitchen appliances, washer/dryer, plus other covered items.

Details
Documents
Listing Info
Status: Pending
Listing Date: 2026-10-06
Delayed Marketing: No
Listing Price: 1495000
Current Price: $1,495,000
List Price/SqFt: 298.64
Type: Single Family Residence
Document Modified: 2026-10-06 08:55:44.530074
Modification Timestamp: 2026-10-10T21:36:38Z
Photo Modified: 2026-10-06T14:06:17Z
General Property Description
# Bedrooms: 6
Baths - Full: 6
Baths - 1/2: 2
Total Baths: 6.2
SqFt - Living: 5006
SqFt - Total: 6294
SqFt - Source: Appraiser
Year Built: 2017
Acres: 0.43
Acreage Range: 0 - 0.5
Assn Fee $: 1200
Assn Fee Terms: Yearly
Lot Dimensions: 100x188x181x105
Originating Details
Originating System ID: ROAMM
Originating System Key: 59895773
Originating System Listing ID: 2579152
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 537
Street Name: DELTA QUEEN Court
Parish: St. Tammany
State: LA
Zip Code: 70433
Subdivision: Natchez Trace
Tax Assessment Number: 11880
Directions: Bounding Streets: Memphis Trace, Millikens Bend
Status Change Info
Under Contract Date: 2026-10-10
Property Features
Style: Traditional
Siding: Stucco
Parking: Attached; Garage
Construction: Brick
Foundation: Slab
Roof: Composition
Fireplace: Gas Log
Heating: Central
Cooling: 2 or More Units; Central Air
Appliances: Dishwasher; Disposal; Microwave; Refrigerator
Rooms: Bedroom 1; Dining Room; Foyer; Kitchen; Living Room; Primary Bedroom; Utility Room; Bedroom 2; Bedroom 3; Bedroom 4; Bedroom 5; Bedroom 6; Bedroom 7; Bedroom 8
Equipment: Generator
Fencing: Privacy
Patio: Covered
Amenities: Community Pool; Gated Community
Exterior: Outside Kitchen
Other Structures: Cabana
Pool: Inground
Room Information
Room Name Length Width Remarks
Foyer6.4012.50Foyer
Foyer6.4012.50Foyer
Bedroom 112.0016.00Bedroom
Bedroom 212.0016.00Bedroom
Utility Room6.8010.60Utility Room
Utility Room6.8010.60Utility Room
Primary Bedroom15.3021.60Primary Bedroom
Primary Bedroom15.3021.60Primary Bedroom
Living Room24.4027.00Living Room
Living Room24.4027.00Living Room
Dining Room11.8015.80Dining Room
Dining Room11.8015.80Dining Room
Bedroom 311.7014.90Bedroom
Bedroom 415.6018.40Bedroom
Bedroom 514.2015.20Bedroom
Kitchen15.9023.50Kitchen
Kitchen15.9023.50Kitchen
Bedroom 611.7014.90Bedroom
Bedroom 714.2015.20Bedroom
Bedroom 815.6025.20Bedroom
Listing Documents
View Document Flood Dec Page
View Document Survey
View Document Floorplan
View Document Property Disclosure
View Document Amenities & Features

IDX
Listing Office: Compass Mandeville

Last Updated: October - 10 - 2026

The data relating to real estate for sale or lease on this website comes in part from the IDX program of the REALTOR® Association of Acadiana MLS. The IDX information is provided exclusively for consumers’ personal, non-commericial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed accurate by the MLS.


Search powered by FBS Products

Find Us

Get Directions
 

1232-A Camellia Blvd.
Lafayette, LA 70508
P: 337-984-4345

 

AGENT ON CALL | 337-277-6503

 

CALL US: 337-984-4345

 

GUIDRY & CO. REAL ESTATE, Lafayette, LA. All offices are independently owned and operated. The data relating to real estate for sale on this web site comes in part from the IDX Program of the Realtor® Association of Acadiana; MLS Real Estate listings held by brokerage firms other than GUIDRY & CO. REAL ESTATE are marked with the MLS approved icon for IDX. “Information Deemed Reliable But Not Guaranteed”. Copyright 2016 REALTOR® Association of Acadiana, All rights reserved.

Licensed & Regulated in the jurisdiction of the Louisiana Real Estate Commission, Members of the National Association of Realtors®, Louisiana Realtors®, Realtor® Association of Acadiana, Multiple Listing Service (MLS), Louisiana Commercial (www.lacdb.com), The Realtor® Commercial Alliance, Equal Housing Opportunity.

  • Home
  • 337-984-4345
  • Buyers
    • Looking to Buy?
    • Featured Listings
    • Homes for Sale
    • COMMERCIAL LISTINGS: Business Opportunity, Industrial, Office, Restaurant/Lounge, Shopping Center, Hotel/Motel, Medical/Dental or Retail
    • LAND LISTINGS: Commercial, Industrial, Residential, Farm or Timberland
    • Buyers Guidebook
    • Choose Your Realtor
    • Why Choose Us
  • Sellers
    • Why Choose Us
  • Services
    • Consultation Services
    • Looking to Buy?
    • Inherited Real Estate?
    • Choose Your REALTOR®
  • Blog
  • Success Coaching
  • Who’s Your REALTOR®?
  • Careers
  • About Guidry & Co. Real Estate
  • Contact Us
  • Reviews
Guidry and Company Real Estate