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
11 Raymond Luhta Crescent, Arnprior, Ontario K7S 3G8 (26146142) - Doug Stuewe Team
BungalowFireplaceCentral Air ConditioningForced AirAcreage
Designer perfect! Newly constructed in Glasgow Ridge, this fabulous bungalow has all the charm of country living with the convenience of amenities close by. Set on a 2.46 acre lot, the ‘Smith Walkout’ model by Mackie Homes offers approx 1995 sq ft of above ground living space & numerous upgrades throughout. The open layout lends to family & entertaining with hwd floors, recessed lighting, transom windows & a cozy fireplace w/a mantel & a floor-to-ceiling stone façade. There is also a main floor office w/views of the front yard. The kitchen combines function & style with extended two-tone cabinetry, herringbone subway backsplash, desirable GE. Café appliances & a built-in rangehood, quartz countertops & a spacious centre island w/an apron front sink & pendant lighting. A powder room, family entrance/laundry room, & an attached, 3-car garage are also featured. The primary suite benefits from a walk-in closet & a luxurious 5-pc ensuite, with two secondary bds & a 4-pc bathroom provided. (id:22570)
The trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA. The trademark DDF® is owned by The Canadian Real Estate Association (CREA) and identifies CREA's Data Distribution Facility (DDF®)
Click on the different category headings to find out more. You can also change some of your preferences. Note that blocking some types of cookies may impact your experience on our websites and the services we are able to offer.
Essential Website Cookies
These cookies are strictly necessary to provide you with services available through our website and to use some of its features.
Because these cookies are strictly necessary to deliver the website, you cannot refuse them without impacting how our site functions. You can block or delete them by changing your browser settings and force blocking all cookies on this website.
Google Analytics Cookies
These cookies collect information that is used either in aggregate form to help us understand how our website is being used or how effective our marketing campaigns are, or to help us customize our website and application for you in order to enhance your experience.
If you do not want that we track your visist to our site you can disable tracking in your browser here:
Other external services
We also use different external services like Google Webfonts, Google Maps and external Video providers. Since these providers may collect personal data like your IP address we allow you to block them here. Please be aware that this might heavily reduce the functionality and appearance of our site. Changes will take effect once you reload the page.