Previous Next

247 Beach Walk Unit 504 Honolulu, HI 96815

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202615391"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(3) "247"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(5) "Beach"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(4) "Walk"
  }
  ["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(9) "550000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKIKI"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1151) "Kick back with a cold drink on cozy lanai after a day of beaching, shopping or dining along Waikiki's main strip. Retreat to your air-conditioned, freshly remodeled space featuring modern-chic decor and relaxing vibes. Just a half block to the beach and the 71-acre Fort DeRussy Beach park, and a half block the other way to top restaurants, shops, and entertainment. Don't miss the Friday night fireworks- perfectly viewable right from your lanai! Enjoy your island time in the chic, remodeled condo in a supremely located spot in Waikiki. All handpicked modern decor, and all amenities Waikiki has to offer. Just one block from world-famous Waikiki Beach, you'll be surrounded by award-winning restaurants, boutique shopping, luxury resorts, vibrant nightlife, and endless outdoor activities. Situated along prestigious Beach Walk--one of Waikiki's premier resort corridors-- this prime location puts the very best of paradise right at your doorstep. Whether you're seeking a tropical retreat, a legal vacation rental investment, or the flexibility t enjoy both, this is a rare opportunity to own in one of Hawaii's desirable visitors' designations."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(13) "Locations LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "4990.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "572"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1960"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(15) "Niihau Apts Inc"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(4) "8-14"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "452.00"
  }
  ["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(4) "LOCA"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(30) "doug.weber@locationshawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 799-9983"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(10) "Doug Weber"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19640455"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-08-30T20:04:58.813"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-08-13"
  }
  ["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) "20:04:58.813"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27491644"
  }
  ["listing_image"]=>
  array(21) {
    [0]=>
    string(8) "27491644"
    [1]=>
    string(8) "27491645"
    [2]=>
    string(8) "27491646"
    [3]=>
    string(8) "27491647"
    [4]=>
    string(8) "27491648"
    [5]=>
    string(8) "27491649"
    [6]=>
    string(8) "27491650"
    [7]=>
    string(8) "27491651"
    [8]=>
    string(8) "27491652"
    [9]=>
    string(8) "27491653"
    [10]=>
    string(8) "27491654"
    [11]=>
    string(8) "27491655"
    [12]=>
    string(8) "27491656"
    [13]=>
    string(8) "27491657"
    [14]=>
    string(8) "27491658"
    [15]=>
    string(8) "27491659"
    [16]=>
    string(8) "27491660"
    [17]=>
    string(8) "27491661"
    [18]=>
    string(8) "27491662"
    [19]=>
    string(8) "27491663"
    [20]=>
    string(8) "27491664"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202615391
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Kick back with a cold drink on cozy lanai after a day of beaching, shopping or dining along Waikiki's main strip. Retreat to your air-conditioned, freshly remodeled space featuring modern-chic decor and relaxing vibes. Just a half block to the beach and the 71-acre Fort DeRussy Beach park, and a half block the other way to top restaurants, shops, and entertainment. Don't miss the Friday night fireworks- perfectly viewable right from your lanai! Enjoy your island time in the chic, remodeled condo in a supremely located spot in Waikiki. All handpicked modern decor, and all amenities Waikiki has to offer. Just one block from world-famous Waikiki Beach, you'll be surrounded by award-winning restaurants, boutique shopping, luxury resorts, vibrant nightlife, and endless outdoor activities. Situated along prestigious Beach Walk--one of Waikiki's premier resort corridors-- this prime location puts the very best of paradise right at your doorstep. Whether you're seeking a tropical retreat, a legal vacation rental investment, or the flexibility t enjoy both, this is a rare opportunity to own in one of Hawaii's desirable visitors' designations.
        )

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

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

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

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

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

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

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

    [BuildingName] => Array
        (
            [0] => Niihau Apts Inc
        )

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => doug.weber@locationshawaii.com
        )

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

    [ListAgentFullName] => Array
        (
            [0] => Doug Weber
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-08-30T20:04:58.813
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-08-13
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 20:04:58.813
        )

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

    [listing_image] => Array
        (
            [0] => 27491644
            [1] => 27491645
            [2] => 27491646
            [3] => 27491647
            [4] => 27491648
            [5] => 27491649
            [6] => 27491650
            [7] => 27491651
            [8] => 27491652
            [9] => 27491653
            [10] => 27491654
            [11] => 27491655
            [12] => 27491656
            [13] => 27491657
            [14] => 27491658
            [15] => 27491659
            [16] => 27491660
            [17] => 27491661
            [18] => 27491662
            [19] => 27491663
            [20] => 27491664
        )

)

PROPERTY INFO

• BedsTotal: 1
• Full Baths: 1
• Land Area (sf): 4,990 sf
• Living (sf): 572
• Year Built: 1960
• Building Name: Niihau Apts Inc

KEY FEATURES

• Property Condition: Excellent
• View: None
• Listing Office: Locations LLC

FINANCIAL INFO

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

SCHOOLS

• 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 August 30, 2026 - 8:04 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.