Our office will be closed on November 28 and 29, 2024, for Thanksgiving and the Day After Thanksgiving.
87-561 Farrington Highway Unit 209 Waianae, HI 96792
Listing Overview
Price: $440,000 Area: MAILI Status: Active
Welcome to your dream oceanfront getaway, just steps away from the beach! You will fall in love with this second-floor unit on the majestic Leeward coast with front-and-center ocean views that will command your attention. Your daily routine will consist of waking up to the sound of waves, enjoying your morning coffee on the private balcony, and taking in unforgettable sunsets each evening. Or if you prefer, take a dip in the pool and entertain family & friends with an outdoor BBQ. You will love your custom kitchen with stainless steel appliances, walk-in shower with new bath vanity, spacious walk-in closet in the bedroom, tankless water heater, and newly installed glass balcony doors, ideal for natural lighting and taking in all of the stunning views. Whether you're looking for a private beach retreat or an active lifestyle by the water, this oceanfront gem has it all. Listing by: Caron B Realty (808) 220-8527
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202424380"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "87-561"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(10) "Farrington"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(7) "Highway"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(3) "209"
}
["City"]=>
array(1) {
[0]=>
string(7) "Waianae"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96792"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "440000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "440000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(5) "MAILI"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(881) "Welcome to your dream oceanfront getaway, just steps away from the beach! You will fall in love with this second-floor unit on the majestic Leeward coast with front-and-center ocean views that will command your attention. Your daily routine will consist of waking up to the sound of waves, enjoying your morning coffee on the private balcony, and taking in unforgettable sunsets each evening. Or if you prefer, take a dip in the pool and entertain family & friends with an outdoor BBQ. You will love your custom kitchen with stainless steel appliances, walk-in shower with new bath vanity, spacious walk-in closet in the bedroom, tankless water heater, and newly installed glass balcony doors, ideal for natural lighting and taking in all of the stunning views. Whether you're looking for a private beach retreat or an active lifestyle by the water, this oceanfront gem has it all."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(14) "Caron B 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) "632"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1975"
}
["BuildingName"]=>
array(1) {
[0]=>
string(10) "Maili Cove"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(19) "Garden,Ocean,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "814.00"
}
["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) "CARB"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(19) "gabrilyn@caronb.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 220-8527"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Gabrilyn Lee"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-11-16T20:02:32.270"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18338268"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-24T00:05:36.927"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Leeward"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Ocean"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26743436"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26743436"
[1]=>
string(8) "26743437"
[2]=>
string(8) "26743438"
[3]=>
string(8) "26743439"
[4]=>
string(8) "26743440"
[5]=>
string(8) "26743441"
[6]=>
string(8) "26743442"
[7]=>
string(8) "26743443"
[8]=>
string(8) "26743444"
[9]=>
string(8) "26743445"
[10]=>
string(8) "26743446"
[11]=>
string(8) "26743447"
[12]=>
string(8) "26743448"
[13]=>
string(8) "26743449"
[14]=>
string(8) "26743450"
[15]=>
string(8) "26743451"
[16]=>
string(8) "26743452"
[17]=>
string(8) "26743453"
[18]=>
string(8) "26743454"
[19]=>
string(8) "26743455"
[20]=>
string(8) "26743456"
[21]=>
string(8) "26743457"
[22]=>
string(8) "26743458"
[23]=>
string(8) "26743459"
[24]=>
string(8) "26743460"
[25]=>
string(8) "26743461"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202424380
)
[StreetNumber] => Array
(
[0] => 87-561
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Farrington
)
[StreetSuffix] => Array
(
[0] => Highway
)
[UnitNumber] => Array
(
[0] => 209
)
[City] => Array
(
[0] => Waianae
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96792
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 440000.00
)
[CurrentPrice] => Array
(
[0] => 440000.00
)
[Neighbourhood] => Array
(
[0] => MAILI
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to your dream oceanfront getaway, just steps away from the beach! You will fall in love with this second-floor unit on the majestic Leeward coast with front-and-center ocean views that will command your attention. Your daily routine will consist of waking up to the sound of waves, enjoying your morning coffee on the private balcony, and taking in unforgettable sunsets each evening. Or if you prefer, take a dip in the pool and entertain family & friends with an outdoor BBQ. You will love your custom kitchen with stainless steel appliances, walk-in shower with new bath vanity, spacious walk-in closet in the bedroom, tankless water heater, and newly installed glass balcony doors, ideal for natural lighting and taking in all of the stunning views. Whether you're looking for a private beach retreat or an active lifestyle by the water, this oceanfront gem has it all.
)
[ListOfficeName] => Array
(
[0] => Caron B Realty
)
[BedsTotal] => Array
(
[0] => 1
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 632
)
[YearBuilt] => Array
(
[0] => 1975
)
[BuildingName] => Array
(
[0] => Maili Cove
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Garden,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 814.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => CARB
)
[ListAgentEmail] => Array
(
[0] => gabrilyn@caronb.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 220-8527
)
[ListAgentFullName] => Array
(
[0] => Gabrilyn Lee
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-11-16T20:02:32.270
)
[Matrix_Unique_ID] => Array
(
[0] => 18338268
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-24T00:05:36.927
)
[MLSAreaMajor] => Array
(
[0] => Leeward
)
[PropertyFrontage] => Array
(
[0] => Ocean
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26743436
)
[listing_image] => Array
(
[0] => 26743436
[1] => 26743437
[2] => 26743438
[3] => 26743439
[4] => 26743440
[5] => 26743441
[6] => 26743442
[7] => 26743443
[8] => 26743444
[9] => 26743445
[10] => 26743446
[11] => 26743447
[12] => 26743448
[13] => 26743449
[14] => 26743450
[15] => 26743451
[16] => 26743452
[17] => 26743453
[18] => 26743454
[19] => 26743455
[20] => 26743456
[21] => 26743457
[22] => 26743458
[23] => 26743459
[24] => 26743460
[25] => 26743461
)
)