Sign In

Close

x
Showing 1 of 0
X
Save
1497 FRONTAGE Road Slidell LA 70460US2463332
1497 FRONTAGE Road SlidellLA70460
2000000.0000 1/1/1900 12:00:00 AM
Realty Executives SELA
3748 North Causeway Blvd.MetairieLA70002
504-883-5252
1 /

Courtesy of: Vincent Liuzza, Berkshire Hathaway HomeServices Preferred, REALTOR, vliuzza3@yahoo.com

1497 FRONTAGE Road
Slidell LA 70460 US

Save
1 /

Courtesy of: Vincent Liuzza, Berkshire Hathaway HomeServices Preferred, REALTOR, vliuzza3@yahoo.com

Realty Executives SELA
3748 North Causeway Blvd.
Metairie, LA, US 70002
504-883-5252

Get more info about this property

1497 FRONTAGE Road
Slidell LA 70460 US

$2,000,000

Active Listing ID 2463332
lot icon
Lot: 15.91 Acres
home icon
Other

$2,000,000

Active Listing ID 2463332
Save
3d icon
Maps

1497 FRONTAGE Road 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.

Collapse all

Property Features

  • Facts
  • Lot Size: 15.91 Acres
  • Property Type: Land
  • Property Sub-type: Other

Property

  • propertytype: Land
  • propertysubtype: Other
  • listprice: 2000000
  • unparsedaddress: 1497 FRONTAGE Road
  • postalcity: Slidell
  • stateorprovince: LA
  • country: US
  • postalcode: 70460
  • bathroomsfull: 0
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 15.91
  • lotsizeunits: Acres
  • lotsizearea: 15.91
  • livingarea: 693454
  • livingareaunits: Square Feet
  • listagentfullname: Vincent Liuzza
  • listagentemail: vliuzza3@yahoo.com
  • listagentkey: 3yd-NOMARLA-liuzvinc
  • listagentmlsid: liuzvinc
  • listagentpreferredphone: 5042379634
  • listagentofficephone: 9859512324
  • listofficekey: 3yd-NOMARLA-STCO02
  • listofficemlsid: STCO02
  • disclaimer: Copyright © 2024 Gulf South Real Estate Information Network. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: NOMARLA
  • listingcontractdate: 2024-08-08
  • listagenturl: https://www.bhhspreferredrealtorsnola.com/
  • countyorparish: St. Tammany
  • fireplaceyn: False
  • transactiontype: ForSale
  • storiestotal: 0
  • parkingtotal: 0
  • waterfrontyn: False
  • franchiseaffiliation: Berkshire Hathaway HomeServices
  • architecturalstyle: Other
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"STOPHCO 2, LLC", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"vliuzza3@yahoo.com", "ListBrokerageCity":"New Orleans", "ListBrokerageCountry":"US", "ListBrokerageEmail":"hyatthood@gmail.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/NOMARLA/ea7a319123cb11e89cbe0242ac110006/20220607155200490.png", "ListBrokerageName":"STOPHCO 2, LLC", "ListBrokeragePhone":"(504) 799-1702", "ListBrokeragePostalCode":"70115", "ListBrokerageStateOrProvince":"LA", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"4018 Magazine Street", "ListBrokerageWebsiteUrl":"https://www.bhhspreferredrealtorsnola.com/", "ListOfficeAddress1":"1121 North Causeway Blvd", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":null, "ListOfficeCity":"Mandeville", "ListOfficeCountry":"US", "ListOfficeEmail":"hyatthood@gmail.com", "ListOfficePostalCode":"70471", "ListOfficeStateOrProvince":"LA", "ListPriceCurrencyType":"USD", "ListingTitle":"Vacant Land - Slidell, LA", "ListingURL":"https://listings.listhub.net/pages/NOMARLA/2463332/?channel=rexren", "MLSModificationTimestamp":"2024-08-14T14:59:50Z", "Neighborhoods":[], "PostalCode":null, "RoomCount":null, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 11/8/2024 8:29:37 AM GMT
Source Updated Date: 12/26/2024 6:52:58 AM GMT

Courtesy of: Vincent Liuzza, Berkshire Hathaway HomeServices Preferred, REALTOR, vliuzza3@yahoo.com

Copyright © 2024 Gulf South Real Estate Information Network. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Contact