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

By proceeding and clicking the sign up button, you consent to receive calls and texts (SMS/MMS) including marketing and promotional communications, from , its affiliates, and agents or vendors acting on their behalf. These communications may be delivered using an automatic telephone dialing system or by using an artificial or prerecorded voice. Message and data rates may apply. To opt out of text messages, reply STOP. Your consent is not required as a condition of any purchase. By continuing, you also agree to our Terms of Use and Privacy Policy.
main property photo 0
View All (49)
454 Hasbrouck Boulevard , Oradell, NJ 07649
$1,749,999
Est. Payment: $3,888.89/mo
6 Bed
5 Bath
0 Sqft
Status: Sold | Days on site: 7
Get Pre-Qualified
56787 - 5497,464149,478906
By proceeding and clicking the sign up button, you consent to receive calls and texts (SMS/MMS) including marketing and promotional communications, from , its affiliates, and agents or vendors acting on their behalf. These communications may be delivered using an automatic telephone dialing system or by using an artificial or prerecorded voice. Message and data rates may apply. To opt out of text messages, reply STOP. Your consent is not required as a condition of any purchase. By continuing, you also agree to our Terms of Use and Privacy Policy.
Agent profile image
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.

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:
  • ▪ Additional: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
$3,889
Taxes
$2,326

Home Price

$1,749,999

Loan Details

30 yrs
%

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:
$3,888.89

Principal

Taxes

Principal Taxes HOA Total
Monthly $3,888.89 $2,326.25 $0.00 $6,215.14
Yearly $46,666.64 $27,915.00 $0.00 $74,581.64
Total $1,399,999.20 $837,450.00 $0.00 $2,237,449.20

Today's Rates

30 Year

0%

20 Year

0%

15 Year

0%

Never Miss a Property

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

Current Listings

Last 30 Days
N/A
Sep 2026

Average Price

All Price Ranges
N/A
Sep 2026

Average Days on Market

All Price Ranges
N/A
Sep 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.