Custom Home in gated Gilbert Heights. This is a community of custom homes where no 2 are alike! 7500 sqft of living space on over a half acre with a spacious gourmet kitchen that opens to the family room featuring floor to ceiling windows with expansive views to the inviting back yard with beach-entry heated/AC-pool and large covered patio. The home has been well maintained with new front door enclosure, AC units are 3 years old, recent exterior paint and some updating has been done inside. Main master is up-stairs but there is another guest master downstairs with a separate entrance. 2 laundry rooms, main is downstairs and one in the master. Walk in pantry, high ceilings with lots of room to roam... all this and a private Theatre room. You are invited to come take a peek! Pool is heated and air conditioned with waterfall. All 5 Trane HVAC units are only 3 years old, Exterior was painted last year and windows were replaced 4 years ago. 14.54 kW Solar system is leased. Air conditioned room on the west end of the back patio can be another bedroom or flex room, currently being used for storage. 3 car garage with Tesla car charger.
South on Lindsay past the railroad tracks to Smoketree Rd., turn right to gated entrance straight ahead. Follow the road to first left on Rawhide Ave., right on Kati St. turns into Horseshoe Ave.
Dwelling Type: Residential
Subdivision: GILBERT HEIGHTS LOT 1-78 TR A B
Year Built: 1992, County: US
South on Lindsay past the railroad tracks to Smoketree Rd., turn right to gated entrance straight ahead. Follow the road to first left on Rawhide Ave., right on Kati St. turns into Horseshoe Ave.
Listing is courtesy of
1 x Application (99.15%) | 1.40s |
1 x Booting (0.84%) | 11.87ms |
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` = '6840434' limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `reso_property_saves` where `reso_property_saves`.`ListingId` = 93460 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/6840434" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_URL" => "/web/single-property/details/6840434" "REMOTE_PORT" => "19783" "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" => "13.58.115.236" "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" => "2938956-655-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/6840434" "SCRIPT_URL" => "/web/single-property/details/6840434" "UNIQUE_ID" => "aBWSgKHyqlJR9I7ogIWXcgABDw0" "REDIRECT_STATUS" => "200" "REDIRECT_H2_STREAM_TAG" => "2938956-655-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/6840434" "REDIRECT_SCRIPT_URL" => "/web/single-property/details/6840434" "REDIRECT_UNIQUE_ID" => "aBWSgKHyqlJR9I7ogIWXcgABDw0" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1746244224.9896 "REQUEST_TIME" => 1746244224 "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 03:50:25 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ik5jcE9UdEt5QlBOcmhJZ0ZHRHpKRGc9PSIsInZhbHVlIjoiY05yN3hPcUJhMkEyTlFLd204NVFiNDJPYVJtWk5EUVl0NzJCWnZKMW40OEZyZExSY1gzRi8zS21rb1Q0dUN0dkszRFAvOTM4ZW5PWk50WTdRa25SZ0tubjM2cTBvNHA2UFk2aEE0blV4ZGs0TnltUWcxbVF2d1cwYTRuSXFJbG0iLCJtYWMiOiJjODFmYjNkN2UzMmE0NDY4ODMwNTY4ODI4OTU1Y2U0ODA0NTFjMzlhYjFlYjQxYTg2ODNlNDI1MGE4MzU1NDAzIiwidGFnIjoiIn0%3D; expires=Sat, 03-May-2025 09:40:26 GMT; Max-Age=21000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ik5jcE9UdEt5QlBOcmhJZ0ZHRHpKRGc9PSIsInZhbHVlIjoiY05yN3hPcUJhMkEyTlFLd204NVFiNDJPYVJtWk5EUVl0NzJCWnZKMW40OEZyZExSY1gzRi8zS21rb1Q0dUN0dkszRFAvO ▶" 1 => "us_metro_realty_session=eyJpdiI6IkJEWXorL1M0cG1lNzRZSSsrTUNUVnc9PSIsInZhbHVlIjoiOHcyQjB5enZNVFA5RTNFeWRTa29yeFpsYUhoNUI2a3R5cWdVZjVEK2xUQ2hubUVHa2FIY3BOR3NGMXUrVHl2SDVUeCtWbWx6bmx0eHFuL052a1NQdDNqSUNmRStFclM0dC9RMWR0WWVvMWRaVG1Sb0QwcEZTamJYc0JWWTl0UkYiLCJtYWMiOiJkYjlhODc1ZDJjZWEzYzRiZjhiOTdkM2QxYzgwOGJkNTU3NWE5MjNkN2RiZTNlODkxZTc2MGQ2NGIyNzU3ZDJkIiwidGFnIjoiIn0%3D; expires=Sat, 03-May-2025 09:40:26 GMT; Max-Age=21000; path=/; httponly; samesite=lax ◀us_metro_realty_session=eyJpdiI6IkJEWXorL1M0cG1lNzRZSSsrTUNUVnc9PSIsInZhbHVlIjoiOHcyQjB5enZNVFA5RTNFeWRTa29yeFpsYUhoNUI2a3R5cWdVZjVEK2xUQ2hubUVHa2FIY3BOR3NGMXUr ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ik5jcE9UdEt5QlBOcmhJZ0ZHRHpKRGc9PSIsInZhbHVlIjoiY05yN3hPcUJhMkEyTlFLd204NVFiNDJPYVJtWk5EUVl0NzJCWnZKMW40OEZyZExSY1gzRi8zS21rb1Q0dUN0dkszRFAvOTM4ZW5PWk50WTdRa25SZ0tubjM2cTBvNHA2UFk2aEE0blV4ZGs0TnltUWcxbVF2d1cwYTRuSXFJbG0iLCJtYWMiOiJjODFmYjNkN2UzMmE0NDY4ODMwNTY4ODI4OTU1Y2U0ODA0NTFjMzlhYjFlYjQxYTg2ODNlNDI1MGE4MzU1NDAzIiwidGFnIjoiIn0%3D; expires=Sat, 03-May-2025 09:40:26 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ik5jcE9UdEt5QlBOcmhJZ0ZHRHpKRGc9PSIsInZhbHVlIjoiY05yN3hPcUJhMkEyTlFLd204NVFiNDJPYVJtWk5EUVl0NzJCWnZKMW40OEZyZExSY1gzRi8zS21rb1Q0dUN0dkszRFAvO ▶" 1 => "us_metro_realty_session=eyJpdiI6IkJEWXorL1M0cG1lNzRZSSsrTUNUVnc9PSIsInZhbHVlIjoiOHcyQjB5enZNVFA5RTNFeWRTa29yeFpsYUhoNUI2a3R5cWdVZjVEK2xUQ2hubUVHa2FIY3BOR3NGMXUrVHl2SDVUeCtWbWx6bmx0eHFuL052a1NQdDNqSUNmRStFclM0dC9RMWR0WWVvMWRaVG1Sb0QwcEZTamJYc0JWWTl0UkYiLCJtYWMiOiJkYjlhODc1ZDJjZWEzYzRiZjhiOTdkM2QxYzgwOGJkNTU3NWE5MjNkN2RiZTNlODkxZTc2MGQ2NGIyNzU3ZDJkIiwidGFnIjoiIn0%3D; expires=Sat, 03-May-2025 09:40:26 GMT; path=/; httponly ◀us_metro_realty_session=eyJpdiI6IkJEWXorL1M0cG1lNzRZSSsrTUNUVnc9PSIsInZhbHVlIjoiOHcyQjB5enZNVFA5RTNFeWRTa29yeFpsYUhoNUI2a3R5cWdVZjVEK2xUQ2hubUVHa2FIY3BOR3NGMXUr ▶" ] ]
0 of 0array:4 [▼ "_token" => "QfyyriZvVuNdZRLy7JbzSBouTPZfYYgH8sWl4bMU" "_previous" => array:1 [▶ "url" => "https://usmetrorealty.com/web/single-property/details/6840434" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]