Previous Next

1001 Queen Street Unit PH 4004 Honolulu, HI 96814

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202616550"
  }
  ["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 4004"
  }
  ["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) "1550000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1115) "Ae'o PH #4004 is a distinctive 2BD/2BA penthouse residence offering expansive Pacific Ocean, Ala Moana Beach Park, Diamond Head, city skyline and mountain views. The 04-stack floor plan features approximately 10-ft ceilings and floor-to-ceiling windows, creating an open and light-filled living environment with sunrise views and natural trade winds. The split-bedroom layout provides privacy, with bedrooms positioned on opposite sides of the living area. Features include engineered wood flooring throughout the living area and bedrooms, motorized window curtains, central A/C, contemporary kitchen with quartz countertops and Bosch appliances. Includes 2 standard-size parking stalls and a deeded storage unit (80 SF). Ae'o is directly connected to Whole Foods Market and offers resort-style amenities including lap and leisure pools, hot tub, BBQ cabanas, fitness center, yoga room, movie theater, playground, spa with steam and dry sauna, dog park, guest suites, and a 41st-floor Sky Deck with panoramic views. Conveniently located in Ward Village near Ala Moana Beach Park, shopping, dining and entertainment."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(25) "CENTURY 21 Hawaiian Style"
  }
  ["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) "2019"
  }
  ["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(18) "City,Ocean,Sunrise"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1126.00"
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(9) "Kaahumanu"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(10) "Washington"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(8) "Mckinley"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "HSTL"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(22) "aimee.hawaii@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 561-3050"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(9) "Aimee Kim"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19674634"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-08-29T11:07:33.473"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-08-29"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "11:07:33.473"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27507834"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27507834"
    [1]=>
    string(8) "27507835"
    [2]=>
    string(8) "27507836"
    [3]=>
    string(8) "27507837"
    [4]=>
    string(8) "27507838"
    [5]=>
    string(8) "27507839"
    [6]=>
    string(8) "27507840"
    [7]=>
    string(8) "27507841"
    [8]=>
    string(8) "27507842"
    [9]=>
    string(8) "27507843"
    [10]=>
    string(8) "27507844"
    [11]=>
    string(8) "27507845"
    [12]=>
    string(8) "27507846"
    [13]=>
    string(8) "27507847"
    [14]=>
    string(8) "27507848"
    [15]=>
    string(8) "27507849"
    [16]=>
    string(8) "27507850"
    [17]=>
    string(8) "27507851"
    [18]=>
    string(8) "27507852"
    [19]=>
    string(8) "27507853"
    [20]=>
    string(8) "27507854"
    [21]=>
    string(8) "27507855"
    [22]=>
    string(8) "27507856"
    [23]=>
    string(8) "27507857"
    [24]=>
    string(8) "27507858"
    [25]=>
    string(8) "27507859"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202616550
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Ae'o PH #4004 is a distinctive 2BD/2BA penthouse residence offering expansive Pacific Ocean, Ala Moana Beach Park, Diamond Head, city skyline and mountain views. The 04-stack floor plan features approximately 10-ft ceilings and floor-to-ceiling windows, creating an open and light-filled living environment with sunrise views and natural trade winds. The split-bedroom layout provides privacy, with bedrooms positioned on opposite sides of the living area. Features include engineered wood flooring throughout the living area and bedrooms, motorized window curtains, central A/C, contemporary kitchen with quartz countertops and Bosch appliances. Includes 2 standard-size parking stalls and a deeded storage unit (80 SF). Ae'o is directly connected to Whole Foods Market and offers resort-style amenities including lap and leisure pools, hot tub, BBQ cabanas, fitness center, yoga room, movie theater, playground, spa with steam and dry sauna, dog park, guest suites, and a 41st-floor Sky Deck with panoramic views. Conveniently located in Ward Village near Ala Moana Beach Park, shopping, dining and entertainment.
        )

    [ListOfficeName] => Array
        (
            [0] => CENTURY 21 Hawaiian Style
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => aimee.hawaii@gmail.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 561-3050
        )

    [ListAgentFullName] => Array
        (
            [0] => Aimee Kim
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-08-29T11:07:33.473
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-08-29
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 11:07:33.473
        )

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

    [listing_image] => Array
        (
            [0] => 27507834
            [1] => 27507835
            [2] => 27507836
            [3] => 27507837
            [4] => 27507838
            [5] => 27507839
            [6] => 27507840
            [7] => 27507841
            [8] => 27507842
            [9] => 27507843
            [10] => 27507844
            [11] => 27507845
            [12] => 27507846
            [13] => 27507847
            [14] => 27507848
            [15] => 27507849
            [16] => 27507850
            [17] => 27507851
            [18] => 27507852
            [19] => 27507853
            [20] => 27507854
            [21] => 27507855
            [22] => 27507856
            [23] => 27507857
            [24] => 27507858
            [25] => 27507859
        )

)

PROPERTY INFO

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

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 2
• View: City,Ocean,Sunrise
• Listing Office: CENTURY 21 Hawaiian Style

FINANCIAL INFO

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

SCHOOLS

• Elementary School: Kaahumanu
• Middle School: Washington
• High School: Mckinley

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 August 29, 2026 - 11:07 AM Information is deemed reliable but not guaranteed. Copyright: 2026 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.