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
  • Who’s Your REALTOR®?
  • Success Coaching
  • Blog
  • Reviews

Agent on Call

agent

Candice Scriber, REALTOR® Sales Associate
337-277-6503


$525,000
248 CHURCHILL DOWNS Drive
Bush, LA 70431
MLS# NO2567206
5 beds  |  2.2 baths  |  5200 sqft


Photo 1
  1 / 40  
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 Photo 34 Photo 35 Photo 36 Photo 37 Photo 38 Photo 39 Photo 40

Property Description
Experience the perfect blend of Southern charm and country living in this stunning 5-bedroom Acadian estate, gracefully set on 5 scenic acres with three horse-ready pastures (fenced and cross fenced), 6 stalls, a 30'x40' barn, majestic live oaks, and mature fruit trees, all just 15 mins to Downtown Covington. Relax and unwind from the spacious covered front porch or entertain on the expansive rear patio and recently refinished deck overlooking the picturesque property. Foyer entrance with soaring ceilings & elegant trim work. Oversized formal dining with French doors, spacious bay window exudes natural light, and a beautifully restored 100-year-old New Orleans mantel adds timeless character and Southern charm. The beautifully appointed galley kitchen offers granite countertops, stainless appliances, walk-in pantry, breakfast bar, & cozy breakfast nook overlooking the backyard. Expansive living room features vaulted ceilings, wood burning fireplace, custom built-ins & coffee bar. Lavish primary suite offers private access to the generous, screened patio, & spacious primary ensuite complete with 2 large, custom built-out closets. Guest bedroom & half bath complete the main level. The second level features 3 large bedrooms with spacious closets & full bathroom. Oversized garage offers 2 HUGE walk-in closets & half bath. Recently refinished deck overlooks cozy firepit area & greenhouse that houses well pump. Roof & Septic system 4yrs old, outside HVAC condenser 2yr old. Flood zone C - no flood insurance required. The grounds are truly beautiful offering incredible views with majestic live oaks, mature fig and blueberry bushes, and multiple shaded seating areas to take in this peaceful estate. Raised flower bed ready for your homesteading touch. Easy 2-way gate latches on all fencing. A rare opportunity to own a turnkey equestrian estate that perfectly combines modern comforts with the beauty and tranquility of country living. A MUST SEE TO APPRECIATE!

Details
Documents
Listing Info
Status: Active
Listing Date: 2026-07-11
Delayed Marketing: No
Listing Price: 525000
Current Price: $525,000
List Price/SqFt: 190.49
Type: Single Family Residence
Document Modified: 2026-09-25 23:36:37.168154
Modification Timestamp: 2026-09-27T15:46:15Z
Photo Modified: 2026-08-12T22:19:33Z
General Property Description
# Bedrooms: 5
Baths - Full: 2
Baths - 1/2: 2
Total Baths: 2.2
SqFt - Living: 2756
SqFt - Total: 5200
SqFt - Source: Public Record
Stories: 2
Year Built: 1989
Acres: 5
Acreage Range: 3 - 5.99
Assn Fee $: 75
Assn Fee Terms: Yearly
Lot Dimensions: 464x443x449x548
Pool on Subject Property: No
Originating Details
Originating System ID: ROAMM
Originating System Key: 59065976
Originating System Listing ID: 2567206
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 248
Street Name: CHURCHILL DOWNS Drive
Parish: St. Tammany
State: LA
Zip Code: 70431
Subdivision: Grande Hills
Tax Assessment Number: 72681
Directions: Bounding Streets: Fairgrounds Blvd, Belmont Park Dr
Property Features
Style: Acadian
Siding: Vinyl Siding
Parking: Garage; RV Access/Parking
Foundation: Piers
Roof: Composition
Interior: Vaulted Ceilings
Fireplace: Wood Burning
Heating: Central
Cooling: 2 or More Units; Central Air
Appliances: Dishwasher; Disposal; Dryer; Microwave; Refrigerator; Washer
Countertops: Granite
Rooms: Bedroom 1; Dining Room; Kitchen; Laundry; Living Room; Primary Bathroom; Primary Bedroom; Bedroom 2; Bedroom 3; Bedroom 4; Bedroom 5; Bedroom 6; Bedroom 7; Bedroom 8
Fencing: Full; Other
Patio: Covered
Amenities: Acreage
Other Structures: Barn(s); Greenhouse
Water Source: Well
Utilities: Elec: Wst
Room Information
Room Name Length Width Remarks
Bedroom 111.5010.10Bedroom
Bedroom 211.3010.10Bedroom
Kitchen12.509.50Kitchen
Kitchen12.509.50Kitchen
Kitchen12.509.50Kitchen
Kitchen12.509.50Kitchen
Kitchen12.509.50Kitchen
Kitchen12.509.50Kitchen
Kitchen12.509.50Kitchen
Kitchen12.509.50Kitchen
Bedroom 311.5011.50Bedroom
Bedroom 420.5014.00Bedroom
Bedroom 511.5010.10Bedroom
Primary Bathroom18.709.90Primary Bathroom
Primary Bathroom18.709.90Primary Bathroom
Primary Bathroom18.709.90Primary Bathroom
Primary Bathroom18.709.90Primary Bathroom
Primary Bathroom18.709.90Primary Bathroom
Primary Bathroom18.709.90Primary Bathroom
Primary Bathroom18.709.90Primary Bathroom
Primary Bathroom18.709.90Primary Bathroom
Bedroom 620.5014.00Bedroom
Bedroom 720.5014.00Bedroom
Primary Bedroom19.0019.00Primary Bedroom
Primary Bedroom19.0019.00Primary Bedroom
Primary Bedroom19.0019.00Primary Bedroom
Primary Bedroom19.0019.00Primary Bedroom
Primary Bedroom19.0019.00Primary Bedroom
Primary Bedroom19.0019.00Primary Bedroom
Primary Bedroom19.0019.00Primary Bedroom
Primary Bedroom19.0019.00Primary Bedroom
Bedroom 811.3010.10Bedroom
Living Room19.5019.11Living Room
Living Room19.5019.11Living Room
Living Room19.5019.11Living Room
Living Room19.5019.11Living Room
Living Room19.5019.11Living Room
Living Room19.5019.11Living Room
Living Room19.5019.11Living Room
Living Room19.5019.11Living Room
Laundry8.807.10Laundry
Laundry8.807.10Laundry
Laundry8.807.10Laundry
Laundry8.807.10Laundry
Laundry8.807.10Laundry
Laundry8.807.10Laundry
Laundry8.807.10Laundry
Laundry8.807.10Laundry
Dining Room17.3011.60Dining Room
Dining Room17.3011.60Dining Room
Dining Room17.3011.60Dining Room
Dining Room17.3011.60Dining Room
Dining Room17.3011.60Dining Room
Dining Room17.3011.60Dining Room
Dining Room17.3011.60Dining Room
Dining Room17.3011.60Dining Room
Listing Documents
View Document Property Disclosures

IDX
Listing Office: 1 Percent Lists Gulf South

Last Updated: September - 27 - 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-277-6503

 

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®
  • Blog
  • Success Coaching
  • Who’s Your REALTOR®?
  • Careers
  • About Guidry & Co. Real Estate
  • Contact Us
  • Reviews
Guidry and Company Real Estate