Listing
Overview
Price: $839,000
Area: WAIKIKI
Status: Active
STEP INTO this BEAUTIFULLY renovated and UPGRADED unit at Waipuna on the edge of Waikiki with Ocean and Diamond Head views to greet you at sunrise and welcome you home at sunset. This 2 bed/ 2 bath piece of paradise exudes attention to detail with features such as quartz counter tops, tiled backsplash, engineered acacia wood flooring throughout, art deco tiled bathroom floor, frosted closet doors, custom cabinets and stenciled accent wall in the primary bedroom and a built-in lighted bar and wine fridge for those well-deserved happy hours and weekends. ENJOY countless amenities including a heated pool, pickleball court, BBQ area, putting green, gym, 22 GUEST STALLS with a separate OVERNIGHT PARKING area allowed, surfboard racks and a convenient pet-run for our furry friends. CALL your favorite agent and make an appointment today! Please visit our FIRST OPEN HOUSE Sunday, 9/15 from 2-5pm. Listing by: BHGRE Advantage Realty (808) 372-7670
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202420911"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(3) "469"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(3) "Ena"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Road"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(4) "2804"
}
["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(60) "https://my.matterport.com/show/?m=Q6r9pQ7UMAq&brand=0&mls=1&"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "839000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "839000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIKIKI"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(900) "STEP INTO this BEAUTIFULLY renovated and UPGRADED unit at Waipuna on the edge of Waikiki with Ocean and Diamond Head views to greet you at sunrise and welcome you home at sunset. This 2 bed/ 2 bath piece of paradise exudes attention to detail with features such as quartz counter tops, tiled backsplash, engineered acacia wood flooring throughout, art deco tiled bathroom floor, frosted closet doors, custom cabinets and stenciled accent wall in the primary bedroom and a built-in lighted bar and wine fridge for those well-deserved happy hours and weekends. ENJOY countless amenities including a heated pool, pickleball court, BBQ area, putting green, gym, 22 GUEST STALLS with a separate OVERNIGHT PARKING area allowed, surfboard racks and a convenient pet-run for our furry friends. CALL your favorite agent and make an appointment today! Please visit our FIRST OPEN HOUSE Sunday, 9/15 from 2-5pm."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1071"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1971"
}
["BuildingName"]=>
array(1) {
[0]=>
string(7) "Waipuna"
}
["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(23) "City,Diamond Head,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "777.00"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(9) "Jefferson"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(10) "Washington"
}
["HighSchool"]=>
array(1) {
[0]=>
string(7) "Kaimuki"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(6) "ADVG02"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(25) "MelyssaS@BetterHawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 372-7670"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(24) "Melyssa Montes Shimamoto"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-18T11:30:01.913"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18257476"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-09-12T09:14:50.957"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26691502"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "26691502"
[1]=>
string(8) "26691503"
[2]=>
string(8) "26691504"
[3]=>
string(8) "26691505"
[4]=>
string(8) "26691506"
[5]=>
string(8) "26691507"
[6]=>
string(8) "26691508"
[7]=>
string(8) "26691509"
[8]=>
string(8) "26691510"
[9]=>
string(8) "26691511"
[10]=>
string(8) "26691512"
[11]=>
string(8) "26691513"
[12]=>
string(8) "26691514"
[13]=>
string(8) "26691515"
[14]=>
string(8) "26691516"
[15]=>
string(8) "26691517"
[16]=>
string(8) "26691518"
[17]=>
string(8) "26691519"
[18]=>
string(8) "26691520"
[19]=>
string(8) "26691521"
[20]=>
string(8) "26691522"
[21]=>
string(8) "26691523"
[22]=>
string(8) "26691524"
[23]=>
string(8) "26691525"
[24]=>
string(8) "26691526"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202420911
)
[StreetNumber] => Array
(
[0] => 469
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Ena
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] => 2804
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96815
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=Q6r9pQ7UMAq&brand=0&mls=1&
)
[ListPrice] => Array
(
[0] => 839000.00
)
[CurrentPrice] => Array
(
[0] => 839000.00
)
[Neighbourhood] => Array
(
[0] => WAIKIKI
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => STEP INTO this BEAUTIFULLY renovated and UPGRADED unit at Waipuna on the edge of Waikiki with Ocean and Diamond Head views to greet you at sunrise and welcome you home at sunset. This 2 bed/ 2 bath piece of paradise exudes attention to detail with features such as quartz counter tops, tiled backsplash, engineered acacia wood flooring throughout, art deco tiled bathroom floor, frosted closet doors, custom cabinets and stenciled accent wall in the primary bedroom and a built-in lighted bar and wine fridge for those well-deserved happy hours and weekends. ENJOY countless amenities including a heated pool, pickleball court, BBQ area, putting green, gym, 22 GUEST STALLS with a separate OVERNIGHT PARKING area allowed, surfboard racks and a convenient pet-run for our furry friends. CALL your favorite agent and make an appointment today! Please visit our FIRST OPEN HOUSE Sunday, 9/15 from 2-5pm.
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 1071
)
[YearBuilt] => Array
(
[0] => 1971
)
[BuildingName] => Array
(
[0] => Waipuna
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => 21+
)
[View] => Array
(
[0] => City,Diamond Head,Ocean
)
[MaintenanceExpense] => Array
(
[0] => 777.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Jefferson
)
[MiddleOrJuniorSchool] => Array
(
[0] => Washington
)
[HighSchool] => Array
(
[0] => Kaimuki
)
[ListOfficeMLSID] => Array
(
[0] => ADVG02
)
[ListAgentEmail] => Array
(
[0] => MelyssaS@BetterHawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 372-7670
)
[ListAgentFullName] => Array
(
[0] => Melyssa Montes Shimamoto
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-18T11:30:01.913
)
[Matrix_Unique_ID] => Array
(
[0] => 18257476
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-09-12T09:14:50.957
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26691502
)
[listing_image] => Array
(
[0] => 26691502
[1] => 26691503
[2] => 26691504
[3] => 26691505
[4] => 26691506
[5] => 26691507
[6] => 26691508
[7] => 26691509
[8] => 26691510
[9] => 26691511
[10] => 26691512
[11] => 26691513
[12] => 26691514
[13] => 26691515
[14] => 26691516
[15] => 26691517
[16] => 26691518
[17] => 26691519
[18] => 26691520
[19] => 26691521
[20] => 26691522
[21] => 26691523
[22] => 26691524
[23] => 26691525
[24] => 26691526
)
)
- BedsTotal: 2
- Full Baths: 2
- Living (sf): 1,071
- Year Built: 1971
- Building Name: Waipuna
- Property Condition: Excellent,Above Average
- Number of Parking Spaces: 1
- View: City,Diamond Head,Ocean
- Listing Office: BHGRE Advantage Realty
- Maintenance Fees: $777
- Land Tenure: FS - Fee Simple
- Elementary School: Jefferson
- Middle School: Washington
- High School: Kaimuki
