Listing
Overview
Price: $625,000
Area: WAIKIKI
Status: Active Under Contract
Back on Market due to no fault of the unit! Turnkey Waikiki Retreat with Legal Vacation Rental Status!
A valid Non-Conforming Use Certificate (NUC), allows for legal daily vacation rentals. Discover the perfect blend of investment potential and island lifestyle in this renovated, fully furnished ocean-facing Condo at Waikiki Sunset! Located in the heart of Waikiki, this one bedroom/one bath unit features a king-size bed, full kitchen, plus an unassigned parking space. Parking can be scarce in Waikiki. Currently part of the Captain Cook rental program, this unit offers an opportunity for income generation or personal use.
On-site amenities include a sparkling pool, BBQ grilling area, sauna, fitness center, lanai/deck, with laundry facilities on each floor, creating a resort-style experience for both residents and guests. As an added bonus, the Monthly special assessment for Brand New central air conditioning will be paid in full by the seller at closing with a full price offer. This is a fantastic opportunity to own a legal vacation property in one of Waikiki’s most desirable buildings. Just a 3-5 minute stroll to iconic Waikiki Beach. Schedule your private showing today. Listing by: Coldwell Banker Island Prop. (808) 875-7000
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202518049"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(3) "229"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(10) "Paoakalani"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Avenue"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(10) "1004 (NUC)"
}
["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=DLegZYV23V9&mls=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "625000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIKIKI"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1202) "Back on Market due to no fault of the unit! Turnkey Waikiki Retreat with Legal Vacation Rental Status!
A valid Non-Conforming Use Certificate (NUC), allows for legal daily vacation rentals. Discover the perfect blend of investment potential and island lifestyle in this renovated, fully furnished ocean-facing Condo at Waikiki Sunset! Located in the heart of Waikiki, this one bedroom/one bath unit features a king-size bed, full kitchen, plus an unassigned parking space. Parking can be scarce in Waikiki. Currently part of the Captain Cook rental program, this unit offers an opportunity for income generation or personal use.
On-site amenities include a sparkling pool, BBQ grilling area, sauna, fitness center, lanai/deck, with laundry facilities on each floor, creating a resort-style experience for both residents and guests. As an added bonus, the Monthly special assessment for Brand New central air conditioning will be paid in full by the seller at closing with a full price offer. This is a fantastic opportunity to own a legal vacation property in one of Waikiki’s most desirable buildings. Just a 3-5 minute stroll to iconic Waikiki Beach. Schedule your private showing today."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(28) "Coldwell Banker Island Prop."
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "49963.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "631"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1979"
}
["BuildingName"]=>
array(1) {
[0]=>
string(14) "Waikiki Sunset"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(23) "Excellent,Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "21+"
}
["View"]=>
array(1) {
[0]=>
string(33) "City,Coastline,Diamond Head,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "926.39"
}
["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(6) "CBIP03"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(19) "Dano@DanoSayles.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 875-7000"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(11) "Dano Sayles"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18923929"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-11-06T10:20:59.497"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-08-15"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "10:20:59.497"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27109484"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27109484"
[1]=>
string(8) "27109485"
[2]=>
string(8) "27109486"
[3]=>
string(8) "27109487"
[4]=>
string(8) "27109488"
[5]=>
string(8) "27109489"
[6]=>
string(8) "27109490"
[7]=>
string(8) "27109491"
[8]=>
string(8) "27109492"
[9]=>
string(8) "27109493"
[10]=>
string(8) "27109494"
[11]=>
string(8) "27109495"
[12]=>
string(8) "27109496"
[13]=>
string(8) "27109497"
[14]=>
string(8) "27109498"
[15]=>
string(8) "27109499"
[16]=>
string(8) "27109500"
[17]=>
string(8) "27109501"
[18]=>
string(8) "27109502"
[19]=>
string(8) "27109503"
[20]=>
string(8) "27109504"
[21]=>
string(8) "27109505"
[22]=>
string(8) "27109506"
[23]=>
string(8) "27109507"
[24]=>
string(8) "27109508"
[25]=>
string(8) "27109509"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202518049
)
[StreetNumber] => Array
(
[0] => 229
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Paoakalani
)
[StreetSuffix] => Array
(
[0] => Avenue
)
[UnitNumber] => Array
(
[0] => 1004 (NUC)
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96815
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=DLegZYV23V9&mls=1
)
[ListPrice] => Array
(
[0] => 625000.00
)
[Neighbourhood] => Array
(
[0] => WAIKIKI
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Back on Market due to no fault of the unit! Turnkey Waikiki Retreat with Legal Vacation Rental Status!
A valid Non-Conforming Use Certificate (NUC), allows for legal daily vacation rentals. Discover the perfect blend of investment potential and island lifestyle in this renovated, fully furnished ocean-facing Condo at Waikiki Sunset! Located in the heart of Waikiki, this one bedroom/one bath unit features a king-size bed, full kitchen, plus an unassigned parking space. Parking can be scarce in Waikiki. Currently part of the Captain Cook rental program, this unit offers an opportunity for income generation or personal use.
On-site amenities include a sparkling pool, BBQ grilling area, sauna, fitness center, lanai/deck, with laundry facilities on each floor, creating a resort-style experience for both residents and guests. As an added bonus, the Monthly special assessment for Brand New central air conditioning will be paid in full by the seller at closing with a full price offer. This is a fantastic opportunity to own a legal vacation property in one of Waikiki’s most desirable buildings. Just a 3-5 minute stroll to iconic Waikiki Beach. Schedule your private showing today.
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Island Prop.
)
[BedsTotal] => Array
(
[0] => 1
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 49963.00
)
[SqftTotal] => Array
(
[0] => 631
)
[YearBuilt] => Array
(
[0] => 1979
)
[BuildingName] => Array
(
[0] => Waikiki Sunset
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => 21+
)
[View] => Array
(
[0] => City,Coastline,Diamond Head,Ocean
)
[MaintenanceExpense] => Array
(
[0] => 926.39
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => CBIP03
)
[ListAgentEmail] => Array
(
[0] => Dano@DanoSayles.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 875-7000
)
[ListAgentFullName] => Array
(
[0] => Dano Sayles
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18923929
)
[MatrixModifiedDT] => Array
(
[0] => 2025-11-06T10:20:59.497
)
[ListingContractDate] => Array
(
[0] => 2025-08-15
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 10:20:59.497
)
[_thumbnail_id] => Array
(
[0] => 27109484
)
[listing_image] => Array
(
[0] => 27109484
[1] => 27109485
[2] => 27109486
[3] => 27109487
[4] => 27109488
[5] => 27109489
[6] => 27109490
[7] => 27109491
[8] => 27109492
[9] => 27109493
[10] => 27109494
[11] => 27109495
[12] => 27109496
[13] => 27109497
[14] => 27109498
[15] => 27109499
[16] => 27109500
[17] => 27109501
[18] => 27109502
[19] => 27109503
[20] => 27109504
[21] => 27109505
[22] => 27109506
[23] => 27109507
[24] => 27109508
[25] => 27109509
)
)
- BedsTotal: 1
- Full Baths: 1
- Land Area (sf): 49,963 sf
- Living (sf): 631
- Year Built: 1979
- Building Name: Waikiki Sunset
- Property Condition: Excellent,Above Average
- Number of Parking Spaces: 1
- View: City,Coastline,Diamond Head,Ocean
- Listing Office: Coldwell Banker Island Prop.
- Maintenance Fees: $926
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on November 6, 2025 - 10:20 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.
© Marcus Realty. All Rights Reserved.