,

Listing
Overview

Price: $5,500,000
Area: MOKULEIA
Status: Sold

240 ft Beach frontage Unique opportunity to own one of the last large, oceanfront properties on Oahu. Arguably the best beachfront value in all Hawaiian islands! Create your secluded and sustainable lifestyle .Let the Ocean and Land feed your family, and your soul. Two dwellings allowed along with agricultural accessory structures such as barns, stables and AG processing buildings. Stunning beaches stretch for miles. World class surfing fishing diving, & sailing in your front yard. Short walk to Polo grounds. Honolulu is 45-minute drive, or 10 min by copter Short bike ride to Haleiwa Town with dozens of shops and restaurants. Magic Ocean and Mt views, See it and believe it!

Listing by: Hawaii Life

array(124) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(4) "0.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(10) "3738200.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(10) "3738200.00"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["easements"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["frontage"]=>
  array(1) {
    [0]=>
    string(28) "Ocean,Sandy Beach,Waterfront"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(9) "365512.00"
  }
  ["land_recorded"]=>
  array(1) {
    [0]=>
    string(10) "Land Court"
  }
  ["land_tenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["list_agent_email"]=>
  array(1) {
    [0]=>
    string(18) "seanginella@me.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(14) "Sean F Ginella"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(800) 370-3848"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-08-25"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(11) "Hawaii Life"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(10) "5500000.00"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202121517"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(8) "MOKULEIA"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "HLRE"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96791"
  }
  ["property_type"]=>
  array(1) {
    [0]=>
    string(16) "lots_acres_farms"
  }
  ["property_type_label"]=>
  array(1) {
    [0]=>
    string(16) "Lots Acres Farms"
  }
  ["region"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["rets_additional_parcels_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["rets_co_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["rets_co_list_agent_email"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["rets_co_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["rets_co_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["rets_co_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["rets_co_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["rets_co_list_office_mui"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["rets_co_list_office_name"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["rets_co_list_office_phone"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(10) "5000000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_foreclosure_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_id"]=>
  array(1) {
    [0]=>
    string(8) "16118439"
  }
  ["rets_immoviewer_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_internet_automated_valuation_dis"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_internet_consumer_comment_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(800) 370-3848"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(18) "seanginella@me.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(14) "Sean F Ginella"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "26432"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3476111"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "HLRE"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3487136"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(11) "Hawaii Life"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(800) 370-3848"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(10) "5500000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-08-25"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(9) "365512.00"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-27T10:00:38.970"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "16118439"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202121517"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(8) "MOKULEIA"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-08-25T20:25:08.260"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(10) "5500000.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-6-8-003-046-0000"
  }
  ["rets_permit_address_internet_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_permit_internet_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_photo_count"]=>
  array(1) {
    [0]=>
    string(1) "8"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-08T12:27:08.103"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96791"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-08-25T20:25:08.260"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "16118439"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(127) "Contact Sean Ginella: 808.372.8700 SeanGinella@HawaiiLife.com. Go to https://player.vimeo.com/video/286601361 for a video tour."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(682) "240 ft Beach frontage Unique opportunity to own one of the last large, oceanfront properties on Oahu. Arguably the best beachfront value in all Hawaiian islands! Create your secluded and sustainable lifestyle .Let the Ocean and Land feed your family, and your soul. Two dwellings allowed along with agricultural accessory structures such as barns, stables and AG processing buildings. Stunning beaches stretch for miles. World class surfing fishing diving, & sailing in your front yard. Short walk to Polo grounds. Honolulu is 45-minute drive, or 10 min by copter Short bike ride to Haleiwa Town with dozens of shops and restaurants. Magic Ocean and Mt views, See it and believe it!"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-27T10:00:38.970"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-27"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(10) "Farrington"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(6) "68-419"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(3) "2.5"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(7) "1758.00"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(10) "3738200.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(4) "0.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(10) "3738200.00"
  }
  ["rets_tax_paid_by_seller_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_tax_year"]=>
  array(1) {
    [0]=>
    string(4) "2020"
  }
  ["rets_thumbnail_url"]=>
  array(1) {
    [0]=>
    string(81) "https://cdn.rets.ci/marcusrealty-images/16118439/3e1cf54d5d567da94eb72f58e3f8775a"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "168"
  }
  ["rets_tmk_condo_property_regime_number"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_tmk_division"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tmk_parcel"]=>
  array(1) {
    [0]=>
    string(2) "46"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "8"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["setbacks"]=>
  array(1) {
    [0]=>
    string(3) "C&C"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["street_address"]=>
  array(1) {
    [0]=>
    string(44) "68-419 Farrington Highway, Waialua, HI 96791"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(10) "Farrington"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(6) "68-419"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(7) "Highway"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(17) "Cash,Conventional"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-6-8-003-046-0000"
  }
  ["topography"]=>
  array(1) {
    [0]=>
    string(12) "Clear,Wooded"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(24) "Coastline,Mountain,Ocean"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "16118439"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202121517"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463079227"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1632772866"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(30) "52 - AG-2 General Agricultural"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(861) "a:54:{i:0;i:20605111;i:1;i:20605112;i:2;i:20605113;i:3;i:20605114;i:4;i:20605115;i:5;i:20605116;i:6;i:20605117;i:7;i:20605118;i:8;i:20605119;i:9;i:20605120;i:10;i:20605223;i:11;i:20605224;i:12;i:20605225;i:13;i:20605226;i:14;i:20605227;i:15;i:20605228;i:16;i:20605229;i:17;i:20605230;i:18;i:20605231;i:19;i:20605232;i:20;i:20614046;i:21;i:20614047;i:22;i:20614048;i:23;i:20614049;i:24;i:20614050;i:25;i:20614051;i:26;i:20614052;i:27;i:20614053;i:28;i:20614054;i:29;i:20614055;i:30;i:20701691;i:31;i:20701692;i:32;i:20701693;i:33;i:20701694;i:34;i:20701695;i:35;i:20701696;i:36;i:20701697;i:37;i:20701698;i:38;i:20809354;i:39;i:20809355;i:40;i:20809356;i:41;i:20809357;i:42;i:20809358;i:43;i:20809359;i:44;i:20809360;i:45;i:20809361;i:46;i:20845091;i:47;i:20845092;i:48;i:20845093;i:49;i:20845094;i:50;i:20845095;i:51;i:20845096;i:52;i:20845097;i:53;i:20845098;}"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-08-26"
  }
  ["rets_expiration_date"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-27"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(10) "5000000.00"
  }
  ["rets_concessions"]=>
  array(1) {
    [0]=>
    string(6) "500000"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-27"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 825-4277"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(21) "orion@coastaloahu.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(14) "Orion R Barels"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "27696"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3477329"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "COHI"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "15465233"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(7) "Compass"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 825-4277"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20845091"
  }
}
Array
(
    [assd_val_imprv] => Array
        (
            [0] => 0.00
        )

    [assd_val_land] => Array
        (
            [0] => 3738200.00
        )

    [assd_val_total] => Array
        (
            [0] => 3738200.00
        )

    [city] => Array
        (
            [0] => Waialua
        )

    [county] => Array
        (
            [0] => Oahu
        )

    [disclosures] => Array
        (
            [0] => None
        )

    [easements] => Array
        (
            [0] => None
        )

    [frontage] => Array
        (
            [0] => Ocean,Sandy Beach,Waterfront
        )

    [land_area_sf] => Array
        (
            [0] => 365512.00
        )

    [land_recorded] => Array
        (
            [0] => Land Court
        )

    [land_tenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [list_agent_email] => Array
        (
            [0] => seanginella@me.com
        )

    [list_agent_name] => Array
        (
            [0] => Sean F Ginella
        )

    [list_agent_phone_number] => Array
        (
            [0] => (800) 370-3848
        )

    [list_date] => Array
        (
            [0] => 2021-08-25
        )

    [list_office_name] => Array
        (
            [0] => Hawaii Life
        )

    [list_price] => Array
        (
            [0] => 5500000.00
        )

    [mls_] => Array
        (
            [0] => 202121517
        )

    [neighborhood] => Array
        (
            [0] => MOKULEIA
        )

    [office_mls_id] => Array
        (
            [0] => HLRE
        )

    [postal_code] => Array
        (
            [0] => 96791
        )

    [property_type] => Array
        (
            [0] => lots_acres_farms
        )

    [property_type_label] => Array
        (
            [0] => Lots Acres Farms
        )

    [region] => Array
        (
            [0] => North Shore
        )

    [rets_additional_parcels_yn] => Array
        (
            [0] => 0
        )

    [rets_city] => Array
        (
            [0] => Waialua
        )

    [rets_co_list_agent_direct_work_phone] => Array
        (
            [0] => 
        )

    [rets_co_list_agent_email] => Array
        (
            [0] => 
        )

    [rets_co_list_agent_full_name] => Array
        (
            [0] => 
        )

    [rets_co_list_agent_mlsid] => Array
        (
            [0] => 
        )

    [rets_co_list_agent_mui] => Array
        (
            [0] => 
        )

    [rets_co_list_office_mlsid] => Array
        (
            [0] => 
        )

    [rets_co_list_office_mui] => Array
        (
            [0] => 
        )

    [rets_co_list_office_name] => Array
        (
            [0] => 
        )

    [rets_co_list_office_phone] => Array
        (
            [0] => 
        )

    [rets_current_price] => Array
        (
            [0] => 5000000.00
        )

    [rets_dom] => Array
        (
            [0] => 2
        )

    [rets_dual_variable_compensation_yn] => Array
        (
            [0] => 0
        )

    [rets_foreclosure_yn] => Array
        (
            [0] => 0
        )

    [rets_id] => Array
        (
            [0] => 16118439
        )

    [rets_immoviewer_yn] => Array
        (
            [0] => 0
        )

    [rets_internet_automated_valuation_dis] => Array
        (
            [0] => 1
        )

    [rets_internet_consumer_comment_yn] => Array
        (
            [0] => 1
        )

    [rets_list_agent_direct_work_phone] => Array
        (
            [0] => (800) 370-3848
        )

    [rets_list_agent_email] => Array
        (
            [0] => seanginella@me.com
        )

    [rets_list_agent_full_name] => Array
        (
            [0] => Sean F Ginella
        )

    [rets_list_agent_mlsid] => Array
        (
            [0] => 26432
        )

    [rets_list_agent_mui] => Array
        (
            [0] => 3476111
        )

    [rets_list_office_mlsid] => Array
        (
            [0] => HLRE
        )

    [rets_list_office_mui] => Array
        (
            [0] => 3487136
        )

    [rets_list_office_name] => Array
        (
            [0] => Hawaii Life
        )

    [rets_list_office_phone] => Array
        (
            [0] => (800) 370-3848
        )

    [rets_list_price] => Array
        (
            [0] => 5500000.00
        )

    [rets_listing_contract_date] => Array
        (
            [0] => 2021-08-25
        )

    [rets_lot_size_area] => Array
        (
            [0] => 365512.00
        )

    [rets_matrix_modified_dt] => Array
        (
            [0] => 2021-09-27T10:00:38.970
        )

    [rets_matrix_unique_id] => Array
        (
            [0] => 16118439
        )

    [rets_mls_number] => Array
        (
            [0] => 202121517
        )

    [rets_neighbourhood] => Array
        (
            [0] => MOKULEIA
        )

    [rets_original_entry_timestamp] => Array
        (
            [0] => 2021-08-25T20:25:08.260
        )

    [rets_original_list_price] => Array
        (
            [0] => 5500000.00
        )

    [rets_parcel_number] => Array
        (
            [0] => 1-6-8-003-046-0000
        )

    [rets_permit_address_internet_yn] => Array
        (
            [0] => 1
        )

    [rets_permit_internet_yn] => Array
        (
            [0] => 1
        )

    [rets_photo_count] => Array
        (
            [0] => 8
        )

    [rets_photo_modification_timestamp] => Array
        (
            [0] => 2021-09-08T12:27:08.103
        )

    [rets_postal_code] => Array
        (
            [0] => 96791
        )

    [rets_price_change_timestamp] => Array
        (
            [0] => 2021-08-25T20:25:08.260
        )

    [rets_primary_key] => Array
        (
            [0] => 16118439
        )

    [rets_private_remarks] => Array
        (
            [0] => Contact Sean Ginella: 808.372.8700 SeanGinella@HawaiiLife.com. Go to https://player.vimeo.com/video/286601361 for a video tour.
        )

    [rets_public_remarks] => Array
        (
            [0] => 240 ft Beach frontage Unique opportunity to own one of the last large, oceanfront properties on Oahu. Arguably the best beachfront value in all Hawaiian islands! Create your secluded and sustainable lifestyle .Let the Ocean and Land feed your family, and your soul. Two dwellings allowed along with agricultural accessory structures such as barns, stables and AG processing buildings. Stunning beaches stretch for miles. World class surfing fishing diving, & sailing in your front yard. Short walk to Polo grounds. Honolulu is 45-minute drive, or 10 min by copter Short bike ride to Haleiwa Town with dozens of shops and restaurants. Magic Ocean and Mt views, See it and believe it!
        )

    [rets_state_or_province] => Array
        (
            [0] => HI
        )

    [rets_status_change_timestamp] => Array
        (
            [0] => 2021-09-27T10:00:38.970
        )

    [rets_status_contractual_search_date] => Array
        (
            [0] => 2021-09-27
        )

    [rets_street_name] => Array
        (
            [0] => Farrington
        )

    [rets_street_number] => Array
        (
            [0] => 68-419
        )

    [rets_sub_agency_compensation] => Array
        (
            [0] => 2.5
        )

    [rets_tax_amount] => Array
        (
            [0] => 1758.00
        )

    [rets_tax_assessed_value] => Array
        (
            [0] => 3738200.00
        )

    [rets_tax_assessed_value_improvements] => Array
        (
            [0] => 0.00
        )

    [rets_tax_assessed_value_land] => Array
        (
            [0] => 3738200.00
        )

    [rets_tax_paid_by_seller_yn] => Array
        (
            [0] => 0
        )

    [rets_tax_year] => Array
        (
            [0] => 2020
        )

    [rets_thumbnail_url] => Array
        (
            [0] => https://cdn.rets.ci/marcusrealty-images/16118439/3e1cf54d5d567da94eb72f58e3f8775a
        )

    [rets_tmk_area] => Array
        (
            [0] => 168
        )

    [rets_tmk_condo_property_regime_number] => Array
        (
            [0] => 0
        )

    [rets_tmk_division] => Array
        (
            [0] => 1
        )

    [rets_tmk_parcel] => Array
        (
            [0] => 46
        )

    [rets_tmk_section] => Array
        (
            [0] => 8
        )

    [rets_tmk_zone] => Array
        (
            [0] => 6
        )

    [rets_tmkplat] => Array
        (
            [0] => 3
        )

    [setbacks] => Array
        (
            [0] => C&C
        )

    [state_or_province] => Array
        (
            [0] => HI
        )

    [status] => Array
        (
            [0] => Sold
        )

    [street_address] => Array
        (
            [0] => 68-419 Farrington Highway, Waialua, HI 96791
        )

    [street_name] => Array
        (
            [0] => Farrington
        )

    [street_number] => Array
        (
            [0] => 68-419
        )

    [street_suffix] => Array
        (
            [0] => Highway
        )

    [terms_accept] => Array
        (
            [0] => Cash,Conventional
        )

    [tmk] => Array
        (
            [0] => 1-6-8-003-046-0000
        )

    [topography] => Array
        (
            [0] => Clear,Wooded
        )

    [view] => Array
        (
            [0] => Coastline,Mountain,Ocean
        )

    [wpp::rets_pk] => Array
        (
            [0] => 16118439
        )

    [wpp_gpid] => Array
        (
            [0] => 202121517
        )

    [wpp_import_schedule_id] => Array
        (
            [0] => 1463079227
        )

    [wpp_import_time] => Array
        (
            [0] => 1632772866
        )

    [zoning] => Array
        (
            [0] => 52 - AG-2 General Agricultural
        )

    [new_attached_media] => Array
        (
            [0] => a:54:{i:0;i:20605111;i:1;i:20605112;i:2;i:20605113;i:3;i:20605114;i:4;i:20605115;i:5;i:20605116;i:6;i:20605117;i:7;i:20605118;i:8;i:20605119;i:9;i:20605120;i:10;i:20605223;i:11;i:20605224;i:12;i:20605225;i:13;i:20605226;i:14;i:20605227;i:15;i:20605228;i:16;i:20605229;i:17;i:20605230;i:18;i:20605231;i:19;i:20605232;i:20;i:20614046;i:21;i:20614047;i:22;i:20614048;i:23;i:20614049;i:24;i:20614050;i:25;i:20614051;i:26;i:20614052;i:27;i:20614053;i:28;i:20614054;i:29;i:20614055;i:30;i:20701691;i:31;i:20701692;i:32;i:20701693;i:33;i:20701694;i:34;i:20701695;i:35;i:20701696;i:36;i:20701697;i:37;i:20701698;i:38;i:20809354;i:39;i:20809355;i:40;i:20809356;i:41;i:20809357;i:42;i:20809358;i:43;i:20809359;i:44;i:20809360;i:45;i:20809361;i:46;i:20845091;i:47;i:20845092;i:48;i:20845093;i:49;i:20845094;i:50;i:20845095;i:51;i:20845096;i:52;i:20845097;i:53;i:20845098;}
        )

    [rets_active_continue_to_show_date] => Array
        (
            [0] => 2021-08-26
        )

    [rets_expiration_date] => Array
        (
            [0] => 
        )

    [rets_close_date] => Array
        (
            [0] => 2021-09-27
        )

    [rets_close_price] => Array
        (
            [0] => 5000000.00
        )

    [rets_concessions] => Array
        (
            [0] => 500000
        )

    [rets_off_market_date] => Array
        (
            [0] => 2021-09-27
        )

    [rets_selling_agent_direct_work_phone] => Array
        (
            [0] => (808) 825-4277
        )

    [rets_selling_agent_email] => Array
        (
            [0] => orion@coastaloahu.com
        )

    [rets_selling_agent_full_name] => Array
        (
            [0] => Orion R Barels
        )

    [rets_selling_agent_mlsid] => Array
        (
            [0] => 27696
        )

    [rets_selling_agent_mui] => Array
        (
            [0] => 3477329
        )

    [rets_selling_office_mlsid] => Array
        (
            [0] => COHI
        )

    [rets_selling_office_mui] => Array
        (
            [0] => 15465233
        )

    [rets_selling_office_name] => Array
        (
            [0] => Compass
        )

    [rets_selling_office_phone] => Array
        (
            [0] => (808) 825-4277
        )

    [_thumbnail_id] => Array
        (
            [0] => 20845091
        )

)

  • Land Area (sf): 365,512

  • View: Coastline,Mountain,Ocean
  • Listing Office: Hawaii Life

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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