Best priced unit with lower maintenance fees and property taxes adding to its appeal as a great and hassle-free investment. Quiet corner end studio unit in Palms at Waikiki Condotel. This studio offers City views and is located on the quieter side of the building, ensuring a tranquil escape amidst the vibrant Waikiki atmosphere. As a legal vacation rental in Waikiki, making it a highly attractive investment opportunity. Unit comes fully furnished allowing for immediate occupancy making it an excellent vacation investment. Located at the crossroads of Waikiki and Ala Moana, just a short distance to Waikiki beach. Residents and guests alike will relish in the convenient location with a plethora of dining, shopping, and entertainment options at their doorstep. The boutique condotel amenities, including a fitness center, pool, lounge area and a barbecue space. For added convenience, an IHOP restaurant is located within the building, making dining options readily available. Parking is available from the front desk. Experience the best of island living and vacation ownership. Listing by: Redfin Corporation (808) 201-2821
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202321002"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "1850"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(9) "Ala Moana"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(9) "Boulevard"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(3) "809"
}
["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(51) "https://my.matterport.com/show/?m=xnFjaZ4TKLy&mls=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "313000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "313000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIKIKI"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1086) "Best priced unit with lower maintenance fees and property taxes adding to its appeal as a great and hassle-free investment. Quiet corner end studio unit in Palms at Waikiki Condotel. This studio offers City views and is located on the quieter side of the building, ensuring a tranquil escape amidst the vibrant Waikiki atmosphere. As a legal vacation rental in Waikiki, making it a highly attractive investment opportunity. Unit comes fully furnished allowing for immediate occupancy making it an excellent vacation investment. Located at the crossroads of Waikiki and Ala Moana, just a short distance to Waikiki beach. Residents and guests alike will relish in the convenient location with a plethora of dining, shopping, and entertainment options at their doorstep. The boutique condotel amenities, including a fitness center, pool, lounge area and a barbecue space. For added convenience, an IHOP restaurant is located within the building, making dining options readily available. Parking is available from the front desk. Experience the best of island living and vacation ownership."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(18) "Redfin Corporation"
}
["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) "265"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1970"
}
["BuildingName"]=>
array(1) {
[0]=>
string(16) "Palms At Waikiki"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "0"
}
["StoriesType"]=>
array(1) {
[0]=>
string(4) "8-14"
}
["View"]=>
array(1) {
[0]=>
string(4) "City"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "582.38"
}
["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) "RFIN"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "mike.demello@redfin.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 201-2821"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(17) "Michael D DeMello"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-12-28T13:29:20.927"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17559823"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-09-14T13:12:01.637"
}
["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) "25955583"
}
["listing_image"]=>
array(16) {
[0]=>
string(8) "25955583"
[1]=>
string(8) "25955584"
[2]=>
string(8) "25955585"
[3]=>
string(8) "25955586"
[4]=>
string(8) "25955587"
[5]=>
string(8) "25955588"
[6]=>
string(8) "25955589"
[7]=>
string(8) "25955590"
[8]=>
string(8) "25955591"
[9]=>
string(8) "25955592"
[10]=>
string(8) "25955593"
[11]=>
string(8) "25955594"
[12]=>
string(8) "25955595"
[13]=>
string(8) "25955596"
[14]=>
string(8) "25955597"
[15]=>
string(8) "25957039"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202321002
)
[StreetNumber] => Array
(
[0] => 1850
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Ala Moana
)
[StreetSuffix] => Array
(
[0] => Boulevard
)
[UnitNumber] => Array
(
[0] => 809
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96815
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=xnFjaZ4TKLy&mls=1
)
[ListPrice] => Array
(
[0] => 313000.00
)
[CurrentPrice] => Array
(
[0] => 313000.00
)
[Neighbourhood] => Array
(
[0] => WAIKIKI
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Best priced unit with lower maintenance fees and property taxes adding to its appeal as a great and hassle-free investment. Quiet corner end studio unit in Palms at Waikiki Condotel. This studio offers City views and is located on the quieter side of the building, ensuring a tranquil escape amidst the vibrant Waikiki atmosphere. As a legal vacation rental in Waikiki, making it a highly attractive investment opportunity. Unit comes fully furnished allowing for immediate occupancy making it an excellent vacation investment. Located at the crossroads of Waikiki and Ala Moana, just a short distance to Waikiki beach. Residents and guests alike will relish in the convenient location with a plethora of dining, shopping, and entertainment options at their doorstep. The boutique condotel amenities, including a fitness center, pool, lounge area and a barbecue space. For added convenience, an IHOP restaurant is located within the building, making dining options readily available. Parking is available from the front desk. Experience the best of island living and vacation ownership.
)
[ListOfficeName] => Array
(
[0] => Redfin Corporation
)
[BedsTotal] => Array
(
[0] => 0
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 265
)
[YearBuilt] => Array
(
[0] => 1970
)
[BuildingName] => Array
(
[0] => Palms At Waikiki
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 0
)
[StoriesType] => Array
(
[0] => 8-14
)
[View] => Array
(
[0] => City
)
[MaintenanceExpense] => Array
(
[0] => 582.38
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => RFIN
)
[ListAgentEmail] => Array
(
[0] => mike.demello@redfin.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 201-2821
)
[ListAgentFullName] => Array
(
[0] => Michael D DeMello
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-12-28T13:29:20.927
)
[Matrix_Unique_ID] => Array
(
[0] => 17559823
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-09-14T13:12:01.637
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 25955583
)
[listing_image] => Array
(
[0] => 25955583
[1] => 25955584
[2] => 25955585
[3] => 25955586
[4] => 25955587
[5] => 25955588
[6] => 25955589
[7] => 25955590
[8] => 25955591
[9] => 25955592
[10] => 25955593
[11] => 25955594
[12] => 25955595
[13] => 25955596
[14] => 25955597
[15] => 25957039
)
)