1177 Queen Street Unit 2602 Honolulu, HI 96814

Listing
Overview

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

Truly one-of-a-kind luxury residence at The Koolani with spectacular ocean views and beautiful luxury vinyl flooring throughout. Original 3 bedroom stack, designed by the developer as a generous / unique 2 bedroom, creating a superb layout with 2 living quarters, ideal for relaxing or entertaining. The kitchen comes with Viking appliances - includes a new fridge and gas cooktop - and adjacent to the kitchen is a built-in bar area. Automatic shades throughout the unit, with additional black out shades in both bedrooms. The bathrooms have been upgraded with high-end Toto toilets that include washlets. The Koolani has an incredible amenity galore, including 2 tennis courts (1 court also has lines for pickleball), heated pool, hot tub, BBQ, movie theater, billiard room, putting green, business center, game room, car wash, dog park and offers residents access to the upscale Island Club & Spa at a nominal monthly fee (verify). Outstanding location, being a stone's throw from Ala Moana Shopping Center, Ala Moana Beach Park and adjacent to Ward Village with WholeFoods, restaurants and so much more. It doesn’t get any better; come see the magic for yourself! Listing by: Hawaii Living LLC (808) 372-6184

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202404542"
  }
  ["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) "2602"
  }
  ["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) "1849000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1849000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1170) "Truly one-of-a-kind luxury residence at The Koolani with spectacular ocean views and beautiful luxury vinyl flooring throughout. Original 3 bedroom stack, designed by the developer as a generous / unique 2 bedroom, creating a superb layout with 2 living quarters, ideal for relaxing or entertaining. The kitchen comes with Viking appliances - includes a new fridge and gas cooktop - and adjacent to the kitchen is a built-in bar area. Automatic shades  throughout the unit, with additional black out shades in both bedrooms. The bathrooms have been upgraded with high-end Toto toilets that include washlets. The Koolani has an incredible amenity galore, including 2 tennis courts (1 court also has lines for pickleball), heated pool, hot tub, BBQ, movie theater, billiard room, putting green, business center, game room, car wash, dog park and offers residents access to the upscale Island Club & Spa at a nominal monthly fee (verify). Outstanding location, being a stone's throw from Ala Moana Shopping Center, Ala Moana Beach Park and adjacent to Ward Village with WholeFoods, restaurants and so much more. It doesn’t get any better; come see the magic for yourself!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(17) "Hawaii Living 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) "1561"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2006"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(7) "Koolani"
  }
  ["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(27) "City,Coastline,Ocean,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1707.65"
  }
  ["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) "HOHI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(25) "Kristian@HawaiiLiving.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 372-6184"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(16) "Kristian Nielsen"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-03-22T15:06:37.737"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17855541"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-03-01T20:26:13.263"
  }
  ["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) "26114402"
  }
  ["listing_image"]=>
  array(21) {
    [0]=>
    string(8) "26114402"
    [1]=>
    string(8) "26114403"
    [2]=>
    string(8) "26114404"
    [3]=>
    string(8) "26114405"
    [4]=>
    string(8) "26114406"
    [5]=>
    string(8) "26114407"
    [6]=>
    string(8) "26114408"
    [7]=>
    string(8) "26114409"
    [8]=>
    string(8) "26114410"
    [9]=>
    string(8) "26114411"
    [10]=>
    string(8) "26114412"
    [11]=>
    string(8) "26114413"
    [12]=>
    string(8) "26114414"
    [13]=>
    string(8) "26114415"
    [14]=>
    string(8) "26114416"
    [15]=>
    string(8) "26114417"
    [16]=>
    string(8) "26114418"
    [17]=>
    string(8) "26114419"
    [18]=>
    string(8) "26114420"
    [19]=>
    string(8) "26114421"
    [20]=>
    string(8) "26114422"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202404542
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Truly one-of-a-kind luxury residence at The Koolani with spectacular ocean views and beautiful luxury vinyl flooring throughout. Original 3 bedroom stack, designed by the developer as a generous / unique 2 bedroom, creating a superb layout with 2 living quarters, ideal for relaxing or entertaining. The kitchen comes with Viking appliances - includes a new fridge and gas cooktop - and adjacent to the kitchen is a built-in bar area. Automatic shades  throughout the unit, with additional black out shades in both bedrooms. The bathrooms have been upgraded with high-end Toto toilets that include washlets. The Koolani has an incredible amenity galore, including 2 tennis courts (1 court also has lines for pickleball), heated pool, hot tub, BBQ, movie theater, billiard room, putting green, business center, game room, car wash, dog park and offers residents access to the upscale Island Club & Spa at a nominal monthly fee (verify). Outstanding location, being a stone's throw from Ala Moana Shopping Center, Ala Moana Beach Park and adjacent to Ward Village with WholeFoods, restaurants and so much more. It doesn’t get any better; come see the magic for yourself!
        )

    [ListOfficeName] => Array
        (
            [0] => Hawaii Living LLC
        )

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

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

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

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

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

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

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

    [PropertyCondition] => Array
        (
            [0] => Excellent
        )

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => Kristian@HawaiiLiving.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 372-6184
        )

    [ListAgentFullName] => Array
        (
            [0] => Kristian Nielsen
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-03-22T15:06:37.737
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-03-01T20:26:13.263
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26114402
            [1] => 26114403
            [2] => 26114404
            [3] => 26114405
            [4] => 26114406
            [5] => 26114407
            [6] => 26114408
            [7] => 26114409
            [8] => 26114410
            [9] => 26114411
            [10] => 26114412
            [11] => 26114413
            [12] => 26114414
            [13] => 26114415
            [14] => 26114416
            [15] => 26114417
            [16] => 26114418
            [17] => 26114419
            [18] => 26114420
            [19] => 26114421
            [20] => 26114422
        )

)

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

  • Property Condition: Excellent
  • Number of Parking Spaces: 2
  • View: City,Coastline,Ocean,Sunset
  • Listing Office: Hawaii Living LLC

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

CONTACT US

Marcus Realty

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