Agent profile image in chat bubble
Agent profile image in chat header

Susan Maryanski

Operator | Opulent Living | Keller Williams City Life

Agent profile image in message

I agree to receive automated marketing calls and texts (SMS/MMS) from Opulent Living | Keller Williams City Life, its affiliates and their agents. Msg & data rates may apply. Msg frequency varies. Reply STOP to cancel. Consent is not required for purchase. I also agree to the Terms of Use and Privacy Policy.

main property photo 0
main property photo 1
main property photo 2
main property photo 3
main property photo 4
main property photo 5
main property photo 6
main property photo 7
main property photo 8
main property photo 9
main property photo 10
main property photo 11
main property photo 12
main property photo 13
main property photo 14
main property photo 15
main property photo 16
main property photo 17
main property photo 18
main property photo 19
main property photo 20
main property photo 21
main property photo 22
main property photo 23
main property photo 24
main property photo 25
main property photo 26
main property photo 27
main property photo 28
main property photo 29
main property photo 30
main property photo 31
main property photo 32
main property photo 33
main property photo 34
main property photo 35
main property photo 36
main property photo 37
main property photo 38
main property photo 39
main property photo 40
main property photo 41
main property photo 42
main property photo 43
main property photo 44
main property photo 45
main property photo 46
main property photo 47
main property photo 48
View All (49)
property photo 1
property photo 2
property photo 3
454 Hasbrouck Boulevard , Oradell, NJ 07649
$1,749,999
Est. Payment: $8,906.11/mo
6 Bed
5 Bath
0 Sqft
Status: pending | Days on site: 7
Get Pre-Qualified
VCR-C15903466 - VCR-C159091383,VCR-C159052275

By providing your number, you are expressly consenting, in writing, to receive telemarketing and other messages, including calls or texts at the number you provided above. This consent is not required to purchase any good or service. Message and data rates may apply. Text STOP to cancel.

This site is protected by reCAPTCHA and the GooglePrivacy Policy and Terms of Service apply.

Agent profile image
Susan Maryanski
Operator
View agent profile
Email
Call

House Description

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
Show more

Highlights

Listed by Kelly Weber , 201-281-5594 and Roger Tashjian , 201-925-9229 Keller Williams Valley Realty , 201-391-2500. New Jersey Multiple Listing Service mls logo

Property Type

Residential

County

Bergen

Area

Oradell

Listing ID

26019405

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • ▪ Bedrooms:6
  • ▪ Bathrooms:5
  • ▪ Full Bathrooms:4
  • ▪ 1/2 Bathrooms:1
Air Cond:Central Air
Fireplaces:
Basement:Full,Prt Finished
Other:10,Expanded,Center Stairwell,Deck / Patio,Hdwd As In,Sprinklers,Strms/Scrns,WW/Carpet As In

Exterior Features

Lot:Regular
Parking Features:Attached
Principal Interest
$8,906
Taxes
$2,326

Home Price

$1,749,999

Loan Details

30 yrs
6.562%

Down Payment

20%
$350,000
All calculations are estimates and provided by Blueroof360. Today’s Rates provided by Blueroof360. Information and interactive calculators are made available to you only as self-help tools for your independent use and are not intended to provide investment or tax advice. We cannot and do not guarantee their applicability or accuracy in regards to your individual circumstances. All examples are hypothetical and are for illustrative purposes. We encourage you to seek personalized advice from qualified professionals regarding all personal finance issues.
Monthly Price:
$8,906.11

Principal

Taxes

Principal Taxes HOA Total
Monthly $8,906.11 $2,326.25 $0.00 $11,232.36
Yearly $106,873.30 $27,915.00 $0.00 $134,788.30
Total $3,206,198.99 $837,450.00 $0.00 $4,043,648.99

Today's Rates

30 Year

6.56%

20 Year

6.5%

15 Year

6%

Never Miss a Property

Be the first to know when a property hits the market.

Current Listings

Last 30 Days
N/A
Jul 2026

Average Price

All Price Ranges
N/A
Jul 2026

Average Days on Market

All Price Ranges
N/A
Jul 2026
Market insight data is pulled from the same city as the listing being viewed (Oradell, NJ).

The schools listed are within a 2-mile radius of the property; however, attendance is not guaranteed. Please contact the local school district to confirm zoning and enrollment options.

(c) 2026 New Jersey Multiple Listing Service, Inc, All Rights Reserved. Information provided by the New Jersey Multiple Listing Service, and Information Deemed Reliable But Not Guaranteed. The listing content relating to 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 the brokerage firm of this website are marked with the Internet Data Exchange logo and detailed information about them includes the name of the listing brokers. The information provided by this website is for the personal, non-commercial use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

Data last updated: 2026-07-21T23:39:14.400Z

© 2026 New Jersey Multiple Listing Service

MLS Logo - New Jersey Multiple Listing Service