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
Under contract
$1,749,999
454 Hasbrouck Blvd, Oradell, NJ 07649
6beds
--sqft
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
- 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#: 26019405
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
| Date | Event | Price |
|---|---|---|
| 6/4/2026 | Pending sale | $1,749,999 |
Source: | ||
| 5/28/2026 | Listed for sale | $1,749,999+821.1% |
Source: | ||
| 6/24/2008 | Sold | $190,000-77.5% |
Source: Public Record Report a problem | ||
| 2/25/2005 | Sold | $845,000+52% |
Source: Public Record Report a problem | ||
| 6/14/2004 | Sold | $556,000 |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax 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$--/mo
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
Nearby schools
GreatSchools rating
- 9/10Oradell Elementary SchoolGrades: PK-6Distance: 0.6 mi
- 8/10River Dell Middle SchoolGrades: 7-8Distance: 1.1 mi
- 8/10River Dell Regional High SchoolGrades: 9-12Distance: 0.9 mi
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.
- New Jersey
- Bergen County
- Oradell
- 07649
- 454 Hasbrouck Blvd







