Previous Next

1177 Queen Street Unit 3905 Honolulu, HI 96814

Listing
Overview

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

array(48) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202415073"
  }
  ["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"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(772) "High floor with Lanai turquoise ocean water and golden sunsets from this spacious condo. This freshly painted unit boasts
luxury Viking appliances, central air and fantastic layout allowing for privacy. Master bedroom features 2 closets, double
vanity and separate soaking tub & shower. Fantastic ocean views from every room! Unit includes 2 side by side full size parking
stalls. Koolani has amazing amenities including expansive recreation deck with pool, spa, pickle ball & tennis court,
putting green, and dog area. The building also includes a billiards room, theater room, business center and party room.
Shopping and restaurants in trendy Kakaako are right outside and just walking distance to Ala Moana shopping center. Other monthly fee is until August 2025."
  }
  ["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) "1206"
  }
  ["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(3) "21+"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(34) "City,Coastline,Garden,Ocean,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1449.72"
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(9) "Kaahumanu"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(11) "Keelikolani"
  }
  ["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) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-03-22T13:26:08.493"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18096255"
  }
  ["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) "26603815"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26603815"
    [1]=>
    string(8) "26603816"
    [2]=>
    string(8) "26603817"
    [3]=>
    string(8) "26603818"
    [4]=>
    string(8) "26603819"
    [5]=>
    string(8) "26603820"
    [6]=>
    string(8) "26603821"
    [7]=>
    string(8) "26603822"
    [8]=>
    string(8) "26606238"
    [9]=>
    string(8) "26606239"
    [10]=>
    string(8) "26755266"
    [11]=>
    string(8) "26755267"
    [12]=>
    string(8) "26755268"
    [13]=>
    string(8) "26755269"
    [14]=>
    string(8) "26755270"
    [15]=>
    string(8) "26755271"
    [16]=>
    string(8) "26755272"
    [17]=>
    string(8) "26755273"
    [18]=>
    string(8) "26755274"
    [19]=>
    string(8) "26755275"
    [20]=>
    string(8) "26755276"
    [21]=>
    string(8) "26755277"
    [22]=>
    string(8) "26755278"
    [23]=>
    string(8) "26755279"
    [24]=>
    string(8) "26755280"
    [25]=>
    string(8) "26755281"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-06-28"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "13:26:08.493"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202415073
        )

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => High floor with Lanai turquoise ocean water and golden sunsets from this spacious condo. This freshly painted unit boasts
luxury Viking appliances, central air and fantastic layout allowing for privacy. Master bedroom features 2 closets, double
vanity and separate soaking tub & shower. Fantastic ocean views from every room! Unit includes 2 side by side full size parking
stalls. Koolani has amazing amenities including expansive recreation deck with pool, spa, pickle ball & tennis court,
putting green, and dog area. The building also includes a billiards room, theater room, business center and party room.
Shopping and restaurants in trendy Kakaako are right outside and just walking distance to Ala Moana shopping center. Other monthly fee is until August 2025.
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-03-22T13:26:08.493
        )

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

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

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26603815
            [1] => 26603816
            [2] => 26603817
            [3] => 26603818
            [4] => 26603819
            [5] => 26603820
            [6] => 26603821
            [7] => 26603822
            [8] => 26606238
            [9] => 26606239
            [10] => 26755266
            [11] => 26755267
            [12] => 26755268
            [13] => 26755269
            [14] => 26755270
            [15] => 26755271
            [16] => 26755272
            [17] => 26755273
            [18] => 26755274
            [19] => 26755275
            [20] => 26755276
            [21] => 26755277
            [22] => 26755278
            [23] => 26755279
            [24] => 26755280
            [25] => 26755281
        )

    [ListingContractDate] => Array
        (
            [0] => 2024-06-28
        )

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

    [MatrixModifiedTime] => Array
        (
            [0] => 13:26:08.493
        )

)

PROPERTY INFO

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

KEY FEATURES

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

FINANCIAL INFO

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

SCHOOLS

• Elementary School: Kaahumanu
• Middle School: Keelikolani
• 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 March 22, 2025 - 1:26 PM 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.