Don't miss this rare opportunity to own a stunning brand-new luxury duplex in one of Bogota's most sought-after neighborhoods. Thoughtfully designed with premium finishes throughout, this home features engineered hardwood flooring, soaring 9-foot ceilings, and an abundance of natural light. The main level offers a spacious living room, a guest bedroom, and an open-concept family and dining area that flows seamlessly into a modern kitchen with elegant gray shaker cabinetry and stainless steel appliances perfect for both everyday living and entertaining. Upstairs, the generous primary suite boasts a walk-in closet and a spa-inspired en-suite bath with a double vanity and oversized shower. Two additional bedrooms, a full bathroom, and a conveniently located laundry room complete the second level.
Don't miss this rare opportunity to own a stunning brand-new luxury duplex in one of Bogota's most sought-after neighborhoods. Thoughtfully designed with premium finishes throughout, this home features engineered hardwood flooring, soaring 9-foot ceilings, and an abundance of natural light. The main level offers a spacious living room, a guest bedroom, and an open-concept family and dining area that flows seamlessly into a modern kitchen with elegant gray shaker cabinetry and stainless steel appliances perfect for both everyday living and entertaining. Upstairs, the generous primary suite boasts a walk-in closet and a spa-inspired en-suite bath with a double vanity and oversized shower. Two additional bedrooms, a full bathroom, and a conveniently located laundry room complete the second level.
GSMLS #4045579
Aug 7, 2026
Listed
$749,000
NJMLS #26003430
Jan 31, 2026
Listed
$750,000
Public Records
Oct 5, 1994
Sold
$138,000
Year
Property tax
Land + Additions
Assessment*
2023
$5,745 (+1.6%)
$133,800
2022
$5,653 (−17.5%)
$133,800
2021
$6,853 (+1.6%)
$133,800
2020
$6,745 (+1.4%)
$133,800 + $31,800
$165,600
2019
$6,654 (+2.5%)
$133,800 + $31,800
$165,600
2018
$6,492 (+3.2%)
$133,800 + $31,800
$165,600
2017
$6,293
$133,800 + $31,800
$165,600
Public record
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
7,850 Sq. Ft.
Year renovated
—
Finished Sq. Ft.
—
Unfinished Sq. Ft.
—
Total Sq. Ft.
—
Year built
—
Style
Single Family Residential
County
Bergen County
APN
0400053 00005
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 7, 2026.
Historical weather
Bogota, NJ • 07603-1600
Average low and high temperatures (°F)
36
23
39
26
55
37
64
46
72
54
83
65
87
71
82
64
78
62
68
50
56
41
41
28
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
95/ 100
Exceptional sunlight
Sunscore
This home ranks in the top 1% for direct sun exposure in Bogota. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
10 hrs
5.7 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 203 Queen Anne Rd
We cannot show automated home-value estimates for this home.
Nearby homes have recently sold between $650,000 and $1,185,000.
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $650K to $1.2M.