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

Candice Scriber REALTOR® Sales Associate
337-257-2058


$315,000
228 S ESTATE Drive
Mandeville, LA 70448
MLS# NO2546460
4 beds  |  2 baths  |  2513 sqft


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

Property Description
Attention all investors and flippers. Here's your opportunity to renovate this adorable Acadian home that is loaded with curb appeal. It's located at the end of a cul-de-sac in popular Greenleaves subdivision! Most of the home is in it's original state, but the HVAC system was changed approximately 2 years ago. 4 bedrooms, 2 full baths and 2113 square feet of living area. It has a split floor plan with the primary bedroom on one side and other bedrooms on the opposite side of the house. Seller will not make any repairs. Inspections are for buyers information only. Quarterly dues are $160 and include garbage collection, common ground maintenance and security. The subdivision has a gazebo, two ponds with fountains and a path that runs a mile and a quarter from the front of the subdivision to the back. The subdivision is loaded with trees giving a country feel, but conveniently located minutes from the Causeway bridge, shopping, pharmacies and great restaurants.

Details
Documents
Listing Info
Delayed Marketing: No
List Price/SqFt: 149.08
Document Modified: 2026-04-02 12:10:20.956185
Status: Active
Listing Date: 2026-04-02
Listing Price: 315000
Current Price: $315,000
Type: Single Family Residence
Modification Timestamp: 2026-04-02T19:29:33Z
Photo Modified: 2026-04-02T17:10:24Z
General Property Description
Lot Dimensions: 46x133x166x133
Stories: 1
SqFt - Living: 2113
SqFt - Source: Measured
SqFt - Total: 2513
Assn Fee $: 160
Assn Fee Terms: Quarterly
Acreage Range: 0 - 0.5
Pool on Subject Property: No
# Bedrooms: 4
Baths - Full: 2
Total Baths: 2
Year Built: 1992
Remarks & Misc
Remarks: Attention all investors and flippers. Here's your opportunity to renovate this adorable Acadian home that is loaded with curb appeal. It's located at the end of a cul-de-sac in popular Greenleaves subdivision! Most of the home is in it's original state, but the HVAC system was changed approximately 2 years ago. 4 bedrooms, 2 full baths and 2113 square feet of living area. It has a split floor plan with the primary bedroom on one side and other bedrooms on the opposite side of the house. Seller will not make any repairs. Inspections are for buyers information only. Quarterly dues are $160 and include garbage collection, common ground maintenance and security. The subdivision has a gazebo, two ponds with fountains and a path that runs a mile and a quarter from the front of the subdivision to the back. The subdivision is loaded with trees giving a country feel, but conveniently located minutes from the Causeway bridge, shopping, pharmacies and great restaurants.
Office/Member/Contract Info
List AOR: NOMAR
Style
Acadian: 1
Siding
Vinyl Siding: 1
Parking
Attached: 1
Garage: 1
Construction
Brick: 1
Foundation
Piers: 1
Slab: 1
Fireplace
Gas Log: 1
Roof
Composition: 1
Heating
Natural Gas: 1
Interior
Cathedral Ceiling: 1
Cooling
Central Air: 1
Appliances
Dishwasher: 1
Disposal: 1
Microwave: 1
Rooms
Bedroom 1: 1
Dining Room: 1
Foyer: 1
Kitchen: 1
Laundry: 1
Living Room: 1
Primary Bedroom: 1
Bedroom 2: 1
Bedroom 3: 1
Lot
Cul-De-Sac: 1
Originating Details
Originating System ID: ROAMM
Originating System Key: 57302362
Originating System Listing ID: 2546460
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 228
Dir: S
Street Name: ESTATE Drive
Parish: St. Tammany
State: LA
Zip Code: 70448
Subdivision: Greenleaves Plantation
Tax Assessment Number: 1154567
Directions: Hwy 190 to Greenleaves Blvd. Greenleaves Blvd to Plantation Parcel. Right on first street Bounding Streets: Mayhaw Branch and Estate Drive West
Property Features
Style: Acadian
Siding: Vinyl Siding
Parking: Attached; Garage
Construction: Brick
Foundation: Piers; Slab
Roof: Composition
Interior: Cathedral Ceiling
Fireplace: Gas Log
Heating: Natural Gas
Cooling: Central Air
Appliances: Dishwasher; Disposal; Microwave
Rooms: Bedroom 1; Dining Room; Foyer; Kitchen; Laundry; Living Room; Primary Bedroom; Bedroom 2; Bedroom 3
Lot: Cul-De-Sac
Room Information
Room Name Length Width Remarks
Bedroom 111.6010.50Bedroom
Primary Bedroom15.3014.80Primary Bedroom
Dining Room12.9011.10Dining Room
Foyer13.104.80Foyer
Living Room20.0019.00Living Room
Kitchen14.0011.10Kitchen
Bedroom 214.2012.60Bedroom
Bedroom 313.2013.00Bedroom
Laundry7.405.20Laundry
Listing Documents
View Document Property Disclosure
View Document New Attachment
View Document New Attachment
View Document New Attachment

IDX
Listing Office: Compass Covington (COMP27)

Last Updated: April - 02 - 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-257-2058
 

 

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