Versatile property with so much to offer!! 3 bedrooms, 2.5 bathrooms + a large formal dining room that is currently being used as an additional bedroom. This property would make an amazing group home or assisted living facility. It is close to I-12, downtown Hammond, & Southeastern. There is a bonus room upstairs that could be used as a "mancave" or rec room. Enjoy the beautiful weather without the bugs on a spacious screened in porch. This house was made for entertaining. A large bar (already plumbed!) appoints the main living area. This spacious 1.2 acre parcel has a fenced yard, covered carport, and ample space for parking. The AIR CONDITIONED warehouse in the back provides more storage than you can imagine. Plus, there is a barn in the very back of the property. MX-N zoning allows for a multitude of uses. Residential or commercial development is welcome. There has been a long term renter occupying the house for the last 5 years. Flood zone X (high and dry!). Call me today to schedule your private showing.
5 parcels are being sold as a 9.89 acre tract. 3 parcels are wooded and 2 have single family and small misc. structures. Properties have dual zoning. The frontage along Hewitt Rd. is zoned Neighborhood Mixed-Use whereas the remaining and majority of the properties are zoned Commercial Mixed-Use. Both zoning districts allow for a mixture of uses including light commercial and both single and multi-family residential uses.
AcadianaMLS #NO2237193
Nov 6, 2019
Listed
$899,000
$366/sq ft
GSREIN #953535
Oct 10, 2016
Listing Removed
—
May 13, 2015
Listed
$996,000
$406/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$2,108 (+64.1%)
$1,699 + $23,639
$25,338
2024
$1,284 (−9.6%)
$1,836 + $13,680
$15,516
2023
$1,420
$2,500 + $14,490
$16,990
2022
$1,420 (−20.1%)
$2,500 + $14,490
$16,990
2020
$1,777 (+0.3%)
$2,500 + $14,490
$16,990
2019
$1,772 (−0.3%)
$2,500 + $14,490
$16,990
2018
$1,777
$2,500 + $14,490
$16,990
2017
$1,777
$2,500 + $14,490
$16,990
2016
$1,777 (+26.0%)
$2,500 + $14,490
$16,990
2014
$1,410 (+22.4%)
$2,500 + $15,189
$17,689
2013
$1,152
$2,500 + $15,189
$17,689
Tax history for 515 Hewitt Rd
Year
Property tax
Land + Additions
Assessment*
2025
$2,108 (+64.1%)
$1,699 + $23,639
$25,338
2024
$1,284 (−9.6%)
$1,836 + $13,680
$15,516
2023
$1,420
$2,500 + $14,490
$16,990
2022
$1,420 (−20.1%)
$2,500 + $14,490
$16,990
2020
$1,777 (+0.3%)
$2,500 + $14,490
$16,990
2019
$1,772 (−0.3%)
$2,500 + $14,490
$16,990
2018
$1,777
$2,500 + $14,490
$16,990
2017
$1,777
$2,500 + $14,490
$16,990
2016
$1,777 (+26.0%)
$2,500 + $14,490
$16,990
2014
$1,410 (+22.4%)
$2,500 + $15,189
$17,689
2013
$1,152
$2,500 + $15,189
$17,689
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Permits
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
1.21 Acres
Year renovated
—
Sq. Ft.
1,500
Year built
1995
Style
Single Family Residential
County
Tangipahoa Parish
APN
1721801
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 24, 2026.
MX-C
Mixed Use Commercial District
MX-C is intended to provide for a variety of residential, retail, service, and commercial uses. While MX-C accommodates commercial uses, the inclusion of residential and employment uses are strongly encouraged in order to promote live-work and mixed use opportunities.
Permitted uses
Include but are not limited to:
Bank
Day care facility
Laundromat
General retail
Restaurant
Housing-Group
Housing-Single unit
Housing-Multiple units
Industrial
Office
Aug 27, 2020 • Final
Imported project
Obtain a permit for an electrical service connection.
Electrical
Electric meter
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Property details
Parking
Parking
Features: Covered
Interior
Bathroom Information
# of Full Bathrooms: 2
# of Half Bathrooms: 1
Room Information
# of Rooms (Total): 5
Laundry Information
Features: Washer Hookup, Dryer Hookup
Fireplace Information
Has Fireplace
Features: Wood Burning
Equipment
Appliances: Double Oven, Dishwasher
Interior Features
Accessibility Features: Accessibility Features
Other Features: Attic, Ceiling Fan(s), Granite Counters, Pantry
Exterior
Building Information
Stories: 1
Roof Details: Shingle
Construction Details: Brick
Exterior Features
Exterior Features: Enclosed Porch, Fence
Patio And Porch Features: Concrete, Covered, Porch, Screened
Other Structures: Barn(s), Workshop
Lot Information
Lot Size Area: 1.211
Lot Size Acres: 1.211
Lot Size Dimensions: 168x315
Lot Features: City Lot, Oversized Lot
Property Information
Foundation Details: Slab
Very Good Condition
Utilities
Utility Information
Sewer: Public Sewer
Water Source: Public
Heating & Cooling
Has Cooling
Has Heating
Public facts
Beds: —
Baths: —
Sq. Ft.: 1,500
Stories: —
Lot Size: 1.21 acres
Style: Single Family Residential
Year Built: 1995
Year Renovated: —
County: Tangipahoa Parish
APN: 1721801
Home facts updated by county records on Aug 24, 2026
Other
Listing Information
Is Human Modified
Around this home
Schools
Greenville Park Leadership Academy
Public 4-8 • Assigned • 0.7mi
4/10
Hammond High Magnet School
Public 9-12 • Assigned • 5.4mi
4/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
8/10 Heat Factor
7 days above 109° expected this year, 21 days in 30 years
9/10 Wind Factor
99% chance of strong winds in next 30 years
2/10 Air Factor
0 unhealthy days expected this year, 1 days in 30 years
Provided by First Street
Historical weather
Hammond, LA • 70403
Average low and high temperatures (°F)
61
40
71
48
77
54
81
61
83
67
90
73
92
74
92
74
89
70
83
60
75
54
66
45
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.2 hours in
June and 5 hours in December, which is comparable to the
U.S. average for solar exposure.
9.2 hrs
5 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$280,000 – $339,000
Reach more buyers when you sell with Redfin. Save up to $2,945 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.