2572 Lemon Road Unit 806 Honolulu, HI 96815

Listing
Overview

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

WOW!. Clean, largest model full kitchen studio in boutique building - steps to beach, park, zoo. Can be completely functioning with furnishings (furniture and furnishings are negotiable.) Brand new carpeting. Brand new drapes. Great, clean, secure building (computer fobs, cameras, resident manager). Please note the 1 parking stall shown in the listing means that every resident has the right to use up to 1 stall, subject to availability. Parking is first come first serve for all residents. Not guaranteed all residents will find a stall. Please inquire. (BONUS: deeded, covered, secure parking stall is available separately - ask about it.) LEGAL zoning for vacation rental/airbnb - even with new Honolulu ordinance. Coin laundry. Resident manager lives in blg. You will LOVE the location. Electric, hot water, cable included in maint. fee. AC. This is the BEST end of Waikiki; easy in/out to building. Walk the park in the mornings/evenings. Parades. Living in paradise. Listing by: Pacific Oasis Realty, LLC (808) 778-3275

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202417618"
  }
  ["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) "806"
  }
  ["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) "467000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "467000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKIKI"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(979) "WOW!. Clean, largest model full kitchen studio in boutique building - steps to beach, park, zoo. Can be completely functioning with furnishings (furniture and furnishings are negotiable.) Brand new carpeting.  Brand new drapes.  Great, clean, secure building (computer fobs, cameras, resident manager). Please note the 1 parking stall shown in the listing means that every resident has the right to use up to 1 stall, subject to availability. Parking is first come first serve for all residents. Not guaranteed all residents will find a stall. Please inquire.  (BONUS:  deeded, covered, secure parking stall is available separately - ask about it.) LEGAL zoning for vacation rental/airbnb - even with new Honolulu ordinance. Coin laundry. Resident manager lives in blg. You will LOVE the location. Electric, hot water, cable included in maint. fee. AC. This is the BEST end of Waikiki; easy in/out to building. Walk the park in the mornings/evenings. Parades. Living in paradise."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(25) "Pacific Oasis Realty, LLC"
  }
  ["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(8) "10019.00"
  }
  ["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) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(9) "None,City"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "703.34"
  }
  ["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) "HKNY"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(22) "neil@pacific-oasis.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 778-3275"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(10) "Neil Bates"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-09-01T10:28:54.727"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18182699"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-08-06T21:27:05.890"
  }
  ["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) "26650351"
  }
  ["listing_image"]=>
  array(16) {
    [0]=>
    string(8) "26650351"
    [1]=>
    string(8) "26650352"
    [2]=>
    string(8) "26650353"
    [3]=>
    string(8) "26650354"
    [4]=>
    string(8) "26650355"
    [5]=>
    string(8) "26650356"
    [6]=>
    string(8) "26650357"
    [7]=>
    string(8) "26650358"
    [8]=>
    string(8) "26650359"
    [9]=>
    string(8) "26650360"
    [10]=>
    string(8) "26650361"
    [11]=>
    string(8) "26650362"
    [12]=>
    string(8) "26650363"
    [13]=>
    string(8) "26650364"
    [14]=>
    string(8) "26650365"
    [15]=>
    string(8) "26650366"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202417618
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => WOW!. Clean, largest model full kitchen studio in boutique building - steps to beach, park, zoo. Can be completely functioning with furnishings (furniture and furnishings are negotiable.) Brand new carpeting.  Brand new drapes.  Great, clean, secure building (computer fobs, cameras, resident manager). Please note the 1 parking stall shown in the listing means that every resident has the right to use up to 1 stall, subject to availability. Parking is first come first serve for all residents. Not guaranteed all residents will find a stall. Please inquire.  (BONUS:  deeded, covered, secure parking stall is available separately - ask about it.) LEGAL zoning for vacation rental/airbnb - even with new Honolulu ordinance. Coin laundry. Resident manager lives in blg. You will LOVE the location. Electric, hot water, cable included in maint. fee. AC. This is the BEST end of Waikiki; easy in/out to building. Walk the park in the mornings/evenings. Parades. Living in paradise.
        )

    [ListOfficeName] => Array
        (
            [0] => Pacific Oasis Realty, LLC
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => neil@pacific-oasis.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 778-3275
        )

    [ListAgentFullName] => Array
        (
            [0] => Neil Bates
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-09-01T10:28:54.727
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-08-06T21:27:05.890
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26650351
            [1] => 26650352
            [2] => 26650353
            [3] => 26650354
            [4] => 26650355
            [5] => 26650356
            [6] => 26650357
            [7] => 26650358
            [8] => 26650359
            [9] => 26650360
            [10] => 26650361
            [11] => 26650362
            [12] => 26650363
            [13] => 26650364
            [14] => 26650365
            [15] => 26650366
        )

)

  • Full Baths: 1
  • Land Area (sf): 10,019
  • Living (sf): 481
  • Year Built: 1979
  • Building Name: Tradewinds Plaza

  • Property Condition: Average
  • Number of Parking Spaces: 1
  • View: None,City
  • Listing Office: Pacific Oasis Realty, LLC

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

CONTACT US

Marcus Realty

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