Executive Luxury with Maximum Rental Potential at 164 Wild Rose Street This custom-built executive raised modified bungalow offers an expansive 3,948 SF of total living space, masterfully designed to balance high-end luxury with exceptional functionality. The interior is defined by sophisticated details, including coffered ceilings, elegant crown moldings, and a seamless blend of hardwood and gleaming porcelain tile. Flooded with natural light through large windows, the home features a chef-inspired kitchen with a massive granite island and premium maple cabinetry that flows into a Great Room anchored by a two-way fireplace. The main floor is perfectly laid out for a growing family, offering two large bedrooms plus a versatile office den or entertainment room. The living quarters are topped by a spectacular master suite located above the garage, featuring a spacious layout, a huge walk-in closet, and a luxurious spa-style ensuite. Designed as a strategic "mortgage helper," the fully finished basement includes a separate entrance and is intelligently configured to maximize rental income. This layout provides the potential to accommodate multiple tenants or offer a private, expansive wing for extended guests. Situated on a prime corner lot with a stucco exterior, an oversized double garage, and an aggregate exposed driveway with extra side parking, this move-in-ready masterpiece is the ideal solution for those seeking an elite lifestyle paired with smart financial versatility.
Listed by RAJ SHAH of Century 21 Quantum Realty

Listing Tools (detailViewNewGen)

Property Details of 164 Wild Rose Street

Property Details

Interior Features

Exterior Features

Utilities and Appliances

Map Location

 Based on information submitted to Pillar 9 as of June 11, 2026 6:41 AM UTC. All data is deemed reliable but is not guaranteed accurate by the MLS. All information should be independently reviewed and verified for accuracy. IDX information is provided exclusively for consumers’ personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

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 Vera Van der Luit. 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.