Previous Next

1001 Queen Street Unit 2504 Honolulu, HI 96814

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202518896"
  }
  ["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) "2504"
  }
  ["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) "1275000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1205) "Price adjustment, motivated sellers! Best value in Kakaako-Ward Village! 
Elevate your lifestyle in this stunning high-floor residence at A‘eo in vibrant Kaka‘ako! Perched on the 25th floor, this spacious, pet-friendly condo is bathed in natural light and showcases sweeping ocean views. Recently painted and meticulously cared for, the unit is part of a sought-after stack featuring a smart, functional layout—including a pantry for extra storage.
Enjoy the convenience of two tandem parking stalls on the same level as Whole Foods, making everyday errands effortless.
A‘eo offers an impressive collection of resort-style amenities: relax on the rooftop sky deck, take a dip in one of the pools, unwind in the Jacuzzi, sauna, or steam room, and entertain in style with BBQ cabanas, private dining rooms, a theater, and karaoke lounge. Other highlights include a state-of-the-art fitness center, playground, dog park, guest suites, and more.
Step outside and walk to the beach, world-class shopping, dining, cafes, fitness studios, and entertainment—all just minutes from your door in Honolulu’s thriving urban core. Contact your favorite Realtor today and experience luxury island living!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(10) "eXp Realty"
  }
  ["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) "985"
  }
  ["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(33) "City,Coastline,Diamond Head,Ocean"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1025.00"
  }
  ["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) "EXPI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(25) "chelseapferschy@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 725-2794"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(16) "Chelsea Pferschy"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18948127"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-11-02T14:26:08.507"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-08-27"
  }
  ["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:26:08.507"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27124470"
  }
  ["listing_image"]=>
  array(25) {
    [0]=>
    string(8) "27124470"
    [1]=>
    string(8) "27124471"
    [2]=>
    string(8) "27124472"
    [3]=>
    string(8) "27124473"
    [4]=>
    string(8) "27124474"
    [5]=>
    string(8) "27124475"
    [6]=>
    string(8) "27124476"
    [7]=>
    string(8) "27124477"
    [8]=>
    string(8) "27124478"
    [9]=>
    string(8) "27124479"
    [10]=>
    string(8) "27124480"
    [11]=>
    string(8) "27124481"
    [12]=>
    string(8) "27124482"
    [13]=>
    string(8) "27124483"
    [14]=>
    string(8) "27124484"
    [15]=>
    string(8) "27124485"
    [16]=>
    string(8) "27124486"
    [17]=>
    string(8) "27124487"
    [18]=>
    string(8) "27124488"
    [19]=>
    string(8) "27124489"
    [20]=>
    string(8) "27124490"
    [21]=>
    string(8) "27124491"
    [22]=>
    string(8) "27124492"
    [23]=>
    string(8) "27124493"
    [24]=>
    string(8) "27124494"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202518896
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Price adjustment, motivated sellers! Best value in Kakaako-Ward Village! 
Elevate your lifestyle in this stunning high-floor residence at A‘eo in vibrant Kaka‘ako! Perched on the 25th floor, this spacious, pet-friendly condo is bathed in natural light and showcases sweeping ocean views. Recently painted and meticulously cared for, the unit is part of a sought-after stack featuring a smart, functional layout—including a pantry for extra storage.
Enjoy the convenience of two tandem parking stalls on the same level as Whole Foods, making everyday errands effortless.
A‘eo offers an impressive collection of resort-style amenities: relax on the rooftop sky deck, take a dip in one of the pools, unwind in the Jacuzzi, sauna, or steam room, and entertain in style with BBQ cabanas, private dining rooms, a theater, and karaoke lounge. Other highlights include a state-of-the-art fitness center, playground, dog park, guest suites, and more.
Step outside and walk to the beach, world-class shopping, dining, cafes, fitness studios, and entertainment—all just minutes from your door in Honolulu’s thriving urban core. Contact your favorite Realtor today and experience luxury island living!
        )

    [ListOfficeName] => Array
        (
            [0] => eXp Realty
        )

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

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

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

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

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

    [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,Diamond Head,Ocean
        )

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 725-2794
        )

    [ListAgentFullName] => Array
        (
            [0] => Chelsea Pferschy
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-11-02T14:26:08.507
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-08-27
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 14:26:08.507
        )

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

    [listing_image] => Array
        (
            [0] => 27124470
            [1] => 27124471
            [2] => 27124472
            [3] => 27124473
            [4] => 27124474
            [5] => 27124475
            [6] => 27124476
            [7] => 27124477
            [8] => 27124478
            [9] => 27124479
            [10] => 27124480
            [11] => 27124481
            [12] => 27124482
            [13] => 27124483
            [14] => 27124484
            [15] => 27124485
            [16] => 27124486
            [17] => 27124487
            [18] => 27124488
            [19] => 27124489
            [20] => 27124490
            [21] => 27124491
            [22] => 27124492
            [23] => 27124493
            [24] => 27124494
        )

)

PROPERTY INFO

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

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 2
• View: City,Coastline,Diamond Head,Ocean
• Listing Office: eXp Realty

FINANCIAL INFO

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

SCHOOLS

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 November 2, 2025 - 2:26 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.