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.
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
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#: 2414785

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