This well-maintained 4-bedroom, 2.5-bathroom home in a quiet North Phoenix community offers comfort and convenience, with easy access to SR51 and Loop 101. The open floor plan features high ceilings and plenty of natural light, with multiple living and dining areas. Upstairs, the spacious primary suite includes a dual-sink bathroom, soaking tub, and separate shower. Three additional bedrooms share a full bathroom, and a flexible loft space can serve as an office or gym.
The beautifully landscaped backyard boasts a private, low-maintenance oasis with a covered patio ideal for outdoor dining or relaxation. With quick access to WestWorld and TPC Scottsdale, and with State Farm Stadium only 30 minutes away, this home is perfect for event-goers and sports fans, Whether for Airbnb, VRBO, or your own personal retreat, this home offers an unbeatable location and opportunity.
North of E Beardsley Road to E Yukon Drive. Go East on E Yukon Drive to N 32nd Place. Go South on N 32nd Place to Blackhawk. Go east on E Blackhawk Drive to 33rd Place. House on left of 33rd Place.
Dwelling Type: Residential
Subdivision: SPRINGFIELD PARK
Year Built: 1996, County: US
North of E Beardsley Road to E Yukon Drive. Go East on E Yukon Drive to N 32nd Place. Go South on N 32nd Place to Blackhawk. Go east on E Blackhawk Drive to 33rd Place. House on left of 33rd Place.
Listing is courtesy of K & C Realty LLC
1 x Application (99.46%) | 2.01s |
1 x Booting (0.53%) | 10.70ms |
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` = '6804534' limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `reso_property_saves` where `reso_property_saves`.`ListingId` = 328790 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/6804534" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_URL" => "/web/single-property/details/6804534" "REMOTE_PORT" => "18619" "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.141.2.184" "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" => "636552-831-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/6804534" "SCRIPT_URL" => "/web/single-property/details/6804534" "UNIQUE_ID" => "aB0yCJ4YoiXdlopnwaDTUQAAExU" "REDIRECT_STATUS" => "200" "REDIRECT_H2_STREAM_TAG" => "636552-831-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/6804534" "REDIRECT_SCRIPT_URL" => "/web/single-property/details/6804534" "REDIRECT_UNIQUE_ID" => "aB0yCJ4YoiXdlopnwaDTUQAAExU" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1746743816.314 "REQUEST_TIME" => 1746743816 "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 22:36:56 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ik5FWS9zc0w0NUdrUkhjN1NlSFAxZHc9PSIsInZhbHVlIjoieTh5OFpWenowRENXU1d6Y3ZzWVhkWW1ScmhWT1o3N1cvVTV5SFZJVVVZMkZMb2RJVHg5WnFQUkE4bXZTMUQxT2FhVWpST2tYWEtzbmNra3l2Z2p0OTdQMXVGclRSWUpCWWJyZzlWWS9RNEVmazRkWGU5bEtlVDl4bzV1K1hOcy8iLCJtYWMiOiI2NWNiMmFjMjg3MzE0NjRiMmM5ODZjNjc3NDQ1Y2QxZDJhYzljZDRlMGY0ZTYzNmM5ZWUyMDQzMTU3ZGRlNTQyIiwidGFnIjoiIn0%3D; expires=Fri, 09-May-2025 04:26:58 GMT; Max-Age=21000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ik5FWS9zc0w0NUdrUkhjN1NlSFAxZHc9PSIsInZhbHVlIjoieTh5OFpWenowRENXU1d6Y3ZzWVhkWW1ScmhWT1o3N1cvVTV5SFZJVVVZMkZMb2RJVHg5WnFQUkE4bXZTMUQxT2FhVWpST ▶" 1 => "us_metro_realty_session=eyJpdiI6IndTZWtUZUswakhQWlJET3doZXYrSkE9PSIsInZhbHVlIjoiTUlhZXF2S2NrNWYzNTUzbnVINGErZlZ2MWV2Y1lmK1UwNVgrTnpndkZyZC9RS0ZyVVBDYUVESnVYZVF1dzRldkdtY21yakkwQnVVbDl0TGYyWURZbmhJQmphVE0raEZJRGRxNUtWZ2dDQ0FZRStsMGpHY3lrRUl3aUpmdGF2YnciLCJtYWMiOiJiNjMwYmMzMDk4OGIwOWY5NDJiYWI1YTM3NWNmZDIzMWU2ZjM0ODUxYjUyZTY3YjA1NjQ4Mjc3MTU2N2MyMmZlIiwidGFnIjoiIn0%3D; expires=Fri, 09-May-2025 04:26:58 GMT; Max-Age=21000; path=/; httponly; samesite=lax ◀us_metro_realty_session=eyJpdiI6IndTZWtUZUswakhQWlJET3doZXYrSkE9PSIsInZhbHVlIjoiTUlhZXF2S2NrNWYzNTUzbnVINGErZlZ2MWV2Y1lmK1UwNVgrTnpndkZyZC9RS0ZyVVBDYUVESnVYZVF1 ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ik5FWS9zc0w0NUdrUkhjN1NlSFAxZHc9PSIsInZhbHVlIjoieTh5OFpWenowRENXU1d6Y3ZzWVhkWW1ScmhWT1o3N1cvVTV5SFZJVVVZMkZMb2RJVHg5WnFQUkE4bXZTMUQxT2FhVWpST2tYWEtzbmNra3l2Z2p0OTdQMXVGclRSWUpCWWJyZzlWWS9RNEVmazRkWGU5bEtlVDl4bzV1K1hOcy8iLCJtYWMiOiI2NWNiMmFjMjg3MzE0NjRiMmM5ODZjNjc3NDQ1Y2QxZDJhYzljZDRlMGY0ZTYzNmM5ZWUyMDQzMTU3ZGRlNTQyIiwidGFnIjoiIn0%3D; expires=Fri, 09-May-2025 04:26:58 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ik5FWS9zc0w0NUdrUkhjN1NlSFAxZHc9PSIsInZhbHVlIjoieTh5OFpWenowRENXU1d6Y3ZzWVhkWW1ScmhWT1o3N1cvVTV5SFZJVVVZMkZMb2RJVHg5WnFQUkE4bXZTMUQxT2FhVWpST ▶" 1 => "us_metro_realty_session=eyJpdiI6IndTZWtUZUswakhQWlJET3doZXYrSkE9PSIsInZhbHVlIjoiTUlhZXF2S2NrNWYzNTUzbnVINGErZlZ2MWV2Y1lmK1UwNVgrTnpndkZyZC9RS0ZyVVBDYUVESnVYZVF1dzRldkdtY21yakkwQnVVbDl0TGYyWURZbmhJQmphVE0raEZJRGRxNUtWZ2dDQ0FZRStsMGpHY3lrRUl3aUpmdGF2YnciLCJtYWMiOiJiNjMwYmMzMDk4OGIwOWY5NDJiYWI1YTM3NWNmZDIzMWU2ZjM0ODUxYjUyZTY3YjA1NjQ4Mjc3MTU2N2MyMmZlIiwidGFnIjoiIn0%3D; expires=Fri, 09-May-2025 04:26:58 GMT; path=/; httponly ◀us_metro_realty_session=eyJpdiI6IndTZWtUZUswakhQWlJET3doZXYrSkE9PSIsInZhbHVlIjoiTUlhZXF2S2NrNWYzNTUzbnVINGErZlZ2MWV2Y1lmK1UwNVgrTnpndkZyZC9RS0ZyVVBDYUVESnVYZVF1 ▶" ] ]
0 of 0array:4 [▼ "_token" => "Kr5B9gDMJbpawF4Oz2KkhIDBLA75PAXnZ3R1KVl0" "_previous" => array:1 [▶ "url" => "https://usmetrorealty.com/web/single-property/details/6804534" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]