Previous Next

1001 queen Street Unit 2604 Honolulu, HI 96814

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202607917"
  }
  ["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) "2604"
  }
  ["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) "1350000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1066) "Experience elevated island living in this stunning luxury residence at Ae?o. This beautifully appointed 2-bedroom, 2-bathroom condo offers modern elegance paired with exceptional convenience, featuring two coveted parking stalls. Floor-to-ceiling windows fill the space with natural light, while refined finishes and an open-concept layout create a seamless flow between living, dining, and kitchen areas—perfect for both relaxing and entertaining. The gourmet kitchen is outfitted with high-end appliances, sleek cabinetry, and premium countertops, ideal for the discerning home chef.The spacious primary suite provides a private retreat with a spa-inspired bathroom and ample closet space, while the second bedroom offers flexibility for guests, a home office, or additional living needs. Enjoy resort-style amenities including a pool, fitness center, rooftop terrace, and more—all within a vibrant, walkable community offering world-class shopping, dining, and entertainment just steps away. This is luxury urban living at its finest in the heart of Honolulu."
  }
  ["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(10) "City,Ocean"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1134.32"
  }
  ["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(23) "JohnMaiHawaii@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 255-8826"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(10) "John N Mai"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19399711"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-04-20T22:11:48.393"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-04-20"
  }
  ["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:11:48.393"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27366274"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27366274"
    [1]=>
    string(8) "27366275"
    [2]=>
    string(8) "27366276"
    [3]=>
    string(8) "27366277"
    [4]=>
    string(8) "27366278"
    [5]=>
    string(8) "27366279"
    [6]=>
    string(8) "27366280"
    [7]=>
    string(8) "27366281"
    [8]=>
    string(8) "27366282"
    [9]=>
    string(8) "27366283"
    [10]=>
    string(8) "27366284"
    [11]=>
    string(8) "27366285"
    [12]=>
    string(8) "27366286"
    [13]=>
    string(8) "27366287"
    [14]=>
    string(8) "27366288"
    [15]=>
    string(8) "27366289"
    [16]=>
    string(8) "27366290"
    [17]=>
    string(8) "27366291"
    [18]=>
    string(8) "27366292"
    [19]=>
    string(8) "27366293"
    [20]=>
    string(8) "27366294"
    [21]=>
    string(8) "27366295"
    [22]=>
    string(8) "27366296"
    [23]=>
    string(8) "27366297"
    [24]=>
    string(8) "27366298"
    [25]=>
    string(8) "27366299"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202607917
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Experience elevated island living in this stunning luxury residence at Ae?o. This beautifully appointed 2-bedroom, 2-bathroom condo offers modern elegance paired with exceptional convenience, featuring two coveted parking stalls. Floor-to-ceiling windows fill the space with natural light, while refined finishes and an open-concept layout create a seamless flow between living, dining, and kitchen areas—perfect for both relaxing and entertaining. The gourmet kitchen is outfitted with high-end appliances, sleek cabinetry, and premium countertops, ideal for the discerning home chef.The spacious primary suite provides a private retreat with a spa-inspired bathroom and ample closet space, while the second bedroom offers flexibility for guests, a home office, or additional living needs. Enjoy resort-style amenities including a pool, fitness center, rooftop terrace, and more—all within a vibrant, walkable community offering world-class shopping, dining, and entertainment just steps away. This is luxury urban living at its finest in the heart of Honolulu.
        )

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

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 255-8826
        )

    [ListAgentFullName] => Array
        (
            [0] => John N Mai
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-04-20T22:11:48.393
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-04-20
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 22:11:48.393
        )

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

    [listing_image] => Array
        (
            [0] => 27366274
            [1] => 27366275
            [2] => 27366276
            [3] => 27366277
            [4] => 27366278
            [5] => 27366279
            [6] => 27366280
            [7] => 27366281
            [8] => 27366282
            [9] => 27366283
            [10] => 27366284
            [11] => 27366285
            [12] => 27366286
            [13] => 27366287
            [14] => 27366288
            [15] => 27366289
            [16] => 27366290
            [17] => 27366291
            [18] => 27366292
            [19] => 27366293
            [20] => 27366294
            [21] => 27366295
            [22] => 27366296
            [23] => 27366297
            [24] => 27366298
            [25] => 27366299
        )

)

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,Ocean
• Listing Office: eXp Realty

FINANCIAL INFO

• Maintenance Fees: $1,134
• 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 April 20, 2026 - 10:11 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.