987 Queen Street Unit 3010 Honolulu, HI 96814

Listing
Overview

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

PRICE REDUCED TO SELL!!! FULLY-FURNISHED and NICELY DONE! Enjoy a high-floor unit with ocean views! Check out the surf before hitting the waves. Furnishings include a queen-size Murphy bed w/a built-in sofa, a built-in office section, a shoe closet and lots of storage. This unit is also furnished with a foldable table with 2 chairs, a full set of linens, complete set of dinner & cookware, bath towels and much more! Awesome amenities like a great fitness center, yoga room, pool & Jacuzzi, cabanas, BBQ areas, playground & play structure for children, private party rooms, spacious rooftop lanai with amazing views of the sunset and fireworks, and a Sky Lounge on 42nd floor. There are also Cino restaurant & a Pilates studio on the ground floor. Convenient location near shops, Ala Moana Beach Park, more restaurants & pastry shops, the Kakaako Farmer's Market, Whole Foods, South Shore Market, Ward Centre, Ala Moana Center, etc. Perfect for your personal residence or an investment property with cash flow! Must see! Listing by: Real Estate Plus, Inc. (808) 342-3516

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202413948"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(3) "987"
  }
  ["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) "3010"
  }
  ["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) "575000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "575000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1030) "PRICE REDUCED TO SELL!!!  FULLY-FURNISHED and NICELY DONE! Enjoy a high-floor unit with ocean views!  Check out the surf before hitting the waves.  Furnishings include a queen-size Murphy bed w/a built-in sofa, a built-in office section, a shoe closet and lots of storage. This unit is also furnished with a foldable table with 2 chairs, a full set of linens, complete set of dinner & cookware, bath towels and much more!  Awesome amenities like a great fitness center, yoga room, pool & Jacuzzi, cabanas, BBQ areas, playground & play structure for children, private party rooms, spacious rooftop lanai with amazing views of the sunset and fireworks, and a Sky Lounge on 42nd floor.  There are also Cino restaurant & a Pilates studio on the ground floor.  Convenient location near shops, Ala Moana Beach Park, more restaurants & pastry shops, the Kakaako Farmer's Market, Whole Foods, South Shore Market, Ward Centre, Ala Moana Center, etc.  Perfect for your personal residence or an investment property with cash flow!  Must see!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Real Estate Plus, Inc."
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "433"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2019"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(5) "Aalii"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "21+"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(37) "City,Coastline,Mountain,Ocean,Sunrise"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "516.48"
  }
  ["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) "RPLS"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(27) "realestateplus808@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 342-3516"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(17) "Francis R Calleon"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-08-12T08:47:08.030"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18063285"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-06-21T21:12:03.223"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26595226"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26595226"
    [1]=>
    string(8) "26595227"
    [2]=>
    string(8) "26595228"
    [3]=>
    string(8) "26595229"
    [4]=>
    string(8) "26595230"
    [5]=>
    string(8) "26595231"
    [6]=>
    string(8) "26595232"
    [7]=>
    string(8) "26595233"
    [8]=>
    string(8) "26595234"
    [9]=>
    string(8) "26595235"
    [10]=>
    string(8) "26595236"
    [11]=>
    string(8) "26595237"
    [12]=>
    string(8) "26595238"
    [13]=>
    string(8) "26595239"
    [14]=>
    string(8) "26595240"
    [15]=>
    string(8) "26595241"
    [16]=>
    string(8) "26595242"
    [17]=>
    string(8) "26595243"
    [18]=>
    string(8) "26595244"
    [19]=>
    string(8) "26595245"
    [20]=>
    string(8) "26595246"
    [21]=>
    string(8) "26595247"
    [22]=>
    string(8) "26595248"
    [23]=>
    string(8) "26621287"
    [24]=>
    string(8) "26628156"
    [25]=>
    string(8) "26628157"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202413948
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => PRICE REDUCED TO SELL!!!  FULLY-FURNISHED and NICELY DONE! Enjoy a high-floor unit with ocean views!  Check out the surf before hitting the waves.  Furnishings include a queen-size Murphy bed w/a built-in sofa, a built-in office section, a shoe closet and lots of storage. This unit is also furnished with a foldable table with 2 chairs, a full set of linens, complete set of dinner & cookware, bath towels and much more!  Awesome amenities like a great fitness center, yoga room, pool & Jacuzzi, cabanas, BBQ areas, playground & play structure for children, private party rooms, spacious rooftop lanai with amazing views of the sunset and fireworks, and a Sky Lounge on 42nd floor.  There are also Cino restaurant & a Pilates studio on the ground floor.  Convenient location near shops, Ala Moana Beach Park, more restaurants & pastry shops, the Kakaako Farmer's Market, Whole Foods, South Shore Market, Ward Centre, Ala Moana Center, etc.  Perfect for your personal residence or an investment property with cash flow!  Must see!
        )

    [ListOfficeName] => Array
        (
            [0] => Real Estate Plus, Inc.
        )

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

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

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

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

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

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

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

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

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

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

    [View] => Array
        (
            [0] => City,Coastline,Mountain,Ocean,Sunrise
        )

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 342-3516
        )

    [ListAgentFullName] => Array
        (
            [0] => Francis R Calleon
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-08-12T08:47:08.030
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-06-21T21:12:03.223
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26595226
            [1] => 26595227
            [2] => 26595228
            [3] => 26595229
            [4] => 26595230
            [5] => 26595231
            [6] => 26595232
            [7] => 26595233
            [8] => 26595234
            [9] => 26595235
            [10] => 26595236
            [11] => 26595237
            [12] => 26595238
            [13] => 26595239
            [14] => 26595240
            [15] => 26595241
            [16] => 26595242
            [17] => 26595243
            [18] => 26595244
            [19] => 26595245
            [20] => 26595246
            [21] => 26595247
            [22] => 26595248
            [23] => 26621287
            [24] => 26628156
            [25] => 26628157
        )

)

  • Full Baths: 1
  • Living (sf): 433
  • Year Built: 2019
  • Building Name: Aalii

  • Property Condition: Above Average
  • Number of Parking Spaces: 1
  • View: City,Coastline,Mountain,Ocean,Sunrise
  • Listing Office: Real Estate Plus, Inc.

  • Maintenance Fees: $516
  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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