You will be in awe when you see this stunning home located on the border of Gilbert and Queen Creek. From the front yard landscaping, the massive kitchen island, the insane primary shower & an entertainers dream back yard. This home has it all! As you journey up to the home you will enter an iron gate to your own private front courtyard. When you enter the front door you will be in owe w/ the ceiling heights, custom wanes coating & how open this home is. Wood looking tile floors, spacious kitchen that opens to the family room, a living room/dining room, 4 bedrooms and 2.5 bath. The primary bathroom has double split sinks & the biggest shower you have ever seen. Head outside to your entertainers backyard w/ built in BBQ, firepits, turf, & spa w/ bar top from your two backyard sliders.
East on Rittenhouse. South on 198th St. West on Emperor Blvd. Pass the round about to your new home on the north side of the road.
Dwelling Type: Residential
Subdivision: EMPEROR ESTATES PARCEL H
Year Built: 2016, County: US
East on Rittenhouse. South on 198th St. West on Emperor Blvd. Pass the round about to your new home on the north side of the road.
Listing is courtesy of Realty ONE Group
1 x Application (99.27%) | 1.51s |
1 x Booting (0.72%) | 10.88ms |
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` = '6829403' limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `reso_property_saves` where `reso_property_saves`.`ListingId` = 277966 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/6829403" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_URL" => "/web/single-property/details/6829403" "REMOTE_PORT" => "65091" "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.191.174.190" "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" => "431574-347-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/6829403" "SCRIPT_URL" => "/web/single-property/details/6829403" "UNIQUE_ID" => "aBw-xyuQE6Tvjfh2VmnMsgAARAA" "REDIRECT_STATUS" => "200" "REDIRECT_H2_STREAM_TAG" => "431574-347-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/6829403" "REDIRECT_SCRIPT_URL" => "/web/single-property/details/6829403" "REDIRECT_UNIQUE_ID" => "aBw-xyuQE6Tvjfh2VmnMsgAARAA" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1746681543.798 "REQUEST_TIME" => 1746681543 "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 => "Thu, 08 May 2025 05:19:03 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InZQbVNkR2RVdVZkODNrR055Rm1HS1E9PSIsInZhbHVlIjoicm9ldlYrYVdNZFBKTGVEejRsSjEvQkZhMkVHZ1hGRkFCSmpqdlFUSUZBYjEvU3RJV2ZHWllNaUxIQnJVQVVkM2ZoT0VieHBncDRMRFhoVWx2RXhvWXpIUHJUOFB6Skk2Si92bzMwZ0c5Yk5WODJJbEVVU3JRVWxrZ2JLbjRKbkYiLCJtYWMiOiJiMTEzYWM4MjgzNzEzZTRjYmEyYTJhNWI3NWQ3NTgwMGZhMzlmNjA4ODE2OTliMGI5NzJmMThjZTU2MDQxNmQ2IiwidGFnIjoiIn0%3D; expires=Thu, 08-May-2025 11:09:05 GMT; Max-Age=21000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InZQbVNkR2RVdVZkODNrR055Rm1HS1E9PSIsInZhbHVlIjoicm9ldlYrYVdNZFBKTGVEejRsSjEvQkZhMkVHZ1hGRkFCSmpqdlFUSUZBYjEvU3RJV2ZHWllNaUxIQnJVQVVkM2ZoT0Vie ▶" 1 => "us_metro_realty_session=eyJpdiI6IkVwS25vdStHbXhvSlJNSWtXN0ZEbXc9PSIsInZhbHVlIjoiVW1ic2JZT1c3NWRQRlBCeWVGclNFZGh4RURGcG91bXo0eTZROHN4VnNYYVp6SitudDBpZlhiSXJTVmpkSk5LMGQxZXRkNUJEMVo5cHZOQzJleDFXUnMvVTZwRjNMRmtxcVRnY0M3SDZmR2tER1NjNTg5d2hFbWZZTnZPZkRSaisiLCJtYWMiOiIyZDUyNDBhNTU4ZDJmNDNiZTFjM2QyNjQxYjQwYzlmYjRmYzg4YTUwOTNjMmYyZWZjMDBkM2VhN2Q0OGI3M2VkIiwidGFnIjoiIn0%3D; expires=Thu, 08-May-2025 11:09:05 GMT; Max-Age=21000; path=/; httponly; samesite=lax ◀us_metro_realty_session=eyJpdiI6IkVwS25vdStHbXhvSlJNSWtXN0ZEbXc9PSIsInZhbHVlIjoiVW1ic2JZT1c3NWRQRlBCeWVGclNFZGh4RURGcG91bXo0eTZROHN4VnNYYVp6SitudDBpZlhiSXJTVmpk ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InZQbVNkR2RVdVZkODNrR055Rm1HS1E9PSIsInZhbHVlIjoicm9ldlYrYVdNZFBKTGVEejRsSjEvQkZhMkVHZ1hGRkFCSmpqdlFUSUZBYjEvU3RJV2ZHWllNaUxIQnJVQVVkM2ZoT0VieHBncDRMRFhoVWx2RXhvWXpIUHJUOFB6Skk2Si92bzMwZ0c5Yk5WODJJbEVVU3JRVWxrZ2JLbjRKbkYiLCJtYWMiOiJiMTEzYWM4MjgzNzEzZTRjYmEyYTJhNWI3NWQ3NTgwMGZhMzlmNjA4ODE2OTliMGI5NzJmMThjZTU2MDQxNmQ2IiwidGFnIjoiIn0%3D; expires=Thu, 08-May-2025 11:09:05 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InZQbVNkR2RVdVZkODNrR055Rm1HS1E9PSIsInZhbHVlIjoicm9ldlYrYVdNZFBKTGVEejRsSjEvQkZhMkVHZ1hGRkFCSmpqdlFUSUZBYjEvU3RJV2ZHWllNaUxIQnJVQVVkM2ZoT0Vie ▶" 1 => "us_metro_realty_session=eyJpdiI6IkVwS25vdStHbXhvSlJNSWtXN0ZEbXc9PSIsInZhbHVlIjoiVW1ic2JZT1c3NWRQRlBCeWVGclNFZGh4RURGcG91bXo0eTZROHN4VnNYYVp6SitudDBpZlhiSXJTVmpkSk5LMGQxZXRkNUJEMVo5cHZOQzJleDFXUnMvVTZwRjNMRmtxcVRnY0M3SDZmR2tER1NjNTg5d2hFbWZZTnZPZkRSaisiLCJtYWMiOiIyZDUyNDBhNTU4ZDJmNDNiZTFjM2QyNjQxYjQwYzlmYjRmYzg4YTUwOTNjMmYyZWZjMDBkM2VhN2Q0OGI3M2VkIiwidGFnIjoiIn0%3D; expires=Thu, 08-May-2025 11:09:05 GMT; path=/; httponly ◀us_metro_realty_session=eyJpdiI6IkVwS25vdStHbXhvSlJNSWtXN0ZEbXc9PSIsInZhbHVlIjoiVW1ic2JZT1c3NWRQRlBCeWVGclNFZGh4RURGcG91bXo0eTZROHN4VnNYYVp6SitudDBpZlhiSXJTVmpk ▶" ] ]
0 of 0array:4 [▼ "_token" => "U8bUrpTIL4XQ8TlNcYJ8RQhFdpQq074nxF5xDIBg" "_previous" => array:1 [▶ "url" => "https://usmetrorealty.com/web/single-property/details/6829403" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]