Skip main navigation
Under contract
  • $1,749,999

    454 Hasbrouck Blvd, Oradell, NJ 07649

    6beds
    --sqft
    : 
    Loading
    Get pre-qualified
    Single Family Residence
    Built in ----
    -- sqft lot
    $-- Zestimate®
    $--/sqft
    $-- HOA

    What's special

    Timeless eleganceLuxury finishesHeated saltwater gunite poolCustom lightingImpeccable craftsmanship throughoutMother-of-pearl sinkResort-style backyard
    Far from a drive-by, this exceptional Center Hall Colonial was masterfully renovated & custom designed by renowned designer Heidi Piron w/ no expense spared. Featuring 6 BRs & 4.5 baths, this home offers timeless elegance, luxury finishes & impeccable craftsmanship throughout. Entry foyer opens to expansive living & dining spaces w/ custom built-ins, wine fridge, ice maker, DW, LED lighting, glass backsplash & mother-of-pearl sink. Designer EIK features a one-piece marble island, farmhouse sink & premium Wolf/Sub-Zero appls. Main level includes private en-suite BR w/ sitting area, WICs & backyard access. Lux primary suite offers gas FP, oversized WIC & spa-like bath. Finished basement adds flexible living space. Resort-style backyard features lush landscaping, custom lighting & heated saltwater gunite pool. Prime location near top schools, NYC transit & major highways. Fire Places & Chimney As Is - No known issues
    38 days
    |
    317
    |
    10
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Kelly Weber 201-281-5594,

    Keller Williams Valley Realty,

    Roger Tashjian 201-925-9229,

    Keller Williams Valley Realty

    Source: NJMLS,MLS#: 26019405MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 6
      • Bathrooms: 5
      • Full bathrooms: 4
      • 1/2 bathrooms: 1
      Heating
      • Baseboard, Natural Gas, Forced Air, Hot Water, Zoned
      Cooling
      • Central Air
      Features
      • Flooring: Hardwood, Carpet
      • Basement: Full,Partially Finished
      • Number of fireplaces: 2
      • Fireplace features: 2 Fireplaces, Gas, Self-start
      Video & virtual tour

      Property

      Parking
      • Total spaces: 2
      • Parking features: Garage
      • Garage spaces: 2
      • Details: Attached
      Features
      • Patio & porch: Deck / Patio
      • Pool features: Gunite, In Ground
      • Has view: Yes
      • View description: South
      • Waterfront features: None
      Lot
      • Features: Regular
      Details
      • Parcel number: 4401308000000019

      Construction

      Type & style
      • Home type: SingleFamily
      • Property subtype: Single Family Residence
      Materials
      • Stone, Vinyl Siding

      Community & HOA

      Community
      • Features: Close/Parks, Close/School, Close/Shopg, Close/Trans, Close/Wrshp, Extended Family
      Location
      • Region: Oradell

      Financial & listing details

      • Tax assessed value: $1,216,300
      • Annual tax amount: $27,915
      • Date on market: 5/28/2026
      • Listing agreement: Exclusive Right To Sell
      • Ownership: Private

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        6/4/2026Pending sale$1,749,999
        Source: NJMLS #26019405 Report a problem
        5/28/2026Listed for sale$1,749,999+821.1%
        Source: NJMLS #26019405 Report a problem
        6/24/2008Sold$190,000-77.5%
        Source: Public Record Report a problem
        2/25/2005Sold$845,000+52%
        Source: Public Record Report a problem
        6/14/2004Sold$556,000
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$33,108 +16.9%$1,216,300 +16.9%
        2024$28,331 +2.5%$1,040,800 +0.5%
        2023$27,640 +4.6%$1,036,000 +4.8%
        2022$26,422 +0.6%$988,100 +5.2%
        2021$26,263 +2.8%$939,300 +0.7%
        2020$25,536 +20.7%$932,900 +20.3%
        2019$21,164 $775,600 +0.6%
        2018$21,164 +2.4%$771,000 +1.8%
        2017$20,662 +2.2%$757,500 +9.1%
        2016$20,211 +4.6%$694,300
        2015$19,329 +2.2%$694,300
        2014$18,906 +8.5%$694,300 -9%
        2013$17,422 $762,800
        2012$17,422 +8.5%$762,800 +6.4%
        2011$16,051 +4.5%$717,200
        2010$15,362 +11.6%$717,200
        2009$13,771 $717,200 +125.7%
        2007-- $317,700 +2.8%
        2006-- $309,100 +13.9%
        2005-- $271,300
        2004-- $271,300
        2003-- $271,300
        2002-- $271,300
        2001-- $271,300

        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: 07649

        Getting around

        55 / 100
        Somewhat Walkable
        41 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Oradell Public
        • Middle: RDMS
        • High: RDHS

        Source: NJMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

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

        A local lender can help you make sure your offer is ready when you are.

        Browse local experts

        Similar homes

        Skip to the end of the carouselSkip to the beginning of the carousel