AgentLogo

None

203 Queen Anne Road

Bogota, NJ 07603

MLS#: 26029887

$749,000

Status: Active
Listing number: 26029887
Listing provided by: EXP Realty, LLC
Listing agent phone: None
Last update: 28 days ago
On site: 28 days ago
Browse Properties
Main image without alt text

Property

Beds

4

Full Baths

3

1/2 Baths

None

Year Built

None

Sq.Footage

N/A

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.

Features & Amenities

Interior

  • Total Bedrooms

    4

  • Bathrooms

    3

  • Basement YN

    NO

  • Cooling YN

    YES

  • Cooling

    Central Air

  • Heating YN

    YES

  • Heating

    Baseboard, Electric

  • Pet friendly

    N/A

Exterior

  • Garage

    No

  • Construction Materials

    Aluminum Siding

  • Parking

    Garage Door Opener, Attached

  • Pool

    No

  • View

    None

Area & Lot

  • Property Type

    Residential

  • Property Sub Type

    Duplex

  • Architectural Style

    None

Price

  • Sales Price

    $749,000

  • Tax Amount

    $16,296

  • Sq. Footage

    N/A

  • Price/SqFt

    N/A

HOA

  • Association

    No

School District

  • Elementary School

    N/A

  • Middle School

    N/A

  • High School

    N/A

Property Features

  • New Construction

    YES

  • Ownership

    Private

Schedule a Showing

Showing scheduled successfully.

<
>
IN PERSON
VIA CHAT

What is 3 + 4 ?


Change time

Mortgage calculator

Estimate your monthly mortgage payment, including the principal and interest, property taxes, and HOA. Adjust the values to generate a more accurate rate.

Your payment

Principal and Interest:

$

Property taxes:

$

HOA fees:

$

Total loan payment:

$

Total interest amount:

$

Location

County

BERGEN

Elementary School

Middle School

High School

Listing Courtesy of Frank Capoano, EXP Realty, LLC

RealHub Information is provided exclusively for consumers' personal, non-commercial use, and it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. RealHub website owner shall not be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless.

Agent Patrick Bolger

FOUNDER

Patrick Bolger

Call Patrick today to schedule a private showing.

(973) 945-9979

patrickbolger@kw.com


* Listings on this website come from the FMLS IDX Compilation and may be held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request.© 2024 FMLS.
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.

203 Queen Anne Road

Message successfully sent.

What would you like to know?

What is 3 + 4 ?

I agree to receive email communication and understand I can unsubscribe at any time.

I agree to be contacted by KW Metropolitan via call, email, and text for real estate services. To opt out, you can reply 'stop' at any time or reply 'help' for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. Privacy Policy

Related Properties

New on site 3 days ago
Welcome to this Charming spacious Colonial house in a convenient location close to schools, shopping, dining, parks, and major transportation. This beautifully home with updated floors features living room, formal dining room, five generously sized bedrooms, and two bathrooms providing plenty space for comfortable living. The finished basement offers perfect for a recreation room, home office, or gym. Step outside to a large backyard, New fence for privacy and ideal for entertaining, relaxing, or enjoying outdoor activities. Don't mis this wonderful opportunity to own a move-in-ready home with plenty of space both inside and out!
#26033180

Bogota

161 Walnut Avenue

5 Beds

2 Baths

N/A

$749,000

MLS#: 26033180

New on site 3 days ago
Welcome to this well-maintained and extensively updated three-bedroom Colonial offering a desirable combination of modern upgrades, functional living space, and convenient location. The home features 1 1/2 brand-new bathrooms, a brand-new kitchen, and beautifully refinished hardwood flooring & woodwork throughout. The full-size finished attic offers versatile additional living space with excellent potential for a home office, recreation room, guest area, or other lifestyle needs. The full unfinished basement provides substantial storage and additional potential. Numerous recent improvements include a newer-roof, new copper water service line, new first floor wall mounted air conditioning along with many additional enhancements throughout the property. Set on a generous sized approximately 46' x 100' plus lot, the property offers a private setting yard complemented by a long private driveway and detached garage. The layout provides ample space for comfortable family living and entertaining. Ideally situated in a close proximity to New York City Express bus transportation, major highways, shopping centers, and premier medical facilities, this home offers exceptional conveniences for commuters and everyday living. A rare opportunity to own a substantially updated Colonial with excellent space, privacy, parking, and accessibility. Truly move-in ready and not to be missed. Owner does have a NJ Real Estate License
#26033240

Bogota

246 Cypress Avenue

3 Beds

1 Baths

N/A

$625,000

MLS#: 26033240

Step into this rare 5-bedroom, 3-full-bath detached home situated on a coveted corner lot at 407 Palisades Ave, Bogota, NJ! The main level boasts a spacious living room featuring a stunning stone fireplace, gleaming hardwood floors, and a bright screened sun porch overlooking the circular brick patio. The kitchen stuns with crisp white cabinetry, hexagonal tile backsplash, and stainless steel appliances. Upstairs, retreat to the primary suite featuring a private en-suite bathroom with elegant blue and white diamond tiling. Downstairs, the finished basement offers a large bonus room, full bath, laundry, and dual entrances. Enjoy unmatched convenience with two separate driveways and an attached garage. Explore nearby parks, grab dinner at local hotspots, and commute with ease: just a 3-minute drive to I-80, 5 minutes to Anderson St Station, 20 minutes to the GWB, and 10 minutes to American Dream Mall or Garden State Plaza. Book your private tour today!
#26032350

Bogota

407 Palisade Avenue

5 Beds

3 Baths

N/A

$675,000

MLS#: 26032350

