Escape the hustle and bustle with this beautiful equestrian paradise just minutes to shopping, restaurants, schools and the Coquille Sports Complex. Location, location! No need to drive for an hour to experience the boutique farm lifestyle, this beauty is just a hop away from I-12! Situated on beautiful land which is fenced and cross-fenced, this offering includes 7 paddocks, an arena, a pavilion overlooking a tranquil stocked pond, a refreshing heated in-ground pool, and an over-the-top outdoor kitchen and party room, plus a charming "she shed" to boot. .. Think craft room? Gym? Art studio? The possibilities are endless. The home is a lovely mix of formal and informal living spaces with multiple living areas for everyone to spread out, a formal paneled dining room, two primary suites and a wonderful primary bath, 2 laundry rooms and a handy separate staircase to a spacious walk up attic for storage or future living space if desired. Plus a 2-YEAR-OLD ROOF! Outbuildings include an amazing barn with 12 stalls, 2 wash racks, climate controlled tack and feed rooms, and a 1200 sf apartment with bedroom, office and 1.5 baths for added convenience and security. Two additional workshops feature electricity, spray foam insulation, an office and extra stalls, allowing for unparalleled functionality and options for this property. Several income generating opportunities exist for this unique property and are only limited to your imagination. A 36kw whole-home generator provides peace of mind during storm season. Check out the amenities list for additional special features. Priced below recent appraisal! Also listed with the large barn only and +/- 7 acres, see mls #2490307.
Single-familyProperty Type
2006Year Built
15.6 acresLot Size
$331Est. Price/Sq.Ft.
3 spacesParking
Listed by Alice McNeely• REVE, REALTORS
Listed by E Wayne Mayberry• United Real Estate Partners
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Permits
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
14.83 Acres
Year renovated
—
Sq. Ft.
5,298
Year built
2007
Style
Single Family Residential
County
St. Tammany Parish
APN
9633
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jun 29, 2026.
L-1
Large Lot Residential District.
The L-1 Large Lot Residential District is intended to provide a single-family residential
environment on moderate sized lots which are served by central utility systems and other urban
services. The L-1 Large Lot Residential District is located in areas appropriate for urbanized
single-family development in areas convenient to commercial and employment centers. To protect the intention of the district, permitted activities are limited to single-family dwellings and
utility uses. All commercial uses are prohibited in the L-1 District.
Permitted uses
Include but are not limited to:
Agriculture
Housing-Single unit
Wastewater treatment
Mar 18, 2019 • Final
Residential single family (customer orignially applied for barn, but didnt meet plannings requirements so changed to single family)
Electrical
HVAC
New construction
Plumbing
Oct 8, 2014 • Final
Elec service for gate
Install electrical service for a gate.
Electrical
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.
Property details
Parking
Parking
Features: Detached, Three or more Spaces
Interior
Bathroom Information
# of Full Bathrooms: 4
# of Half Bathrooms: 1
Room Information
# of Rooms (Total): 13
Fireplace Information
Has Fireplace
Features: Wood Burning
Equipment
Appliances: Oven, Range, Refrigerator
Exterior
Building Information
Stories: 2
Roof Details: Shingle
Construction Details: HardiPlank Type
Exterior Features
Patio And Porch Features: Covered, Pavers
Other Structures: Apartment, Barn(s), Guest House
Pool Information
Pool Features: In Ground
Lot Information
Lot Size Area: 15.6
Lot Size Acres: 15.6
Lot Size Dimensions: 562 X 795 X 987 x 560
Lot Features: Acreage, Outside City Limits
Property Information
Foundation Details: Slab
Excellent
Utilities
Utility Information
Sewer: Treatment Plant
Water Source: Well
Heating & Cooling
Has Cooling
Cooling: Central Air
Has Heating
Heating: Central, Multiple Heating Units
Public facts
Beds: —
Baths: —
Sq. Ft.: 5,298
Stories: —
Lot Size: 14.83 acres
Style: Single Family Residential
Year Built: 2007
Year Renovated: —
County: St. Tammany Parish
APN: 9633
Home facts updated by county records on Jun 29, 2026
Other
Listing Information
Is Human Modified
Around this home
Schools
Joseph B. Lancaster Elementary School
Public 3-6 • Assigned • 2.3mi
8/10
Madisonville Junior High School
Public 7-8 • Assigned • 4.9mi
7/10
Mandeville High School
Public 9-12 • Assigned • 8.9mi
9/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
9/10 Heat Factor
7 days above 109° expected this year, 22 days in 30 years
9/10 Wind Factor
99% chance of strong winds in next 30 years
2/10 Air Factor
0 unhealthy days expected this year, 1 days in 30 years
Provided by First Street
Historical weather
Madisonville, LA • 70447
Average low and high temperatures (°F)
60
41
69
49
76
56
80
63
84
69
90
76
92
76
91
75
88
72
82
61
74
56
65
47
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.1 hours in
June and 5 hours in December, which is comparable to the
U.S. average for solar exposure.
9.1 hrs
5 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$1.67M – $2.02M
Reach more buyers when you sell with Redfin. Save up to $17,519 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.