Previous Next

1177 Queen Street Unit 604 Honolulu, HI 96814

Listing
Overview

Price: $859,000
Area: KAKAAKO
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202616931"
  }
  ["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(3) "604"
  }
  ["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(9) "859000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(871) "Affordable LOWEST priced unit for one of the highly desirable luxury building with resort-style amenities in the heart of Kakaako! Resort-style amenities include BBQ Pavilions, Tennis Courts, Putting Green, Heated Pool, Whirlpool Spa, Theatre, Ballard & Game Room, recreation & meeting rooms, Dog Park, and 24-hour security.  Conveniently located close to Ala Moana Shopping Center, Ala Moana Beach Park, Ward theaters, Whole Foods, Banks, Restaurants, Coffee shops, and much much more! This is a move-in ready spacious two-bedroom unit comes with two covered tandem parking stalls.  The unit has been updated with newer appliances, window blinds, and vinyl flooring. Wonderful opportunity to purchase in Koolani whether it is a primary residence, second home, or investment in one of Honolulu’s most sought-after market. Sold As-Is and easy to show, short notice okay."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(26) "Advance Pacific Realty 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) "1157"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2006"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(7) "Koolani"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "21+"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1648.00"
  }
  ["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) "APRT"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(19) "tvelacion@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 824-1671"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Thao N Velacion"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19696068"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-09-06T17:00:02.253"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-09-04"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "17:00:02.253"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27515757"
  }
  ["listing_image"]=>
  array(24) {
    [0]=>
    string(8) "27515757"
    [1]=>
    string(8) "27515758"
    [2]=>
    string(8) "27515759"
    [3]=>
    string(8) "27515760"
    [4]=>
    string(8) "27515761"
    [5]=>
    string(8) "27515762"
    [6]=>
    string(8) "27515763"
    [7]=>
    string(8) "27515764"
    [8]=>
    string(8) "27515765"
    [9]=>
    string(8) "27515766"
    [10]=>
    string(8) "27515767"
    [11]=>
    string(8) "27515768"
    [12]=>
    string(8) "27515769"
    [13]=>
    string(8) "27515770"
    [14]=>
    string(8) "27515771"
    [15]=>
    string(8) "27515772"
    [16]=>
    string(8) "27515773"
    [17]=>
    string(8) "27515774"
    [18]=>
    string(8) "27515775"
    [19]=>
    string(8) "27515776"
    [20]=>
    string(8) "27515777"
    [21]=>
    string(8) "27515778"
    [22]=>
    string(8) "27515779"
    [23]=>
    string(8) "27515780"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202616931
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Affordable LOWEST priced unit for one of the highly desirable luxury building with resort-style amenities in the heart of Kakaako! Resort-style amenities include BBQ Pavilions, Tennis Courts, Putting Green, Heated Pool, Whirlpool Spa, Theatre, Ballard & Game Room, recreation & meeting rooms, Dog Park, and 24-hour security.  Conveniently located close to Ala Moana Shopping Center, Ala Moana Beach Park, Ward theaters, Whole Foods, Banks, Restaurants, Coffee shops, and much much more! This is a move-in ready spacious two-bedroom unit comes with two covered tandem parking stalls.  The unit has been updated with newer appliances, window blinds, and vinyl flooring. Wonderful opportunity to purchase in Koolani whether it is a primary residence, second home, or investment in one of Honolulu’s most sought-after market. Sold As-Is and easy to show, short notice okay.
        )

    [ListOfficeName] => Array
        (
            [0] => Advance Pacific Realty LLC
        )

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

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

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

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

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

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

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

    [PropertyCondition] => Array
        (
            [0] => Excellent
        )

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

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

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

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 824-1671
        )

    [ListAgentFullName] => Array
        (
            [0] => Thao N Velacion
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-09-06T17:00:02.253
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-09-04
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 17:00:02.253
        )

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

    [listing_image] => Array
        (
            [0] => 27515757
            [1] => 27515758
            [2] => 27515759
            [3] => 27515760
            [4] => 27515761
            [5] => 27515762
            [6] => 27515763
            [7] => 27515764
            [8] => 27515765
            [9] => 27515766
            [10] => 27515767
            [11] => 27515768
            [12] => 27515769
            [13] => 27515770
            [14] => 27515771
            [15] => 27515772
            [16] => 27515773
            [17] => 27515774
            [18] => 27515775
            [19] => 27515776
            [20] => 27515777
            [21] => 27515778
            [22] => 27515779
            [23] => 27515780
        )

)

PROPERTY INFO

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

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 2
• View: None
• Listing Office: Advance Pacific Realty LLC

FINANCIAL INFO

• Maintenance Fees: $1,648
• 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 September 6, 2026 - 5:00 PM Information is deemed reliable but not guaranteed. Copyright: 2026 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.