1177 Queen Street Unit 3905 Honolulu, HI 96814

Listing
Overview

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

Enjoy luxury superb living in Koolani, a highly sought-after condo at the heart of exciting neighborhood in Kakaako. This stunning 35th-floor unit offers assigned side-by-side parking stalls. Step into a spacious living room featuring an open floor plan and top-of-the-line finishes. The kitchen boasts Viking Professional stainless steel appliances, including a gas stove, granite countertops, and marble floors. The living room windows open wide, providing excellent ventilation. This unit come with your private lanai. Indulge in Koolani's superb amenities, including tennis courts, a putting green, BBQ areas, meeting and party rooms, a heated saltwater pool with a whirlpool, a conference room, guest suite, theater room, and billiards room. This prime location is close to everything, including the world-famous Ala Moana Center, Whole Foods, restaurants, beaches, theaters, and entertainment options. Experience the ultimate in luxury and convenience in this exceptional condo. Listing by: Locations LLC (808) 735-4200

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202509721"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "1177"
  }
  ["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) "3905"
  }
  ["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) "1200000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(992) "Enjoy luxury superb living in Koolani, a highly sought-after condo at the heart of exciting neighborhood in Kakaako. This
stunning 35th-floor unit offers assigned side-by-side parking stalls. Step into a spacious living room featuring an open floor
plan and top-of-the-line finishes. The kitchen boasts Viking Professional stainless steel appliances, including a gas stove,
granite countertops, and marble floors. The living room windows open wide, providing excellent ventilation. This unit
come with your private lanai. Indulge in Koolani's superb amenities, including tennis courts, a putting green, BBQ areas,
meeting and party rooms, a heated saltwater pool with a whirlpool, a conference room, guest suite, theater room, and
billiards room. This prime location is close to everything, including the world-famous Ala Moana Center, Whole Foods,
restaurants, beaches, theaters, and entertainment options. Experience the ultimate in luxury and convenience in this
exceptional condo."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(13) "Locations LLC"
  }
  ["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(4) "1162"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2006"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(7) "Koolani"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(34) "City,Coastline,Garden,Ocean,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1499.72"
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(9) "Kaahumanu"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(10) "Washington"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(8) "Mckinley"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "LOCA"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(34) "rina.shinagawa@locationshawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 735-4200"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Rina Shinagawa"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18681113"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-04-28T09:40:42.377"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-04-28"
  }
  ["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) "09:40:42.377"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26975429"
  }
  ["listing_image"]=>
  array(16) {
    [0]=>
    string(8) "26975429"
    [1]=>
    string(8) "26975430"
    [2]=>
    string(8) "26975431"
    [3]=>
    string(8) "26975432"
    [4]=>
    string(8) "26975433"
    [5]=>
    string(8) "26975434"
    [6]=>
    string(8) "26975435"
    [7]=>
    string(8) "26975436"
    [8]=>
    string(8) "26975437"
    [9]=>
    string(8) "26975438"
    [10]=>
    string(8) "26975439"
    [11]=>
    string(8) "26975440"
    [12]=>
    string(8) "26975441"
    [13]=>
    string(8) "26975442"
    [14]=>
    string(8) "26975443"
    [15]=>
    string(8) "26975444"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202509721
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Enjoy luxury superb living in Koolani, a highly sought-after condo at the heart of exciting neighborhood in Kakaako. This
stunning 35th-floor unit offers assigned side-by-side parking stalls. Step into a spacious living room featuring an open floor
plan and top-of-the-line finishes. The kitchen boasts Viking Professional stainless steel appliances, including a gas stove,
granite countertops, and marble floors. The living room windows open wide, providing excellent ventilation. This unit
come with your private lanai. Indulge in Koolani's superb amenities, including tennis courts, a putting green, BBQ areas,
meeting and party rooms, a heated saltwater pool with a whirlpool, a conference room, guest suite, theater room, and
billiards room. This prime location is close to everything, including the world-famous Ala Moana Center, Whole Foods,
restaurants, beaches, theaters, and entertainment options. Experience the ultimate in luxury and convenience in this
exceptional condo.
        )

    [ListOfficeName] => Array
        (
            [0] => Locations LLC
        )

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

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

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

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

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

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

    [BuildingName] => Array
        (
            [0] => Koolani
        )

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => rina.shinagawa@locationshawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 735-4200
        )

    [ListAgentFullName] => Array
        (
            [0] => Rina Shinagawa
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-04-28T09:40:42.377
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-04-28
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 09:40:42.377
        )

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

    [listing_image] => Array
        (
            [0] => 26975429
            [1] => 26975430
            [2] => 26975431
            [3] => 26975432
            [4] => 26975433
            [5] => 26975434
            [6] => 26975435
            [7] => 26975436
            [8] => 26975437
            [9] => 26975438
            [10] => 26975439
            [11] => 26975440
            [12] => 26975441
            [13] => 26975442
            [14] => 26975443
            [15] => 26975444
        )

)

  • BedsTotal: 2
  • Full Baths: 2
  • Living (sf): 1,162
  • Year Built: 2006
  • Building Name: Koolani

  • Property Condition: Above Average
  • Number of Parking Spaces: 2
  • View: City,Coastline,Garden,Ocean,Sunset
  • Listing Office: Locations LLC

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

  • Elementary School: Kaahumanu
  • Middle School: Washington
  • 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 April 28, 2025 - 9:40 AM 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.