Previous Next

1850 Ala Moana Boulevard Unit 604 Honolulu, HI 96815

Listing
Overview

Price: $485,000
Area: WAIKIKI
Status: Active Under Contract

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202504941"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "1850"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(9) "Ala Moana"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(9) "Boulevard"
  }
  ["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) "96815"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "485000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKIKI"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(782) "Don't miss out to own the premier unit that comes with two assigned parkings! The desirable Diamond Head & ocean view unit in Palms at Waikiki. It is conveniently located at gateway to Waikiki and also close to Ala Moana Center, Duke Kahanamoku Lagoon and Fort DeRussy. Ther are on-site amenities including BBQ, A pool and sun deck and restaurant. Guest rooms were newly renovated in 2020 with carpet, cabinet, closet, furniture, curtain and fresh paint. There are microwave and refrigerator at the kitchenette.  Tasteful furnished and decorated but the earth color makes Hawaiian & contemporary style. There are sprinklers and wired smoke detectors in the building. The unit is currently in the hotel pool which is managed by Aqua Aston. New Ower can take over or manage by itself."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(13) "Locations LLC"
  }
  ["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) "323"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1970"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(16) "Palms At Waikiki"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(4) "8-14"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(18) "Diamond Head,Ocean"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "769.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) "LOCA"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(33) "angela.brenna@locationshawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 735-4200"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(20) "Angela Hiroko Brenna"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18554971"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-12-30T16:27:07.547"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-02-14"
  }
  ["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) "16:27:07.547"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26880871"
  }
  ["listing_image"]=>
  array(25) {
    [0]=>
    string(8) "26880871"
    [1]=>
    string(8) "26880872"
    [2]=>
    string(8) "26880873"
    [3]=>
    string(8) "26880874"
    [4]=>
    string(8) "26880875"
    [5]=>
    string(8) "26880876"
    [6]=>
    string(8) "26880877"
    [7]=>
    string(8) "26880878"
    [8]=>
    string(8) "26880879"
    [9]=>
    string(8) "26880880"
    [10]=>
    string(8) "26880881"
    [11]=>
    string(8) "26880882"
    [12]=>
    string(8) "26880883"
    [13]=>
    string(8) "26880884"
    [14]=>
    string(8) "26880885"
    [15]=>
    string(8) "26880886"
    [16]=>
    string(8) "26880887"
    [17]=>
    string(8) "26880888"
    [18]=>
    string(8) "26880889"
    [19]=>
    string(8) "26880890"
    [20]=>
    string(8) "26880891"
    [21]=>
    string(8) "26880892"
    [22]=>
    string(8) "26880893"
    [23]=>
    string(8) "26880894"
    [24]=>
    string(8) "26880895"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202504941
        )

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

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

    [StreetName] => Array
        (
            [0] => Ala Moana
        )

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Don't miss out to own the premier unit that comes with two assigned parkings! The desirable Diamond Head & ocean view unit in Palms at Waikiki. It is conveniently located at gateway to Waikiki and also close to Ala Moana Center, Duke Kahanamoku Lagoon and Fort DeRussy. Ther are on-site amenities including BBQ, A pool and sun deck and restaurant. Guest rooms were newly renovated in 2020 with carpet, cabinet, closet, furniture, curtain and fresh paint. There are microwave and refrigerator at the kitchenette.  Tasteful furnished and decorated but the earth color makes Hawaiian & contemporary style. There are sprinklers and wired smoke detectors in the building. The unit is currently in the hotel pool which is managed by Aqua Aston. New Ower can take over or manage by itself.
        )

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

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

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

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

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

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

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

    [BuildingName] => Array
        (
            [0] => Palms At Waikiki
        )

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

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

    [StoriesType] => Array
        (
            [0] => 8-14
        )

    [View] => Array
        (
            [0] => Diamond Head,Ocean
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => angela.brenna@locationshawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 735-4200
        )

    [ListAgentFullName] => Array
        (
            [0] => Angela Hiroko Brenna
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-12-30T16:27:07.547
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-02-14
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 16:27:07.547
        )

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

    [listing_image] => Array
        (
            [0] => 26880871
            [1] => 26880872
            [2] => 26880873
            [3] => 26880874
            [4] => 26880875
            [5] => 26880876
            [6] => 26880877
            [7] => 26880878
            [8] => 26880879
            [9] => 26880880
            [10] => 26880881
            [11] => 26880882
            [12] => 26880883
            [13] => 26880884
            [14] => 26880885
            [15] => 26880886
            [16] => 26880887
            [17] => 26880888
            [18] => 26880889
            [19] => 26880890
            [20] => 26880891
            [21] => 26880892
            [22] => 26880893
            [23] => 26880894
            [24] => 26880895
        )

)

PROPERTY INFO

• Full Baths: 1
• Living (sf): 323
• Year Built: 1970
• Building Name: Palms At Waikiki

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 2
• View: Diamond Head,Ocean
• Listing Office: Locations LLC

FINANCIAL INFO

• Maintenance Fees: $769
• 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 December 30, 2025 - 4:27 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.