454 Hasbrouck Boulevard, Oradell, NJ 07649

Local realty services provided by:ERA Queen City Realty
454 Hasbrouck Boulevard,Oradell, NJ 07649
$1,749,999
  • 6 Beds
  • 5 Baths
  • - sq. ft.
  • Single family
  • Pending
Listed by: kelly weber, roger tashjian
Office: keller williams valley realty201-391-2500
MLS#:26019405
Source:NJ_MLS

Price summary

  • Price:$1,749,999

About this home

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

Contact an agent

contact an agent

Yes, I would like more information. Please use and/or share my information with an ERA®  affiliated agent to contact me about my real estate needs. By clicking Send message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an ERA®  affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE® , CENTURY 21® , Coldwell Banker® , Corcoran® , Sotheby's International Realty® ).
 I acknowledge that I have read and agree to theTerms of useandPrivacy notice

Home facts

  • Listing ID #:26019405
  • Added:6 day(s) ago
  • Updated:June 04, 2026 at 08:52 PM

Rooms and interior

  • Bedrooms:6
  • Total bathrooms:5
  • Full bathrooms:4
  • Half bathrooms:1
  • Rooms Total:10
  • Basement Description:Full

Heating and cooling

  • Cooling:Central Air
  • Heating:Baseboard, Gas, Hot Air, Multi-Zone
  • Central air:Yes

Structure and exterior

  • Lot Features:Regular
  • Architectural Style:Colonial
  • Construction Materials:Stone, Vinyl

Schools

  • High school:RDHS
  • Middle school:RDMS
  • Elementary school:Oradell Public

Finances and disclosures

  • Price:$1,749,999
  • Tax amount:$27,915

Features and amenities

  • Pool features:Gunite, In-ground

Parking

  • Parking description:Attached
  • Garage spaces:2
MLS Logo The data relating to the real estate for sale on this web site comes in part from the Internet Data Exchange Program of the NJMLS. Real estate listings held by brokerage firms other than ERA Queen City Realty are marked with the Internet Data Exchange logo and information about them includes the name of the listing brokers. Some properties listed with the participating brokers do not appear on this website at the request of the seller. Listings of brokers that do not participate in Internet Data Exchange do not appear on this website. All information deemed reliable but not guaranteed. Last date updated: June 4, 2026. Source: New Jersey Multiple Listing Service, Inc. 2026 New Jersey Multiple Listing Service, Inc. All rights reserved.