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 and golf course views that tower above the rest! (Check 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 or personal vacation use. Additional perks include 1 covered unassigned parking stall, popcorn ceiling removal, sprinklers, a private open lanai, and a fully equipped kitchen—making 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 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) 295-5195
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(1107) "Legal Vacation Rental at Waikiki Sunset! Incredible value for this fully furnished, turnkey, high-floor unit with stunning mountain and golf course views that tower above the rest! (Check 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 or personal vacation use. Additional perks include 1 covered unassigned parking stall, popcorn ceiling removal, sprinklers, a private open lanai, and a fully equipped kitchen—making 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 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) 295-5195"
}
["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-02-01T18:00:01.410"
}
["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) "18:00:01.410"
}
["_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 and golf course views that tower above the rest! (Check 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 or personal vacation use. Additional perks include 1 covered unassigned parking stall, popcorn ceiling removal, sprinklers, a private open lanai, and a fully equipped kitchen—making 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 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) 295-5195
)
[ListAgentFullName] => Array
(
[0] => Gill Mara
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18507431
)
[MatrixModifiedDT] => Array
(
[0] => 2025-02-01T18:00:01.410
)
[ListingContractDate] => Array
(
[0] => 2025-01-27
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 18:00:01.410
)
[_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
