Listing
Overview
Price: $2,250,000
Area: WAIKIKI
Status: Active
RESORT ZONING! Niihau Hotel allows for vacation rentals! New changes expected to the Oahu Vacation rental regulations indicate only Resort zoning! This amazing 3 bedroom and 2 full bath property with a washer and dryer, is simply amazing. The only unit on the top floor. Gorgeous views of the ocean, city and mountains. Large wrap-around lanai. Adjacent to Trump Tower, half a block to the Halekulani and the public beach access. Easily walk to the heart of Waikiki Shopping and Dining. Soon, the Hilton Hawaiian Village could start their Friday night fireworks, which can be viewed from the lanai of this exceptional and unique property. PARKING!!! There are 2 (TWO) Parking Stalls. Two parking! Travel back in time to the era of local entertainment and ocean evenings. This property offers it all. The epitome of an island experience. Full kitchen, high speed wi-fi, Eero extenders, smart TV and more. Everything you see is included in the sale, and all future bookings may be passed on to the new owner. This highly desired property is simply one of a kind. The top floor & 2 parking stalls!! Don’t miss this one! Information deemed reliable and comments are opinions. Sold As-Is. Listing by: Pacific International Realty (808) 375-9223
array(42) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202226209"
}
["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(7) "PH 1101"
}
["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(69) "https://app.immoviewer.com/landing/unbranded/63d2170893c1d01a8fd1a657"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "2250000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "2250000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIKIKI"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1185) "RESORT ZONING! Niihau Hotel allows for vacation rentals! New changes expected to the Oahu Vacation rental regulations indicate only Resort zoning! This amazing 3 bedroom and 2 full bath property with a washer and dryer, is simply amazing. The only unit on the top floor. Gorgeous views of the ocean, city and mountains. Large wrap-around lanai. Adjacent to Trump Tower, half a block to the Halekulani and the public beach access. Easily walk to the heart of Waikiki Shopping and Dining. Soon, the Hilton Hawaiian Village could start their Friday night fireworks, which can be viewed from the lanai of this exceptional and unique property. PARKING!!! There are 2 (TWO) Parking Stalls. Two parking! Travel back in time to the era of local entertainment and ocean evenings. This property offers it all. The epitome of an island experience. Full kitchen, high speed wi-fi, Eero extenders, smart TV and more. Everything you see is included in the sale, and all future bookings may be passed on to the new owner. This highly desired property is simply one of a kind. The top floor & 2 parking stalls!! Don’t miss this one! Information deemed reliable and comments are opinions. Sold As-Is."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(28) "Pacific International Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5009.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1863"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1960"
}
["BuildingName"]=>
array(1) {
[0]=>
string(15) "Niihau Apts Inc"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(8) "One,8-14"
}
["View"]=>
array(1) {
[0]=>
string(34) "City,Mountain,Ocean,Sunrise,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1239.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) "PINT"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "Melanie@MelanieLong.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 375-9223"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Melanie Long"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-07-18T15:12:03.093"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17055596"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-01-25T18:41:05.183"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25835465"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "25835465"
[1]=>
string(8) "25835466"
[2]=>
string(8) "25835467"
[3]=>
string(8) "25835468"
[4]=>
string(8) "25835469"
[5]=>
string(8) "25835470"
[6]=>
string(8) "25835471"
[7]=>
string(8) "25835472"
[8]=>
string(8) "25835473"
[9]=>
string(8) "25835474"
[10]=>
string(8) "25835475"
[11]=>
string(8) "25835476"
[12]=>
string(8) "25835477"
[13]=>
string(8) "25835478"
[14]=>
string(8) "25835479"
[15]=>
string(8) "25835480"
[16]=>
string(8) "25835481"
[17]=>
string(8) "25835482"
[18]=>
string(8) "25835483"
[19]=>
string(8) "25835484"
[20]=>
string(8) "25835485"
[21]=>
string(8) "25835486"
[22]=>
string(8) "25835487"
[23]=>
string(8) "25835488"
[24]=>
string(8) "25835489"
[25]=>
string(8) "25835490"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202226209
)
[StreetNumber] => Array
(
[0] => 247
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Beach
)
[StreetSuffix] => Array
(
[0] => Walk
)
[UnitNumber] => Array
(
[0] => PH 1101
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96815
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://app.immoviewer.com/landing/unbranded/63d2170893c1d01a8fd1a657
)
[ListPrice] => Array
(
[0] => 2250000.00
)
[CurrentPrice] => Array
(
[0] => 2250000.00
)
[Neighbourhood] => Array
(
[0] => WAIKIKI
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => RESORT ZONING! Niihau Hotel allows for vacation rentals! New changes expected to the Oahu Vacation rental regulations indicate only Resort zoning! This amazing 3 bedroom and 2 full bath property with a washer and dryer, is simply amazing. The only unit on the top floor. Gorgeous views of the ocean, city and mountains. Large wrap-around lanai. Adjacent to Trump Tower, half a block to the Halekulani and the public beach access. Easily walk to the heart of Waikiki Shopping and Dining. Soon, the Hilton Hawaiian Village could start their Friday night fireworks, which can be viewed from the lanai of this exceptional and unique property. PARKING!!! There are 2 (TWO) Parking Stalls. Two parking! Travel back in time to the era of local entertainment and ocean evenings. This property offers it all. The epitome of an island experience. Full kitchen, high speed wi-fi, Eero extenders, smart TV and more. Everything you see is included in the sale, and all future bookings may be passed on to the new owner. This highly desired property is simply one of a kind. The top floor & 2 parking stalls!! Don’t miss this one! Information deemed reliable and comments are opinions. Sold As-Is.
)
[ListOfficeName] => Array
(
[0] => Pacific International Realty
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 5009.00
)
[SqftTotal] => Array
(
[0] => 1863
)
[YearBuilt] => Array
(
[0] => 1960
)
[BuildingName] => Array
(
[0] => Niihau Apts Inc
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => One,8-14
)
[View] => Array
(
[0] => City,Mountain,Ocean,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 1239.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => PINT
)
[ListAgentEmail] => Array
(
[0] => Melanie@MelanieLong.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 375-9223
)
[ListAgentFullName] => Array
(
[0] => Melanie Long
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-07-18T15:12:03.093
)
[Matrix_Unique_ID] => Array
(
[0] => 17055596
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-01-25T18:41:05.183
)
[_thumbnail_id] => Array
(
[0] => 25835465
)
[listing_image] => Array
(
[0] => 25835465
[1] => 25835466
[2] => 25835467
[3] => 25835468
[4] => 25835469
[5] => 25835470
[6] => 25835471
[7] => 25835472
[8] => 25835473
[9] => 25835474
[10] => 25835475
[11] => 25835476
[12] => 25835477
[13] => 25835478
[14] => 25835479
[15] => 25835480
[16] => 25835481
[17] => 25835482
[18] => 25835483
[19] => 25835484
[20] => 25835485
[21] => 25835486
[22] => 25835487
[23] => 25835488
[24] => 25835489
[25] => 25835490
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 5,009
- Living (sf): 1,863
- Year Built: 1960
- Building Name: Niihau Apts Inc
- Property Condition: Above Average
- Number of Parking Spaces: 2
- View: City,Mountain,Ocean,Sunrise,Sunset
- Listing Office: Pacific International Realty
- Maintenance Fees: $1,239
- Land Tenure: FS - Fee Simple
