2410 Cleghorn Street Unit 2504 Honolulu, HI 96815

Listing
Overview

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

Location, Location, Location - AND TWO SIDE BY SIDE COVERED SECURED PARKING STALLS WITH 180 DEGREE OCEAN VIEWS! This stunning property offers unparalleled views of the vibrant Waikiki coastline and cityscape from its spacious, beautifully designed interior and comes fully furnished. Experience the perfect blend of luxury and convenience in this prime location with easy access to world class shopping, dining, and the iconic beaches of Waikiki. Whether you're looking for a serene retreat or a dynamic urban lifestyle, Waikiki SkyTower #2504 has it all. Listing by: Hawaii Americana Realty (808) 791-2923 

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202421348"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "2410"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(8) "Cleghorn"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(4) "2504"
  }
  ["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) "539000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "539000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKIKI"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(555) "Location, Location, Location - AND TWO SIDE BY SIDE COVERED SECURED PARKING STALLS WITH 180 DEGREE OCEAN VIEWS! This stunning property offers unparalleled views of the vibrant Waikiki coastline and cityscape from its spacious, beautifully designed interior and comes fully furnished. Experience the perfect blend of luxury and convenience in this prime location with easy access to world class shopping, dining, and the iconic beaches of Waikiki. Whether you're looking for a serene retreat or a dynamic urban lifestyle, Waikiki SkyTower #2504 has it all."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(23) "Hawaii Americana Realty"
  }
  ["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(8) "22041.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "675"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1978"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(16) "Waikiki Skytower"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(23) "Excellent,Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "21+"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(27) "City,Coastline,Ocean,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1081.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) "HWAM"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(18) "mrsfilek@yahoo.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 791-2923"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Melissa J Filek"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-10-06T17:00:01.260"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18269928"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-09-19T13:57:51.533"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26701431"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26701431"
    [1]=>
    string(8) "26701432"
    [2]=>
    string(8) "26701433"
    [3]=>
    string(8) "26701434"
    [4]=>
    string(8) "26701435"
    [5]=>
    string(8) "26701436"
    [6]=>
    string(8) "26701437"
    [7]=>
    string(8) "26701438"
    [8]=>
    string(8) "26701439"
    [9]=>
    string(8) "26701440"
    [10]=>
    string(8) "26701441"
    [11]=>
    string(8) "26701442"
    [12]=>
    string(8) "26701443"
    [13]=>
    string(8) "26701444"
    [14]=>
    string(8) "26701445"
    [15]=>
    string(8) "26701446"
    [16]=>
    string(8) "26701447"
    [17]=>
    string(8) "26701448"
    [18]=>
    string(8) "26701449"
    [19]=>
    string(8) "26701450"
    [20]=>
    string(8) "26701451"
    [21]=>
    string(8) "26701452"
    [22]=>
    string(8) "26701453"
    [23]=>
    string(8) "26701454"
    [24]=>
    string(8) "26701455"
    [25]=>
    string(8) "26701456"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202421348
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Location, Location, Location - AND TWO SIDE BY SIDE COVERED SECURED PARKING STALLS WITH 180 DEGREE OCEAN VIEWS! This stunning property offers unparalleled views of the vibrant Waikiki coastline and cityscape from its spacious, beautifully designed interior and comes fully furnished. Experience the perfect blend of luxury and convenience in this prime location with easy access to world class shopping, dining, and the iconic beaches of Waikiki. Whether you're looking for a serene retreat or a dynamic urban lifestyle, Waikiki SkyTower #2504 has it all.
        )

    [ListOfficeName] => Array
        (
            [0] => Hawaii Americana Realty
        )

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

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

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

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

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

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

    [BuildingName] => Array
        (
            [0] => Waikiki Skytower
        )

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

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

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

    [View] => Array
        (
            [0] => City,Coastline,Ocean,Sunset
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => mrsfilek@yahoo.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 791-2923
        )

    [ListAgentFullName] => Array
        (
            [0] => Melissa J Filek
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-10-06T17:00:01.260
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-09-19T13:57:51.533
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26701431
            [1] => 26701432
            [2] => 26701433
            [3] => 26701434
            [4] => 26701435
            [5] => 26701436
            [6] => 26701437
            [7] => 26701438
            [8] => 26701439
            [9] => 26701440
            [10] => 26701441
            [11] => 26701442
            [12] => 26701443
            [13] => 26701444
            [14] => 26701445
            [15] => 26701446
            [16] => 26701447
            [17] => 26701448
            [18] => 26701449
            [19] => 26701450
            [20] => 26701451
            [21] => 26701452
            [22] => 26701453
            [23] => 26701454
            [24] => 26701455
            [25] => 26701456
        )

)

  • BedsTotal: 1
  • Full Baths: 1
  • Land Area (sf): 22,041
  • Living (sf): 675
  • Year Built: 1978
  • Building Name: Waikiki Skytower

  • Property Condition: Excellent,Above Average
  • Number of Parking Spaces: 2
  • View: City,Coastline,Ocean,Sunset
  • Listing Office: Hawaii Americana Realty

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

CONTACT US

Marcus Realty

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