1177 Queen Street Unit 4002 Honolulu, HI 96814

Listing
Overview

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

This exceptional residence offers the highly coveted 02 floor plan (3-bedroom, 2-bath) in one of the most sought-after buildings in the area. With a spacious layout, it provides stunning views and upscale finishes throughout, perfectly blending elegance and functionality. Boasting the largest layout aside from the penthouse, this residence offers stunning ocean views and an array of top-tier upgrades. Revel in the comfort of motorized shades, granite kitchen countertops, and premium appliances including Viking. Living at Ko’olani feels like a year-round vacation with amenities that include a heated saltwater pool, a lap pool, whirlpool, tennis courts, putting greens, BBQ areas, and a dog park. The building also features a large party room, game room, business center, theater room, guest room, and car wash area. Plus, you’re just moments away from the Ala Moana shopping center and beach, next door playground, whole foods, shopping malls, theaters, and restaurants. Sold "As Is". Listing by: eXp Realty (808) 358-2021

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202426378"
  }
  ["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) "4002"
  }
  ["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) "1995000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1995000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(995) "This exceptional residence offers the highly coveted 02 floor plan (3-bedroom, 2-bath) in one of the most sought-after buildings in the area. With a spacious layout, it provides stunning views and upscale finishes throughout, perfectly blending elegance and functionality. Boasting the largest layout aside from the penthouse, this residence offers stunning ocean views and an array of top-tier upgrades. Revel in the comfort of motorized shades, granite kitchen countertops, and premium appliances including Viking. Living at Ko’olani feels like a year-round vacation with amenities that include a heated saltwater pool, a lap pool, whirlpool, tennis courts, putting greens, BBQ areas, and a dog park. The building also features a large party room, game room, business center, theater room, guest room, and car wash area. Plus, you’re just moments away from the Ala Moana shopping center and beach, next door playground, whole foods, shopping malls, theaters, and restaurants. Sold "As Is"."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(10) "eXp Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(9) "120956.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1573"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2006"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(7) "Koolani"
  }
  ["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(17) "City,Ocean,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1720.54"
  }
  ["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) "EXPI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(21) "lucyliushen@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 358-2021"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(13) "Lucy Liu Shen"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-11-15T10:39:40.243"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18376062"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-11-15T10:39:40.243"
  }
  ["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) "26770302"
  }
  ["listing_image"]=>
  array(21) {
    [0]=>
    string(8) "26770302"
    [1]=>
    string(8) "26770303"
    [2]=>
    string(8) "26770304"
    [3]=>
    string(8) "26770305"
    [4]=>
    string(8) "26770306"
    [5]=>
    string(8) "26770307"
    [6]=>
    string(8) "26770308"
    [7]=>
    string(8) "26770309"
    [8]=>
    string(8) "26770310"
    [9]=>
    string(8) "26770311"
    [10]=>
    string(8) "26770312"
    [11]=>
    string(8) "26770313"
    [12]=>
    string(8) "26770314"
    [13]=>
    string(8) "26770315"
    [14]=>
    string(8) "26770316"
    [15]=>
    string(8) "26770317"
    [16]=>
    string(8) "26770318"
    [17]=>
    string(8) "26770319"
    [18]=>
    string(8) "26770320"
    [19]=>
    string(8) "26770321"
    [20]=>
    string(8) "26770322"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202426378
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => This exceptional residence offers the highly coveted 02 floor plan (3-bedroom, 2-bath) in one of the most sought-after buildings in the area. With a spacious layout, it provides stunning views and upscale finishes throughout, perfectly blending elegance and functionality. Boasting the largest layout aside from the penthouse, this residence offers stunning ocean views and an array of top-tier upgrades. Revel in the comfort of motorized shades, granite kitchen countertops, and premium appliances including Viking. Living at Ko’olani feels like a year-round vacation with amenities that include a heated saltwater pool, a lap pool, whirlpool, tennis courts, putting greens, BBQ areas, and a dog park. The building also features a large party room, game room, business center, theater room, guest room, and car wash area. Plus, you’re just moments away from the Ala Moana shopping center and beach, next door playground, whole foods, shopping malls, theaters, and restaurants. Sold "As Is".
        )

    [ListOfficeName] => Array
        (
            [0] => eXp Realty
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 358-2021
        )

    [ListAgentFullName] => Array
        (
            [0] => Lucy Liu Shen
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-11-15T10:39:40.243
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-11-15T10:39:40.243
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26770302
            [1] => 26770303
            [2] => 26770304
            [3] => 26770305
            [4] => 26770306
            [5] => 26770307
            [6] => 26770308
            [7] => 26770309
            [8] => 26770310
            [9] => 26770311
            [10] => 26770312
            [11] => 26770313
            [12] => 26770314
            [13] => 26770315
            [14] => 26770316
            [15] => 26770317
            [16] => 26770318
            [17] => 26770319
            [18] => 26770320
            [19] => 26770321
            [20] => 26770322
        )

)

  • BedsTotal: 3
  • Full Baths: 2
  • Land Area (sf): 120,956
  • Living (sf): 1,573
  • Year Built: 2006
  • Building Name: Koolani

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

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

CONTACT US

Marcus Realty

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