Sidebar Fav/

    Immaculate 3700 sq ft detached home featuring 5+3 bedrooms and 6 bathrooms, complete with a legal second dwelling unit. This stone-and-brick beauty sits on a deep lot backing onto a ravine, offering privacy and scenic views. The main level showcases upgraded porcelain tile, 9 ft ceilings, a living/dining area, and a spacious family room with a gas fireplace. The chef's kitchen includes a breakfast bar, seamless quartz countertops and backsplash, an eat-in area with walkout to the deck, and wide-plank oak-stained hardwood carried throughout with matching staircase and iron pickets. The primary bedroom offers his-and-her walk-in closets and a spa-like ensuite with double sinks, soaker tub, and separate shower; the second bedroom also features a walk-in closet. Pot lights throughout the living/dining, great room, kitchen, and exterior. A ground-floor in-law suite includes an open-concept kitchen with quartz counters, 1 bedroom, 1 bathroom, laundry, and walkout to the backyard. The legal basement apartment offers 3 bedrooms, 1 bathroom, a full kitchen with stainless steel appliances, 6 above-grade windows, and separate laundry. Additional features include electric car charger wiring and a BBQ gas line installed by the builder. (id:24093)
    Listed by SHAWN CHHABRA of REAL ESTATE ADVISORS INC.

    Property Details of 574 Queen Mary Drive

    Property Details

    Interior Features

    Utilities and Appliances

    Map Location

    Never Miss New Listings

    Never miss new listings between $1,259,000 - $1,539,000 in this neighborhood
    Successfully Subscribed!
    Do not fill in this field:

    I agree to receive marketing and customer service calls and text messages from The Zahnd Team. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

    We will never spam you or sell your details. You can unsubscribe whenever you like.

    "Based on information submitted to CREA as of September 11, 2026 . All data is obtained from various sources and has not been, and will not be, verified by broker or CREA.  All information should be independently reviewed and verified for accuracy.  Properties may or may not be listed by the office/agent presenting the information. NOTICE: Many homes contain recording devices, and buyers should be aware they may be recorded during a showing."

    Hi there! How can we help you?

    Contact us using the form below or give us a call.

    Send Us A Message:

    I agree to receive marketing and customer service calls and text messages from The Zahnd Team. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

    Do not fill in this field:

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

    Hi there! How can we help you?

    Contact us using the form below or give us a call.

    Send Us A Message:

    Do not fill in this field:

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

    Hi there! How can we help you?

    Contact us using the form below or give us a call.

    Send Us A Message:

    Do not fill in this field:

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

    Do not fill in this field:

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

    Do not fill in this field:

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

    Do not fill in this field:

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

    $

    Do not fill in this field:

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