A must-see 4,126 square foot custom home featuring 4 bedrooms and 4.5 baths in the secluded neighborhood of guard gated Artesano in Troon of North Scottsdale. From the 0.406-acre lot, enjoy the spectacular views of city, McDowell, Troon and Pinnacle Peak Mountains. Upon arrival, an open concept living layout welcomes you. The spacious living room features custom cabinets with a gas fireplace. The kitchen is an entertainer's delight with a Wolf gas cook top, double ovens and two Asko dishwashers. Conveniently located between the kitchen and family room, a bar featuring expansive counters, a fridge and an ice maker. The primary bedroom is on the second floor and has amazing city light views, the backyard and the pool. The master shower includes two separate shower controls. The secondary bedrooms have all en-suite bathrooms. The spacious floor plan with large windows and high ceilings allow the natural light to brighten the home. The laundry room is equipped with upper and lower cabinetry and a sink. For golfers and outdoor enthusiasts, the location provides quick access to numerous golf courses, Brown's Ranch and the Tonto national forest. The deep garages can accommodate large SUVs and trucks plus the high ceilings provide enough room for car lift/s. The elementary and high school buses stop just a quick 5-minute walk from the property.
Go East on Happy Valley and head North on Windy Walk Dr. Go East through the two Artesano gates and take the first right. Home is located at the end of the cul de sac.
Dwelling Type: Residential
Subdivision: ARTESANO AT TROON CANYON
Year Built: 2004, County: US
Go East on Happy Valley and head North on Windy Walk Dr. Go East through the two Artesano gates and take the first right. Home is located at the end of the cul de sac.
Listing is courtesy of
1 x Application (99.43%) | 1.81s |
1 x Booting (0.57%) | 10.32ms |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
select * from `agents` where `id` is null limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `resoapi_properties` where `ListingId` = '6763577' limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `reso_property_saves` where `reso_property_saves`.`ListingId` = 75444 and `reso_property_saves`.`ListingId` is not null limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `neighbour_menus`
Metadata | |
---|---|
Backtrace |
|
select * from `neighbour_menus`
Metadata | |
---|---|
Backtrace |
|
select * from `page_builders` where `status` = 1 and `main_menu` = 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `page_builders` where `status` = 1 and `main_menu` = 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `page_builders` where `status` = 1 and `main_menu` = 2
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `page_builders` where `status` = 1 and `main_menu` = 2
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `page_builders` where `status` = 1 and `main_menu` = 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `page_builders` where `status` = 1 and `main_menu` = 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `page_builders` where `status` = 1 and `main_menu` = 2
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `page_builders` where `status` = 1 and `main_menu` = 2
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `website_infos` limit 1
Metadata | |
---|---|
Backtrace |
|
200
[]
[]
0 of 0array:16 [▼ "x-https" => array:1 [▶ 0 => "1" ] "host" => array:1 [▶ 0 => "usmetrorealty.com" ] "priority" => array:1 [▶ 0 => "u=0, i" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] ]
0 of 0array:71 [▼ "USER" => "rootusmrcom" "HOME" => "/home/rootusmrcom" "SCRIPT_NAME" => "/index.php" "REQUEST_URI" => "/web/single-property/details/6763577" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_URL" => "/web/single-property/details/6763577" "REMOTE_PORT" => "7278" "SCRIPT_FILENAME" => "/home/rootusmrcom/public_html/index.php" "SERVER_ADMIN" => "webmaster@usmetrorealty.com" "CONTEXT_DOCUMENT_ROOT" => "/home/rootusmrcom/public_html" "CONTEXT_PREFIX" => "" "REQUEST_SCHEME" => "https" "DOCUMENT_ROOT" => "/home/rootusmrcom/public_html" "REMOTE_ADDR" => "18.216.186.122" "SERVER_PORT" => "443" "SERVER_ADDR" => "67.222.9.129" "SERVER_NAME" => "usmetrorealty.com" "SERVER_SOFTWARE" => "Apache" "SERVER_SIGNATURE" => "" "PATH" => "/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin ◀/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bi ▶" "HTTP_X_HTTPS" => "1" "HTTP_HOST" => "usmetrorealty.com" "HTTP_PRIORITY" => "u=0, i" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "proxy-nokeepalive" => "1" "H2_STREAM_TAG" => "3066829-71-1" "H2_STREAM_ID" => "1" "H2_PUSHED_ON" => "" "H2_PUSHED" => "" "H2_PUSH" => "off" "H2PUSH" => "off" "HTTP2" => "on" "SSL_TLS_SNI" => "usmetrorealty.com" "HTTPS" => "on" "SCRIPT_URI" => "https://usmetrorealty.com/web/single-property/details/6763577" "SCRIPT_URL" => "/web/single-property/details/6763577" "UNIQUE_ID" => "aBV7GIHBOh6RsRDKT_ffgQAAjwE" "REDIRECT_STATUS" => "200" "REDIRECT_H2_STREAM_TAG" => "3066829-71-1" "REDIRECT_H2_STREAM_ID" => "1" "REDIRECT_H2_PUSHED_ON" => "" "REDIRECT_H2_PUSHED" => "" "REDIRECT_H2_PUSH" => "off" "REDIRECT_H2PUSH" => "off" "REDIRECT_HTTP2" => "on" "REDIRECT_SSL_TLS_SNI" => "usmetrorealty.com" "REDIRECT_HTTPS" => "on" "REDIRECT_SCRIPT_URI" => "https://usmetrorealty.com/web/single-property/details/6763577" "REDIRECT_SCRIPT_URL" => "/web/single-property/details/6763577" "REDIRECT_UNIQUE_ID" => "aBV7GIHBOh6RsRDKT_ffgQAAjwE" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1746238232.443 "REQUEST_TIME" => 1746238232 "argv" => [] "argc" => 0 ]
[]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Sat, 03 May 2025 02:10:32 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlBORDhIRTIyTGdLemxTN1VNcDdVMVE9PSIsInZhbHVlIjoiWVdrOC9kNlliekZVQmdNa0FTS3RIbkV2RExPYTJ4NHMvOVZxTmpNcFJ1SEVwdHAzVmpJc0lWRjRIcFVzUUVpS2tseklWZTY3alZpQlRqZjRIQUwzZnJnZmZKNlE2c2poQzgwZ0VvdGNmWkRqcDJSZmdoY2M4ZXlDTXM0TVkyRUciLCJtYWMiOiI3ZTcxYjQwOWJhNWEyMDRhOTAxZjM4OWZlZmJiOGM1ZTI4MTMzNDUwZjA1NzBiY2ZmOGU4MzA2NGM2MjUyMTJjIiwidGFnIjoiIn0%3D; expires=Sat, 03-May-2025 08:00:34 GMT; Max-Age=21000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlBORDhIRTIyTGdLemxTN1VNcDdVMVE9PSIsInZhbHVlIjoiWVdrOC9kNlliekZVQmdNa0FTS3RIbkV2RExPYTJ4NHMvOVZxTmpNcFJ1SEVwdHAzVmpJc0lWRjRIcFVzUUVpS2tseklWZ ▶" 1 => "us_metro_realty_session=eyJpdiI6IjdnU0tyVkRIVStiMG1yTGZpd1pnVlE9PSIsInZhbHVlIjoibW9PSTBDL2E3V3FuWHRtUWVYclprSWEyZ3Z1TG5XQkJxQmM3SG8wOWdOZUwwQ1FGKzNzbldoYnBrUVY4RXZLOFZrTGFlY0NpSUc1b0U0azZNWVUxdE40QkxQbjkzZjdGL2xPMi9wamkzMnRNUkZmaWRZSmFqQnR1SDJRSUxkamMiLCJtYWMiOiI1NWM4YzhkM2ZlOTQxNzUxZjM3MzRlYzU3YzUwZDY1OTU0OWQ4NDM4YmZkNmQ4Y2JhMWMxZDQ4YzZkMWQ5MmQyIiwidGFnIjoiIn0%3D; expires=Sat, 03-May-2025 08:00:34 GMT; Max-Age=21000; path=/; httponly; samesite=lax ◀us_metro_realty_session=eyJpdiI6IjdnU0tyVkRIVStiMG1yTGZpd1pnVlE9PSIsInZhbHVlIjoibW9PSTBDL2E3V3FuWHRtUWVYclprSWEyZ3Z1TG5XQkJxQmM3SG8wOWdOZUwwQ1FGKzNzbldoYnBrUVY4 ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlBORDhIRTIyTGdLemxTN1VNcDdVMVE9PSIsInZhbHVlIjoiWVdrOC9kNlliekZVQmdNa0FTS3RIbkV2RExPYTJ4NHMvOVZxTmpNcFJ1SEVwdHAzVmpJc0lWRjRIcFVzUUVpS2tseklWZTY3alZpQlRqZjRIQUwzZnJnZmZKNlE2c2poQzgwZ0VvdGNmWkRqcDJSZmdoY2M4ZXlDTXM0TVkyRUciLCJtYWMiOiI3ZTcxYjQwOWJhNWEyMDRhOTAxZjM4OWZlZmJiOGM1ZTI4MTMzNDUwZjA1NzBiY2ZmOGU4MzA2NGM2MjUyMTJjIiwidGFnIjoiIn0%3D; expires=Sat, 03-May-2025 08:00:34 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlBORDhIRTIyTGdLemxTN1VNcDdVMVE9PSIsInZhbHVlIjoiWVdrOC9kNlliekZVQmdNa0FTS3RIbkV2RExPYTJ4NHMvOVZxTmpNcFJ1SEVwdHAzVmpJc0lWRjRIcFVzUUVpS2tseklWZ ▶" 1 => "us_metro_realty_session=eyJpdiI6IjdnU0tyVkRIVStiMG1yTGZpd1pnVlE9PSIsInZhbHVlIjoibW9PSTBDL2E3V3FuWHRtUWVYclprSWEyZ3Z1TG5XQkJxQmM3SG8wOWdOZUwwQ1FGKzNzbldoYnBrUVY4RXZLOFZrTGFlY0NpSUc1b0U0azZNWVUxdE40QkxQbjkzZjdGL2xPMi9wamkzMnRNUkZmaWRZSmFqQnR1SDJRSUxkamMiLCJtYWMiOiI1NWM4YzhkM2ZlOTQxNzUxZjM3MzRlYzU3YzUwZDY1OTU0OWQ4NDM4YmZkNmQ4Y2JhMWMxZDQ4YzZkMWQ5MmQyIiwidGFnIjoiIn0%3D; expires=Sat, 03-May-2025 08:00:34 GMT; path=/; httponly ◀us_metro_realty_session=eyJpdiI6IjdnU0tyVkRIVStiMG1yTGZpd1pnVlE9PSIsInZhbHVlIjoibW9PSTBDL2E3V3FuWHRtUWVYclprSWEyZ3Z1TG5XQkJxQmM3SG8wOWdOZUwwQ1FGKzNzbldoYnBrUVY4 ▶" ] ]
0 of 0array:4 [▼ "_token" => "VVn3vHk6rfvcpnHvLdHVZkUGIogwRsNtYMgWrEbl" "_previous" => array:1 [▶ "url" => "https://usmetrorealty.com/web/single-property/details/6763577" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]