1551 Ala Wai Boulevard Unit 504 Honolulu, HI 96815

Listing
Overview

Price: $1,079,000
Area: WAIKIKI
Status: Active

Honolulu's premier luxury condominium offering true resort-style living near Waikiki and Ala Moana. This renovated 2-bedroom, 2-bath residence features new flooring, a new refrigerator, and new washer/dryer. The bright open floor plan flows to a generous 222 sq. ft. lanai, ideal for relaxing, dining, and enjoying the tropical breeze. Primary suite offers great privacy with an ensuite bath and ample closet space. Two covered parking stalls included. Enjoy exceptional amenities - heated pool, spa, fitness center, BBQ pavilions, walking paths, and 24-hour security - all within a peaceful, lush setting. A perfect blend of luxury, comfort, and island lifestyle. Listing by: Coldwell Banker Realty (808) 799-8890

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202600684"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "1551"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(7) "Ala Wai"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(9) "Boulevard"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(3) "504"
  }
  ["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(10) "1079000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKIKI"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(665) "Honolulu's premier luxury condominium offering true resort-style living near Waikiki and Ala Moana. This renovated 2-bedroom, 2-bath residence features new flooring, a new refrigerator, and new washer/dryer. The bright open floor plan flows to a generous 222 sq. ft. lanai, ideal for relaxing, dining, and enjoying the tropical breeze. Primary suite offers great privacy with an ensuite bath and ample closet space. Two covered parking stalls included. Enjoy exceptional amenities - heated pool, spa, fitness center, BBQ pavilions, walking paths, and 24-hour security - all within a  peaceful, lush setting. A perfect blend of luxury, comfort, and island lifestyle."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["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) "1334"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2008"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(13) "The Watermark"
  }
  ["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(30) "City,Marina/Canal,Ocean,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1861.63"
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(9) "Jefferson"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(10) "Washington"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(7) "Kaimuki"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(6) "CBPP02"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(32) "sabinekimhawaiirealtor@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 799-8890"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(12) "Sabine M Kim"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19207931"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-03-05T11:56:52.570"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-01-12"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(19) "Marina,Stream/Canal"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "11:56:52.570"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27269693"
  }
  ["listing_image"]=>
  array(22) {
    [0]=>
    string(8) "27269693"
    [1]=>
    string(8) "27269694"
    [2]=>
    string(8) "27269695"
    [3]=>
    string(8) "27269696"
    [4]=>
    string(8) "27269697"
    [5]=>
    string(8) "27269698"
    [6]=>
    string(8) "27269699"
    [7]=>
    string(8) "27269700"
    [8]=>
    string(8) "27269701"
    [9]=>
    string(8) "27269702"
    [10]=>
    string(8) "27269703"
    [11]=>
    string(8) "27269704"
    [12]=>
    string(8) "27269705"
    [13]=>
    string(8) "27269706"
    [14]=>
    string(8) "27269707"
    [15]=>
    string(8) "27269708"
    [16]=>
    string(8) "27269709"
    [17]=>
    string(8) "27269710"
    [18]=>
    string(8) "27269711"
    [19]=>
    string(8) "27269712"
    [20]=>
    string(8) "27269713"
    [21]=>
    string(8) "27269714"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202600684
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Honolulu's premier luxury condominium offering true resort-style living near Waikiki and Ala Moana. This renovated 2-bedroom, 2-bath residence features new flooring, a new refrigerator, and new washer/dryer. The bright open floor plan flows to a generous 222 sq. ft. lanai, ideal for relaxing, dining, and enjoying the tropical breeze. Primary suite offers great privacy with an ensuite bath and ample closet space. Two covered parking stalls included. Enjoy exceptional amenities - heated pool, spa, fitness center, BBQ pavilions, walking paths, and 24-hour security - all within a  peaceful, lush setting. A perfect blend of luxury, comfort, and island lifestyle.
        )

    [ListOfficeName] => Array
        (
            [0] => Coldwell Banker Realty
        )

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

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

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

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

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

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

    [BuildingName] => Array
        (
            [0] => The Watermark
        )

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

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

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

    [View] => Array
        (
            [0] => City,Marina/Canal,Ocean,Sunset
        )

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 799-8890
        )

    [ListAgentFullName] => Array
        (
            [0] => Sabine M Kim
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-03-05T11:56:52.570
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-01-12
        )

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

    [PropertyFrontage] => Array
        (
            [0] => Marina,Stream/Canal
        )

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

    [MatrixModifiedTime] => Array
        (
            [0] => 11:56:52.570
        )

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

    [listing_image] => Array
        (
            [0] => 27269693
            [1] => 27269694
            [2] => 27269695
            [3] => 27269696
            [4] => 27269697
            [5] => 27269698
            [6] => 27269699
            [7] => 27269700
            [8] => 27269701
            [9] => 27269702
            [10] => 27269703
            [11] => 27269704
            [12] => 27269705
            [13] => 27269706
            [14] => 27269707
            [15] => 27269708
            [16] => 27269709
            [17] => 27269710
            [18] => 27269711
            [19] => 27269712
            [20] => 27269713
            [21] => 27269714
        )

)

  • BedsTotal: 2
  • Full Baths: 2
  • Living (sf): 1,334
  • Year Built: 2008
  • Building Name: The Watermark

  • Property Condition: Above Average
  • Number of Parking Spaces: 2
  • View: City,Marina/Canal,Ocean,Sunset
  • Listing Office: Coldwell Banker Realty

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

  • Elementary School: Jefferson
  • Middle School: Washington
  • High School: Kaimuki

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 March 5, 2026 - 11:56 AM 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.

© Marcus Realty. All Rights Reserved.