Our office will be closed on November 28 and 29, 2024, for Thanksgiving and the Day After Thanksgiving.
1200 Queen Emma Street Unit 3207 Honolulu, HI 96813
Listing Overview
Price: $910,000 Area: DOWNTOWN Status: Active
Step into unparalleled elegance and breathtaking views from this luxurious 2-bedroom, 2-bathroom condominium, nestled in the heart of downtown Honolulu. With sweeping panoramic vistas that stretch from the serene mountains to the sparkling ocean and iconic Diamond Head, this is your sanctuary in the sky. This modern residence features a gourmet kitchen equipped with top-of-the-line stainless steel Viking appliances and exquisite natural stone countertops, perfect for the at-home chef. Relax in comfort with automated electric blinds and floor-to-ceiling windows, allowing you to soak in the mesmerizing views from every room. Indulge in resort-style amenities including a heated infinity pool, a spacious Jacuzzi, a state-of-the-art exercise room, media and music studios, and a tranquil yoga room. Entertain in style with BBQ areas, while your four-legged friends enjoy the dedicated dog park. There’s also a children’s play area. Located in downtown Honolulu, you’ll be just steps away from world-class dining, shopping, and entertainment. Don't miss the opportunity to own a piece of paradise! Listing by: Keller Williams Honolulu (808) 228-8209
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202424018"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "1200"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(10) "Queen Emma"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(4) "3207"
}
["City"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96813"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "910000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "910000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "DOWNTOWN"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1107) "Step into unparalleled elegance and breathtaking views from this luxurious 2-bedroom, 2-bathroom condominium, nestled in the heart of downtown Honolulu. With sweeping panoramic vistas that stretch from the serene mountains to the sparkling ocean and iconic Diamond Head, this is your sanctuary in the sky. This modern residence features a gourmet kitchen equipped with top-of-the-line stainless steel Viking appliances and exquisite natural stone countertops, perfect for the at-home chef. Relax in comfort with automated electric blinds and floor-to-ceiling windows, allowing you to soak in the mesmerizing views from every room. Indulge in resort-style amenities including a heated infinity pool, a spacious Jacuzzi, a state-of-the-art exercise room, media and music studios, and a tranquil yoga room. Entertain in style with BBQ areas, while your four-legged friends enjoy the dedicated dog park. There’s also a children’s play area. Located in downtown Honolulu, you’ll be just steps away from world-class dining, shopping, and entertainment. Don't miss the opportunity to own a piece of paradise!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(24) "Keller Williams Honolulu"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1040"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2008"
}
["BuildingName"]=>
array(1) {
[0]=>
string(13) "Capitol Place"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(0) ""
}
["View"]=>
array(1) {
[0]=>
string(27) "Diamond Head,Mountain,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1217.89"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(0) ""
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "KWPP"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(18) "deanueda@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 228-8209"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(16) "Dean Hiromi Ueda"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-11-05T07:55:44.390"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18327423"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-16T11:45:31.063"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26735615"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26735615"
[1]=>
string(8) "26735616"
[2]=>
string(8) "26735617"
[3]=>
string(8) "26735618"
[4]=>
string(8) "26735619"
[5]=>
string(8) "26735620"
[6]=>
string(8) "26735621"
[7]=>
string(8) "26735622"
[8]=>
string(8) "26735623"
[9]=>
string(8) "26735624"
[10]=>
string(8) "26735625"
[11]=>
string(8) "26735626"
[12]=>
string(8) "26735627"
[13]=>
string(8) "26735628"
[14]=>
string(8) "26735629"
[15]=>
string(8) "26735630"
[16]=>
string(8) "26735631"
[17]=>
string(8) "26735632"
[18]=>
string(8) "26735633"
[19]=>
string(8) "26735634"
[20]=>
string(8) "26735635"
[21]=>
string(8) "26735636"
[22]=>
string(8) "26735637"
[23]=>
string(8) "26735638"
[24]=>
string(8) "26735639"
[25]=>
string(8) "26735640"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202424018
)
[StreetNumber] => Array
(
[0] => 1200
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Queen Emma
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 3207
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96813
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 910000.00
)
[CurrentPrice] => Array
(
[0] => 910000.00
)
[Neighbourhood] => Array
(
[0] => DOWNTOWN
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Step into unparalleled elegance and breathtaking views from this luxurious 2-bedroom, 2-bathroom condominium, nestled in the heart of downtown Honolulu. With sweeping panoramic vistas that stretch from the serene mountains to the sparkling ocean and iconic Diamond Head, this is your sanctuary in the sky. This modern residence features a gourmet kitchen equipped with top-of-the-line stainless steel Viking appliances and exquisite natural stone countertops, perfect for the at-home chef. Relax in comfort with automated electric blinds and floor-to-ceiling windows, allowing you to soak in the mesmerizing views from every room. Indulge in resort-style amenities including a heated infinity pool, a spacious Jacuzzi, a state-of-the-art exercise room, media and music studios, and a tranquil yoga room. Entertain in style with BBQ areas, while your four-legged friends enjoy the dedicated dog park. There’s also a children’s play area. Located in downtown Honolulu, you’ll be just steps away from world-class dining, shopping, and entertainment. Don't miss the opportunity to own a piece of paradise!
)
[ListOfficeName] => Array
(
[0] => Keller Williams Honolulu
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 1040
)
[YearBuilt] => Array
(
[0] => 2008
)
[BuildingName] => Array
(
[0] => Capitol Place
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Diamond Head,Mountain,Ocean
)
[MaintenanceExpense] => Array
(
[0] => 1217.89
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => KWPP
)
[ListAgentEmail] => Array
(
[0] => deanueda@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 228-8209
)
[ListAgentFullName] => Array
(
[0] => Dean Hiromi Ueda
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-11-05T07:55:44.390
)
[Matrix_Unique_ID] => Array
(
[0] => 18327423
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-16T11:45:31.063
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26735615
)
[listing_image] => Array
(
[0] => 26735615
[1] => 26735616
[2] => 26735617
[3] => 26735618
[4] => 26735619
[5] => 26735620
[6] => 26735621
[7] => 26735622
[8] => 26735623
[9] => 26735624
[10] => 26735625
[11] => 26735626
[12] => 26735627
[13] => 26735628
[14] => 26735629
[15] => 26735630
[16] => 26735631
[17] => 26735632
[18] => 26735633
[19] => 26735634
[20] => 26735635
[21] => 26735636
[22] => 26735637
[23] => 26735638
[24] => 26735639
[25] => 26735640
)
)