Previous Next

1001 Queen Street Unit 2904 Honolulu, HI 96814

Take a Virtual Tour

Listing
Overview

Price: $1,250,000
Area: KAKAAKO
Status: Active Under Contract

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202613345"
  }
  ["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) "2904"
  }
  ["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(60) "https://listings.hetproductions.com/sites/eojwvvon/unbranded"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1250000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(964) "Welcome to this beautifully designed, Diamond Head facing 2-bedroom pet-friendly residence at Ae'o. Thoughtfully laid-out unit features floor-to-ceiling windows offering stunning city, mountain & ocean views. Newly painted with newly installed luxury vinyl floors in kitchen/living room and new carpeting in bedrooms. The open-concept living area seamlessly connects to a modern kitchen equipped with high-end Bosch appliances, sleek cabinetry & quartz countertops. Other features include 2 assigned separate parking stalls (3rd & 6th flrs), in-unit laundry & central air conditioning. Ae'o residents have access to fitness pools, cabanas w/BBQ areas, private dining rooms, karaoke rooms, rooftop “Sky Terrace”, fitness center, spa/sauna, movie theaters, and direct access to Whole Foods Market! Located in the heart of vibrant Kaka'ako, you’re just steps from world-class dining, shopping, beaches, and Ala Moana Beach Park! *Some photos have been enhanced*"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(12) "REMAX Hawaii"
  }
  ["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(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "21+"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(32) "City,Diamond Head,Mountain,Ocean"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1134.32"
  }
  ["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) "ADVG"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(36) "Michelle.NouchiOgata@remaxhawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 271-9333"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(23) "Michelle K Nouchi Ogata"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19570433"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-07-19T17:05:54.630"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-07-13"
  }
  ["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) "17:05:54.630"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27455915"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27455915"
    [1]=>
    string(8) "27455916"
    [2]=>
    string(8) "27455917"
    [3]=>
    string(8) "27455918"
    [4]=>
    string(8) "27455919"
    [5]=>
    string(8) "27455920"
    [6]=>
    string(8) "27455921"
    [7]=>
    string(8) "27455922"
    [8]=>
    string(8) "27455923"
    [9]=>
    string(8) "27455924"
    [10]=>
    string(8) "27455925"
    [11]=>
    string(8) "27455926"
    [12]=>
    string(8) "27455927"
    [13]=>
    string(8) "27455928"
    [14]=>
    string(8) "27455929"
    [15]=>
    string(8) "27455930"
    [16]=>
    string(8) "27455931"
    [17]=>
    string(8) "27455932"
    [18]=>
    string(8) "27455933"
    [19]=>
    string(8) "27455934"
    [20]=>
    string(8) "27455935"
    [21]=>
    string(8) "27455936"
    [22]=>
    string(8) "27455937"
    [23]=>
    string(8) "27455938"
    [24]=>
    string(8) "27455939"
    [25]=>
    string(8) "27455940"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202613345
        )

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

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

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://listings.hetproductions.com/sites/eojwvvon/unbranded
        )

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Welcome to this beautifully designed, Diamond Head facing 2-bedroom pet-friendly residence at Ae'o. Thoughtfully laid-out unit features floor-to-ceiling windows offering stunning city, mountain & ocean views. Newly painted with newly installed luxury vinyl floors in kitchen/living room and new carpeting in bedrooms. The open-concept living area seamlessly connects to a modern kitchen equipped with high-end Bosch appliances, sleek cabinetry & quartz countertops. Other features include 2 assigned separate parking stalls (3rd & 6th flrs), in-unit laundry & central air conditioning. Ae'o residents have access to fitness pools, cabanas w/BBQ areas, private dining rooms, karaoke rooms, rooftop “Sky Terrace”, fitness center, spa/sauna, movie theaters, and direct access to Whole Foods Market! Located in the heart of vibrant Kaka'ako, you’re just steps from world-class dining, shopping, beaches, and Ala Moana Beach Park! *Some photos have been enhanced*
        )

    [ListOfficeName] => Array
        (
            [0] => REMAX Hawaii
        )

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => Michelle.NouchiOgata@remaxhawaii.com
        )

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

    [ListAgentFullName] => Array
        (
            [0] => Michelle K Nouchi Ogata
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-07-19T17:05:54.630
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-07-13
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 17:05:54.630
        )

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

    [listing_image] => Array
        (
            [0] => 27455915
            [1] => 27455916
            [2] => 27455917
            [3] => 27455918
            [4] => 27455919
            [5] => 27455920
            [6] => 27455921
            [7] => 27455922
            [8] => 27455923
            [9] => 27455924
            [10] => 27455925
            [11] => 27455926
            [12] => 27455927
            [13] => 27455928
            [14] => 27455929
            [15] => 27455930
            [16] => 27455931
            [17] => 27455932
            [18] => 27455933
            [19] => 27455934
            [20] => 27455935
            [21] => 27455936
            [22] => 27455937
            [23] => 27455938
            [24] => 27455939
            [25] => 27455940
        )

)

PROPERTY INFO

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

KEY FEATURES

• Property Condition: Above Average
• Number of Parking Spaces: 2
• View: City,Diamond Head,Mountain,Ocean
• Listing Office: REMAX Hawaii

FINANCIAL INFO

• Maintenance Fees: $1,134
• 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 July 19, 2026 - 5:05 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.