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

Jennifer Guidry, REALTOR® Sales Associate
337-349-8076


$1,899,000
15587 CLUB DELUXE Road
Hammond, LA 70403
MLS# NO2541595




Property Description
Here is your chance to own the former Fun Farm. Large commercial tract in high traffic area, property backs up to I-12 for excellent exposure.

Details
Listing Info
Delayed Marketing: No
Status: Active
Listing Date: 2026-02-04
Listing Price: 1899000
Current Price: $1,899,000
Modification Timestamp: 2026-02-06T17:55:47Z
Location, Tax & Legal Info
Legal Desc: Tract 2 and Tract 3, containing 12.34 Acres, located in Sections 35 and 36, T6S, R7E.
General Property Description
Lot Dimensions: 613.00 x 778.00 x 1068.00 x 1050.00
St Front (Ft): 613
Mobile Allowed: No
Divisible: No
Acreage Range: 11 - 19.99
Acres: 12.34
Remarks & Misc
Remarks: Here is your chance to own the former Fun Farm. Large commercial tract in high traffic area, property backs up to I-12 for excellent exposure.
Office/Member/Contract Info
List AOR: NOMAR
Land Type
Commercial: 1
Potential Use
Commercial: 1
Utilities
Electricity Available: 1
Natural Gas Available: 1
Telephone: 1
Fencing
None: 1
Originating Details
Originating System ID: ROAMM
Originating System Key: 56931841
Originating System Listing ID: 2541595
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 15587
Street Name: CLUB DELUXE Road
Parish: Tangipahoa
State: LA
Zip Code: 70403
Zone: Commer
Directions: Club Deluxe Road, formerly The Fun Farm. Bounding Streets: Veterans Blvd.
Property Features
Land Type: Commercial
Potential Use: Commercial
Utilities: Electricity Available; Natural Gas Available; Telephone
Fencing: None

IDX
Listing Office: Pevey Realtors & Appraisers

Last Updated: February - 06 - 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-349-8076
 

 

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