*SELLER OFFERING 2% CONCESSIONS TO BE USED AT BUYERS DISCRETION WITH FULL PRICE OFFER* **ASK LISTING AGENT ABOUT AN ADDITIONAL 1% IN CONCESSIONS WHEN USING ONE OF OUR PREFERRED LENDERS**Discover the perfect blend of style and functionality in this 4-bedroom, 2.5-bathroom, 2,620 sq. ft. home situated on a desirable corner lot. Featuring an open-concept design, the main floor boasts wood-look tile flooring, a spacious den, and a chef's kitchen complete with rich wood cabinetry, stainless steel appliances, gas range, a large island, a walk-in pantry, and an impressive three-panel sliding glass door, seamlessly connecting indoor and outdoor living. Upstairs, you'll find all bedrooms plus a loft, including a primary suite with two walk-in closets for ample storage. Step into the $100K backyard retreat, designed for both relaxation and entertainment! Enjoy fence-to-fence pavers, a heated pool with a retractable cover, and a gazebo featuring a built-in fire pitperfect for year-round enjoyment.
Located near the popular Schnepf Farms and Queen Creek Olive Mill, this home offers the best of convenience and lifestyle. Don't miss out on this incredible opportunity!
Input 1052 W Capulin Trail into your car or phones Maps or Google Maps to get the most accurate directions.
Dwelling Type: Residential
Subdivision: THE PARKS PARCEL D
Year Built: 2017, County: US
Input 1052 W Capulin Trail into your car or phones Maps or Google Maps to get the most accurate directions.
Listing is courtesy of
1 x Application (99.22%) | 1.35s |
1 x Booting (0.77%) | 10.44ms |
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` = '6823527' limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `reso_property_saves` where `reso_property_saves`.`ListingId` = 83525 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/6823527" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_URL" => "/web/single-property/details/6823527" "REMOTE_PORT" => "22384" "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.150.124" "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" => "3531430-18-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/6823527" "SCRIPT_URL" => "/web/single-property/details/6823527" "UNIQUE_ID" => "aBfOnuSrfezJ718kK6vHXgAA1Bc" "REDIRECT_STATUS" => "200" "REDIRECT_H2_STREAM_TAG" => "3531430-18-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/6823527" "REDIRECT_SCRIPT_URL" => "/web/single-property/details/6823527" "REDIRECT_UNIQUE_ID" => "aBfOnuSrfezJ718kK6vHXgAA1Bc" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1746390686.4179 "REQUEST_TIME" => 1746390686 "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 => "Sun, 04 May 2025 20:31:26 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjhvTjA5UGgwTGpEU2RQa0hmODZGckE9PSIsInZhbHVlIjoiYXFpMUlaTHhTVElVeDVMbTMrLzJKc2pMdG9tZFFIZDRDMEdZNmpzeXA2MVlsMjNlTXUrSlFzVUExcFZPekZDWEFmNlhRbFVkRnJwZnlxdTJxQWhveEM4WWFpS3Y2VUxRYmMwdU02c3l1VnkrcEZyRDdzWHFCK1M3Ykh0bitFRjAiLCJtYWMiOiIyNWVkM2QzYTgxOWNmZTcwZGNmNjg4Mjk4YmQyNTY3ODg0MzVkMzMzODNjMTUxM2U4OGYwNzg0ZDExYzljZmVlIiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 02:21:27 GMT; Max-Age=21000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjhvTjA5UGgwTGpEU2RQa0hmODZGckE9PSIsInZhbHVlIjoiYXFpMUlaTHhTVElVeDVMbTMrLzJKc2pMdG9tZFFIZDRDMEdZNmpzeXA2MVlsMjNlTXUrSlFzVUExcFZPekZDWEFmNlhRb ▶" 1 => "us_metro_realty_session=eyJpdiI6IlZPdU55YkphL0wxSlFrWG5UR2wxeWc9PSIsInZhbHVlIjoiZGhMNnVaMEdrZFhVTWZLZjdBT0ExVUR5NjUrM2YydXYwQ3J4ZndVdFFkMTM1SEhNS0k4RlVzcTh5bElZaFJPZktZZjNoblFTUzUwVHpMbFNNMUNhVC9SR3FjZitHRUZrbys1V3FOdlhvbnFIUGR6Kzl5NnNOdFpNNTZKODBzbWwiLCJtYWMiOiI2Yzg4ODEzNDlmODdiNTM3MzdhOTE3ZDUyODAzYTViZTdlN2RkODYxNzJkZWI0ZGZjM2IxZWZkNGFmYTIzZjUyIiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 02:21:27 GMT; Max-Age=21000; path=/; httponly; samesite=lax ◀us_metro_realty_session=eyJpdiI6IlZPdU55YkphL0wxSlFrWG5UR2wxeWc9PSIsInZhbHVlIjoiZGhMNnVaMEdrZFhVTWZLZjdBT0ExVUR5NjUrM2YydXYwQ3J4ZndVdFFkMTM1SEhNS0k4RlVzcTh5bElZ ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjhvTjA5UGgwTGpEU2RQa0hmODZGckE9PSIsInZhbHVlIjoiYXFpMUlaTHhTVElVeDVMbTMrLzJKc2pMdG9tZFFIZDRDMEdZNmpzeXA2MVlsMjNlTXUrSlFzVUExcFZPekZDWEFmNlhRbFVkRnJwZnlxdTJxQWhveEM4WWFpS3Y2VUxRYmMwdU02c3l1VnkrcEZyRDdzWHFCK1M3Ykh0bitFRjAiLCJtYWMiOiIyNWVkM2QzYTgxOWNmZTcwZGNmNjg4Mjk4YmQyNTY3ODg0MzVkMzMzODNjMTUxM2U4OGYwNzg0ZDExYzljZmVlIiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 02:21:27 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjhvTjA5UGgwTGpEU2RQa0hmODZGckE9PSIsInZhbHVlIjoiYXFpMUlaTHhTVElVeDVMbTMrLzJKc2pMdG9tZFFIZDRDMEdZNmpzeXA2MVlsMjNlTXUrSlFzVUExcFZPekZDWEFmNlhRb ▶" 1 => "us_metro_realty_session=eyJpdiI6IlZPdU55YkphL0wxSlFrWG5UR2wxeWc9PSIsInZhbHVlIjoiZGhMNnVaMEdrZFhVTWZLZjdBT0ExVUR5NjUrM2YydXYwQ3J4ZndVdFFkMTM1SEhNS0k4RlVzcTh5bElZaFJPZktZZjNoblFTUzUwVHpMbFNNMUNhVC9SR3FjZitHRUZrbys1V3FOdlhvbnFIUGR6Kzl5NnNOdFpNNTZKODBzbWwiLCJtYWMiOiI2Yzg4ODEzNDlmODdiNTM3MzdhOTE3ZDUyODAzYTViZTdlN2RkODYxNzJkZWI0ZGZjM2IxZWZkNGFmYTIzZjUyIiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 02:21:27 GMT; path=/; httponly ◀us_metro_realty_session=eyJpdiI6IlZPdU55YkphL0wxSlFrWG5UR2wxeWc9PSIsInZhbHVlIjoiZGhMNnVaMEdrZFhVTWZLZjdBT0ExVUR5NjUrM2YydXYwQ3J4ZndVdFFkMTM1SEhNS0k4RlVzcTh5bElZ ▶" ] ]
0 of 0array:4 [▼ "_token" => "tSgENunMuLyOU4rqm4h3mISr667WGdKELd6lN4jx" "_previous" => array:1 [▶ "url" => "https://usmetrorealty.com/web/single-property/details/6823527" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]