1001 Queen Street Unit 1502 Honolulu, HI 96814

Take a Virtual Tour

Listing
Overview

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

Interior freshly painted and fully furnished Ae'o #1502 - Discover the ultimate city living in this spacious 2-bedroom, 2-bathroom residence with 2 parking stalls. It's the biggest unit in the bldg, designed for both efficiency and comfort. The place is filled with natural light, giving it a bright and airy feel. The bathrooms are roomy and stylish, with the primary bath featuring a bathtub and wet room. You'll love the community amenities, which include two large outdoor pools, a fitness center, guest suites, and clubrooms perfect for gathering and entertaining. The rooftop outdoor lounge above 40th floor offers amazing waterfront and city views, perfect for admiring beauty of Hawaii has to offer. Located in the popular Ward Village community, you're literally next to Whole Foods, great restaurants, new boutique stores, and much more. This is the lifestyle you've been looking for! Listing by: Coldwell Banker Realty (808) 226-2790

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202417165"
  }
  ["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) "1502"
  }
  ["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(61) "https://www.youtube.com/embed/ENQo3m0QfGM?si=H037dDR1-YQNRDaG"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1350000.00"
  }
  ["CurrentPrice"]=>
  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(894) "Interior freshly painted and fully furnished Ae'o #1502 - Discover the ultimate city living in this spacious 2-bedroom, 2-bathroom residence with 2 parking stalls. It's the biggest unit in the bldg, designed for both efficiency and comfort. The place is filled with natural light, giving it a bright and airy feel. The bathrooms are roomy and stylish, with the primary bath featuring a bathtub and wet room. You'll love the community amenities, which include two large outdoor pools, a fitness center, guest suites, and clubrooms perfect for gathering and entertaining. The rooftop outdoor lounge above 40th floor offers amazing waterfront and city views, perfect for admiring beauty of Hawaii has to offer. Located in the popular Ward Village community, you're literally next to Whole Foods, great restaurants, new boutique stores, and much more. This is the lifestyle you've been looking for!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker 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) "983"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2018"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(4) "Ae'o"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(23) "Excellent,Above Average"
  }
  ["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) "1094.36"
  }
  ["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) "CBPP"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(18) "ikuh@cbpacific.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 226-2790"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(11) "Iku S Honda"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-08-28T13:53:06.013"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18159301"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-08-08T10:05:38.960"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26652001"
  }
  ["listing_image"]=>
  array(23) {
    [0]=>
    string(8) "26652001"
    [1]=>
    string(8) "26652002"
    [2]=>
    string(8) "26652003"
    [3]=>
    string(8) "26652004"
    [4]=>
    string(8) "26652005"
    [5]=>
    string(8) "26652006"
    [6]=>
    string(8) "26652007"
    [7]=>
    string(8) "26652008"
    [8]=>
    string(8) "26652009"
    [9]=>
    string(8) "26652010"
    [10]=>
    string(8) "26652011"
    [11]=>
    string(8) "26652012"
    [12]=>
    string(8) "26652013"
    [13]=>
    string(8) "26652014"
    [14]=>
    string(8) "26652015"
    [15]=>
    string(8) "26652016"
    [16]=>
    string(8) "26652017"
    [17]=>
    string(8) "26652018"
    [18]=>
    string(8) "26652019"
    [19]=>
    string(8) "26652020"
    [20]=>
    string(8) "26652021"
    [21]=>
    string(8) "26652022"
    [22]=>
    string(8) "26652023"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202417165
        )

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

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

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://www.youtube.com/embed/ENQo3m0QfGM?si=H037dDR1-YQNRDaG
        )

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Interior freshly painted and fully furnished Ae'o #1502 - Discover the ultimate city living in this spacious 2-bedroom, 2-bathroom residence with 2 parking stalls. It's the biggest unit in the bldg, designed for both efficiency and comfort. The place is filled with natural light, giving it a bright and airy feel. The bathrooms are roomy and stylish, with the primary bath featuring a bathtub and wet room. You'll love the community amenities, which include two large outdoor pools, a fitness center, guest suites, and clubrooms perfect for gathering and entertaining. The rooftop outdoor lounge above 40th floor offers amazing waterfront and city views, perfect for admiring beauty of Hawaii has to offer. Located in the popular Ward Village community, you're literally next to Whole Foods, great restaurants, new boutique stores, and much more. This is the lifestyle you've been looking for!
        )

    [ListOfficeName] => Array
        (
            [0] => Coldwell Banker Realty
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => ikuh@cbpacific.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 226-2790
        )

    [ListAgentFullName] => Array
        (
            [0] => Iku S Honda
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-08-28T13:53:06.013
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-08-08T10:05:38.960
        )

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

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

    [SpecialListingConditions] => Array
        (
            [0] => None
        )

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

    [listing_image] => Array
        (
            [0] => 26652001
            [1] => 26652002
            [2] => 26652003
            [3] => 26652004
            [4] => 26652005
            [5] => 26652006
            [6] => 26652007
            [7] => 26652008
            [8] => 26652009
            [9] => 26652010
            [10] => 26652011
            [11] => 26652012
            [12] => 26652013
            [13] => 26652014
            [14] => 26652015
            [15] => 26652016
            [16] => 26652017
            [17] => 26652018
            [18] => 26652019
            [19] => 26652020
            [20] => 26652021
            [21] => 26652022
            [22] => 26652023
        )

)

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

  • Property Condition: Excellent,Above Average
  • Number of Parking Spaces: 2
  • View: City,Ocean
  • Listing Office: Coldwell Banker Realty

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

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446