Move right into this beautifully renovated 3-bedroom, 2.5-bath Side Hall Colonial, completely updated in 2022 and offering four finished levels of living space, including a finished attic and finished basement. The first floor features an enclosed front porch, spacious living and dining rooms with hardwood floors, an open-concept kitchen with granite countertops, Samsung stainless steel appliances, and a convenient half bath. Upstairs offers three generously sized bedrooms and a beautifully renovated full bath. Major 2022 improvements include a new roof, all new windows, new electrical wiring with a 200-amp service, recessed lighting throughout, a new kitchen, and all new bathrooms. Outside, enjoy a newly paved driveway with parking for 4+ vehicles and a detached 2-car garage featuring a new roof, new windows, and new garage doors. Ideally located just two blocks from NYC transportation and close to schools, parks, shopping, and major highways, this move-in ready home offers the perfect combination of modern updates, functional living space, and commuter convenience. Don't miss this incredible opportunity!
#26031538

Bogota

187 Cypress Avenue

3 Beds

2 Baths

N/A

$699,999

MLS#: 26031538

This fully renovated 3-bedroom, 2-bath Colonial in Bogota offers 1,430 square feet of turn-key living space, featuring extensive upgrades. Step past the heated enclosed porch into an open floor plan showcasing elegant tray ceilings and pristine hardwood floors throughout, flowing seamlessly into a gorgeous modern kitchen equipped with sleek quartz countertops and brand-new stainless steel appliances. The spacious upper level holds three generous bedrooms, while the partially finished basement expands your usable space with plenty of room for recreation, a home gym, laundry, and extra storage. Outside, the home showcases a large, beautifully manicured yard perfect for outdoor relaxation and entertaining, along with an expansive driveway that easily accommodates parking for 3+ cars. Situated in a highly desirable neighborhood, this classic-meets-modern gem sits just 20 minutes outside of New York City with incredibly convenient access to major highways, public transit bus stops, local schools, and shopping.
#26030400

Bogota

26 Linwood Avenue

3 Beds

2 Baths

N/A

$635,000

MLS#: 26030400

Welcome to a hidden gem nestled in charming Bogota! As you enter this beautifully maintained 3 bed 2 bath colonial, you're welcomed by a bright and inviting open layout featuring a spacious living and dining area with hardwood floors throughout. Natural light fills the first floor, highlighting the updated kitchen, which flows seamlessly into the main living spaces. A full bathroom and a cozy wood-burning fireplace complete the first level. The fully carpeted second floor features three generously sized bedrooms, a full bathroom, and access to the third floor. The finished third floor offers exceptional bonus space, ideal for a recreation room, home office, or playroom. A skylight fills the space with abundant natural light, creating a bright and inviting atmosphere perfect for work, play, or relaxation. The partially finished basement features another bonus room along with extra storage. Step outside and enjoy the expansive backyard featuring a large deck with convenient access from both the dining room's sliding glass doors and the rear entrance ideal for entertainment and relaxation. The detached garage and oversized driveway with parking for 5-6 vehicles provide exceptional convenience, a rare find in today's market. Situated in a desirable neighborhood close to schools, parks, shopping, and major transportation, this move-in-ready home offers space, comfort, and versatility both inside and out. Don't miss this incredible opportunity to make this exceptional home yours!
#26025816

Bogota

377 Orchard Terrace

3 Beds

2 Baths

N/A

$675,000

MLS#: 26025816

Opportunity awaits in this charming 4 bedroom, 1.5 bath home, nestled in a wonderful neighborhood in desirable Bergen County with endless potential. From the moment you arrive, the inviting curb appeal and expansive front porch create a warm welcome. Inside, the sun-filled living room flows seamlessly into a spacious formal dining room, while hardwood floors add timeless character throughout much of the home. The kitchen is ready for your personal touch and features a cozy breakfast nook overlooking the large, fully fenced backyard ideal for outdoor entertaining or gardening. Upstairs, the second level offers two bedrooms, a shared hall bathroom, and a versatile bonus room perfect for a home office or future walk-in closet. The third floor adds two additional bright bedrooms with freshly painted walls and well-maintained laminate flooring, providing flexible space for guests, or hobbies. A finished basement with a convenient powder room offers additional storage and functionality. The spacious yard, abundant guest parking, and classic charm make this home a rare opportunity for buyers ready to bring their vision to life. With solid bones, great space, and an unbeatable Bergen County location, this is your chance to create the home you've always imagined.
#26024305

Bogota

244 Elm Avenue

4 Beds

1 Baths

N/A

$629,000

MLS#: 26024305

- property

Send a message

Message successfully sent.

Your message

What is 3 + 4 ?

Reason for contacting?

I agree to receive email communication and understand I can unsubscribe at any time.

I agree to be contacted by KW Metropolitan via call, email, and text for real estate services. To opt out, you can reply 'stop' at any time or reply 'help' for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. Privacy Policy

Sign Out

Virtual Assistant

Would you like to take the next step with this property? We can help you schedule a showing or virtual tour, or send you more details.

Yes, I would like more information.

Thank You for Your Reply, One of Our Agents will contact you as soon as possible

No, maybe later.

Thank you, you can always contact me via email, phone number or through the contact form.

Realhub AI

Lucy - Your AI-Powered Realtor

Update Your Temporary Password

Personalize your search

Enter your email and we'll notify you immediately when new listings match what you're looking for.

or enter email address

Already have an account ? Login here

Continue your home search

I agree to receive communications and understand I can unsubscribe at any time.

I agree to be contacted by KW Metropolitan via call, email, and text for real estate services. To opt out, you can reply 'stop' at any time or reply 'help' for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. Privacy Policy

Already have an account ? Login here

We use cookies

We use cookies primarily for analytics to enhance your experience. By accepting, you agree to our use of these cookies. You can manage your preferences or learn more about our cookies policy.

Privacy Policy Terms of Service