1200 Queen Emma Street Unit 3207 Honolulu, HI 96813

Listing
Overview

Price: $945,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) "945000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "945000.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-10-17T14:02:57.803"
  }
  ["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] => 945000.00
        )

    [CurrentPrice] => Array
        (
            [0] => 945000.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-10-17T14:02:57.803
        )

    [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
        )

)

  • BedsTotal: 2
  • Full Baths: 2
  • Living (sf): 1,040
  • Year Built: 2008
  • Building Name: Capitol Place

  • Property Condition: Above Average
  • Number of Parking Spaces: 2
  • View: Diamond Head,Mountain,Ocean
  • Listing Office: Keller Williams Honolulu

  • Maintenance Fees: $1,218
  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446