Listing
Overview

Price: $350,000
Area: AG/PRESERVE
Status: Sold

Farm Land Only. Perfect to create your own private farm getaway. Direct river access to ocean and the North Shore beaches. Paddle your Kayak or drive your jet ski or boat to explore the near by beaches and bays or go for a surf. Fish and crab from your back yard deck. Can have green houses, storage sheds or other supporting farm structures. Property has county drinking water and AG farm water with power line close to driveway. Located at the beginning of Waialua and Haleiwa for prime location. Currently farmed with taro, mango, limes, banana lemon but ready for you to come in and grow what you want. Yurt is removed and property is sold with no structures.

  • Land Area (sf): 89,821

  • View: Marina/Canal,Mountain,Sunset
  • Listing Office: Hawaii Homes International

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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

array(118) {
  ["address_is_formatted"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(4) "0.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(7) "8400.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(7) "8400.00"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(24) "Property Disclosure Stmt"
  }
  ["easements"]=>
  array(1) {
    [0]=>
    string(38) "Driveway,Egress,Electric,Ingress,Water"
  }
  ["formatted_address"]=>
  array(1) {
    [0]=>
    string(32) "Farrington Hwy, Waialua, HI, USA"
  }
  ["formatted_address_simple"]=>
  array(1) {
    [0]=>
    string(32) "Farrington Hwy, Waialua, HI, USA"
  }
  ["frontage"]=>
  array(1) {
    [0]=>
    string(23) "Stream/Canal,Waterfront"
  }
  ["google_place_id"]=>
  array(1) {
    [0]=>
    string(110) "EiBGYXJyaW5ndG9uIEh3eSwgV2FpYWx1YSwgSEksIFVTQSIuKiwKFAoSCb0Td5pMYAB8EbLJjwz6W96xEhQKEgkNGNleXF8AfBGq8f41fki1vg"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(8) "89821.00"
  }
  ["land_recorded"]=>
  array(1) {
    [0]=>
    string(14) "Regular System"
  }
  ["land_tenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["list_agent_email"]=>
  array(1) {
    [0]=>
    string(15) "bgwvrdr@aol.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(12) "Ralph S Gray"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 949-0020"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2020-10-12"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(26) "Hawaii Homes International"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "350000.00"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202027187"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(11) "AG/PRESERVE"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "REEW"
  }
  ["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_compensation_method"]=>
  array(1) {
    [0]=>
    string(13) "Dual Variable"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(9) "280000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(3) "140"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_foreclosure_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_id"]=>
  array(1) {
    [0]=>
    string(8) "15493776"
  }
  ["rets_immoviewer_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 949-0020"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(15) "bgwvrdr@aol.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(12) "Ralph S Gray"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "24511"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3474891"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "REEW"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3486350"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(26) "Hawaii Homes International"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 949-0020"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(9) "350000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2020-10-12"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(8) "89821.00"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-04-27T10:34:55.153"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "15493776"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202027187"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(11) "AG/PRESERVE"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2020-10-15T18:22:45.113"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(10) "4000000.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-6-6-025-006-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(2) "23"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2020-10-16T09:37:27.923"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96791"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-01-21T12:32:41.700"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "15493776"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(290) "The yurt has been removed and the land is vacant. Private property, do not go on land without an appointment. Power available, AG water and potable water on property. Call Ralph for showing and information. Please use Commercial PSA for all offers. Virtual Tour: http://youtu.be/CCy5Emzq3Y0"
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(663) "Farm Land Only. Perfect to create your own private farm getaway. Direct river access to ocean and the North Shore beaches. Paddle your Kayak or drive your jet ski or boat to explore the near by beaches and bays or go for a surf. Fish and crab from your back yard deck. Can have green houses, storage sheds or other supporting farm structures. Property has county drinking water and AG farm water with power line close to driveway. Located at the beginning of Waialua and Haleiwa for prime location. Currently farmed with taro, mango, limes, banana lemon but ready for you to come in and grow what you want. Yurt is removed and property is sold with no structures."
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-04-27T10:34:55.153"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-04-27"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(10) "Farrington"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(3) "006"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(64) "1$21.569885$-158.137841$136.75$13.33$1.00$SLcFcKVPfUo0rBs3vJ7Wng"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(3) "2.5"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(5) "25.00"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(7) "8400.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(4) "0.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(7) "8400.00"
  }
  ["rets_tax_paid_by_seller_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tax_year"]=>
  array(1) {
    [0]=>
    string(4) "2020"
  }
  ["rets_thumbnail_url"]=>
  array(1) {
    [0]=>
    string(81) "https://cdn.rets.ci/marcusrealty-images/15493776/e5d67f92aa2e25092697391798540d31"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "166"
  }
  ["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(1) "6"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(2) "25"
  }
  ["rets_virtual_tour_url_unbranded"]=>
  array(1) {
    [0]=>
    string(27) "http://youtu.be/CCy5Emzq3Y0"
  }
  ["setbacks"]=>
  array(1) {
    [0]=>
    string(3) "C&C"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["street_address"]=>
  array(1) {
    [0]=>
    string(41) "006 Farrington Highway, Waialua, HI 96791"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(17) "Cash,Conventional"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-6-6-025-006-0000"
  }
  ["topography"]=>
  array(1) {
    [0]=>
    string(5) "Clear"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(28) "Marina/Canal,Mountain,Sunset"
  }
  ["virtual_tour"]=>
  array(1) {
    [0]=>
    string(27) "http://youtu.be/CCy5Emzq3Y0"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "15493776"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202027187"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463079227"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1628860110"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(31) "51 - AG-1 Restricted Agricultur"
  }
  ["latitude"]=>
  array(1) {
    [0]=>
    string(9) "21.567435"
  }
  ["longitude"]=>
  array(1) {
    [0]=>
    string(12) "-158.1272338"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(5202) "a:312:{i:0;i:16824327;i:1;i:16824328;i:2;i:16824329;i:3;i:16824330;i:4;i:16824331;i:5;i:16824332;i:6;i:16824333;i:7;i:16824334;i:8;i:16824335;i:9;i:16824336;i:10;i:16824337;i:11;i:16824338;i:12;i:16824339;i:13;i:16824340;i:14;i:16824341;i:15;i:16824342;i:16;i:16824343;i:17;i:16824344;i:18;i:16827061;i:19;i:16827062;i:20;i:16827063;i:21;i:16827064;i:22;i:16827065;i:23;i:16827066;i:24;i:16827067;i:25;i:16827068;i:26;i:16827069;i:27;i:16827070;i:28;i:16827071;i:29;i:16827072;i:30;i:16827073;i:31;i:16827074;i:32;i:16827075;i:33;i:16827076;i:34;i:16827077;i:35;i:16827078;i:36;i:16827079;i:37;i:16827080;i:38;i:16827081;i:39;i:16827140;i:40;i:16827141;i:41;i:16827142;i:42;i:16827143;i:43;i:16827144;i:44;i:16827145;i:45;i:16827146;i:46;i:16827147;i:47;i:16827148;i:48;i:16827149;i:49;i:16827150;i:50;i:16827151;i:51;i:16827152;i:52;i:16827153;i:53;i:16827154;i:54;i:16827155;i:55;i:16827156;i:56;i:16827157;i:57;i:16827158;i:58;i:16827159;i:59;i:16827160;i:60;i:17193650;i:61;i:17193651;i:62;i:17193652;i:63;i:17193653;i:64;i:17193654;i:65;i:17193655;i:66;i:17193656;i:67;i:17193657;i:68;i:17193658;i:69;i:17193659;i:70;i:17193660;i:71;i:17193661;i:72;i:17193662;i:73;i:17193663;i:74;i:17193664;i:75;i:17193665;i:76;i:17193666;i:77;i:17193667;i:78;i:17193668;i:79;i:17193669;i:80;i:17193670;i:81;i:17225960;i:82;i:17225961;i:83;i:17225962;i:84;i:17225963;i:85;i:17225964;i:86;i:17225965;i:87;i:17225966;i:88;i:17225967;i:89;i:17225968;i:90;i:17225969;i:91;i:17225970;i:92;i:17225971;i:93;i:17225972;i:94;i:17225973;i:95;i:17225974;i:96;i:17225975;i:97;i:17225976;i:98;i:17225977;i:99;i:17225978;i:100;i:17225979;i:101;i:17225980;i:102;i:17299542;i:103;i:17299543;i:104;i:17299544;i:105;i:17299545;i:106;i:17299546;i:107;i:17299547;i:108;i:17299548;i:109;i:17299549;i:110;i:17299550;i:111;i:17299551;i:112;i:17299552;i:113;i:17299553;i:114;i:17299554;i:115;i:17299555;i:116;i:17299556;i:117;i:17299557;i:118;i:17299558;i:119;i:17299559;i:120;i:17299560;i:121;i:17299561;i:122;i:17299562;i:123;i:17357152;i:124;i:17357153;i:125;i:17357154;i:126;i:17357155;i:127;i:17357156;i:128;i:17357157;i:129;i:17357158;i:130;i:17357159;i:131;i:17357160;i:132;i:17357161;i:133;i:17357162;i:134;i:17357163;i:135;i:17357164;i:136;i:17357165;i:137;i:17357166;i:138;i:17357167;i:139;i:17357168;i:140;i:17357169;i:141;i:17357170;i:142;i:17357171;i:143;i:17357172;i:144;i:17401838;i:145;i:17401839;i:146;i:17401840;i:147;i:17401841;i:148;i:17401842;i:149;i:17401843;i:150;i:17401844;i:151;i:17401845;i:152;i:17401846;i:153;i:17401847;i:154;i:17401848;i:155;i:17401849;i:156;i:17401850;i:157;i:17401851;i:158;i:17401852;i:159;i:17401853;i:160;i:17401854;i:161;i:17401855;i:162;i:17401856;i:163;i:17401857;i:164;i:17401858;i:165;i:17505596;i:166;i:17505597;i:167;i:17505598;i:168;i:17505599;i:169;i:17505600;i:170;i:17505601;i:171;i:17505602;i:172;i:17505603;i:173;i:17505604;i:174;i:17505605;i:175;i:17505606;i:176;i:17505607;i:177;i:17505608;i:178;i:17505609;i:179;i:17505610;i:180;i:17505611;i:181;i:17505612;i:182;i:17505613;i:183;i:17505614;i:184;i:17505615;i:185;i:17505616;i:186;i:19327183;i:187;i:19327184;i:188;i:19327185;i:189;i:19327186;i:190;i:19327187;i:191;i:19327188;i:192;i:19327189;i:193;i:19327190;i:194;i:19327191;i:195;i:19327192;i:196;i:19327193;i:197;i:19327194;i:198;i:19327195;i:199;i:19327196;i:200;i:19327197;i:201;i:19327198;i:202;i:19327199;i:203;i:19327200;i:204;i:19327201;i:205;i:19327202;i:206;i:19327203;i:207;i:19505555;i:208;i:19505556;i:209;i:19505557;i:210;i:19505558;i:211;i:19505559;i:212;i:19505560;i:213;i:19505561;i:214;i:19505562;i:215;i:19505563;i:216;i:19505564;i:217;i:19505565;i:218;i:19505566;i:219;i:19505567;i:220;i:19505568;i:221;i:19505569;i:222;i:19505570;i:223;i:19505571;i:224;i:19505572;i:225;i:19505573;i:226;i:19505574;i:227;i:19505575;i:228;i:19660785;i:229;i:19660786;i:230;i:19660787;i:231;i:19660788;i:232;i:19660789;i:233;i:19660790;i:234;i:19660791;i:235;i:19660792;i:236;i:19660793;i:237;i:19660794;i:238;i:19660795;i:239;i:19660796;i:240;i:19660797;i:241;i:19660798;i:242;i:19660799;i:243;i:19660800;i:244;i:19660801;i:245;i:19660802;i:246;i:19660803;i:247;i:19660804;i:248;i:19660805;i:249;i:19881287;i:250;i:19881288;i:251;i:19881289;i:252;i:19881290;i:253;i:19881291;i:254;i:19881292;i:255;i:19881293;i:256;i:19881294;i:257;i:19881295;i:258;i:19881296;i:259;i:19881297;i:260;i:19881298;i:261;i:19881299;i:262;i:19881300;i:263;i:19881301;i:264;i:19881302;i:265;i:19881303;i:266;i:19881304;i:267;i:19881305;i:268;i:19881306;i:269;i:19881307;i:270;i:19920894;i:271;i:19920895;i:272;i:19920896;i:273;i:19920897;i:274;i:19920898;i:275;i:19920899;i:276;i:19920900;i:277;i:19920901;i:278;i:19920902;i:279;i:19920903;i:280;i:19920904;i:281;i:19920905;i:282;i:19920906;i:283;i:19920907;i:284;i:19920908;i:285;i:19920909;i:286;i:19920910;i:287;i:19920911;i:288;i:19920912;i:289;i:19920913;i:290;i:19920914;i:291;i:20208299;i:292;i:20208301;i:293;i:20208302;i:294;i:20208303;i:295;i:20208304;i:296;i:20208305;i:297;i:20208306;i:298;i:20208307;i:299;i:20208308;i:300;i:20208309;i:301;i:20208310;i:302;i:20208311;i:303;i:20208312;i:304;i:20208313;i:305;i:20208314;i:306;i:20208315;i:307;i:20208316;i:308;i:20208317;i:309;i:20208318;i:310;i:20208319;i:311;i:20208320;}"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-03-24"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-04-27"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(9) "280000.00"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-04-27"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(7) "NON MLS"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "99988"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3483993"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "NMLS"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3486878"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(7) "Non-MLS"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96791"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(10) "Farrington"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(3) "006"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(7) "Highway"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20208299"
  }
}