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


$449,000
49 HESTER Street
Madisonville, LA 70447
MLS# NO2550869
4 beds  |  2.1 baths  |  3645 sqft


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

Property Description
This 4-bedroom, 2.5-bath home has so much to offer! The foyer features double doors, a barrel ceiling with wood slat inlay and brick columns leading into an open living area. The den includes a crown lace coffered ceiling and a custom entertainment center that opens to a large kitchen and dining room. The kitchen is equipped with a large island, contrasting granite countertops, stainless appliances, subway tile backsplash, separate bar area, and a walk-in pantry. The primary bedroom features a double tray ceiling with crown molding, while the primary bath offers double undermount sinks, a garden tub, a separate shower, and two closets. Upstairs, you will find an oversized L-shaped bonus room with a closet and a huge walk-in attic. The home features luxury vinyl plank flooring, granite countertops in kitchen and baths, beautiful crown molding throughout the living areas and primary suite. Additional highlights include: Oversized garage with an attached 350 sq. ft. workshop and rear roll-up door*Extended covered patio and an 18'x33' aluminum countersunk pool with a surrounding Trex deck*Two HVAC systems (upstairs and downstairs)*Exterior security cameras and gutters*50-amp RV hookup* Located in Flood Zone C within a great school district* Long driveway for extra parking*Charcoal filtration and sand/sediment separation system*Brick and Hardie Board Construction.

Details
Documents
Listing Info
Delayed Marketing: No
List Price/SqFt: 181.78
Document Modified: 2026-04-02 17:14:55.061911
Status: Active
Listing Date: 2026-04-02
Listing Price: 449000
Current Price: $449,000
Type: Single Family Residence
Modification Timestamp: 2026-04-03T00:33:19Z
Photo Modified: 2026-04-02T22:14:56Z
Location, Tax & Legal Info
Legal Desc: Lot 10, Square 7, Live Oak Hills Subd
General Property Description
Lot Dimensions: 140x210
Stories: 2
SqFt - Living: 2470
SqFt - Source: Blueprint
SqFt - Total: 3645
Acreage Range: 0 - 0.5
# Bedrooms: 4
Baths - Full: 2
Baths - 1/2: 1
Total Baths: 2.1
Year Built: 2017
Remarks & Misc
Remarks: This 4-bedroom, 2.5-bath home has so much to offer! The foyer features double doors, a barrel ceiling with wood slat inlay and brick columns leading into an open living area. The den includes a crown lace coffered ceiling and a custom entertainment center that opens to a large kitchen and dining room. The kitchen is equipped with a large island, contrasting granite countertops, stainless appliances, subway tile backsplash, separate bar area, and a walk-in pantry. The primary bedroom features a double tray ceiling with crown molding, while the primary bath offers double undermount sinks, a garden tub, a separate shower, and two closets. Upstairs, you will find an oversized L-shaped bonus room with a closet and a huge walk-in attic. The home features luxury vinyl plank flooring, granite countertops in kitchen and baths, beautiful crown molding throughout the living areas and primary suite. Additional highlights include: Oversized garage with an attached 350 sq. ft. workshop and rear roll-up door*Extended covered patio and an 18'x33' aluminum countersunk pool with a surrounding Trex deck*Two HVAC systems (upstairs and downstairs)*Exterior security cameras and gutters*50-amp RV hookup* Located in Flood Zone C within a great school district* Long driveway for extra parking*Charcoal filtration and sand/sediment separation system*Brick and Hardie Board Construction.
Office/Member/Contract Info
List AOR: NOMAR
Style
Traditional: 1
Siding
Hardiplank: 1
Parking
Attached: 1
Garage: 1
Construction
Brick: 1
Foundation
Slab: 1
Patio
Covered: 1
Roof
Composition: 1
Heating
Central: 1
Cooling
2 or More Units: 1
Central Air: 1
Water Source
Well: 1
Appliances
Dishwasher: 1
Disposal: 1
Microwave: 1
Utilities
Elec: Entergy: 1
Countertops
Granite: 1
Rooms
Bedroom 1: 1
Den: 1
Dining Room: 1
Foyer: 1
Kitchen: 1
Laundry: 1
Primary Bedroom: 1
Bedroom 2: 1
Bedroom 3: 1
Fencing
Privacy: 1
Wood: 1
Other: 1
Lot
Corner: 1
Pool
Above Ground: 1
Originating Details
Originating System ID: ROAMM
Originating System Key: 57610576
Originating System Listing ID: 2550869
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 49
Street Name: HESTER Street
Parish: St. Tammany
State: LA
Zip Code: 70447
Subdivision: Live Oak Hills
Tax Assessment Number: 11209
Directions: Hwy 22 West; Right @ 1085; Left on Hester Bounding Streets: N. Landry; Kathman
Property Features
Style: Traditional
Siding: Hardiplank
Parking: Attached; Garage
Construction: Brick
Foundation: Slab
Roof: Composition
Heating: Central
Cooling: 2 or More Units; Central Air
Appliances: Dishwasher; Disposal; Microwave
Countertops: Granite
Rooms: Bedroom 1; Den; Dining Room; Foyer; Kitchen; Laundry; Primary Bedroom; Bedroom 2; Bedroom 3
Fencing: Privacy; Wood; Other
Lot: Corner
Patio: Covered
Water Source: Well
Utilities: Elec: Entergy
Pool: Above Ground
Room Information
Room Name Length Width Remarks
Bedroom 112.0012.90Bedroom
Kitchen18.7013.80Kitchen
Primary Bedroom17.0015.00Primary Bedroom
Dining Room10.909.00Dining Room
Laundry9.605.50Laundry
Bedroom 212.0011.00Bedroom
Bedroom 311.0010.00Bedroom
Foyer12.507.20Foyer
Den18.2017.10Den
Listing Documents
View Document New Attachment
View Document New Attachment
View Document New Attachment

IDX
Listing Office: REVE, REALTORS

Last Updated: April - 03 - 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