WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM wp_rps_property WHERE `ListingID` = 23888570' at line 1 for query SELECT FROM wp_rps_property WHERE `ListingID` = 23888570 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), apply_filters('template_include'), WP_Hook->apply_filters, RealtyPress_Template->include_template, RealtyPress_DDF_CRUD->rps_get_post_listing_details, RealtyPress_DDF_CRUD->get_local_listing_details
Warning: Creating default object from empty value in /home/dougestu/public_html/wp2017/wp-content/themes/enfold/config-templatebuilder/avia-shortcodes/slideshow_layerslider/slideshow_layerslider.php on line 28

Warning: Cannot modify header information - headers already sent by (output started at /home/dougestu/public_html/index.php:1) in /home/dougestu/public_html/wp2017/wp-content/plugins/realtypress-premium/includes/functions-realtypress.php on line 89
457 Turmeric Court, Stittsville, Ontario K2S 2X7 (26179761) - Doug Stuewe Team


457 Turmeric Court Stittsville, Ontario K2S 2X7

4 Bedroom 3 Bathroom
Central Air Conditioning Forced Air

$3,000 Monthly

An incredible opportunity to rent your dream home is here! This brand new, never-lived-in Claridge Cumberland model in Stittsville is ready for you. With 3,365 square feet of living space, including a finished basement, you'll have ample room to make it your own. The main floor and stairs feature beautiful hardwood flooring, and it boasts a living room, dining room, and a cozy great room with a double-sided fireplace. The upgraded kitchen, with a walk-in pantry and lots of counter and cabinet space, features granite countertops and stainless steel appliances. Upstairs, you'll find 4 sunny bedrooms, a versatile loft with a huge window, including a master bedroom with a walk-in closet and ensuite bathroom. The second floor also includes a convenient laundry room and another full bathroom. The finished basement offers extra space for your hobbies or entertainment needs. Conveniently located near schools, shopping, recreational facilities, and even a nearby golf course. (id:22570)

Property Details

MLS® Number 1365231
Property Type Single Family
Neigbourhood Stittaville
Amenities Near By Golf Nearby, Recreation Nearby, Shopping
Community Features Family Oriented
Parking Space Total 4


Bathroom Total 3
Bedrooms Above Ground 4
Bedrooms Total 4
Amenities Laundry - In Suite
Appliances Refrigerator, Dishwasher, Dryer, Hood Fan, Stove, Washer, Blinds
Basement Development Finished
Basement Type Full (finished)
Constructed Date 2023
Construction Style Attachment Detached
Cooling Type Central Air Conditioning
Exterior Finish Brick, Siding
Flooring Type Wall-to-wall Carpet, Hardwood, Ceramic
Half Bath Total 1
Heating Fuel Natural Gas
Heating Type Forced Air
Stories Total 2
Type House
Utility Water Municipal Water


Attached Garage
Inside Entry


Acreage No
Land Amenities Golf Nearby, Recreation Nearby, Shopping
Sewer Municipal Sewage System
Size Irregular * Ft X * Ft
Size Total Text * Ft X * Ft
Zoning Description Residential


Level Type Dimensions
Second Level Loft 11'4" x 11'4"
Second Level Bedroom 12'0" x 12'0"
Second Level Bedroom 11'5" x 10'11"
Second Level Bedroom 11'4" x 10'1"
Second Level Primary Bedroom 18'11" x 11'8"
Basement Recreation Room 27'7" x 27'3"
Main Level Dining Room 14'5" x 13'11"
Main Level Living Room 12'8" x 13'11"
Main Level Great Room 12'8" x 14'9"
Main Level Kitchen 16'5" x 14'4"



Contact us for more information

Harpreet Pandher

(613) 852-5262

Keller Williams Integrity Realty
2148 Carling Ave., Units 5 & 6
Ottawa, Ontario K2A 1H1

(613) 829-1818
(613) 829-3223

Your Favourites


No Favourites Found


Copyright © 2002-2017 Royal LePage Team Realty independently owned & operated. Patent Pending. All Rights Reserved