Listing
Overview
Price: $675,000
Area: WAIKIKI
Status: Active
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
)
)
- BedsTotal: 1
- Full Baths: 1
- Land Area (sf): 49,963 sf
- Living (sf): 601
- Year Built: 1979
- Building Name: Waikiki Sunset
- Property Condition: Above Average
- Number of Parking Spaces: 1
- View: Mountain
- Listing Office: Redfin Corporation
- Maintenance Fees: $871
- Land Tenure: FS - Fee Simple
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.
© Marcus Realty. All Rights Reserved.