Discover the charm of this custom-built, private residence set on 1.2 acres, ready for you to call home. Relish in the stunning mountain sunrises from your covered back deck or 360° views from the rooftop deck, offering ever-changing panoramic views of the McDowell, Mazatzal, Four Peaks, Granite, and Superstition mountains.
This elegant home boasts solid Knotty Alder cabinetry throughout, a split floor plan, 10-foot vaulted ceilings, and solid wood beams in the entryway. The spacious living room features a cozy corner fireplace, while the oversized laundry room provides ample storage.
The master suite opens to a private courtyard with mountain views. The en suite bathroom includes a generous closet, walk-in shower, soaking tub, and dual vanity sinks. The beautifully designed kitchen is a culinary enthusiast's dream, with a large center island, substantial pantry, wine cooler, large oven and warming drawer, granite counters, and a large granite sink. The kitchen flows seamlessly into a spacious dining area, perfect for entertaining.
Adjacent to the courtyard and main home, the 337 sqft private casita features its own entrance, full bath, oversized closet space, mini-split HVAC, and water heater.
This charming home sits on over an acre of land and includes a private dog run, three-car oversized garage, and a 2600-gallon water storage tank. Assured water for the property is provided by EPCOR and monitored by Dynamite Water Co. No HOA fees. Bring your horses, RV, boat, farm animals, and toys. This home is ready for you to move in and make it your own.
E RIO VERDE DRIVE, LT ON N. 172ND STREET, LT LOWDEN ROAD, HOME IS THE THIRD HOME ON THE LEFT. SIGN AT DRIVEWAY.
Dwelling Type: Residential
Subdivision: Metes and bounds
Year Built: 2008, County: US
E RIO VERDE DRIVE, LT ON N. 172ND STREET, LT LOWDEN ROAD, HOME IS THE THIRD HOME ON THE LEFT. SIGN AT DRIVEWAY.
Listing is courtesy of
1 x Application (99.5%) | 2.02s |
1 x Booting (0.49%) | 10.05ms |
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` = '6761212' limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `reso_property_saves` where `reso_property_saves`.`ListingId` = 92031 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/6761212" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_URL" => "/web/single-property/details/6761212" "REMOTE_PORT" => "11959" "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.227.197" "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" => "2215049-483-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/6761212" "SCRIPT_URL" => "/web/single-property/details/6761212" "UNIQUE_ID" => "aBGOL0D-4ou8khnIUs1asQABQAg" "REDIRECT_STATUS" => "200" "REDIRECT_H2_STREAM_TAG" => "2215049-483-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/6761212" "REDIRECT_SCRIPT_URL" => "/web/single-property/details/6761212" "REDIRECT_UNIQUE_ID" => "aBGOL0D-4ou8khnIUs1asQABQAg" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1745980975.7263 "REQUEST_TIME" => 1745980975 "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 02:42:55 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjNmSmtnMVBjODF1RVVZdkFtTVNlenc9PSIsInZhbHVlIjoidTRnektockxQSFhHNC9KbkxIZUV5OHl0dHUySTd2eGVLVnVrL3Jhb09rZ0JrV1REN0hkY2xGWDJqRHVFeENZQnpRY0hIeUFzUmlLRnRGaEwvRlVzeDZLYk9zL3lsdlVUYkdXNldqYUZqZjZ4bnkrbEpLc01ha3VhZllzeExQc1QiLCJtYWMiOiJhNzRlNWQ3NGMxYzk0MzZhNzIyMzQwZTU1NmMxZTdmMmIxYjZjYWQ3YTcwY2E2MjQzMDdkNDE3NjllNzE5ZmI3IiwidGFnIjoiIn0%3D; expires=Wed, 30-Apr-2025 08:32:57 GMT; Max-Age=21000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjNmSmtnMVBjODF1RVVZdkFtTVNlenc9PSIsInZhbHVlIjoidTRnektockxQSFhHNC9KbkxIZUV5OHl0dHUySTd2eGVLVnVrL3Jhb09rZ0JrV1REN0hkY2xGWDJqRHVFeENZQnpRY0hIe ▶" 1 => "us_metro_realty_session=eyJpdiI6InhtUkVpRHlWdmdQY1dVSnJYekQ1dlE9PSIsInZhbHVlIjoiaUs3UFZrNDZUM29IVUdrSDVIdCt2dVFpemNFc0NsZ210Y2lxc3ZnRFBFS2ZSSU1lSEVmTHZCNUVHanFGSnJ4eGptQVVtcFVuR0Y5RlNmQmRCQTZFWVhUWHZ0aWVXWGVwZ3hMYTJjV1BBVXR2aDl0Yy8xL3JhbzlRc0xBbVpWeXMiLCJtYWMiOiJlZTFjZThjZDQ0ZDEyMjRlZGRiZTg2OTkxNzQ1ODRkZmU5MWE4MTVhMzRhMjYwZjY2M2M4ZmJkZDI2YTZiMWRkIiwidGFnIjoiIn0%3D; expires=Wed, 30-Apr-2025 08:32:57 GMT; Max-Age=21000; path=/; httponly; samesite=lax ◀us_metro_realty_session=eyJpdiI6InhtUkVpRHlWdmdQY1dVSnJYekQ1dlE9PSIsInZhbHVlIjoiaUs3UFZrNDZUM29IVUdrSDVIdCt2dVFpemNFc0NsZ210Y2lxc3ZnRFBFS2ZSSU1lSEVmTHZCNUVHanFG ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjNmSmtnMVBjODF1RVVZdkFtTVNlenc9PSIsInZhbHVlIjoidTRnektockxQSFhHNC9KbkxIZUV5OHl0dHUySTd2eGVLVnVrL3Jhb09rZ0JrV1REN0hkY2xGWDJqRHVFeENZQnpRY0hIeUFzUmlLRnRGaEwvRlVzeDZLYk9zL3lsdlVUYkdXNldqYUZqZjZ4bnkrbEpLc01ha3VhZllzeExQc1QiLCJtYWMiOiJhNzRlNWQ3NGMxYzk0MzZhNzIyMzQwZTU1NmMxZTdmMmIxYjZjYWQ3YTcwY2E2MjQzMDdkNDE3NjllNzE5ZmI3IiwidGFnIjoiIn0%3D; expires=Wed, 30-Apr-2025 08:32:57 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjNmSmtnMVBjODF1RVVZdkFtTVNlenc9PSIsInZhbHVlIjoidTRnektockxQSFhHNC9KbkxIZUV5OHl0dHUySTd2eGVLVnVrL3Jhb09rZ0JrV1REN0hkY2xGWDJqRHVFeENZQnpRY0hIe ▶" 1 => "us_metro_realty_session=eyJpdiI6InhtUkVpRHlWdmdQY1dVSnJYekQ1dlE9PSIsInZhbHVlIjoiaUs3UFZrNDZUM29IVUdrSDVIdCt2dVFpemNFc0NsZ210Y2lxc3ZnRFBFS2ZSSU1lSEVmTHZCNUVHanFGSnJ4eGptQVVtcFVuR0Y5RlNmQmRCQTZFWVhUWHZ0aWVXWGVwZ3hMYTJjV1BBVXR2aDl0Yy8xL3JhbzlRc0xBbVpWeXMiLCJtYWMiOiJlZTFjZThjZDQ0ZDEyMjRlZGRiZTg2OTkxNzQ1ODRkZmU5MWE4MTVhMzRhMjYwZjY2M2M4ZmJkZDI2YTZiMWRkIiwidGFnIjoiIn0%3D; expires=Wed, 30-Apr-2025 08:32:57 GMT; path=/; httponly ◀us_metro_realty_session=eyJpdiI6InhtUkVpRHlWdmdQY1dVSnJYekQ1dlE9PSIsInZhbHVlIjoiaUs3UFZrNDZUM29IVUdrSDVIdCt2dVFpemNFc0NsZ210Y2lxc3ZnRFBFS2ZSSU1lSEVmTHZCNUVHanFG ▶" ] ]
0 of 0array:4 [▼ "_token" => "7B2sueJy7rrXK6Qw0nI4YhUjACPnHQCZBDP3BrR3" "_previous" => array:1 [▶ "url" => "https://usmetrorealty.com/web/single-property/details/6761212" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]