1497 Frontage Rd

693,039 / 15.91
Lot Size / Acres

Description

15.91 acres with excellent visibility and accessibility from I-12 and Airport Rd. with 1200' of frontage on Frontage Rd. This tract is adjacent to a Holiday Inn Express to the south and is the northern anchor to a Sam's Club, Walmart, LaQuinta Inn, Homewood Suites and a Starbucks. This retail hub of the I-12/Airport Rd, intersection also includes Academy Sports, Petsmart, Ross Dress for Less, Shoe Carnival and a Comfort Inn. Zoned C-4 Highway Commercial District. Priced $355,000 below April '23 appraisal.15.91 acres with excellent visibility and accessibility from I-12 and Airport Rd. with 1200' of frontage on Frontage Rd. This tract is adjacent to a Holiday Inn Express to the south and is the northern anchor to a Sam's Club, Walmart, LaQuinta Inn, Homewood Suites and a Starbucks. This retail hub of the I-12/Airport Rd, intersection also includes Academy Sports, Petsmart, Ross Dress for Less, Shoe Carnival and a Comfort Inn. Zoned C-4 Highway Commercial District. Priced $355,000 below April '23 appraisal.
  1. Listed by Vince Liuzza III • Berkshire Hathaway HomeServices Preferred, REALTOR
    P: (504)-237-9634 C: (504)-237-9634 vliuzza3@yahoo.com

Property Details for 1497 Frontage Road

Subdivision Name
Not a Subdivision
Zoning
C-4
LISTING UPDATED: 12/14/2025 03:00 PM

Property Details for 1497 Frontage Road

StatusActive
MLS #2534604
Days on Market26
Taxes-
HOA Fees-
Condo/Co-op Fees-
Compass TypeLand
MLS TypeLand
Year Built-
Lot Size15.91 AC
CountySt. Tammany Parish

Location

Listing Courtesy of Berkshire Hathaway HomeServices Preferred, REALTOR
Add your commute

Building Information for 1497 Frontage Road

Lot Size15.91 AC

Payment Calculator

$9,754 per month

30 year fixed, 6.15% Interest

Principal and Interest

$9,748

Property Taxes

$6

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Property Information for 1497 Frontage Road

Summary
Location and General Information
  • Directions: I-12 @ Airport Road Bounding Streets: I-21 and Airport Road
  • Latitude: 30.31
  • Longitude: -89.83
  • MLS Area Minor: ST. TAMMANY
  • In City Limits: 1
  • Road Surface Type: Asphalt
Taxes and HOA
  • Association Amenities: Subd Acreage
  • Association: No
  • Tax Legal Description: Section 31, Township 8 South, Range 14 East, St. Tammany Parish
  • Tax Lot: -
  • Tax Block: -
  • Tax Square: -
Virtual Tour
Property
Lot Information
  • Lot Size Acres: 15.91
  • Lot Size Dimensions: 1200.00 x 669.00 x 1408.00 x 495.00
  • St Frontage Ft: 1200.0000
  • Lot Size Source: Appraiser
Property and Assessments
  • Property Type: Land
  • Possible Use: Commercial
Utilities
  • Sewer: Public Sewer
  • Water Source: Public
  • GS Utilities Gas: Other Gas
  • EL Utilities Elec: Other Elec
Interior and Exterior Features
Exterior Features
  • Fencing: None
Mobile Home
Mobile & Manufactured Home
  • Mobile Allowed: 0

Property History for 1497 Frontage Road

DateEvent & SourcePriceAppreciation
Dec 14, 2025

Listed (Active)

ROAM MLS #2534604

$200,000
Aug 8, 2025

Temporarily Off Market

ROAM MLS #2463332

$2,000,000
Aug 8, 2024

Temporarily Off Market

ROAM MLS #NO2408038

$2,000,000
Aug 8, 2024

Listed (Active)

ROAM MLS #NO2463332

$2,000,000
Aug 8, 2023

Listed (Active)

ROAM MLS #NO2408038

$2,000,000
DateEvent & SourcePrice
12/14/2025

Listed (Active)

ROAM MLS #2534604

$200,000
08/08/2025

Temporarily Off Market

ROAM MLS #2463332

$2,000,000
08/08/2024

Temporarily Off Market

ROAM MLS #NO2408038

$2,000,000
08/08/2024

Listed (Active)

ROAM MLS #NO2463332

$2,000,000
08/08/2023

Listed (Active)

ROAM MLS #NO2408038

$2,000,000

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 1497 Frontage Road

Taxable ValueLand$454Additions-Total$454
Tax Record2024$70 ($6 / month)
Home Facts
Lot Size693,040 SqFtStyleVines and Bush FruitsCountySAINT TAMMANYAPN92417

Schools near 1497 Frontage Road

This home is within St. Tammany Parish School District.
Rating
School
Type
Grades
Distance
Public - PK to 3
Public - 4 to 6
Public - 7 to 8
Public - 9 to 12
Rating
School
Distance
Bayou Woods Elementary School
PublicPK to 3

Carolyn Park Middle School
Public4 to 6

Slidell Junior High School
Public7 to 8

Slidell High School
Public9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Similar Sold Homes

1497 Frontage Road is a 15.91 ac of land for sale in Slidell, LA 70460. This property was listed for sale on December 14, 2025 by Berkshire Hathaway HomeServices Preferred, REALTOR, it's currently listed at $2,000,000. This listing's school district is St. Tammany Parish School District. Nearby schools include Bayou Woods Elementary School, Carolyn Park Middle School and Slidell Junior High School. 1497 Frontage Road is a 0-bed, 0-bath, 15.91 ac of land on a 693,039 sq. ft. / 15.91 acres lot.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Berkshire Hathaway HomeServices Preferred, REALTOR

The data relating to real estate listings on this website comes in part from the Internet Data Exchange (IDX) program of Multiple Listing Service of ROAM MLS, Gulf Coast Association of REALTORS, REALTOR Association of Acadiana and South West Louisiana Association of REALTORS. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Listings provided by brokerages other than Compass are identified with the ROAM MLS, Gulf Coast Association of REALTORS, REALTOR Association of Acadiana and South West Louisiana Association of REALTORS Logos. All Information Is Deemed Reliable But Is Not Guaranteed Accurate. All information should be verified by the recipient and none is guaranteed as accurate by ROAM MLS, Gulf Coast, REALTOR Association of Acadiana and South West Louisiana Association of REALTORS.Listing information Copyright© 2026 MLS of ROAM, Gulf Coast, REALTOR Association of Acadiana and South West Louisiana Multiple Listing Service, Inc. All Rights Reserved.