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
        )

)

  • BedsTotal: 1
  • Full Baths: 1
  • Living (sf): 632
  • Year Built: 1975
  • Building Name: Maili Cove

  • Property Condition: Above Average
  • Number of Parking Spaces: 1
  • View: Garden,Ocean,Sunset
  • Listing Office: Caron B Realty

  • Maintenance Fees: $814
  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446