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
229 Paoakalani Avenue Unit 3203 Honolulu, HI 96815
Legal Vacation Rental at Waikiki Sunset! Incredible value for this fully furnished, turnkey, high-floor unit with stunning mountain, city and golf course views that tower above the rest! Come see for yourself! This unit comes with a Non-Conforming Use Certificate (NCU), allowing for daily vacation rentals—ideal for an investor, second home, or full-time residence (lower taxes when owner-occupied!). This spacious 1-bedroom, 1-bath unit is move-in ready, whether for rental, personal, or vacation use. Additional perks include 1 covered unassigned parking stall, popcorn ceiling removal, sprinklers, a private open lanai, and a fully equipped kitchen—making lender financing easier. Located in a secure high-rise building in the heart of Waikiki, this unit is just steps from world-class beaches, shopping, dining, schools, parks, and all that Waikiki has to offer! The monthly maintenance fee covers all your necessities: electricity, water, hot water, cable TV, central air, sewer, and common area expenses. You're welcome to view our 3D Matterport scan online from the comfort of your phone or computer, or book your private tour today! Listing by: Redfin Corporation (808) 201-2821
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202502550"
}
["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(4) "3203"
}
["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=snjVttE943f&mls=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "675000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIKIKI"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1145) "Legal Vacation Rental at Waikiki Sunset! Incredible value for this fully furnished, turnkey, high-floor unit with stunning mountain, city and golf course views that tower above the rest! Come see for yourself! This unit comes with a Non-Conforming Use Certificate (NCU), allowing for daily vacation rentals—ideal for an investor, second home, or full-time residence (lower taxes when owner-occupied!). This spacious 1-bedroom, 1-bath unit is move-in ready, whether for rental, personal, or vacation use. Additional perks include 1 covered unassigned parking stall, popcorn ceiling removal, sprinklers, a private open lanai, and a fully equipped kitchen—making lender financing easier. Located in a secure high-rise building in the heart of Waikiki, this unit is just steps from world-class beaches, shopping, dining, schools, parks, and all that Waikiki has to offer! The monthly maintenance fee covers all your necessities: electricity, water, hot water, cable TV, central air, sewer, and common area expenses. You're welcome to view our 3D Matterport scan online from the comfort of your phone or computer, or book your private tour today!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(18) "Redfin Corporation"
}
["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) "601"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1979"
}
["BuildingName"]=>
array(1) {
[0]=>
string(14) "Waikiki Sunset"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "21+"
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "870.97"
}
["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(20) "gill.mara@redfin.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 201-2821"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(9) "Gill Mara"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18507431"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-10-29T17:20:32.950"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-01-27"
}
["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) "17:20:32.950"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26857246"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26857246"
[1]=>
string(8) "26857247"
[2]=>
string(8) "26857248"
[3]=>
string(8) "26857249"
[4]=>
string(8) "26857250"
[5]=>
string(8) "26857251"
[6]=>
string(8) "26857252"
[7]=>
string(8) "26857253"
[8]=>
string(8) "26857254"
[9]=>
string(8) "26857255"
[10]=>
string(8) "26857256"
[11]=>
string(8) "26857257"
[12]=>
string(8) "26857258"
[13]=>
string(8) "26857259"
[14]=>
string(8) "26857260"
[15]=>
string(8) "26857261"
[16]=>
string(8) "26857262"
[17]=>
string(8) "26857263"
[18]=>
string(8) "26857264"
[19]=>
string(8) "26857265"
[20]=>
string(8) "26857266"
[21]=>
string(8) "26857267"
[22]=>
string(8) "26857268"
[23]=>
string(8) "26857269"
[24]=>
string(8) "26857270"
[25]=>
string(8) "26857271"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202502550
)
[StreetNumber] => Array
(
[0] => 229
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Paoakalani
)
[StreetSuffix] => Array
(
[0] => Avenue
)
[UnitNumber] => Array
(
[0] => 3203
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96815
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=snjVttE943f&mls=1
)
[ListPrice] => Array
(
[0] => 675000.00
)
[Neighbourhood] => Array
(
[0] => WAIKIKI
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Legal Vacation Rental at Waikiki Sunset! Incredible value for this fully furnished, turnkey, high-floor unit with stunning mountain, city and golf course views that tower above the rest! Come see for yourself! This unit comes with a Non-Conforming Use Certificate (NCU), allowing for daily vacation rentals—ideal for an investor, second home, or full-time residence (lower taxes when owner-occupied!). This spacious 1-bedroom, 1-bath unit is move-in ready, whether for rental, personal, or vacation use. Additional perks include 1 covered unassigned parking stall, popcorn ceiling removal, sprinklers, a private open lanai, and a fully equipped kitchen—making lender financing easier. Located in a secure high-rise building in the heart of Waikiki, this unit is just steps from world-class beaches, shopping, dining, schools, parks, and all that Waikiki has to offer! The monthly maintenance fee covers all your necessities: electricity, water, hot water, cable TV, central air, sewer, and common area expenses. You're welcome to view our 3D Matterport scan online from the comfort of your phone or computer, or book your private tour today!
)
[ListOfficeName] => Array
(
[0] => Redfin Corporation
)
[BedsTotal] => Array
(
[0] => 1
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 49963.00
)
[SqftTotal] => Array
(
[0] => 601
)
[YearBuilt] => Array
(
[0] => 1979
)
[BuildingName] => Array
(
[0] => Waikiki Sunset
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => 21+
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] => 870.97
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => RFIN
)
[ListAgentEmail] => Array
(
[0] => gill.mara@redfin.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 201-2821
)
[ListAgentFullName] => Array
(
[0] => Gill Mara
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18507431
)
[MatrixModifiedDT] => Array
(
[0] => 2025-10-29T17:20:32.950
)
[ListingContractDate] => Array
(
[0] => 2025-01-27
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:20:32.950
)
[_thumbnail_id] => Array
(
[0] => 26857246
)
[listing_image] => Array
(
[0] => 26857246
[1] => 26857247
[2] => 26857248
[3] => 26857249
[4] => 26857250
[5] => 26857251
[6] => 26857252
[7] => 26857253
[8] => 26857254
[9] => 26857255
[10] => 26857256
[11] => 26857257
[12] => 26857258
[13] => 26857259
[14] => 26857260
[15] => 26857261
[16] => 26857262
[17] => 26857263
[18] => 26857264
[19] => 26857265
[20] => 26857266
[21] => 26857267
[22] => 26857268
[23] => 26857269
[24] => 26857270
[25] => 26857271
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on October 29, 2025 - 5:20 PM
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.
