Welcome to your dream family home! The courtyard entry adds a touch of elegance, while the custom pool and spa create a resort-like atmosphere. The en suite bedroom on the main floor offers convenience, and the spiral staircase leading to the den and additional bedrooms adds character.The gourmet kitchen with double gas ovens is a chef's delight, and the gas fireplace adds warmth and charm. Plus, being close to excellent schools and shopping makes it even more appealing. This beautiful home is the ideal space for creating lasting memories with loved ones! Enjoy a carefree lifestyle at Fireside with resort amenities at the luxurious community center and the convenience of being minutes from Desert Ridge award-winning schools,
dining, shopping, and convenient freeway access.
From 40th and Deer Valley, continue west to Aviano Way and turn south (left). Take your first right(west) on Cat Balue Dr. to home on right (north) side of street.
Dwelling Type: Residential
Subdivision: DESERT RIDGE SUPERBLOCK 11 PARCEL 4
Year Built: 2013, County: US
From 40th and Deer Valley, continue west to Aviano Way and turn south (left). Take your first right(west) on Cat Balue Dr. to home on right (north) side of street.
Listing is courtesy of
1 x Application (99.4%) | 1.68s |
1 x Booting (0.59%) | 10.07ms |
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` = '6768541' limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `reso_property_saves` where `reso_property_saves`.`ListingId` = 146826 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/6768541" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_URL" => "/web/single-property/details/6768541" "REMOTE_PORT" => "16175" "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" => "3.148.179.161" "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" => "2350271-764-3" "H2_STREAM_ID" => "3" "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/6768541" "SCRIPT_URL" => "/web/single-property/details/6768541" "UNIQUE_ID" => "aBJ2BY_ab_Zp2gJJueENVgAABQI" "REDIRECT_STATUS" => "200" "REDIRECT_H2_STREAM_TAG" => "2350271-764-3" "REDIRECT_H2_STREAM_ID" => "3" "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/6768541" "REDIRECT_SCRIPT_URL" => "/web/single-property/details/6768541" "REDIRECT_UNIQUE_ID" => "aBJ2BY_ab_Zp2gJJueENVgAABQI" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1746040325.2028 "REQUEST_TIME" => 1746040325 "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 => "Wed, 30 Apr 2025 19:12:05 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InVydXBNOG5kRm90cjBWMXR5eGtpYnc9PSIsInZhbHVlIjoidmZra1YwZ3VENlBQUHhCbnRuMHJieDJjdTVxRzRhWWxlM0h5N1N0UXBZOWlMZFJycTdySFhWeWxISlJjRStyMUZlVW16VFkxMzEya1JBS21GL1ZVUDQ0dE5DcCthSzE4WFh6d0NicTdBanZhZVkxVTduaFo2WTZ2N1c5eVh6WUwiLCJtYWMiOiIyMzNlZTQ0MzkyMzhhODA3ODExMzE2YTc4YTdlMGI1OGUzOWU5YWFjNjE3N2JlN2Q4MTdhOTQ4YjAyM2NkMWQ0IiwidGFnIjoiIn0%3D; expires=Thu, 01-May-2025 01:02:06 GMT; Max-Age=21000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InVydXBNOG5kRm90cjBWMXR5eGtpYnc9PSIsInZhbHVlIjoidmZra1YwZ3VENlBQUHhCbnRuMHJieDJjdTVxRzRhWWxlM0h5N1N0UXBZOWlMZFJycTdySFhWeWxISlJjRStyMUZlVW16V ▶" 1 => "us_metro_realty_session=eyJpdiI6InB0ZThYUnBtejJHa1pYc0lVQnl0RUE9PSIsInZhbHVlIjoiL3Yyd1pJaXpQL2RFc2tvNTlJQ3BRZWxLa3Fjd0xKNUREOTRLRkJIMTU5L1ZudklBUXpSYlg1MmpRMzc2Z0h0YmJST3hJOHhwZGZhYXFSaHZ5RUdaTDRrWkNxNnA3Rm1xZmJEQVVENWdzU082QnJUUmdiQzBiK0lFZVpPWVFJcW0iLCJtYWMiOiI0ZmI3Zjk4ZDYyMTZkOTExNDdkMjA5NzVjNjRjOWZkZDUxZGNkMGUxZDc0ZjgzNTYwZmFkZWEzZWVjOGMyY2VhIiwidGFnIjoiIn0%3D; expires=Thu, 01-May-2025 01:02:06 GMT; Max-Age=21000; path=/; httponly; samesite=lax ◀us_metro_realty_session=eyJpdiI6InB0ZThYUnBtejJHa1pYc0lVQnl0RUE9PSIsInZhbHVlIjoiL3Yyd1pJaXpQL2RFc2tvNTlJQ3BRZWxLa3Fjd0xKNUREOTRLRkJIMTU5L1ZudklBUXpSYlg1MmpRMzc2 ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InVydXBNOG5kRm90cjBWMXR5eGtpYnc9PSIsInZhbHVlIjoidmZra1YwZ3VENlBQUHhCbnRuMHJieDJjdTVxRzRhWWxlM0h5N1N0UXBZOWlMZFJycTdySFhWeWxISlJjRStyMUZlVW16VFkxMzEya1JBS21GL1ZVUDQ0dE5DcCthSzE4WFh6d0NicTdBanZhZVkxVTduaFo2WTZ2N1c5eVh6WUwiLCJtYWMiOiIyMzNlZTQ0MzkyMzhhODA3ODExMzE2YTc4YTdlMGI1OGUzOWU5YWFjNjE3N2JlN2Q4MTdhOTQ4YjAyM2NkMWQ0IiwidGFnIjoiIn0%3D; expires=Thu, 01-May-2025 01:02:06 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InVydXBNOG5kRm90cjBWMXR5eGtpYnc9PSIsInZhbHVlIjoidmZra1YwZ3VENlBQUHhCbnRuMHJieDJjdTVxRzRhWWxlM0h5N1N0UXBZOWlMZFJycTdySFhWeWxISlJjRStyMUZlVW16V ▶" 1 => "us_metro_realty_session=eyJpdiI6InB0ZThYUnBtejJHa1pYc0lVQnl0RUE9PSIsInZhbHVlIjoiL3Yyd1pJaXpQL2RFc2tvNTlJQ3BRZWxLa3Fjd0xKNUREOTRLRkJIMTU5L1ZudklBUXpSYlg1MmpRMzc2Z0h0YmJST3hJOHhwZGZhYXFSaHZ5RUdaTDRrWkNxNnA3Rm1xZmJEQVVENWdzU082QnJUUmdiQzBiK0lFZVpPWVFJcW0iLCJtYWMiOiI0ZmI3Zjk4ZDYyMTZkOTExNDdkMjA5NzVjNjRjOWZkZDUxZGNkMGUxZDc0ZjgzNTYwZmFkZWEzZWVjOGMyY2VhIiwidGFnIjoiIn0%3D; expires=Thu, 01-May-2025 01:02:06 GMT; path=/; httponly ◀us_metro_realty_session=eyJpdiI6InB0ZThYUnBtejJHa1pYc0lVQnl0RUE9PSIsInZhbHVlIjoiL3Yyd1pJaXpQL2RFc2tvNTlJQ3BRZWxLa3Fjd0xKNUREOTRLRkJIMTU5L1ZudklBUXpSYlg1MmpRMzc2 ▶" ] ]
0 of 0array:4 [▼ "_token" => "tXJfKlkTj9MxLPRyqCRd1KV5ickdaWuhoRbdUc10" "_previous" => array:1 [▶ "url" => "https://usmetrorealty.com/web/single-property/details/6768541" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]