Skip main navigation
Active
  • $590,000

    612 Hesper Ave, Metairie, LA 70005

    4beds
    3,127sqft
    : 
    $3,801/mo
    Get pre-qualified
    Single Family Residence
    Built in 1997
    6,059 Square Feet Lot
    $558,100 Zestimate®
    $189/sqft
    $-- HOA

    What's special

    Private office nookWalk-in floored atticAll brickCurb appealEndless closets throughoutWet barGrand layout
    **FIRST SHOWING AT OPEN HOUSE - TUESDAY, JULY 21ST - 11:00AM-1:00PM** Unleash your design dreams on this all Brick, sprawling 4-bedroom, plus office and 4-full bath Metairie Estates Gem! Offering over 3100 sq. ft of living area and over 3,800 total sq. ft. of incredible potential and perfectly positioned in a highly coveted X flood zone. Situated on a lush corner lot at a quiet dead-end street, this incredibly livable, very well-maintained "diamond in the rough" offers the ultimate floorplan and structural bones, just waiting for your cosmetic updates to bring it into today’s luxury standards. Location is everything and this demand neighborhood offers effortless access to downtown and anywhere in the city. Inside, the Grand layout features a sprawling den with a soaring cove-lit tray ceiling, built-in bookcases, a fireplace, a wet bar, and a private office nook, plus a formal dining room and a chef’s kitchen equipped with a center island, gas stove, double ovens and a wine fridge. The bedroom setup is an absolute rarity where a spacious primary suite with two separate closets, dual vanities and a relaxing jetted soaking tub anchors the downstairs alongside a large second bedroom that can easily be converted into a private ensuite. Upstairs, you will find two additional oversized bedrooms, both boasting private attached baths. Storage is unmatched with endless closets throughout and a walk-in floored attic. Another showstopper is the unique double garage featuring roll-up doors on both the driveway and backyard sides, instantly transforming into a covered indoor/outdoor entertaining pavilion that flows into the fenced yard with a utility sink and counter space for easy hosting. Complete with a roof that is approximately 5 years old, this is the rare opportunity to secure space, premium flood zoning, curb appeal, and an unbeatable location—bring your design vision and turn this masterpiece into your own! *Some photos are virtually staged for illustrative and design inspiration purposes only. All measurements and dimensions are approximate and should be independently verified*
    7 days
    |
    698
    |
    34
    |

    Likely to sell faster than

    Zillow last checked:

    Listing updated:

    Listed by:

    Melissa Adamcewicz 504-881-4122,

    KELLER WILLIAMS REALTY 455-0100 504-455-0100,

    Stan Adamcewicz 504-881-4172,

    KELLER WILLIAMS REALTY 455-0100

    Source: GSREIN,MLS#: 2568365MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 4
      • Full bathrooms: 4
      Primary bedroom
      • Description: Flooring: Carpet
      • Level: First
      • Dimensions: 15.5x14.2
      Bedroom
      • Description: Flooring: Carpet
      • Level: First
      • Dimensions: 16.7x12.7
      Bedroom
      • Description: Flooring: Carpet
      • Level: Second
      • Dimensions: 17.3x15.5
      Bedroom
      • Description: Flooring: Carpet
      • Level: Second
      • Dimensions: 16.11x15.5
      Breakfast room nook
      • Description: Flooring: Tile
      • Level: First
      • Dimensions: 12.9x9.9
      Dining room
      • Description: Flooring: Wood
      • Level: First
      • Dimensions: 16.3x15.9
      Kitchen
      • Description: Flooring: Tile
      • Level: First
      • Dimensions: 16.7x9.9
      Living room
      • Description: Flooring: Wood
      • Level: First
      • Dimensions: 27.11x19.8
      Office
      • Description: Flooring: Wood
      • Level: First
      • Dimensions: 5.2x5.9
      Heating
      • Central, Multiple Heating Units
      Cooling
      • Central Air, 2 Units
      Appliances
      • Included: Cooktop, Double Oven, Dishwasher, Disposal, Microwave, Refrigerator, Wine Cooler
      • Laundry: Washer Hookup, Dryer Hookup
      Features
      • Attic, Tray Ceiling(s), Ceiling Fan(s), Jetted Tub, Cable TV
      • Has fireplace: Yes
      • Fireplace features: Gas, Wood Burning
      Interior area
      • Total structure area: 3,836
      • Total interior livable area: 3,127 sqft
      Video & virtual tour

      Property

      Parking
      • Total spaces: 2
      • Parking features: Attached, Garage, Two Spaces, Garage Door Opener
      • Has attached garage: Yes
      Features
      • Levels: Two
      • Stories: 2
      • Patio & porch: Concrete
      • Has spa: Yes
      Lot
      • Size: 6,059 Square Feet
      • Dimensions: 60 x 101
      • Features: Corner Lot, City Lot, Rectangular Lot
      Details
      • Additional structures: Shed(s)
      • Parcel number: 0820045097
      • Special conditions: None

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Traditional
      • Property subtype: Single Family Residence
      Materials
      • Brick
      • Foundation: Slab
      • Roof: Shingle
      Condition
      • Very Good Condition
      • Year built: 1997

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public
      Green energy
      • Energy efficient items: Windows

      Community & HOA

      Community
      • Security: Security System
      HOA
      • Has HOA: No
      Location
      • Region: Metairie

      Financial & listing details

      • Price per square foot: $189/sqft
      • Tax assessed value: $442,000
      • Annual tax amount: $4,625
      • Date on market: 7/19/2026

        Estimated market value

        $558,100

        $530,000 - $586,000

        $2,795/mo

        Price history

        DateEventPrice
        7/19/2026Listed for sale$590,000-10.5%$189/sqft
        Source: GSREIN #2568365 Report a problem
        4/2/2026Listing removed$659,000$211/sqft
        Source: GSREIN #2537094 Report a problem
        3/19/2026Price change$659,000-1.6%$211/sqft
        Source: GSREIN #2537094 Report a problem
        2/9/2026Price change$670,000-0.7%$214/sqft
        Source: GSREIN #2537094 Report a problem
        1/10/2026Listed for sale$675,000$216/sqft
        Source: GSREIN #2537094 Report a problem
        1/7/2026Listing removed$675,000$216/sqft
        Source: GSREIN #2517001 Report a problem
        12/29/2025Price change$675,000-3.4%$216/sqft
        Source: GSREIN #2517001 Report a problem
        10/17/2025Price change$699,000-4.8%$224/sqft
        Source: GSREIN #2517001 Report a problem
        8/19/2025Listed for sale$734,500$235/sqft
        Source: GSREIN #2517001 Report a problem
        8/1/2025Listing removed$734,500$235/sqft
        Source: GSREIN #2511010 Report a problem
        7/9/2025Listed for sale$734,500-1.7%$235/sqft
        Source: GSREIN #2511010 Report a problem
        7/9/2025Listing removed$747,000$239/sqft
        Source: GSREIN #2463471 Report a problem
        12/20/2024Price change$747,000-3.6%$239/sqft
        Source: GSREIN #2463471 Report a problem
        12/2/2024Price change$775,000-2.5%$248/sqft
        Source: GSREIN #2463471 Report a problem
        9/4/2024Listed for sale$795,000$254/sqft
        Source: GSREIN #2463471 Report a problem
        5/25/2004Sold--
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2024$4,625 -4.2%$44,200
        2023$4,828 +2.7%$44,200
        2022$4,702 +7.7%$44,200
        2021$4,367 +0.7%$44,200
        2020$4,336 -2.7%$44,200
        2019$4,457 +7.1%$44,200
        2018$4,162 $44,200
        2017$4,162 $44,200
        2016$4,162 +0.8%$44,200
        2015$4,128 $44,200
        2014$4,128 $44,200
        2013-- $44,200
        2012-- $44,200
        2011-- $44,200
        2010-- $44,200
        2009-- $44,200
        2008-- $44,200 +4%
        2007-- $42,500
        2006-- --
        2005-- --
        2004-- --
        2003-- --
        2002-- --
        2001-- --
        2000-- --
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 70005

        Getting around

        71 / 100
        Very Walkable
        53 / 100
        Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes