Listing
Overview
Price: $810,000
Area: KAKAAKO
Status: Pending
Amazing mountain, city and ocean views from this breezy high floor unit! Come home to this well kept 2 bedroom, 2 bathroom with 2 covered parking stall unit in the pet-friendly and secure Keola Lai. Expansive amenities include a beautiful pool, BBQ cabanas, Jacuzzi, fitness gym and lots of guest parking stalls. Roam the neighborhood full of shopping, restaurants, coffee shops, SALT, Ward Center, Ala Moana Center, sandy beaches and more. 2.375% VA assumable loan for qualified VA buyers. Estimated payoff is $721,836 with $3,281 monthly payments which include principal, interest, and escrow for taxes and insurance. Put this on your must see list! One or more photos have been enhanced. Listing by: Redfin Corporation (808) 755-5052
array(48) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202427219"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(3) "600"
}
["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) "3507"
}
["City"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96813"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(51) "https://my.matterport.com/show/?m=gyWvECjdMkf&mls=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "810000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KAKAAKO"
}
["Status"]=>
array(1) {
[0]=>
string(7) "Pending"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(690) "Amazing mountain, city and ocean views from this breezy high floor unit! Come home to this well kept 2 bedroom, 2 bathroom with 2 covered parking stall unit in the pet-friendly and secure Keola Lai. Expansive amenities include a beautiful pool, BBQ cabanas, Jacuzzi, fitness gym and lots of guest parking stalls. Roam the neighborhood full of shopping, restaurants, coffee shops, SALT, Ward Center, Ala Moana Center, sandy beaches and more. 2.375% VA assumable loan for qualified VA buyers. Estimated payoff is $721,836 with $3,281 monthly payments which include principal, interest, and escrow for taxes and insurance. Put this on your must see list! One or more photos have been enhanced."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(18) "Redfin Corporation"
}
["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(3) "934"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2008"
}
["BuildingName"]=>
array(1) {
[0]=>
string(9) "Keola Lai"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "21+"
}
["View"]=>
array(1) {
[0]=>
string(27) "City,Mountain,Ocean,Sunrise"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "828.16"
}
["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(23) "mike.demello@redfin.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 755-5052"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(17) "Michael D DeMello"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-12-27T19:55:07.790"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18398911"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26787242"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26787242"
[1]=>
string(8) "26787243"
[2]=>
string(8) "26787244"
[3]=>
string(8) "26787245"
[4]=>
string(8) "26787246"
[5]=>
string(8) "26787247"
[6]=>
string(8) "26787248"
[7]=>
string(8) "26787249"
[8]=>
string(8) "26787250"
[9]=>
string(8) "26787251"
[10]=>
string(8) "26787252"
[11]=>
string(8) "26787253"
[12]=>
string(8) "26787254"
[13]=>
string(8) "26787255"
[14]=>
string(8) "26787256"
[15]=>
string(8) "26787257"
[16]=>
string(8) "26787258"
[17]=>
string(8) "26787259"
[18]=>
string(8) "26787260"
[19]=>
string(8) "26787261"
[20]=>
string(8) "26787262"
[21]=>
string(8) "26787263"
[22]=>
string(8) "26787264"
[23]=>
string(8) "26787265"
[24]=>
string(8) "26787266"
[25]=>
string(8) "26787267"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-11-27"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "19:55:07.790"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202427219
)
[StreetNumber] => Array
(
[0] => 600
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Queen
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 3507
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96813
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=gyWvECjdMkf&mls=1
)
[ListPrice] => Array
(
[0] => 810000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => KAKAAKO
)
[Status] => Array
(
[0] => Pending
)
[PublicRemarks] => Array
(
[0] => Amazing mountain, city and ocean views from this breezy high floor unit! Come home to this well kept 2 bedroom, 2 bathroom with 2 covered parking stall unit in the pet-friendly and secure Keola Lai. Expansive amenities include a beautiful pool, BBQ cabanas, Jacuzzi, fitness gym and lots of guest parking stalls. Roam the neighborhood full of shopping, restaurants, coffee shops, SALT, Ward Center, Ala Moana Center, sandy beaches and more. 2.375% VA assumable loan for qualified VA buyers. Estimated payoff is $721,836 with $3,281 monthly payments which include principal, interest, and escrow for taxes and insurance. Put this on your must see list! One or more photos have been enhanced.
)
[ListOfficeName] => Array
(
[0] => Redfin Corporation
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 934
)
[YearBuilt] => Array
(
[0] => 2008
)
[BuildingName] => Array
(
[0] => Keola Lai
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => 21+
)
[View] => Array
(
[0] => City,Mountain,Ocean,Sunrise
)
[MaintenanceExpense] => Array
(
[0] => 828.16
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => RFIN
)
[ListAgentEmail] => Array
(
[0] => mike.demello@redfin.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 755-5052
)
[ListAgentFullName] => Array
(
[0] => Michael D DeMello
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-12-27T19:55:07.790
)
[Matrix_Unique_ID] => Array
(
[0] => 18398911
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26787242
)
[listing_image] => Array
(
[0] => 26787242
[1] => 26787243
[2] => 26787244
[3] => 26787245
[4] => 26787246
[5] => 26787247
[6] => 26787248
[7] => 26787249
[8] => 26787250
[9] => 26787251
[10] => 26787252
[11] => 26787253
[12] => 26787254
[13] => 26787255
[14] => 26787256
[15] => 26787257
[16] => 26787258
[17] => 26787259
[18] => 26787260
[19] => 26787261
[20] => 26787262
[21] => 26787263
[22] => 26787264
[23] => 26787265
[24] => 26787266
[25] => 26787267
)
[ListingContractDate] => Array
(
[0] => 2024-11-27
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 19:55:07.790
)
)
- BedsTotal: 2
- Full Baths: 2
- Living (sf): 934
- Year Built: 2008
- Building Name: Keola Lai
- Property Condition: Average
- Number of Parking Spaces: 2
- View: City,Mountain,Ocean,Sunrise
- Listing Office: Redfin Corporation
- Maintenance Fees: $828
- Land Tenure: FS - Fee Simple
