Listing
Overview
Price: $1,100,000
Area: WAIKIKI
Status: Active
Welcome to the nicest unit at the Waipuna! This stunning corner unit in the sky features panoramic Ocean, Diamond Head, and Mountain views! The meticulous 2023 remodel and three exposures truly set this home apart. The huge living room greets you with sweeping ocean views. The open kitchen has new crisp modern white cabinets and quartz counters accentuating the blue ocean and sky! The third bedroom was tastefully converted into an open dining room with mountain views and a built-in buffet with cabinets and storage. The primary bedroom has been reconfigured to fit a king sized bed, walk-in closet, and has a remodeled full bathroom and linen closet. The large second bedroom has floor to ceiling windows with gorgeous mountain views and a full en-suite bathroom. The third bathroom has a full bathtub. The three exposures maximize tradewinds keeping the home cool. There are brand new Mitsubishi split air conditioners. There are two large side-by-side covered parking stalls on the second floor and a separate storage unit. Waipuna is a well managed property and offers pickleball court, pool, gym, sauna, putting green, library, and plenty of guest parking. There is a dedicated dog park. Listing by: BHGRE Advantage Realty (808) 738-3600
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202501736"
}
["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) "3201"
}
["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(59) "https://listings.hetproductions.com/sites/kjljqgv/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1100000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIKIKI"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1198) "Welcome to the nicest unit at the Waipuna! This stunning corner unit in the sky features panoramic Ocean, Diamond Head, and Mountain views! The meticulous 2023 remodel and three exposures truly set this home apart. The huge living room greets you with sweeping ocean views. The open kitchen has new crisp modern white cabinets and quartz counters accentuating the blue ocean and sky! The third bedroom was tastefully converted into an open dining room with mountain views and a built-in buffet with cabinets and storage. The primary bedroom has been reconfigured to fit a king sized bed, walk-in closet, and has a remodeled full bathroom and linen closet. The large second bedroom has floor to ceiling windows with gorgeous mountain views and a full en-suite bathroom. The third bathroom has a full bathtub. The three exposures maximize tradewinds keeping the home cool. There are brand new Mitsubishi split air conditioners. There are two large side-by-side covered parking stalls on the second floor and a separate storage unit. Waipuna is a well managed property and offers pickleball court, pool, gym, sauna, putting green, library, and plenty of guest parking. There is a dedicated dog park."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1399"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1971"
}
["BuildingName"]=>
array(1) {
[0]=>
string(7) "Waipuna"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "21+"
}
["View"]=>
array(1) {
[0]=>
string(35) "Coastline,Diamond Head,Ocean,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1109.10"
}
["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) "ADVG"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(21) "SalG@betterhawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 738-3600"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Sal Gonzalez"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18485445"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-02-02T16:00:01.680"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-01-20"
}
["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) "16:00:01.680"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26847229"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26847229"
[1]=>
string(8) "26847230"
[2]=>
string(8) "26847231"
[3]=>
string(8) "26847232"
[4]=>
string(8) "26847233"
[5]=>
string(8) "26847234"
[6]=>
string(8) "26847235"
[7]=>
string(8) "26847236"
[8]=>
string(8) "26847237"
[9]=>
string(8) "26847238"
[10]=>
string(8) "26847239"
[11]=>
string(8) "26847240"
[12]=>
string(8) "26847241"
[13]=>
string(8) "26847242"
[14]=>
string(8) "26847243"
[15]=>
string(8) "26847244"
[16]=>
string(8) "26847245"
[17]=>
string(8) "26847246"
[18]=>
string(8) "26847247"
[19]=>
string(8) "26847248"
[20]=>
string(8) "26847249"
[21]=>
string(8) "26847250"
[22]=>
string(8) "26847251"
[23]=>
string(8) "26847252"
[24]=>
string(8) "26847253"
[25]=>
string(8) "26847254"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202501736
)
[StreetNumber] => Array
(
[0] => 469
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Ena
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] => 3201
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96815
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://listings.hetproductions.com/sites/kjljqgv/unbranded
)
[ListPrice] => Array
(
[0] => 1100000.00
)
[Neighbourhood] => Array
(
[0] => WAIKIKI
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to the nicest unit at the Waipuna! This stunning corner unit in the sky features panoramic Ocean, Diamond Head, and Mountain views! The meticulous 2023 remodel and three exposures truly set this home apart. The huge living room greets you with sweeping ocean views. The open kitchen has new crisp modern white cabinets and quartz counters accentuating the blue ocean and sky! The third bedroom was tastefully converted into an open dining room with mountain views and a built-in buffet with cabinets and storage. The primary bedroom has been reconfigured to fit a king sized bed, walk-in closet, and has a remodeled full bathroom and linen closet. The large second bedroom has floor to ceiling windows with gorgeous mountain views and a full en-suite bathroom. The third bathroom has a full bathtub. The three exposures maximize tradewinds keeping the home cool. There are brand new Mitsubishi split air conditioners. There are two large side-by-side covered parking stalls on the second floor and a separate storage unit. Waipuna is a well managed property and offers pickleball court, pool, gym, sauna, putting green, library, and plenty of guest parking. There is a dedicated dog park.
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 1399
)
[YearBuilt] => Array
(
[0] => 1971
)
[BuildingName] => Array
(
[0] => Waipuna
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => 21+
)
[View] => Array
(
[0] => Coastline,Diamond Head,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 1109.10
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => ADVG
)
[ListAgentEmail] => Array
(
[0] => SalG@betterhawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 738-3600
)
[ListAgentFullName] => Array
(
[0] => Sal Gonzalez
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18485445
)
[MatrixModifiedDT] => Array
(
[0] => 2025-02-02T16:00:01.680
)
[ListingContractDate] => Array
(
[0] => 2025-01-20
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 16:00:01.680
)
[_thumbnail_id] => Array
(
[0] => 26847229
)
[listing_image] => Array
(
[0] => 26847229
[1] => 26847230
[2] => 26847231
[3] => 26847232
[4] => 26847233
[5] => 26847234
[6] => 26847235
[7] => 26847236
[8] => 26847237
[9] => 26847238
[10] => 26847239
[11] => 26847240
[12] => 26847241
[13] => 26847242
[14] => 26847243
[15] => 26847244
[16] => 26847245
[17] => 26847246
[18] => 26847247
[19] => 26847248
[20] => 26847249
[21] => 26847250
[22] => 26847251
[23] => 26847252
[24] => 26847253
[25] => 26847254
)
)
- BedsTotal: 2
- Full Baths: 3
- Living (sf): 1,399
- Year Built: 1971
- Building Name: Waipuna
- Property Condition: Excellent
- Number of Parking Spaces: 2
- View: Coastline,Diamond Head,Ocean,Sunset
- Listing Office: BHGRE Advantage Realty
- Maintenance Fees: $1,109
- Land Tenure: FS - Fee Simple
