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
    • Professional Development
  • Who’s Your REALTOR®?
  • Blog
  • Reviews

Agent on Call

Peggy Voorhies, REALTOR® Sales Associate
337-230-1304


$309,900
623 BEAULIEUX Street
Mandeville, LA 70448
MLS# NO2532350
Status: Pending
3 beds  |  2 baths  |  2050 sqft


Photo 1
  1 / 18  
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

Property Description
NEW CONSTRUCTION BY "YAR CONSTRUCTION" - Min TO I-12 and the Causeway! NO SEWER, WATER BILL- OR HOA DUES $$- SAVE- ENERGY STAR STANDARD- Experience, meticulously crafted to custom home perfection, offering all the custom details and amenities you desire -yet priced affordably!

Welcome to your dream home! This stunning property boasts a spacious primary bedroom featuring an en suite bath, complete with dual sinks, a separate shower, and a relaxing soaking tub--perfect for unwinding after a long day. Enjoy the convenience of a large custom walk-in closet.

Built to the latest energy-efficient standards. Commuters will appreciate the easy access to major routes, making your daily travels a breeze.

The heart of the home is the beautifully designed kitchen, showcasing elegant quartz countertops throughout. The oversized single-serving island is perfect for entertaining or casual dining, complemented by a complete stainless steel ENERGY STAR appliance package.

Complete with a transferable termite contract, New Construction Home Warranty, and additional attic storage above the garage. Don't miss out on this incredible opportunity--schedule your showing today and experience the perfect blend of comfort, style, and convenience!

Details
Listing Info
Delayed Marketing: No
List Price/SqFt: 179.34
Status: Pending
Listing Date: 2025-11-25
Listing Price: 309900
Current Price: $309,900
Type: Single Family Residence
Modification Timestamp: 2026-02-11T21:33:27Z
Photo Modified: 2026-02-03T15:50:04Z
General Property Description
Lot Dimensions: 50 x 116
Stories: 1
SqFt - Living: 1728
SqFt - Source: Blueprint
SqFt - Total: 2050
Acreage Range: 0 - 0.5
# Bedrooms: 3
Baths - Full: 2
Total Baths: 2
Year Built: 2026
Remarks & Misc
Remarks: NEW CONSTRUCTION BY "YAR CONSTRUCTION" - Min TO I-12 and the Causeway! NO SEWER, WATER BILL- OR HOA DUES $$- SAVE- ENERGY STAR STANDARD- Experience, meticulously crafted to custom home perfection, offering all the custom details and amenities you desire -yet priced affordably!

Welcome to your dream home! This stunning property boasts a spacious primary bedroom featuring an en suite bath, complete with dual sinks, a separate shower, and a relaxing soaking tub--perfect for unwinding after a long day. Enjoy the convenience of a large custom walk-in closet.

Built to the latest energy-efficient standards. Commuters will appreciate the easy access to major routes, making your daily travels a breeze.

The heart of the home is the beautifully designed kitchen, showcasing elegant quartz countertops throughout. The oversized single-serving island is perfect for entertaining or casual dining, complemented by a complete stainless steel ENERGY STAR appliance package.

Complete with a transferable termite contract, New Construction Home Warranty, and additional attic storage above the garage. Don't miss out on this incredible opportunity--schedule your showing today and experience the perfect blend of comfort, style, and convenience!
Office/Member/Contract Info
List AOR: NOMAR
Style
Other: 1
Parking
Garage: 1
Construction
Brick: 1
Other: 1
Foundation
Slab: 1
Roof
Composition: 1
Heating
Central: 1
Interior
Attic Access: 1
Cooling
Central Air: 1
Water Source
Well: 1
Appliances
Dishwasher: 1
Disposal: 1
Microwave: 1
Rooms
Bedroom 1: 1
Foyer: 1
Kitchen: 1
Laundry: 1
Living Room: 1
Bedroom 2: 1
Bedroom 3: 1
Bedroom 4: 1
Bedroom 5: 1
Bedroom 6: 1
Originating Details
Originating System ID: ROAMM
Originating System Key: 53967788
Originating System Listing ID: 2532350
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 623
Street Name: BEAULIEUX Street
Parish: St. Tammany
State: LA
Zip Code: 70448
Tax Assessment Number: 145203
Directions: Soult, Chevreuil, Left McDonald, Left on Beaulieux (dead end street) Bounding Streets: McDonald
Status Change Info
Under Contract Date: 2026-02-11
Property Features
Style: Other
Parking: Garage
Construction: Brick; Other
Foundation: Slab
Roof: Composition
Interior: Attic Access
Heating: Central
Cooling: Central Air
Appliances: Dishwasher; Disposal; Microwave
Rooms: Bedroom 1; Foyer; Kitchen; Laundry; Living Room; Bedroom 2; Bedroom 3; Bedroom 4; Bedroom 5; Bedroom 6
Water Source: Well
Room Information
Room Name Length Width Remarks
Kitchen11.8012.00Kitchen
Kitchen11.8012.00Kitchen
Bedroom 113.5012.00Bedroom
Foyer6.909.00Foyer
Foyer6.909.00Foyer
Living Room13.0013.11Living Room
Living Room13.0013.11Living Room
Bedroom 211.0011.11Bedroom
Bedroom 313.3016.10Bedroom
Bedroom 411.0011.11Bedroom
Laundry7.0010.00Laundry
Laundry7.0010.00Laundry
Bedroom 513.5012.00Bedroom
Bedroom 613.3016.10Bedroom

IDX
Listing Office: NOLA Living Realty

Last Updated: February - 11 - 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-230-1304
 

 

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®
    • Professional Development
  • Blog
  • Who’s Your REALTOR®?
  • Careers
  • About Guidry & Co. Real Estate
  • Contact Us
  • Reviews
Guidry and Company Real Estate
Thank you for visiting Guidry & Co. Real Estate, for more information please register here:

"*" indicates required fields

This field is for validation purposes and should be left unchanged.
Name*

 

Return To Homepage