1001 Queen Street Unit PH 3904 Honolulu, HI 96814

Listing
Overview

Price: $1,570,000
Area: KAKAAKO
Status: Active

'04' stack unit located Diamond Head side of building with ocean views. Penthouse has 10 FOOT floor-to-ceiling windows which create an open feeling. Sold with additional STORAGE unit, located next to the 4th floor parking stall (P4-069) with EV CHARGER. Another parking stall is Mezz. (PM-026) so easy for getting in and out. Upgraded engineered wood flooring extended from the living areas into all bedrooms, motorized window covering throughout, TOTO Washlet in the main bathroom, installed California closet system in the all closets. Ae'o is located in one of the most desired new neighborhoods in Honolulu at Kakaako, Ward Village near Ala Moana Shopping Center. Ala Moana Beach Park, Magic Island, shopping, theater, and variety of restaurants. First class building amenities include two pools, BBQ pavilions, gym, saunas, movie theater, guest suites, dog play area, play ground, and more. Listing by: Shimizu Gateways Inc (808) 922-2992 

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202502206"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "1001"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(5) "Queen"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(7) "PH 3904"
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96814"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1570000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(901) "'04' stack unit located Diamond Head side of building with ocean views. Penthouse has 10 FOOT floor-to-ceiling windows which create an open feeling. 
Sold with additional STORAGE unit, located next to the 4th floor parking stall (P4-069) with EV CHARGER.  Another parking stall is Mezz. (PM-026) so easy for getting in and out.
Upgraded engineered wood flooring extended from the living areas into all bedrooms, motorized window covering throughout, TOTO Washlet in the main bathroom, installed California closet system in the all closets.
Ae'o is located in one of the most desired new neighborhoods in Honolulu at Kakaako, Ward Village near Ala Moana Shopping Center. Ala Moana Beach Park, Magic Island, shopping, theater, and variety of restaurants.
First class building amenities include two pools, BBQ pavilions, gym, saunas, movie theater, guest suites, dog play area, play ground, and more."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(20) "Shimizu Gateways Inc"
  }
  ["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(3) "978"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2018"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(4) "Ae'o"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "21+"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(37) "City,Coastline,Mountain,Ocean,Sunrise"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1017.57"
  }
  ["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) "ASKA"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(22) "Aki@gatewayshawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 922-2992"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(10) "Aki Nakano"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18498329"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-09-09T22:10:57.073"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-03-06"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "22:10:57.073"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26908646"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26908646"
    [1]=>
    string(8) "26908647"
    [2]=>
    string(8) "26908648"
    [3]=>
    string(8) "26908649"
    [4]=>
    string(8) "26908650"
    [5]=>
    string(8) "26908651"
    [6]=>
    string(8) "26908652"
    [7]=>
    string(8) "26908653"
    [8]=>
    string(8) "26908654"
    [9]=>
    string(8) "26908655"
    [10]=>
    string(8) "26908656"
    [11]=>
    string(8) "26908657"
    [12]=>
    string(8) "26908658"
    [13]=>
    string(8) "26908659"
    [14]=>
    string(8) "26908660"
    [15]=>
    string(8) "26908661"
    [16]=>
    string(8) "26908662"
    [17]=>
    string(8) "26908663"
    [18]=>
    string(8) "26908664"
    [19]=>
    string(8) "26908665"
    [20]=>
    string(8) "26908666"
    [21]=>
    string(8) "26908667"
    [22]=>
    string(8) "26908668"
    [23]=>
    string(8) "26908669"
    [24]=>
    string(8) "26908670"
    [25]=>
    string(8) "26908671"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202502206
        )

    [StreetNumber] => Array
        (
            [0] => 1001
        )

    [PropertyType] => Array
        (
            [0] => Condo/Townhouse
        )

    [StreetName] => Array
        (
            [0] => Queen
        )

    [StreetSuffix] => Array
        (
            [0] => Street
        )

    [UnitNumber] => Array
        (
            [0] => PH 3904
        )

    [City] => Array
        (
            [0] => Honolulu
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96814
        )

    [VirtualTourURLUnbranded] => Array
        (
            [0] => 
        )

    [ListPrice] => Array
        (
            [0] => 1570000.00
        )

    [Neighbourhood] => Array
        (
            [0] => KAKAAKO
        )

    [Status] => Array
        (
            [0] => Active
        )

    [PublicRemarks] => Array
        (
            [0] => '04' stack unit located Diamond Head side of building with ocean views. Penthouse has 10 FOOT floor-to-ceiling windows which create an open feeling. 
Sold with additional STORAGE unit, located next to the 4th floor parking stall (P4-069) with EV CHARGER.  Another parking stall is Mezz. (PM-026) so easy for getting in and out.
Upgraded engineered wood flooring extended from the living areas into all bedrooms, motorized window covering throughout, TOTO Washlet in the main bathroom, installed California closet system in the all closets.
Ae'o is located in one of the most desired new neighborhoods in Honolulu at Kakaako, Ward Village near Ala Moana Shopping Center. Ala Moana Beach Park, Magic Island, shopping, theater, and variety of restaurants.
First class building amenities include two pools, BBQ pavilions, gym, saunas, movie theater, guest suites, dog play area, play ground, and more.
        )

    [ListOfficeName] => Array
        (
            [0] => Shimizu Gateways Inc
        )

    [BedsTotal] => Array
        (
            [0] => 2
        )

    [BathsFull] => Array
        (
            [0] => 2
        )

    [BathsHalf] => Array
        (
            [0] => 0
        )

    [LotSizeArea] => Array
        (
            [0] => 
        )

    [SqftTotal] => Array
        (
            [0] => 978
        )

    [YearBuilt] => Array
        (
            [0] => 2018
        )

    [BuildingName] => Array
        (
            [0] => Ae'o
        )

    [PropertyCondition] => Array
        (
            [0] => Excellent
        )

    [ParkingTotal] => Array
        (
            [0] => 2
        )

    [StoriesType] => Array
        (
            [0] => 21+
        )

    [View] => Array
        (
            [0] => City,Coastline,Mountain,Ocean,Sunrise
        )

    [MaintenanceExpense] => Array
        (
            [0] => 1017.57
        )

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [ElementarySchool] => Array
        (
            [0] => 
        )

    [MiddleOrJuniorSchool] => Array
        (
            [0] => 
        )

    [HighSchool] => Array
        (
            [0] => 
        )

    [ListOfficeMLSID] => Array
        (
            [0] => ASKA
        )

    [ListAgentEmail] => Array
        (
            [0] => Aki@gatewayshawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 922-2992
        )

    [ListAgentFullName] => Array
        (
            [0] => Aki Nakano
        )

    [CloseDate] => Array
        (
            [0] => 
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 18498329
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-09-09T22:10:57.073
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-03-06
        )

    [MLSAreaMajor] => Array
        (
            [0] => Metro
        )

    [PropertyFrontage] => Array
        (
            [0] => 
        )

    [ExemptListingEntryTimestamp] => Array
        (
            [0] => 
        )

    [MatrixModifiedTime] => Array
        (
            [0] => 22:10:57.073
        )

    [_thumbnail_id] => Array
        (
            [0] => 26908646
        )

    [listing_image] => Array
        (
            [0] => 26908646
            [1] => 26908647
            [2] => 26908648
            [3] => 26908649
            [4] => 26908650
            [5] => 26908651
            [6] => 26908652
            [7] => 26908653
            [8] => 26908654
            [9] => 26908655
            [10] => 26908656
            [11] => 26908657
            [12] => 26908658
            [13] => 26908659
            [14] => 26908660
            [15] => 26908661
            [16] => 26908662
            [17] => 26908663
            [18] => 26908664
            [19] => 26908665
            [20] => 26908666
            [21] => 26908667
            [22] => 26908668
            [23] => 26908669
            [24] => 26908670
            [25] => 26908671
        )

)

  • BedsTotal: 2
  • Full Baths: 2
  • Living (sf): 978
  • Year Built: 2018
  • Building Name: Ae'o

  • Property Condition: Excellent
  • Number of Parking Spaces: 2
  • View: City,Coastline,Mountain,Ocean,Sunrise
  • Listing Office: Shimizu Gateways Inc

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

CONTACT US

Marcus Realty

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

Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. listings last updated on September 9, 2025 - 10:10 PM Information is deemed reliable but not guaranteed. Copyright: 2025 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®. If you are interested in those active listings, our company may represent you as the buyer's agent. If the active listing you are interested in is our company's active listing, you may speak to one of our agents regarding your options for representation.

Terms of Use Privacy Policy DMCA Policy
© Marcus Realty. All Rights Reserved.