2572 Lemon Road Unit 906 Honolulu, HI 96815

Listing
Overview

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

Approved vacation rental building at the Diamond Head end of Waikiki. Investment property or residence. Ideal location for the active lifestyle. Approximately 3 minutes to the beach, Honolulu Zoo and only a mile to beautiful Kapiolani Park and Waikiki Aquarium. Hike world famous Diamond Head Crater only 2.5 miles away. Shopping, restaurants, and entertainment are dispersed throughout the neighborhood. Tradewinds Plaza has low HOA fees covering community laundry, first-come, first-served gated parking, cable, and internet service. Secured building provides full time resident manager, floor-restricted fobs, and cameras. Listing by: List Sotheby's Int'l Realty (808) 735-2411

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202410467"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "2572"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(5) "Lemon"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(4) "Road"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(3) "906"
  }
  ["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"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "550000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKIKI"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(626) "Approved vacation rental building at the Diamond Head end of Waikiki. Investment property or residence. Ideal location for the active lifestyle. Approximately 3 minutes to the beach, Honolulu Zoo and only a mile to beautiful Kapiolani Park and Waikiki Aquarium.  Hike world famous Diamond Head Crater only 2.5 miles away. Shopping, restaurants, and entertainment are dispersed throughout the neighborhood. Tradewinds Plaza has low HOA fees covering community laundry, first-come, first-served gated parking, cable, and internet service. Secured building provides full time resident manager, floor-restricted fobs, and cameras."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(27) "List Sotheby's Int'l Realty"
  }
  ["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) "481"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1979"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(16) "Tradewinds Plaza"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(7) "Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "703.34"
  }
  ["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) "LIST"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(18) "cshope@listsir.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 735-2411"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Cheryl A Shope"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-06-04T09:32:12.160"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17983664"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-05-02T13:19:11.667"
  }
  ["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) "26194338"
  }
  ["listing_image"]=>
  array(19) {
    [0]=>
    string(8) "26194338"
    [1]=>
    string(8) "26194339"
    [2]=>
    string(8) "26194340"
    [3]=>
    string(8) "26194341"
    [4]=>
    string(8) "26194342"
    [5]=>
    string(8) "26194343"
    [6]=>
    string(8) "26194344"
    [7]=>
    string(8) "26194345"
    [8]=>
    string(8) "26194346"
    [9]=>
    string(8) "26194347"
    [10]=>
    string(8) "26194348"
    [11]=>
    string(8) "26194349"
    [12]=>
    string(8) "26194350"
    [13]=>
    string(8) "26194351"
    [14]=>
    string(8) "26566796"
    [15]=>
    string(8) "26566797"
    [16]=>
    string(8) "26566798"
    [17]=>
    string(8) "26566799"
    [18]=>
    string(8) "26566800"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202410467
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Approved vacation rental building at the Diamond Head end of Waikiki. Investment property or residence. Ideal location for the active lifestyle. Approximately 3 minutes to the beach, Honolulu Zoo and only a mile to beautiful Kapiolani Park and Waikiki Aquarium.  Hike world famous Diamond Head Crater only 2.5 miles away. Shopping, restaurants, and entertainment are dispersed throughout the neighborhood. Tradewinds Plaza has low HOA fees covering community laundry, first-come, first-served gated parking, cable, and internet service. Secured building provides full time resident manager, floor-restricted fobs, and cameras.
        )

    [ListOfficeName] => Array
        (
            [0] => List Sotheby's Int'l Realty
        )

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

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

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

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

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

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

    [BuildingName] => Array
        (
            [0] => Tradewinds Plaza
        )

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

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

    [StoriesType] => Array
        (
            [0] => One
        )

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => cshope@listsir.com
        )

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

    [ListAgentFullName] => Array
        (
            [0] => Cheryl A Shope
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-06-04T09:32:12.160
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-05-02T13:19:11.667
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26194338
            [1] => 26194339
            [2] => 26194340
            [3] => 26194341
            [4] => 26194342
            [5] => 26194343
            [6] => 26194344
            [7] => 26194345
            [8] => 26194346
            [9] => 26194347
            [10] => 26194348
            [11] => 26194349
            [12] => 26194350
            [13] => 26194351
            [14] => 26566796
            [15] => 26566797
            [16] => 26566798
            [17] => 26566799
            [18] => 26566800
        )

)

  • Full Baths: 1
  • Living (sf): 481
  • Year Built: 1979
  • Building Name: Tradewinds Plaza

  • Property Condition: Average
  • View: None
  • Listing Office: List Sotheby's Int'l Realty

  • Maintenance Fees: $703
  • 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