801 W Idaho Street
Hammond, LA 70403
- 5 beds
- 7 baths
- 4,950 sqft
- $222 per sqft
- 2013 build
More homes
Everyone thank you for exploring this remarkable home in the heart of Hammond. Located just a stone's throw from SLU stadium, this exquisite custom built home boast 6300 sq ft under roof. The outdoor oasis awaits you, an inviting outdoor kitchen with relaxing hot tub and sparkling inground pool provides the ultimate setting. Inside, you'll find 5 spacious bed rms and baths to insure privacy along with bonus rm. The heart of this home is undoubtedly the gourmet kitchen with huge pantry, equipped with top-of-the-line appliances that will delight any culinary enthusiast. Home is foam insulated, including between floors. Crown is fine wood that can be stripped to expose grain. This home represents the pinnacle of luxury living, with superior craftsmanship and meticulous attention to detail. It's a testament to fine living. Don't miss the opportunity to make this your forever home of elegance and comfort.
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Apr 19, 2025
•
MLS# 2414785 —
The Building
-
Year Built:2013
-
Year Built Details:Resale,All Original
-
New Construction:No
-
Construction Materials:Brick
-
Architectural Style:French/Provincial
-
Building Area Total:6300
-
Building Area Source:Measured
-
Roof:Shingle
-
Foundation:Slab
-
Security Features:Security System, Closed Circuit Camera(s)
-
Exterior Features:Outdoor Kitchen
-
Patio Features:Brick, Covered
-
Levels:Three Or More
-
Stories:3
Interior
-
Rooms Total:12
-
Interior Features:Granite Counters, Pantry, Stainless Steel Appliances
-
Living Area:4950
-
Living Area Source:Measured
-
Fireplace:Yes
-
Fireplace Features:Gas Starter, Wood Burning
Financial & Terms
-
Home Warranty:No
Location
-
Directions:Western to Idaho on Left, Property on corner
-
Cross Street:General Pershing
The Property
-
Property Type:Residential
-
Property Subtype:Detached
-
Property Subtype Additional:Detached, Single Family Residence
-
Property Condition:Excellent, Resale
-
Lot Features:City Lot, Rectangular Lot
-
Lot Size Dimensions:136x150
Listing Agent
- Contact info:
- Agent phone:
- (985) 727-7000
- Office phone:
- (985) 727-7000
Taxes
-
Tax Legal Description:SEC23 T6S R7E
Beds
-
Bedrooms Total:5
Baths
-
Total Baths:7
-
Full Baths:3
-
Half Baths:4
The Listing
-
Current Price:$1,100,000
-
Special Listing Conditions:None
Heating & Cooling
-
Heating:Central, Multiple Heating Units
-
Heating:Yes
-
Cooling:Central Air
-
Cooling:Yes
Utilities
-
Sewer:Public Sewer
-
Electric:Generator
-
Water Source:Public
Appliances
-
Appliances:Cooktop, Double Oven, Dishwasher, Disposal, Oven, Range, Refrigerator
Schools
-
Elementary School:Csb
-
Middle School:Csb
-
High School:csb
The Community
-
Subdivision Name:Not A Subdivision
-
Pool Features:In Ground, Salt Water
-
Spa:No
-
Association:No
Parking
-
Garage:Yes
-
Parking Features:Garage
Extra Units
-
Other Structures:Other
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
| Date | Event | Source | Price | % Change |
|---|---|---|---|---|
|
12/15/23
Dec 15, 2023
|
Sold | GSREIN | $1,100,000 | -15.4% |
|
11/22/23
Nov 22, 2023
|
Sold Subject To Contingencies | GSREIN | $1,300,000 | |
|
9/22/23
Sep 22, 2023
|
Listed / Active | GSREIN | $1,300,000 |
