Previous Next

1177 Queen Street Unit 4002 Honolulu, HI 96814

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202513844"
  }
  ["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) "1750000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1201) "Experience unparalleled island luxury in this exceptional 3-bedroom, 2-bath residence, showcasing the highly sought-after Plan 02 within one of Honolulu's most prestigious buildings. Freshly painted in 2025 and significantly upgraded in 2024 this sophisticated unit features high-quality vinyl flooring modernized window treatments and motorized blackout blinds in every bedroom– ensuring absolute tranquility and a sublime night's rest. This meticulous attention to detail creates a fresh, contemporary sanctuary. Breathtaking ocean views form the backdrop to a chef-inspired kitchen adorned with granite countertops and top-of-the-line Viking appliances, Every element is designed for elegance, comfort, and effortless upscale living. Resort-Style Living at Ko‘olani: Heated saltwater lap pool and rejuvenating hot spa. Tennis/pickleball/putting greens/BBQ areas. Expansive party room, game room, private theater, business center, guest suite, dog park, and car wash area. Prime Walkable Location: Mere steps to Ala Moana Shopping Center, pristine beaches, Whole Foods Market, vibrant playgrounds, diverse restaurants, and premier entertainment. Presented for immediate enjoyment. Offered 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(0) ""
  }
  ["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) "2176.26"
  }
  ["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) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18800196"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-06-12T08:28:56.670"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-06-12"
  }
  ["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) "08:28:56.670"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27028116"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27028116"
    [1]=>
    string(8) "27028117"
    [2]=>
    string(8) "27028118"
    [3]=>
    string(8) "27028119"
    [4]=>
    string(8) "27028120"
    [5]=>
    string(8) "27028121"
    [6]=>
    string(8) "27028122"
    [7]=>
    string(8) "27028123"
    [8]=>
    string(8) "27028124"
    [9]=>
    string(8) "27028125"
    [10]=>
    string(8) "27028126"
    [11]=>
    string(8) "27028127"
    [12]=>
    string(8) "27028128"
    [13]=>
    string(8) "27028129"
    [14]=>
    string(8) "27028130"
    [15]=>
    string(8) "27028131"
    [16]=>
    string(8) "27028132"
    [17]=>
    string(8) "27028133"
    [18]=>
    string(8) "27028134"
    [19]=>
    string(8) "27028135"
    [20]=>
    string(8) "27028136"
    [21]=>
    string(8) "27028137"
    [22]=>
    string(8) "27028138"
    [23]=>
    string(8) "27028139"
    [24]=>
    string(8) "27028140"
    [25]=>
    string(8) "27028141"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202513844
        )

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Experience unparalleled island luxury in this exceptional 3-bedroom, 2-bath residence, showcasing the highly sought-after Plan 02 within one of Honolulu's most prestigious buildings. Freshly painted in 2025 and significantly upgraded in 2024 this sophisticated unit features high-quality vinyl flooring modernized window treatments and motorized blackout blinds in every bedroom– ensuring absolute tranquility and a sublime night's rest. This meticulous attention to detail creates a fresh, contemporary sanctuary. Breathtaking ocean views form the backdrop to a chef-inspired kitchen adorned with granite countertops and top-of-the-line Viking appliances, Every element is designed for elegance, comfort, and effortless upscale living. Resort-Style Living at Ko‘olani: Heated saltwater lap pool and rejuvenating hot spa. Tennis/pickleball/putting greens/BBQ areas. Expansive party room, game room, private theater, business center, guest suite, dog park, and car wash area. Prime Walkable Location: Mere steps to Ala Moana Shopping Center, pristine beaches, Whole Foods Market, vibrant playgrounds, diverse restaurants, and premier entertainment. Presented for immediate enjoyment. Offered As Is.
        )

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

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

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

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

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

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

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-06-12T08:28:56.670
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-06-12
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 08:28:56.670
        )

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

    [listing_image] => Array
        (
            [0] => 27028116
            [1] => 27028117
            [2] => 27028118
            [3] => 27028119
            [4] => 27028120
            [5] => 27028121
            [6] => 27028122
            [7] => 27028123
            [8] => 27028124
            [9] => 27028125
            [10] => 27028126
            [11] => 27028127
            [12] => 27028128
            [13] => 27028129
            [14] => 27028130
            [15] => 27028131
            [16] => 27028132
            [17] => 27028133
            [18] => 27028134
            [19] => 27028135
            [20] => 27028136
            [21] => 27028137
            [22] => 27028138
            [23] => 27028139
            [24] => 27028140
            [25] => 27028141
        )

)

PROPERTY INFO

• BedsTotal: 3
• Full Baths: 2
• 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: $2,176
• 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 June 12, 2025 - 8:28 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.