Last List Price
3 beds1,459 sqft$86/sqft
17287 Frederick Rd, Hammond, LA 70401

Description

3 Bedroom 2 Bath double wide mobile home located at the end of a dead end street. All bedrooms have walk in closets. New heat pump with 5 year warranty, new skirting, new stairs front and back. Primary bedroom and bath have 36" doorways. Rear yard access. 2 miles to downtown hammond.3 Bedroom 2 Bath double wide mobile home located at the end of a dead end street. All bedrooms have walk in closets. New heat pump with 5 year warranty, new skirting, new stairs front and back. Primary bedroom and bath have 36" doorways. Rear yard access. 2 miles to downtown hammond.
LISTING CLOSED: 12/30/2022 12:00 AM

  1. Listed by Geoffrey Druin • United Real Estate Partners LLC
    P: (985) 867-6596 C: (985) 867-6596 gdruin03@gmail.com

Property Details for 17287 Frederick Road

Status
MLS #
2371552
Days on Market
21
Taxes
-
HOA Fees
-
Condo/Co-op Fees
-
Property Type
Mobile/Manufactured
MLS Type
Residential / Mobile/Modular/Manufact.
Year Built
-
Lot Size
0.50 AC / 21,780 SF
Architectural Style
Mobile Home
Subdivision Name
Bellewood Estates

Recent comparable sales

Median sold price

$86,500

Avg days on market

33

Sale-to-list ratio

85.4%

Hammond, LA

9 comparable properties found

$155,000 | 17448 Cardinal Lane, Hammond, LA 70401
1/10
1

$155,000

Sold 10/30/24

3
Bedrooms
1,475
Square Feet
0.51
Acres
$80,000 | 114 Ruth Drive, Hammond, LA 70401
1/16
2

$80,000

Sold 11/25/24

3
Bedrooms
1,284
Square Feet
0.16
Acres
$110,000 | 410 East Michigan Street, Hammond, LA 70401
1/17
3

$110,000

Sold 06/26/26

3
Bedrooms
1,308
Square Feet
0.18
Acres
$100,000 | 203 South Elm Street, Hammond, LA 70403
1/27
4

$100,000

Sold 09/30/25

3
Bedrooms
1,502
Square Feet
0.17
Acres
$185,000 | 44002 Sweet William Drive, Hammond, LA 70403
1/13
5

$185,000

Sold 07/24/25

3
Bedrooms
1,296
Square Feet
0.27
Acres
$133,120 | 16183 Charleton Drive, Hammond, LA 70401
1/18
6

$133,120

Sold 03/31/26

3
Bedrooms
1,253
Square Feet
0.2
Acres
$95,000 | 17066 East Coleman Avenue, Hammond, LA 70403
1/16
7

$95,000

Sold 06/25/25

3
Bedrooms
1,740
Square Feet
0.41
Acres
$100,000 | 321 Monistere Lane, Hammond, LA 70403
1/6
8

$100,000

Sold 10/11/24

3
Bedrooms
1,263
Square Feet
1.25
Acres
$129,900 | 100 Marley Drive, Hammond, LA 70401
1/21
9

$129,900

Sold 08/20/25

3
Bedrooms
1,477
Square Feet
0.14
Acres

Location

Listing Courtesy of United Real Estate Partners LLC

Sold By eXp Realty, LLC

Add your commute

Building Information for 17287 Frederick Road

Stories1Residences-Year Built-Lot Size0.50 AC / 21,780 SF

Payment Calculator

$671 per month

30 year fixed, 6.55% Interest

Principal and Interest

$635

Property Taxes

$36

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 17287 Frederick Road

Summary
Location and General Information
  • Directions: Bounding Streets: Morris Rd
  • Latitude: 30.53
  • Longitude: -90.44
  • MLS Area Minor: TANGIPAHOA
  • In City Limits: No
Parking
  • Parking Features: Driveway
Taxes and HOA
  • Association: No
  • Tax Legal Description: 0.50A BEING TRACT-2A OF WERNER LOT LINE REVISION IN SEC 18 T6SR8E B1494 P620 B1528 P209 B1590 P194 MAP 1590/194
Property
Lot Information
  • Building Area Total: 1459.0
  • Living Area: 1459.0
  • Living Area Source: Measured
  • Lot Features: Rear Yard Vehicle Access, Rectangular Lot
  • Lot Size Acres: 0.5
  • Lot Size Dimensions: 90.6x239.4
