#2494190, Carmen Waring, Listing Office: LATTER & BLUM (LATT01)
Property details
About 1497 Frontage Rd
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.
Highlights
Home typeOther
StatusActive
Size693,454 sqft
Lot size15.91 Acres
MLS #2463332
Summary
- MLS Number: 2463332
- MLS Name: NOMAR
- Office Name: Berkshire Hathaway HomeServices Preferred, REALTOR
- Office Phone: (985) 951-2324
- Office Email: BHHSPreferredrealtors@gmail.com
- Listing Agent: Vincent Liuzza
- Agent Phone: (504) 237-9634
Disclaimer: Copyright © 2025, New Orleans Metropolitan Association of REALTORS©, Inc. All rights reserved. Information deemed reliable, but not verified or guaranteed. Users are responsible for checking the accuracy, completeness, currency, and status of all information. The sharing of MLS database, or any portion thereof, with any unauthorized third party is strictly prohibited. Information contained on this site is believed to be reliable; yet, users of this web site are responsible for checking the accuracy, completeness, currency, or suitability of all information. Neither the New Orleans Metropolitan Association of REALTORS©, Inc. nor the Gulf South Real Estate Information Network, Inc. makes any representation, guarantees, or warranties as to the accuracy, completeness, currency, or suitability of the information provided. They specifically disclaim any and all liability for all claims or damages that may result from providing information to be used on the web site, or the information which it contains, including any web sites maintained by third parties, which may be linked to this web site.
The information being provided is for the consumer's personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties which consumers may be interested in purchasing.
By using this site, you signify your agreement with and acceptance of these terms and conditions. If you do not accept this policy, please do not use this site in any way. Your continued use of this site, and/or its affiliates' sites, following the posting of changes to these terms will mean you accept those changes, regardless of whether you are provided with additional notice of such changes.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 4/19/2025, 5:20:49 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Get an agent. Get a mortgage. Save big.¹
$2,000,000
1497 Frontage Rd
Sell your home with Rocket and save even more!
Seller rebate
0.5% sale price²
Price information
Property sales
We're sorry, we currently don't have property sales data for this listing.
Tax history
| Year | Assessment | Property Tax |
|---|---|---|
| 2023 | $455 | $76 |
| 2022 | $455 | $77 |
| 2021 | $455 | $77 |
History based on county public records data.
Nearby schools
6
Bayou Woods Elementary School
Public District PK-3
2.1 mi
•35614 Liberty Dr
6
Carolyn Park Middle School
Public District 4-6
2.2 mi
•35708 Liberty Dr
4
Florida Avenue Elementary School
Public District PK-6
3.3 mi
•342 Florida Ave
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $55,208. The majority of Slidell, LA residents have income between $35k-100k annually. The most common type of family is single, no kids. Most residents in this area have high school diploma education.
How much money do the neighbors make?
36%
<35k
43%
35k-100k
16%
100k-200k
5%
200k+
What level of education do the neighbors have?
High School Diploma
Post Secondary Degree
Masters Degree
What types of families live nearby?
43%
Single, No Kids
10%
Single, with Kids
30%
Married, No Kids
17%
Married, with Kids
Are the neighbors home owners or renters?
Home Owners
Renters
How old are people in this area?
13%
<11 yrs old
8%
12-17 yrs old
20%
18-34 yrs old
44%
35-64 yrs old
15%
65+ yrs old
What do the neighbors do for fun?
Hunting
NASCAR
Pro Wrestling
Where do the neighbors shop?
Wal-Mart
Academy Sports & Outdoors
Bass Pro Shops
Where do the neighbors go to eat?
Hardee's
Jimmy Johns
Applebees
What do the neighbors drive?
Ram
Chevrolet
GMC
What do the neighbors listen to?
Classic Country
New Country- Country
All data provided by Home Junction and Claritas
Similar homes for sale
Frequently asked questions
Living in Slidell, LA
About 1497 Frontage Rd
This home is located at 1497 Frontage Rd in Slidell, LA and zip code 70460. This 693,454 square foot home sits on a 15.91 acre lot. Features: 0 bedroom, 0 bathroom. It has been listed on Rocket Homes since September 30, 2024 and is currently priced at $2,000,000.
In March 2025, from all listings sold in Slidell, LA there were more than 5 sold above asking price, over 38 sold below and more than 17 were sold right at the asked price. The inventory of homes for sale in Slidell, LA between February and March 2025 increased by 9.1%. The median list price of listings available in March 2025 was $244,900, while the average time on the real estate market was 92 days.
From Rocket Homes Real Estate and based on county public records data.