Skip main navigation
Closed
  • Price Unknown

    801 W Idaho St, Hammond, LA 70401

    5beds
    4,950sqft
    Single Family Residence
    Built in 2013
    0.47 Acres Lot
    $1,109,000 Zestimate®
    $--/sqft
    $3,525 Estimated rent

    What's special

    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.

    Zillow last checked: 7 hours ago

    Listing updated: December 18, 2023 at 02:04pm

    Listed by:

    Yvonne Hulsey 985-969-5058,

    Keller Williams Realty Services

    Bought with:

    Jason Lipscomb

    Downtown Realty

    Source: GSREIN,MLS#: 2414785MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 7
    • Full bathrooms: 3
    • 1/2 bathrooms: 4
    Primary bedroom
    • Description: Flooring: Wood
    • Level: Lower
    • Dimensions: 22.8000 x 16.6000
    Bedroom
    • Description: Flooring: Wood
    • Level: Upper
    • Dimensions: 12.6000 x 14.0000
    Bedroom
    • Description: Flooring: Wood
    • Level: Upper
    • Dimensions: 12.1100 x 14.1000
    Bedroom
    • Description: Flooring: Wood
    • Level: Lower
    • Dimensions: 12.9000 x 13.5000
    Bedroom
    • Description: Flooring: Wood
    • Level: Upper
    • Dimensions: 14.1000 x 13.7000
    Den
    • Description: Flooring: Wood
    • Level: Lower
    • Dimensions: 15.0000 x 16.0000
    Dining room
    • Description: Flooring: Brick
    • Level: Lower
    • Dimensions: 14.6000 x 15.0000
    Game room
    • Level: Upper
    • Dimensions: 19.6000 x 15.8000
    Kitchen
    • Description: Flooring: Brick
    • Level: Lower
    • Dimensions: 23.0000 x 18.0000
    Laundry
    • Description: Flooring: Tile
    • Level: Lower
    • Dimensions: 10.6000 x 10.0000
    Living room
    • Description: Flooring: Brick
    • Level: Lower
    • Dimensions: 22.0000 x 18.0000
    Study
    • Description: Flooring: Wood
    • Level: Lower
    • Dimensions: 14.0000 x 11.0000
    Heating
    • Central, Multiple Heating Units
    Cooling
    • Central Air, 3+ Units
    Appliances
    • Included: Cooktop, Double Oven, Dishwasher, Disposal, Oven, Range, Refrigerator
    Features
    • Granite Counters, Pantry, Stainless Steel Appliances
    • Has fireplace: Yes
    • Fireplace features: Gas Starter, Wood Burning
    Interior area
    • Total structure area: 6,300
    • Total interior livable area: 4,950 sqft

    Property

    Parking
    • Parking features: Garage, Three or more Spaces
    • Has garage: Yes
    Features
    • Levels: Three Or More
    • Stories: 3
    • Patio & porch: Brick, Covered
    • Exterior features: Outdoor Kitchen
    • Pool features: In Ground, Salt Water
    Lot
    • Size: 0.47 Acres
    • Dimensions: 136 x 150
    • Features: City Lot, Rectangular Lot
    Details
    • Additional structures: Other
    • Parcel number: 6006116
    • Special conditions: None

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: French/Provincial
    • Property subtype: Single Family Residence
    Materials
    • Brick
    • Foundation: Slab
    • Roof: Shingle
    Condition
    • Excellent,Resale
    • New construction: No
    • Year built: 2013

    Utilities & green energy

    • Electric: Generator
    • Sewer: Public Sewer
    • Water: Public

    Community & neighborhood

    Security
    • Security features: Security System, Closed Circuit Camera(s)
    Location
    • Region: Hammond
    • Subdivision: Not A Subdivision
    Services availability
    Sell for more on Zillow

    Get a free Zillow Showcase℠ listing and you could sell for .

    $1,109,000
    2% more+ $22,180
    With Zillow Showcase(estimated)
    $1,131,180