Previous Next

1001 Queen Street Unit 2404 Honolulu, HI 96814

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202604174"
  }
  ["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(4) "2404"
  }
  ["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) "1260000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(625) "Splendid east-facing 2-bedroom, 2-bath, 2-parking unit at A‘eo in the award-winning Ward Village master planned neighborhood.  Sweet spot in the building on the 24th floor and positioned for wide views of the ocean, Ala Moana beach park and beyond.  Wet room style primary bath with separate shower and soaking tub.  Parking is located on the 2nd floor for extra easy access to Whole Foods, plus a 4'x6' storage unit also on the 2nd floor, making this a best buy!  Ae'o includes a rooftop deck, 2 swimming pools, hot tub, sauna and steam room, fitness center, media & dining rooms, guest suites, theater, dog park and more."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "ILC & Swell Realty LLC"
  }
  ["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(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "21+"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(41) "City,Coastline,Diamond Head,Ocean,Sunrise"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1126.26"
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(9) "Kaahumanu"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(11) "Keelikolani"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(8) "Mckinley"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "ILCS"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(25) "sandy.lau@sandyhawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 271-4079"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(9) "Sandy Lau"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19285444"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-02-23T14:16:57.133"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-02-23"
  }
  ["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) "14:16:57.133"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27313548"
  }
  ["listing_image"]=>
  array(18) {
    [0]=>
    string(8) "27313548"
    [1]=>
    string(8) "27313549"
    [2]=>
    string(8) "27313550"
    [3]=>
    string(8) "27313551"
    [4]=>
    string(8) "27313552"
    [5]=>
    string(8) "27313553"
    [6]=>
    string(8) "27313554"
    [7]=>
    string(8) "27313555"
    [8]=>
    string(8) "27313556"
    [9]=>
    string(8) "27313557"
    [10]=>
    string(8) "27313558"
    [11]=>
    string(8) "27313559"
    [12]=>
    string(8) "27313560"
    [13]=>
    string(8) "27313561"
    [14]=>
    string(8) "27313562"
    [15]=>
    string(8) "27313965"
    [16]=>
    string(8) "27313966"
    [17]=>
    string(8) "27313967"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202604174
        )

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

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

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

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

    [UnitNumber] => Array
        (
            [0] => 2404
        )

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Splendid east-facing 2-bedroom, 2-bath, 2-parking unit at A‘eo in the award-winning Ward Village master planned neighborhood.  Sweet spot in the building on the 24th floor and positioned for wide views of the ocean, Ala Moana beach park and beyond.  Wet room style primary bath with separate shower and soaking tub.  Parking is located on the 2nd floor for extra easy access to Whole Foods, plus a 4'x6' storage unit also on the 2nd floor, making this a best buy!  Ae'o includes a rooftop deck, 2 swimming pools, hot tub, sauna and steam room, fitness center, media & dining rooms, guest suites, theater, dog park and more.
        )

    [ListOfficeName] => Array
        (
            [0] => ILC & Swell Realty LLC
        )

    [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] => Above Average
        )

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => sandy.lau@sandyhawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 271-4079
        )

    [ListAgentFullName] => Array
        (
            [0] => Sandy Lau
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-02-23T14:16:57.133
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-02-23
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 14:16:57.133
        )

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

    [listing_image] => Array
        (
            [0] => 27313548
            [1] => 27313549
            [2] => 27313550
            [3] => 27313551
            [4] => 27313552
            [5] => 27313553
            [6] => 27313554
            [7] => 27313555
            [8] => 27313556
            [9] => 27313557
            [10] => 27313558
            [11] => 27313559
            [12] => 27313560
            [13] => 27313561
            [14] => 27313562
            [15] => 27313965
            [16] => 27313966
            [17] => 27313967
        )

)

PROPERTY INFO

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

KEY FEATURES

• Property Condition: Above Average
• Number of Parking Spaces: 2
• View: City,Coastline,Diamond Head,Ocean,Sunrise
• Listing Office: ILC & Swell Realty LLC

FINANCIAL INFO

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

SCHOOLS

• Elementary School: Kaahumanu
• Middle School: Keelikolani
• 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 February 23, 2026 - 2:16 PM 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.