$675,000
Hammond, LA 70403
MLS# NO2547416
4 beds | 4.1 baths | 5724 sqft
1 / 31
Property Description
Experience true grand-scale living on nearly 2 acres of private paradise. The moment you step through the entry, this magnificent estate captivates w/its beautiful wood flooring & amazing sprawling layout. At the heart of the home is a massive, 908 sq ft climate-controlled sunroom adorned with a wall of windows w/plantation shutters, an ultimate year-round sanctuary for entertaining. Office/bedroom w/lg closet, linen closet & ensuite full bath. End your day in the breathtaking primary suite which is a destination of its own featuring a dual-sided fireplace, wet bar, keeping rm for morning coffee or evening retreat to relax & an add'l exercise equipmt area. The spa-inspired bath boasts a double-entry glass block shower w/dual shower heads, Jacuzzi tub, his & her wings each w/private toilet area, solid wood vanities, desk area, linen & walkin closets. The right wing includes a formal dining room w/an array of natural light, a gourmet kitchen overlooks the den & breakfast area, beautiful custom solid wood cabinetry, granite tops, pots & pans drawers, glass pane cabinets & desk area, new farmhouse sink, newer dishwasher, double ovens, smooth top cooktop, window overlooking the sunroom & doorway thereto, a 1/2 bath off the kitchen. Fall in love w/the Cathedral ceilings & sun-drenched den, enjoy cozy nights along the fireplace w/massive granite hearth & bookcases, French drs opening to the sunroom. Two guest bedrooms share a jack-n-jill bathrm w/separate toilet & walk-in tub area. 3 car garage w/storage area & full bath & a multiple vehicle driveway, full home generator ran by propane gives peace of mind during electrical outages, separate driveway leads to a 1600+ sf wkshop w/two garage doors, concrete patio, office & bathroom. With meticulous custom finishes throughout, this home blends massive space w/cozy, intimate details. You must see this fabulous estate to appreciate all it has to offer. New roof 2021, new right-wing a/c unit, resurfaced flat roof 3/2026
Details
Documents
Listing Info
Delayed Marketing: No
List Price/SqFt: 143.56
Document Modified: 2026-03-22 13:07:33.149142
Status: Active
Listing Date: 2026-03-20
Listing Price: 675000
Current Price: $675,000
Type: Single Family Residence
Modification Timestamp: 2026-03-23T03:51:10Z
Photo Modified: 2026-03-23T03:50:44Z
Location, Tax & Legal Info
Legal Desc: As per title
General Property Description
Lot Dimensions: 1.93 Acres
Stories: 1
SqFt - Living: 4702
SqFt - Source: Appraiser
SqFt - Total: 5724
Acreage Range: 1 - 2.99
Pool on Subject Property: No
# Bedrooms: 4
Baths - Full: 4
Baths - 1/2: 1
Total Baths: 4.1
Year Built: 2005
Acres: 1.93
Remarks & Misc
Remarks: Experience true grand-scale living on nearly 2 acres of private paradise. The moment you step through the entry, this magnificent estate captivates w/its beautiful wood flooring & amazing sprawling layout. At the heart of the home is a massive, 908 sq ft climate-controlled sunroom adorned with a wall of windows w/plantation shutters, an ultimate year-round sanctuary for entertaining. Office/bedroom w/lg closet, linen closet & ensuite full bath. End your day in the breathtaking primary suite which is a destination of its own featuring a dual-sided fireplace, wet bar, keeping rm for morning coffee or evening retreat to relax & an add'l exercise equipmt area. The spa-inspired bath boasts a double-entry glass block shower w/dual shower heads, Jacuzzi tub, his & her wings each w/private toilet area, solid wood vanities, desk area, linen & walkin closets. The right wing includes a formal dining room w/an array of natural light, a gourmet kitchen overlooks the den & breakfast area, beautiful custom solid wood cabinetry, granite tops, pots & pans drawers, glass pane cabinets & desk area, new farmhouse sink, newer dishwasher, double ovens, smooth top cooktop, window overlooking the sunroom & doorway thereto, a 1/2 bath off the kitchen. Fall in love w/the Cathedral ceilings & sun-drenched den, enjoy cozy nights along the fireplace w/massive granite hearth & bookcases, French drs opening to the sunroom. Two guest bedrooms share a jack-n-jill bathrm w/separate toilet & walk-in tub area. 3 car garage w/storage area & full bath & a multiple vehicle driveway, full home generator ran by propane gives peace of mind during electrical outages, separate driveway leads to a 1600+ sf wkshop w/two garage doors, concrete patio, office & bathroom. With meticulous custom finishes throughout, this home blends massive space w/cozy, intimate details. You must see this fabulous estate to appreciate all it has to offer. New roof 2021, new right-wing a/c unit, resurfaced flat roof 3/2026
Office/Member/Contract Info
List AOR: NOMAR
Style
Contemporary: 1
Siding
Stucco: 1
Parking
Attached: 1
Garage: 1
Equipment
Generator: 1
Construction
Brick: 1
Foundation
Slab: 1
Fireplace
Wood Burning: 1
Roof
Composition: 1
Heating
Central: 1
Interior
Cathedral Ceiling: 1
Cooling
2 or More Units: 1
Central Air: 1
Appliances
Dishwasher: 1
Microwave: 1
Utilities
Elec: Entergy: 1
Propane: 1
Countertops
Granite: 1
Rooms
Bedroom 1: 1
Den: 1
Dining Room: 1
Foyer: 1
Kitchen: 1
Laundry: 1
Living Room: 1
Primary Bathroom: 1
Primary Bedroom: 1
Other: 1
Bedroom 2: 1
Bedroom 3: 1
Amenities
Acreage: 1
Originating Details
Originating System ID: ROAMM
Originating System Key: 57364494
Originating System Listing ID: 2547416
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 43019
Street Name: LOYDS Lane
Parish: Tangipahoa
State: LA
Zip Code: 70403
Tax Assessment Number: 04810708
Directions: Airport Rd to Frontage Rd/I-12 Service Rd Bounding Streets: Frontage Road/I-12 Service Road
Property Features
Style: Contemporary
Siding: Stucco
Parking: Attached; Garage
Construction: Brick
Foundation: Slab
Roof: Composition
Interior: Cathedral Ceiling
Fireplace: Wood Burning
Heating: Central
Cooling: 2 or More Units; Central Air
Appliances: Dishwasher; Microwave
Countertops: Granite
Rooms: Bedroom 1; Den; Dining Room; Foyer; Kitchen; Laundry; Living Room; Other; Primary Bathroom; Primary Bedroom; Bedroom 2; Bedroom 3
Equipment: Generator
Amenities: Acreage
Utilities: Elec: Entergy; Propane
Room Information
| Room Name | Length | Width | Remarks |
| Bedroom 1 | 14.00 | 13.00 | Bedroom |
| Kitchen | 18.50 | 13.80 | Kitchen |
| Living Room | 21.00 | 15.00 | Living Room |
| Bedroom 2 | 17.00 | 12.50 | Bedroom |
| Primary Bathroom | 24.00 | 20.00 | Primary Bathroom |
| Bedroom 3 | 14.50 | 12.00 | Bedroom |
| Other | 32.80 | 21.00 | Other |
| Den | 22.80 | 16.00 | Den |
| Laundry | 13.00 | 7.00 | Laundry |
| Primary Bedroom | 30.50 | 21.00 | Primary Bedroom |
| Foyer | 8.60 | 7.80 | Foyer |
| Dining Room | 15.50 | 12.50 | Dining Room |
Property Disclosure IDX
Listing Office: Hanemann Realty, Inc.
Last Updated: March - 23 - 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.
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.