1551 Ala Wai Boulevard Unit 3102 Honolulu, HI 96815

Listing
Overview

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

The resort-style living in the luxury condo situated in between Waikiki and Ala Moana. The lush green tropical garden welcomes you home! This luxury 2 bedroom, 2 bath unit with 2 full size parking stalls offers breathtaking ocean, marina, and sunset views from the desirable higher floor 02 unit at The Watermark. Freshly painted living room and bedroom walls. This higher 02 stack has a panoramic view of the coastline and city, providing a great ocean view during the day and mesmerizing city lights at night. Close to world-class Waikiki Beach, Ala Moana Shopping Center, and Ala Moana Beach Park. Convenient location yet, the moment you step inside the building, you are in a tranquil oasis. Amenities include, recreation deck, heated saltwater pool, hot tub, exercise room, sauna, BBQ areas, lush garden and pond, meeting room and 24-hr. security. Listing by: Associated Real Estate Advisor (808) 445-9199

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202316960"
  }
  ["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(4) "3102"
  }
  ["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) "1590000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1590000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKIKI"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(856) "The resort-style living in the luxury condo situated in between Waikiki and Ala Moana.  The lush green tropical garden welcomes you home!  This luxury 2 bedroom, 2 bath unit with 2 full size parking stalls offers breathtaking ocean, marina, and sunset views from the desirable higher floor 02 unit at The Watermark. Freshly painted living room and bedroom walls.  This higher 02 stack has a panoramic view of the coastline and city, providing a great ocean view during the day and mesmerizing city lights at night. Close to world-class Waikiki Beach, Ala Moana Shopping Center, and Ala Moana Beach Park.  Convenient location yet, the moment you step inside the building, you are in a tranquil oasis. Amenities include, recreation deck, heated saltwater pool, hot tub, exercise room, sauna, BBQ areas, lush garden and pond, meeting room and 24-hr. security."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(30) "Associated Real Estate Advisor"
  }
  ["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) "1188"
  }
  ["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(17) "City,Ocean,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1560.81"
  }
  ["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) "AREA"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(25) "yuko@associatedhawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 445-9199"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(11) "Yuko H Wada"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2023-09-29T10:39:41.823"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17455755"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2023-07-22T09:12:02.150"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "25878976"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "25878976"
    [1]=>
    string(8) "25878977"
    [2]=>
    string(8) "25878978"
    [3]=>
    string(8) "25878979"
    [4]=>
    string(8) "25878980"
    [5]=>
    string(8) "25878981"
    [6]=>
    string(8) "25878982"
    [7]=>
    string(8) "25878983"
    [8]=>
    string(8) "25878984"
    [9]=>
    string(8) "25878985"
    [10]=>
    string(8) "25878986"
    [11]=>
    string(8) "25878987"
    [12]=>
    string(8) "25878988"
    [13]=>
    string(8) "25878989"
    [14]=>
    string(8) "25878990"
    [15]=>
    string(8) "25878991"
    [16]=>
    string(8) "25878992"
    [17]=>
    string(8) "25878993"
    [18]=>
    string(8) "25878994"
    [19]=>
    string(8) "25878995"
    [20]=>
    string(8) "25878996"
    [21]=>
    string(8) "25878997"
    [22]=>
    string(8) "25878998"
    [23]=>
    string(8) "25878999"
    [24]=>
    string(8) "25879000"
    [25]=>
    string(8) "25879001"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202316960
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => The resort-style living in the luxury condo situated in between Waikiki and Ala Moana.  The lush green tropical garden welcomes you home!  This luxury 2 bedroom, 2 bath unit with 2 full size parking stalls offers breathtaking ocean, marina, and sunset views from the desirable higher floor 02 unit at The Watermark. Freshly painted living room and bedroom walls.  This higher 02 stack has a panoramic view of the coastline and city, providing a great ocean view during the day and mesmerizing city lights at night. Close to world-class Waikiki Beach, Ala Moana Shopping Center, and Ala Moana Beach Park.  Convenient location yet, the moment you step inside the building, you are in a tranquil oasis. Amenities include, recreation deck, heated saltwater pool, hot tub, exercise room, sauna, BBQ areas, lush garden and pond, meeting room and 24-hr. security.
        )

    [ListOfficeName] => Array
        (
            [0] => Associated Real Estate Advisor
        )

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

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

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

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

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

    [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,Ocean,Sunset
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => yuko@associatedhawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 445-9199
        )

    [ListAgentFullName] => Array
        (
            [0] => Yuko H Wada
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2023-09-29T10:39:41.823
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2023-07-22T09:12:02.150
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 25878976
            [1] => 25878977
            [2] => 25878978
            [3] => 25878979
            [4] => 25878980
            [5] => 25878981
            [6] => 25878982
            [7] => 25878983
            [8] => 25878984
            [9] => 25878985
            [10] => 25878986
            [11] => 25878987
            [12] => 25878988
            [13] => 25878989
            [14] => 25878990
            [15] => 25878991
            [16] => 25878992
            [17] => 25878993
            [18] => 25878994
            [19] => 25878995
            [20] => 25878996
            [21] => 25878997
            [22] => 25878998
            [23] => 25878999
            [24] => 25879000
            [25] => 25879001
        )

)

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

  • Property Condition: Above Average
  • Number of Parking Spaces: 2
  • View: City,Ocean,Sunset
  • Listing Office: Associated Real Estate Advisor

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

CONTACT US

Marcus Realty

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