1001 Queen Street Unit 1815 Honolulu, HI 96814

Listing
Overview

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

Immaculate 2 bedroom, 2 bath unit in Ae'o, Kaka'ako's luxury building! Corner end unit has a Floor-to-ceiling windows provide ample light and create a feeling of openness. Unit includes engineered hardwood flooring, stainless steel Bosch appliances, Grohe fixtures, quartz countertops, custom cabinetry, Central A/C, and more! Ae’o boasts resort-like amenities, including large lap pool, hot tub and family pool, several BBQ cabanas, kids playground, fitness center, dry sauna, steam room, movie theater, media/karaoke room, private dining room, dog park & a rooftop recreation deck with sweeping views. Residents conveniently have direct and covered access to Whole Foods, Straub medical clinic and Ward Village's many shops & restaurants. Steps away to Ala Moana Beach Park & Ala Moana Shopping Center! Maintenance fee is $902.08/month. Other monthly fee is cable/internet $45.91 + reserve $177.40. Ward Village association fee is $30.88/month. Listing by: HOMETIQUE (808) 754-2284

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202513257"
  }
  ["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) "1815"
  }
  ["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) "1095000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(950) "Immaculate 2 bedroom, 2 bath unit in Ae'o,  Kaka'ako's luxury building! Corner end unit has a Floor-to-ceiling windows provide ample light and create a feeling of openness. Unit includes engineered hardwood flooring, stainless steel Bosch appliances, Grohe fixtures, quartz countertops, custom cabinetry,  Central A/C, and more! Ae’o boasts resort-like amenities, including large lap pool, hot tub and family pool, several BBQ cabanas, kids playground, fitness center, dry sauna, steam room, movie theater, media/karaoke room, private dining room, dog park & a rooftop recreation deck with sweeping views. Residents conveniently have direct and covered access to Whole Foods, Straub medical clinic and Ward Village's many shops & restaurants. Steps away to Ala Moana Beach Park & Ala Moana Shopping Center! Maintenance fee is $902.08/month. Other monthly fee is cable/internet $45.91 + reserve $177.40. Ward Village association fee is $30.88/month."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(9) "HOMETIQUE"
  }
  ["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) "867"
  }
  ["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) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "21+"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(26) "City,Mountain,Ocean,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "902.08"
  }
  ["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) "HMTQ"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(23) "atsuko.hawaii@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 754-2284"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(11) "Atsuko Sato"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18783526"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-06-03T12:18:27.867"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-06-03"
  }
  ["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) "12:18:27.867"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27017582"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27017582"
    [1]=>
    string(8) "27017583"
    [2]=>
    string(8) "27017584"
    [3]=>
    string(8) "27017585"
    [4]=>
    string(8) "27017586"
    [5]=>
    string(8) "27017587"
    [6]=>
    string(8) "27017588"
    [7]=>
    string(8) "27017589"
    [8]=>
    string(8) "27017590"
    [9]=>
    string(8) "27017591"
    [10]=>
    string(8) "27017592"
    [11]=>
    string(8) "27017593"
    [12]=>
    string(8) "27017594"
    [13]=>
    string(8) "27017595"
    [14]=>
    string(8) "27017596"
    [15]=>
    string(8) "27017597"
    [16]=>
    string(8) "27017598"
    [17]=>
    string(8) "27017599"
    [18]=>
    string(8) "27017600"
    [19]=>
    string(8) "27017601"
    [20]=>
    string(8) "27017602"
    [21]=>
    string(8) "27017603"
    [22]=>
    string(8) "27017604"
    [23]=>
    string(8) "27017605"
    [24]=>
    string(8) "27017606"
    [25]=>
    string(8) "27017607"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202513257
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Immaculate 2 bedroom, 2 bath unit in Ae'o,  Kaka'ako's luxury building! Corner end unit has a Floor-to-ceiling windows provide ample light and create a feeling of openness. Unit includes engineered hardwood flooring, stainless steel Bosch appliances, Grohe fixtures, quartz countertops, custom cabinetry,  Central A/C, and more! Ae’o boasts resort-like amenities, including large lap pool, hot tub and family pool, several BBQ cabanas, kids playground, fitness center, dry sauna, steam room, movie theater, media/karaoke room, private dining room, dog park & a rooftop recreation deck with sweeping views. Residents conveniently have direct and covered access to Whole Foods, Straub medical clinic and Ward Village's many shops & restaurants. Steps away to Ala Moana Beach Park & Ala Moana Shopping Center! Maintenance fee is $902.08/month. Other monthly fee is cable/internet $45.91 + reserve $177.40. Ward Village association fee is $30.88/month.
        )

    [ListOfficeName] => Array
        (
            [0] => HOMETIQUE
        )

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

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

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

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

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

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

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

    [PropertyCondition] => Array
        (
            [0] => Above Average
        )

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

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

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

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 754-2284
        )

    [ListAgentFullName] => Array
        (
            [0] => Atsuko Sato
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-06-03T12:18:27.867
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-06-03
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 12:18:27.867
        )

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

    [listing_image] => Array
        (
            [0] => 27017582
            [1] => 27017583
            [2] => 27017584
            [3] => 27017585
            [4] => 27017586
            [5] => 27017587
            [6] => 27017588
            [7] => 27017589
            [8] => 27017590
            [9] => 27017591
            [10] => 27017592
            [11] => 27017593
            [12] => 27017594
            [13] => 27017595
            [14] => 27017596
            [15] => 27017597
            [16] => 27017598
            [17] => 27017599
            [18] => 27017600
            [19] => 27017601
            [20] => 27017602
            [21] => 27017603
            [22] => 27017604
            [23] => 27017605
            [24] => 27017606
            [25] => 27017607
        )

)

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

  • Property Condition: Above Average
  • Number of Parking Spaces: 1
  • View: City,Mountain,Ocean,Sunset
  • Listing Office: HOMETIQUE

  • Maintenance Fees: $902
  • Land Tenure: FS - Fee Simple

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 June 3, 2025 - 12:18 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.

© Marcus Realty. All Rights Reserved.