Don't miss out on this extraordinary opportunity to become the proud owner of Arizona's most storied hotel. The Copper Queen boasts a bar & restaurant and 48 meticulously remodeled rooms and suites, each appointed with private bathrooms. Every space is adorned with period antiques, vibrant wallpaper, sumptuous curtains, and luxurious bedding, evoking the opulence of a bygone era. The hotel has undergone a meticulous restoration since 2017, preserving its heritage while integrating modern upgrades where necessary. As the largest hotel in Bisbee, boasting both a pool and an elevator, acquiring the Copper Queen represents not just a sound investment but a legacy of pride and distinction. Don't miss your chance to write the next chapter in this timeless tale and legacy of hospitality.
Take Hwy 90 East to the Y, turn right onto Hwy 80,
Take the exit toward Old Bisbee/Historic Dist
Keep right at the fork towards Main St
Turn Right to Brewery Ave then left onto Howell
Dwelling Type: Comm/Industry Sale
Subdivision: BISBEE
Year Built: 1902, County:
Take Hwy 90 East to the Y, turn right onto Hwy 80,
Take the exit toward Old Bisbee/Historic Dist
Keep right at the fork towards Main St
Turn Right to Brewery Ave then left onto Howell
Listing is courtesy of Long Realty Company
1 x Application (98.85%) | 1.03s |
1 x Booting (1.14%) | 11.79ms |
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` = '6764935' limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `reso_property_saves` where `reso_property_saves`.`ListingId` = 561858 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 `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/6764935" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_URL" => "/web/single-property/details/6764935" "REMOTE_PORT" => "55640" "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" => "216.73.217.5" "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" => "2260587-86-9" "H2_STREAM_ID" => "9" "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/6764935" "SCRIPT_URL" => "/web/single-property/details/6764935" "UNIQUE_ID" => "aGxphq2-hsUFgZ4PiDyVuAAA0xU" "REDIRECT_STATUS" => "200" "REDIRECT_H2_STREAM_TAG" => "2260587-86-9" "REDIRECT_H2_STREAM_ID" => "9" "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/6764935" "REDIRECT_SCRIPT_URL" => "/web/single-property/details/6764935" "REDIRECT_UNIQUE_ID" => "aGxphq2-hsUFgZ4PiDyVuAAA0xU" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1751935366.1772 "REQUEST_TIME" => 1751935366 "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 => "Tue, 08 Jul 2025 00:42:46 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjdBVlZwV29Xai9DVFdTSklwM0ZqdXc9PSIsInZhbHVlIjoiVThwU0k2RWo2T085YUhERFVFMjBZQkIyQktLazRETkR2TWMvQXZ4TlZZTjFFSHl0U0pib00vRUh2SlU3emlDNmg3Y1B6aG11ZnA5d2JYRGk1RmhIbmZPU2hzcGgwK1EwZ3V5Y3ppRWlsMmx2dTNVeExra2NQT3VDdUNtMkRLbHUiLCJtYWMiOiIwNDdiYjgwNTAwZWQ2MjUwOTM3ODVhNTRiNGRhYjJhMTdhOGY4OWYxNWIwYmZlZmMzYTY1NGYyMGNlMjQ2NzRmIiwidGFnIjoiIn0%3D; expires=Tue, 08-Jul-2025 06:32:47 GMT; Max-Age=21000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjdBVlZwV29Xai9DVFdTSklwM0ZqdXc9PSIsInZhbHVlIjoiVThwU0k2RWo2T085YUhERFVFMjBZQkIyQktLazRETkR2TWMvQXZ4TlZZTjFFSHl0U0pib00vRUh2SlU3emlDNmg3Y1B6a ▶" 1 => "us_metro_realty_session=eyJpdiI6ImU5OVpHOVFEMWVhYWNxTFFzZVhDMHc9PSIsInZhbHVlIjoiQnhORHI4KzBUV2VuUjdMTlNVMTNrUGdKUjl1UkQ4OUUxT3ZIQlZ2TTUwakd4RWZ5bVVzY0hjZ1B4dXZyLzBXeUVWN2taWjV2S0E1VlJYVCtzUjk3clRUQVMxQ2VOVE5CMWpkMTJoQlpyb0RkNFhXR2hVbjhFZ1NwMWpKZXFud1YiLCJtYWMiOiJmMDU2ZTEzZjVmNzJlNGNiYmNjOGYwNzdlNDVkN2Q3MDZlYjM3ZjIwMTNiMTM2M2EyNGVkOGY3MmIyMTUwMmQ3IiwidGFnIjoiIn0%3D; expires=Tue, 08-Jul-2025 06:32:47 GMT; Max-Age=21000; path=/; httponly; samesite=lax ◀us_metro_realty_session=eyJpdiI6ImU5OVpHOVFEMWVhYWNxTFFzZVhDMHc9PSIsInZhbHVlIjoiQnhORHI4KzBUV2VuUjdMTlNVMTNrUGdKUjl1UkQ4OUUxT3ZIQlZ2TTUwakd4RWZ5bVVzY0hjZ1B4dXZy ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjdBVlZwV29Xai9DVFdTSklwM0ZqdXc9PSIsInZhbHVlIjoiVThwU0k2RWo2T085YUhERFVFMjBZQkIyQktLazRETkR2TWMvQXZ4TlZZTjFFSHl0U0pib00vRUh2SlU3emlDNmg3Y1B6aG11ZnA5d2JYRGk1RmhIbmZPU2hzcGgwK1EwZ3V5Y3ppRWlsMmx2dTNVeExra2NQT3VDdUNtMkRLbHUiLCJtYWMiOiIwNDdiYjgwNTAwZWQ2MjUwOTM3ODVhNTRiNGRhYjJhMTdhOGY4OWYxNWIwYmZlZmMzYTY1NGYyMGNlMjQ2NzRmIiwidGFnIjoiIn0%3D; expires=Tue, 08-Jul-2025 06:32:47 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjdBVlZwV29Xai9DVFdTSklwM0ZqdXc9PSIsInZhbHVlIjoiVThwU0k2RWo2T085YUhERFVFMjBZQkIyQktLazRETkR2TWMvQXZ4TlZZTjFFSHl0U0pib00vRUh2SlU3emlDNmg3Y1B6a ▶" 1 => "us_metro_realty_session=eyJpdiI6ImU5OVpHOVFEMWVhYWNxTFFzZVhDMHc9PSIsInZhbHVlIjoiQnhORHI4KzBUV2VuUjdMTlNVMTNrUGdKUjl1UkQ4OUUxT3ZIQlZ2TTUwakd4RWZ5bVVzY0hjZ1B4dXZyLzBXeUVWN2taWjV2S0E1VlJYVCtzUjk3clRUQVMxQ2VOVE5CMWpkMTJoQlpyb0RkNFhXR2hVbjhFZ1NwMWpKZXFud1YiLCJtYWMiOiJmMDU2ZTEzZjVmNzJlNGNiYmNjOGYwNzdlNDVkN2Q3MDZlYjM3ZjIwMTNiMTM2M2EyNGVkOGY3MmIyMTUwMmQ3IiwidGFnIjoiIn0%3D; expires=Tue, 08-Jul-2025 06:32:47 GMT; path=/; httponly ◀us_metro_realty_session=eyJpdiI6ImU5OVpHOVFEMWVhYWNxTFFzZVhDMHc9PSIsInZhbHVlIjoiQnhORHI4KzBUV2VuUjdMTlNVMTNrUGdKUjl1UkQ4OUUxT3ZIQlZ2TTUwakd4RWZ5bVVzY0hjZ1B4dXZy ▶" ] ]
0 of 0array:4 [▼ "_token" => "pMRtF1H9nYsSbfUBijh9kc4PTawWEzAA5spxUjCM" "_previous" => array:1 [▶ "url" => "https://usmetrorealty.com/web/single-property/details/6764935" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]