Previous Next

1177 Queen Street Unit 4002 Honolulu, HI 96814

Listing
Overview

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

array(46) {
  ["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]=>
    NULL
  }
  ["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]=>
    NULL
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["_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"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-11-15"
  }
}
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] => 
        )

    [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] => 
        )

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

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

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

    [_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
        )

    [ListingContractDate] => Array
        (
            [0] => 2024-11-15
        )

)

PROPERTY INFO

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

KEY FEATURES

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

FINANCIAL INFO

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

SCHOOLS

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 November 15, 2024 - 10:39 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.