987 Queen Street Unit 708 Honolulu, HI 96814

Take a Virtual Tour

Listing
Overview

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

MODERN STUDIO LIVING IN THE HEART OF KAKA'AKO! Welcome to 'A'ali'i at Ward Village, where this thoughtfully designed studio offers 364 sqft of interior space, a 46 sqft lanai, a built-in Murphy bed for flexible living, and includes a covered, secured parking stall plus a dedicated storage unit—rare perks in town. Located just steps from Whole Foods, South Shore Market, top-rated restaurants, and Ala Moana Beach Park, this pet-friendly, fully insured building delivers resort-style living with two levels of incredible amenities: an expansive 8th-floor deck with adult and keiki pools, cabanas, BBQ areas, party rooms, and lush gathering spaces, plus a 42nd-floor rooftop fitness center, yoga studio, and indoor/outdoor sky lounges with panoramic views. Additional features include bike and surfboard storage, a dog run, and 24-hour security. Whether you’re a first-time buyer, investor, or simply seeking a stylish retreat in one of Honolulu’s most walkable neighborhoods, this is the opportunity you’ve been waiting for. Listing by: REMAX Hawaii (808) 753-3923

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202519644"
  }
  ["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(3) "708"
  }
  ["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(59) "https://listings.hetproductions.com/sites/vekzaka/unbranded"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "535000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAKAAKO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1033) "MODERN STUDIO LIVING IN THE HEART OF KAKA'AKO! Welcome to 'A'ali'i at Ward Village, where this thoughtfully designed studio offers 364 sqft of interior space, a 46 sqft lanai, a built-in Murphy bed for flexible living, and includes a covered, secured parking stall plus a dedicated storage unit—rare perks in town. Located just steps from Whole Foods, South Shore Market, top-rated restaurants, and Ala Moana Beach Park, this pet-friendly, fully insured building delivers resort-style living with two levels of incredible amenities: an expansive 8th-floor deck with adult and keiki pools, cabanas, BBQ areas, party rooms, and lush gathering spaces, plus a 42nd-floor rooftop fitness center, yoga studio, and indoor/outdoor sky lounges with panoramic views. Additional features include bike and surfboard storage, a dog run, and 24-hour security. Whether you’re a first-time buyer, investor, or simply seeking a stylish retreat in one of Honolulu’s most walkable neighborhoods, this is the opportunity you’ve been waiting for."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(12) "REMAX Hawaii"
  }
  ["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) "410"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2019"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(5) "Aalii"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(23) "Excellent,Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "21+"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "City"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "507.70"
  }
  ["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) "ADVG"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(25) "Brett.Aka@remaxhawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 753-3923"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(11) "Brett K Aka"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18965614"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-09-12T15:30:01.440"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-09-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) "15:30:01.440"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27146867"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27146867"
    [1]=>
    string(8) "27146868"
    [2]=>
    string(8) "27146869"
    [3]=>
    string(8) "27146870"
    [4]=>
    string(8) "27146871"
    [5]=>
    string(8) "27146872"
    [6]=>
    string(8) "27146873"
    [7]=>
    string(8) "27146874"
    [8]=>
    string(8) "27146875"
    [9]=>
    string(8) "27146876"
    [10]=>
    string(8) "27146877"
    [11]=>
    string(8) "27146878"
    [12]=>
    string(8) "27146879"
    [13]=>
    string(8) "27146880"
    [14]=>
    string(8) "27146881"
    [15]=>
    string(8) "27146882"
    [16]=>
    string(8) "27146883"
    [17]=>
    string(8) "27146884"
    [18]=>
    string(8) "27146885"
    [19]=>
    string(8) "27146886"
    [20]=>
    string(8) "27146887"
    [21]=>
    string(8) "27146888"
    [22]=>
    string(8) "27146889"
    [23]=>
    string(8) "27146890"
    [24]=>
    string(8) "27146891"
    [25]=>
    string(8) "27146892"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202519644
        )

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

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

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://listings.hetproductions.com/sites/vekzaka/unbranded
        )

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

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

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

    [PublicRemarks] => Array
        (
            [0] => MODERN STUDIO LIVING IN THE HEART OF KAKA'AKO! Welcome to 'A'ali'i at Ward Village, where this thoughtfully designed studio offers 364 sqft of interior space, a 46 sqft lanai, a built-in Murphy bed for flexible living, and includes a covered, secured parking stall plus a dedicated storage unit—rare perks in town. Located just steps from Whole Foods, South Shore Market, top-rated restaurants, and Ala Moana Beach Park, this pet-friendly, fully insured building delivers resort-style living with two levels of incredible amenities: an expansive 8th-floor deck with adult and keiki pools, cabanas, BBQ areas, party rooms, and lush gathering spaces, plus a 42nd-floor rooftop fitness center, yoga studio, and indoor/outdoor sky lounges with panoramic views. Additional features include bike and surfboard storage, a dog run, and 24-hour security. Whether you’re a first-time buyer, investor, or simply seeking a stylish retreat in one of Honolulu’s most walkable neighborhoods, this is the opportunity you’ve been waiting for.
        )

    [ListOfficeName] => Array
        (
            [0] => REMAX Hawaii
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => Brett.Aka@remaxhawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 753-3923
        )

    [ListAgentFullName] => Array
        (
            [0] => Brett K Aka
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-09-12T15:30:01.440
        )

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

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 15:30:01.440
        )

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

    [listing_image] => Array
        (
            [0] => 27146867
            [1] => 27146868
            [2] => 27146869
            [3] => 27146870
            [4] => 27146871
            [5] => 27146872
            [6] => 27146873
            [7] => 27146874
            [8] => 27146875
            [9] => 27146876
            [10] => 27146877
            [11] => 27146878
            [12] => 27146879
            [13] => 27146880
            [14] => 27146881
            [15] => 27146882
            [16] => 27146883
            [17] => 27146884
            [18] => 27146885
            [19] => 27146886
            [20] => 27146887
            [21] => 27146888
            [22] => 27146889
            [23] => 27146890
            [24] => 27146891
            [25] => 27146892
        )

)

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

  • Property Condition: Excellent,Above Average
  • Number of Parking Spaces: 1
  • View: City
  • Listing Office: REMAX Hawaii

  • Maintenance Fees: $508
  • 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

Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. listings last updated on September 12, 2025 - 3:30 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.

© Marcus Realty. All Rights Reserved.