Inspired by the timeless architecture of A. Hays Town, this remarkable residence blends authentic Southern character with the kind of comfort that makes everyday living feel extraordinary. Set along the golf course in coveted Tchefuncte Club Estates, the home offers privacy, security, and a lifestyle centered around gathering, relaxing, and enjoying the outdoors. Mornings begin with sunlight streaming through walls of tall windows, illuminating warm wood details, brick accents, exposed beams, and inviting living spaces designed for real life rather than show. The kitchen is the heart of the home, featuring professional-grade appliances, abundant workspace, and seamless connections to the dining and living areas where family and friends naturally gather. Outside, the property truly comes alive. A spectacular resort-style pool anchors the backyard, complete with cascading water features, expansive patios, tropical landscaping, and multiple destinations for entertaining. Spend afternoons under the covered outdoor living room with a full summer kitchen, enjoy dinner overlooking the water, then gather around the fire pit as the sun sets across the golf course. Whether hosting a crowd or enjoying a quiet evening at home, the outdoor spaces feel like a private retreat designed to be enjoyed year-round. The thoughtfully designed floor plan includes a private guest suite, spacious secondary bedrooms, and a luxurious primary retreat. Every bedroom features a walk-in closet, while extensive storage throughout the home ensures there is a place for everything. Upstairs, a dedicated media room creates the perfect setting for movie nights, game days, and family gatherings. Comfortable, welcoming, and rich with architectural character, this is a home that feels as good as it looks. A rare opportunity to enjoy classic Louisiana design, exceptional outdoor living, and golf course frontage in one of the Northshore's most sought-after communities.
Single-familyProperty Type
2014Year Built
0.84 acresLot Size
$358Price/Sq.Ft.
$331/moHOA Dues
2 spacesParking
Listed by Felicity Kahn• Berkshire Hathaway HomeServices Preferred, REALTOR
Inspired by the timeless architecture of A. Hays Town, this remarkable residence blends authentic Southern character with the kind of comfort that makes everyday living feel extraordinary. Set along the golf course in coveted Tchefuncte Club Estates, the home offers privacy, security, and a lifestyle centered around gathering, relaxing, and enjoying the outdoors. Mornings begin with sunlight streaming through walls of tall windows, illuminating warm wood details, brick accents, exposed beams, and inviting living spaces designed for real life rather than show. The kitchen is the heart of the home, featuring professional-grade appliances, abundant workspace, and seamless connections to the dining and living areas where family and friends naturally gather. Outside, the property truly comes alive. A spectacular resort-style pool anchors the backyard, complete with cascading water features, expansive patios, tropical landscaping, and multiple destinations for entertaining. Spend afternoons under the covered outdoor living room with a full summer kitchen, enjoy dinner overlooking the water, then gather around the fire pit as the sun sets across the golf course. Whether hosting a crowd or enjoying a quiet evening at home, the outdoor spaces feel like a private retreat designed to be enjoyed year-round. The thoughtfully designed floor plan includes a private guest suite, spacious secondary bedrooms, and a luxurious primary retreat. Every bedroom features a walk-in closet, while extensive storage throughout the home ensures there is a place for everything. Upstairs, a dedicated media room creates the perfect setting for movie nights, game days, and family gatherings. Comfortable, welcoming, and rich with architectural character, this is a home that feels as good as it looks. A rare opportunity to enjoy classic Louisiana design, exceptional outdoor living, and golf course frontage in one of the Northshore's most sought-after communities.
GSREIN #2188913
Feb 21, 2020
Sold
$1,510,000
$236/sq ft
Jan 18, 2020
Pending
—
Oct 7, 2019
Price Changed
$1,549,000
$242/sq ft
Jun 6, 2019
Price Changed
$1,599,000
$250/sq ft
May 7, 2019
Price Changed
$1,699,000
$265/sq ft
Jan 29, 2019
Listed
$1,740,000
$272/sq ft
AcadianaMLS #NO2188913
Jan 29, 2019
Listed
$1,549,000
$242/sq ft
GSREIN #2140829
Aug 6, 2018
Listing Removed
—
Feb 6, 2018
Listed
$1,795,000
$280/sq ft
AcadianaMLS #NO2140829
Feb 6, 2018
Listed
$1,795,000
$280/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$16,846 (−2.4%)
$37,270 + $114,596
$151,866
2024
$17,263 (+3.8%)
$37,270 + $114,596
$151,866
2023
$16,632
$27,450 + $108,351
$135,801
2022
$16,632 (+0.2%)
$27,450 + $108,351
$135,801
2021
$16,600 (−0.3%)
$27,450 + $108,351
$135,801
2020
$16,642 (−0.2%)
$27,450 + $108,351
$135,801
2019
$16,683 (−0.1%)
$27,450 + $97,275
$124,725
2018
$16,702 (−0.7%)
$27,450 + $97,275
$124,725
2017
$16,824 (−0.4%)
$27,450 + $97,275
$124,725
2016
$16,897
$27,450 + $97,275
$124,725
Public record
Public record
Zoning
Permits
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
0.84 Acres
Year renovated
—
Finished Sq. Ft.
5,811
Unfinished Sq. Ft.
—
Total Sq. Ft.
5,811
Year built
2015
Style
Single Family Residential
County
St. Tammany Parish
APN
11287
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jun 29, 2026.
PUD
Planned Unit Development District.
A planned unit development or PUD describes a zoning designation and a process whereby limited deviation from the standards of this UDC is permitted to provide flexibility to accommodate innovative, high-quality site and building design that is otherwise not possible through the application of existing standards prescribed in the UDC. PUD applications shall be reviewed according to the procedures outlined in Chapter 200, Sec. 200-3.12. To be eligible to submit an application for a PUD zoning district map amendment, a proposed development must: Contain a mix of residential and commercial uses, where uses customarily permitted inresidential areas such as golf or community clubs or recreational areas do not qualify as a commercial use meeting this requirement; and Must include the following approaches in innovative land use planning: Environmentally sensitive design that includes preservation of existing natural features of a site that is of a higher quality than would be possible under the regulations otherwise applicable to the property that reduces the risk of flood damage to life and property and enhances drainage functions.; Diversification and variation in the relationship of residential uses, open space, setbacks, and the height of structures compatible with surrounding neighborhoods, which creates a variety of housing types, environments and living units characterized by a cohesive building, sign, and site development program. Minor changes to setbacks or lot width are not considered a variety of housing types; see Ch. 100 definition of housing types for more information.
Nov 10, 2022 • Active
Pool tchefuncta club estates lot 592
Install a new in-ground gunite swimming pool. Work includes electrical wiring for the pool and a gas test for the pool heater.
Electrical
Gas
New construction
Pool and hot tub
Aug 23, 2013 • Final
Lot 592 - tchefuncta club estates ph ii
Work on new construction.
Electrical
Gas
HVAC
New construction
Plumbing
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Historical weather
Covington, LA • 70433
Average low and high temperatures (°F)
61
41
70
49
77
56
81
63
84
68
91
75
92
76
92
75
88
71
83
61
74
55
65
47
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
96/ 100
Exceptional sunlight
Sunscore
There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
10.7 hrs
7.7 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 25 Hummingbird Rd
$2,137,596
$152K under list price of $2.29M
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $1.1M to $2.2M.