1177 Queen Street Unit 3905 Honolulu, HI 96814

Listing
Overview

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

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 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. Listing by: Locations LLC (808) 351-6003

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(722) "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 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."
  }
  ["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) "1270.79"
  }
  ["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) 351-6003"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Rina Shinagawa"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-12-31T18:19:21.700"
  }
  ["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) "18:19:21.700"
  }
}
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 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.
        )

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

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

    [ListAgentFullName] => Array
        (
            [0] => Rina Shinagawa
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-12-31T18:19:21.700
        )

    [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] => 18:19:21.700
        )

)

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

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

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

  • Elementary School: Kaahumanu
  • Middle School: Keelikolani
  • High School: Mckinley

CONTACT US

Marcus Realty

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