Property and Assessments
  • Home Warranty: No
  • Property Condition: Age Unknown, Existing
  • Property Sub Type: Mobile/Modular/Manufact.
  • Property Type: Residential
  • Apx Age: 23
Green Features
  • Green Energy Efficient: Appliances, Water Heater, Windows
Utilities
  • Sewer: Septic Tank
  • Water Source: Public
  • GS Utilities Gas: None
  • EL Utilities Elec: Entergy
Interior and Exterior Features
Exterior Features
  • Construction Materials: Vinyl Siding
  • Foundation Details: Other
  • Roof: Asphalt
  • Stories: 1
Interior Features
  • Appliances: Dishwasher, Range, Refrigerator
  • Bathrooms Full: 2
  • Bathrooms Partial: 0
  • Bedrooms Total: 3
  • Cooling: Heat Pump
  • Heating: Heat Pump
  • Interior Features: Ceiling Fan(s), Vaulted Ceiling(s), Handicap Interior Prov
  • Laundry Features: Dryer, Washer, Washer/Dryer Hookups
  • Bathrooms Display: 2/0

Property History for 17287 Frederick Road

DateEvent & SourcePriceAppreciation
Dec 30, 2022

Sold (Public Record)

Public Record #1505308803

Dec 30, 2022

Sold

ROAM MLS #NO2371552

Dec 3, 2022

Contract Signed

ROAM MLS #NO2371552

DateEvent & SourcePrice
12/30/2022

Sold (Public Record)

Public Record #1505308803

12/30/2022

Sold

ROAM MLS #NO2371552

12/03/2022

Contract Signed

ROAM MLS #NO2371552

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

Public Records for 17287 Frederick Road

Taxable ValueLand$351Additions$3,440Total$3,791
Tax Record2025$435 ($36 / month)
Home Facts
Total Finished SqFt1,404 SqFtAbove Grade Finished SqFt1,404 SqFtLot Size21,780 SqFtStyleMobile / Manufactured HomeYear Built2009CountyTANGIPAHOAAPN6543689

Schools near 17287 Frederick Road

This home is within Tangipahoa Parish School District.
Rating
School
Type
Grades
Distance
Public - PK to 8
Public - 9 to 12
Public - 5 to 12
Public - PK to 8
Rating
School
Distance
Hammond Eastside Elementary Magnet School
PublicPK to 8

Hammond High Magnet School
Public9 to 12

Tangipahoa Alternative Programs
Public5 to 12

Southeastern La University Lab School
PublicPK to 8

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

New listings in 70401

$219,000 | 45448 Puma Drive, Hammond, LA 70401
1/17

$219,000

3
Bedrooms
1,914
Square Feet
0.37
Acres
$199,000 | 112 North Scanlan Street, Hammond, LA 70401
1/29

$199,000

2
Bedrooms
1,210
Square Feet
0.32
Acres
$224,000 | 18245 Fox Hollow Loop, Hammond, LA 70401
1/10
Coming Soon

$224,000

3
Bedrooms
1,573
Square Feet
0.21
Acres
$160,000 | 200 North Carter Street, Hammond, LA 70401
1/9

$160,000

4
Bedrooms
1,421
Square Feet
0.16
Acres
$260,000 | 17016 East Domiano Lane, Hammond, LA 70401
1/50
Open: 8/22 11:00AM - 01:00PM

$260,000

3
Bedrooms
1,680
Square Feet
0.86
Acres
$235,000 | 11598 Sunset Acres, Hammond, LA 70401
1/19

$235,000

3
Bedrooms
1,398
Square Feet
0.56
Acres
$229,900 | 46471 Milton Road, Hammond, LA 70401
1/18

$229,900

3
Bedrooms
1,225
Square Feet
3.19
Acres
$219,900 | 11488 Rabbit Run, Hammond, LA 70401
1/17

$219,900

3
Bedrooms
1,366
Square Feet
0.28
Acres
$110,000 | 14586 Honeysuckle Street, Unit 139, Hammond, LA 70401
1/11

$110,000

2
Bedrooms
1,182
Square Feet
0.07
Acres

Nearby home values

AddressSold priceBedsBathsSqftLot (Sqft)
This home: 17287 Frederick Road, Hammond, LA 70401
$125,000
3
1,459
21,780
1,264
44,867
1,536
174,240
43,560
$60,000
1,374
43,560
3,185
261,360

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim 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 seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of United Real Estate Partners LLC

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.