Thanksgiving - The office will be closed on Thursday 11/27/25 and Friday 11/28/25
Christmas - The office will be closed on Thursday 12/25/25 and Friday 12/26/25
New Years - The office will be closed on Thursday 1/1/26 and Friday 1/2/26
Legal short term rental opportunity in the center of Waikiki with exceptional amenities and restaurant on site. Amenities include a tropical pool with waterfall, jacuzzi, and BBQ facilities. The pool area is a tropical oasis in the heart of Waikiki. Conveniently one block away from Waikiki Beach, dinning, shopping and entertainment. Remodeled in 2021 with new split A/C. Turnkey spacious studio unit, fully furnished with a tropical island aesthetic. Fantastic investment opportunity with high occupancy, currently in the hotel rental pool. Don't miss this opportunity to own an income generating slice of paradise. Listing by: eXp Realty (808) 725-2794
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202502724"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "2425"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(5) "Kuhio"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Avenue"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(3) "705"
}
["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=GCFNBrPPdBQ&mls=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "394900.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIKIKI"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(620) "Legal short term rental opportunity in the center of Waikiki with exceptional amenities and restaurant on site. Amenities include a tropical pool with waterfall, jacuzzi, and BBQ facilities. The pool area is a tropical oasis in the heart of Waikiki. Conveniently one block away from Waikiki Beach, dinning, shopping and entertainment. Remodeled in 2021 with new split A/C. Turnkey spacious studio unit, fully furnished with a tropical island aesthetic. Fantastic investment opportunity with high occupancy, currently in the hotel rental pool. Don't miss this opportunity to own an income generating slice of paradise."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(10) "eXp 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) "320"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1968"
}
["BuildingName"]=>
array(1) {
[0]=>
string(6) "Bamboo"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "0"
}
["StoriesType"]=>
array(1) {
[0]=>
string(0) ""
}
["View"]=>
array(1) {
[0]=>
string(13) "City,Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "792.20"
}
["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) "EXPI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(18) "kkrug808@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 725-2794"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(19) "Kristina AK Matsuda"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18512105"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-10-28T00:05:09.147"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-01-28"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "00:05:09.147"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26859085"
}
["listing_image"]=>
array(13) {
[0]=>
string(8) "26859085"
[1]=>
string(8) "26859086"
[2]=>
string(8) "26859087"
[3]=>
string(8) "26859088"
[4]=>
string(8) "26859089"
[5]=>
string(8) "26859090"
[6]=>
string(8) "26859091"
[7]=>
string(8) "26859092"
[8]=>
string(8) "26859093"
[9]=>
string(8) "26859094"
[10]=>
string(8) "26859095"
[11]=>
string(8) "26859096"
[12]=>
string(8) "26859097"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202502724
)
[StreetNumber] => Array
(
[0] => 2425
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Kuhio
)
[StreetSuffix] => Array
(
[0] => Avenue
)
[UnitNumber] => Array
(
[0] => 705
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96815
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=GCFNBrPPdBQ&mls=1
)
[ListPrice] => Array
(
[0] => 394900.00
)
[Neighbourhood] => Array
(
[0] => WAIKIKI
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Legal short term rental opportunity in the center of Waikiki with exceptional amenities and restaurant on site. Amenities include a tropical pool with waterfall, jacuzzi, and BBQ facilities. The pool area is a tropical oasis in the heart of Waikiki. Conveniently one block away from Waikiki Beach, dinning, shopping and entertainment. Remodeled in 2021 with new split A/C. Turnkey spacious studio unit, fully furnished with a tropical island aesthetic. Fantastic investment opportunity with high occupancy, currently in the hotel rental pool. Don't miss this opportunity to own an income generating slice of paradise.
)
[ListOfficeName] => Array
(
[0] => eXp Realty
)
[BedsTotal] => Array
(
[0] => 0
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 320
)
[YearBuilt] => Array
(
[0] => 1968
)
[BuildingName] => Array
(
[0] => Bamboo
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 0
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => City,Mountain
)
[MaintenanceExpense] => Array
(
[0] => 792.20
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => EXPI
)
[ListAgentEmail] => Array
(
[0] => kkrug808@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 725-2794
)
[ListAgentFullName] => Array
(
[0] => Kristina AK Matsuda
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18512105
)
[MatrixModifiedDT] => Array
(
[0] => 2025-10-28T00:05:09.147
)
[ListingContractDate] => Array
(
[0] => 2025-01-28
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 00:05:09.147
)
[_thumbnail_id] => Array
(
[0] => 26859085
)
[listing_image] => Array
(
[0] => 26859085
[1] => 26859086
[2] => 26859087
[3] => 26859088
[4] => 26859089
[5] => 26859090
[6] => 26859091
[7] => 26859092
[8] => 26859093
[9] => 26859094
[10] => 26859095
[11] => 26859096
[12] => 26859097
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on October 28, 2025 - 12:05 AM
Information is deemed reliable but not guaranteed.
Copyright: 2025 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®.
If you are interested in those active listings, our company may represent you as the buyer's agent.
If the active listing you are interested in is our company's active listing, you may speak to one of our agents
regarding your options for representation.
