Listing
Overview
Price: $975,000
Area: KAKAAKO
Status: Active
This gorgeous high floor residence comes with more than $100,000 of upgrades including its own EV Outlet for the unit’s parking stall, specious Walk-in Storage Room (approx. 44 sq ft), two storage lockers all on level 6 conveniently located near the elevator, and Developer's original Turn-Key Package crafted by renowned interior designer Lauren Rottet at Rottet Studio! Enjoy cool breezes, panoramic mountains, and city views. The fresh vibrant interior features contemporary elegant finishes throughout. Natural stone countertops with full-height backsplashes, Bosch kitchen appliances, beautiful flooring in the living room and walk-in closet in the bedroom. Stylish amenities include a rooftop Sky deck with breathtaking ocean view, fitness center, Yoga room, resort style pools, jacuzzi, private cabanas, BBQ areas, indoor/outdoor lounge, dog park, children's play area and more. It is Pet friendly! Close to the Whole Foods market, restaurants, shops, parks, Kewalo boat harbor and Ala Moana Beach Park. Listing by: Coldwell Banker Realty (808) 286-5118
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202320793"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(3) "987"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(5) "Queen"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(4) "3517"
}
["City"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96814"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(39) "http://player.vimeo.com/video/725119774"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "975000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "975000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KAKAAKO"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1012) "This gorgeous high floor residence comes with more than $100,000 of upgrades including its own EV Outlet for the unit’s parking stall, specious Walk-in Storage Room (approx. 44 sq ft), two storage lockers all on level 6 conveniently located near the elevator, and Developer's original Turn-Key Package crafted by renowned interior designer Lauren Rottet at Rottet Studio! Enjoy cool breezes, panoramic mountains, and city views. The fresh vibrant interior features contemporary elegant finishes throughout. Natural stone countertops with full-height backsplashes, Bosch kitchen appliances, beautiful flooring in the living room and walk-in closet in the bedroom. Stylish amenities include a rooftop Sky deck with breathtaking ocean view, fitness center, Yoga room, resort style pools, jacuzzi, private cabanas, BBQ areas, indoor/outdoor lounge, dog park, children's play area and more. It is Pet friendly! Close to the Whole Foods market, restaurants, shops, parks, Kewalo boat harbor and Ala Moana Beach Park."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["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(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "596"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2019"
}
["BuildingName"]=>
array(1) {
[0]=>
string(5) "Aalii"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "21+"
}
["View"]=>
array(1) {
[0]=>
string(21) "City,Mountain,Sunrise"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "704.17"
}
["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(6) "CBPP02"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(27) "hiromihawaiihomes@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 286-5118"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Hiromi Farmer"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-16T01:14:31.210"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17553799"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-09-11T14:23:36.210"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25951881"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "25951881"
[1]=>
string(8) "25951882"
[2]=>
string(8) "25951883"
[3]=>
string(8) "25951884"
[4]=>
string(8) "25951885"
[5]=>
string(8) "25951886"
[6]=>
string(8) "25951887"
[7]=>
string(8) "25951888"
[8]=>
string(8) "25951889"
[9]=>
string(8) "25951890"
[10]=>
string(8) "25951891"
[11]=>
string(8) "25951892"
[12]=>
string(8) "25951893"
[13]=>
string(8) "25951894"
[14]=>
string(8) "25951895"
[15]=>
string(8) "25951896"
[16]=>
string(8) "25951897"
[17]=>
string(8) "25951898"
[18]=>
string(8) "25951899"
[19]=>
string(8) "25951900"
[20]=>
string(8) "25951901"
[21]=>
string(8) "25951902"
[22]=>
string(8) "25951903"
[23]=>
string(8) "25951904"
[24]=>
string(8) "25951905"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202320793
)
[StreetNumber] => Array
(
[0] => 987
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Queen
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 3517
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96814
)
[VirtualTourURLUnbranded] => Array
(
[0] => http://player.vimeo.com/video/725119774
)
[ListPrice] => Array
(
[0] => 975000.00
)
[CurrentPrice] => Array
(
[0] => 975000.00
)
[Neighbourhood] => Array
(
[0] => KAKAAKO
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => This gorgeous high floor residence comes with more than $100,000 of upgrades including its own EV Outlet for the unit’s parking stall, specious Walk-in Storage Room (approx. 44 sq ft), two storage lockers all on level 6 conveniently located near the elevator, and Developer's original Turn-Key Package crafted by renowned interior designer Lauren Rottet at Rottet Studio! Enjoy cool breezes, panoramic mountains, and city views. The fresh vibrant interior features contemporary elegant finishes throughout. Natural stone countertops with full-height backsplashes, Bosch kitchen appliances, beautiful flooring in the living room and walk-in closet in the bedroom. Stylish amenities include a rooftop Sky deck with breathtaking ocean view, fitness center, Yoga room, resort style pools, jacuzzi, private cabanas, BBQ areas, indoor/outdoor lounge, dog park, children's play area and more. It is Pet friendly! Close to the Whole Foods market, restaurants, shops, parks, Kewalo boat harbor and Ala Moana Beach Park.
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 1
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 596
)
[YearBuilt] => Array
(
[0] => 2019
)
[BuildingName] => Array
(
[0] => Aalii
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => 21+
)
[View] => Array
(
[0] => City,Mountain,Sunrise
)
[MaintenanceExpense] => Array
(
[0] => 704.17
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => CBPP02
)
[ListAgentEmail] => Array
(
[0] => hiromihawaiihomes@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 286-5118
)
[ListAgentFullName] => Array
(
[0] => Hiromi Farmer
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-16T01:14:31.210
)
[Matrix_Unique_ID] => Array
(
[0] => 17553799
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-09-11T14:23:36.210
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 25951881
)
[listing_image] => Array
(
[0] => 25951881
[1] => 25951882
[2] => 25951883
[3] => 25951884
[4] => 25951885
[5] => 25951886
[6] => 25951887
[7] => 25951888
[8] => 25951889
[9] => 25951890
[10] => 25951891
[11] => 25951892
[12] => 25951893
[13] => 25951894
[14] => 25951895
[15] => 25951896
[16] => 25951897
[17] => 25951898
[18] => 25951899
[19] => 25951900
[20] => 25951901
[21] => 25951902
[22] => 25951903
[23] => 25951904
[24] => 25951905
)
)
- BedsTotal: 1
- Full Baths: 1
- Living (sf): 596
- Year Built: 2019
- Building Name: Aalii
- Property Condition: Excellent
- Number of Parking Spaces: 1
- View: City,Mountain,Sunrise
- Listing Office: Coldwell Banker Realty
- Maintenance Fees: $704
- Land Tenure: FS - Fee Simple