Listing
Overview

Price: $1,495,000
Area: GOVT/AG
Status: Sold

Helemano Farms Unit 2 is nearly 18 acres land zoned AG-1 with stunning ocean, mountain and valley views! The Lot has about 2,000 ft of stream frontage. Access to the stream via ATV and hiking trails. Farm Dwelling (residence), AG Buildings, Barns, Stables, etc are allowed. Route to the property is via the paved Paala Uka Pupukea Rd and entry through private security gate. A Private Water Meter has been installed. No HECO only off grid options available.

There is about 4.5 acres mostly level land on the upper portion of the lot and about 1 acre mostly level land on the lower area next to the stream. Close to everything and away from it all. 10 minutes to Haleiwa beaches, 15 minutes to Costco and 40 minutes Honolulu.

  • Land Area (sf): 777,067

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

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

  • Elementary School: Helemano
  • High School: Leilehua

CONTACT US

Marcus Realty

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

array(137) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(4) "0.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "801000.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "801000.00"
  }
  ["assn_fee_inclusions"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["association_fees"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(7) "Wahiawa"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(24) "Listor Owner,See Remarks"
  }
  ["easements"]=>
  array(1) {
    [0]=>
    string(5) "Water"
  }
  ["elementary_school"]=>
  array(1) {
    [0]=>
    string(8) "Helemano"
  }
  ["frontage"]=>
  array(1) {
    [0]=>
    string(18) "Other,Stream/Canal"
  }
  ["high_school"]=>
  array(1) {
    [0]=>
    string(8) "Leilehua"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(9) "777067.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(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-06-23"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(11) "Hawaii Life"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(10) "1495000.00"
  }
  ["maintenance_fees"]=>
  array(1) {
    [0]=>
    string(4) "0.00"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202116162"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(7) "GOVT/AG"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "HLRE"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96786"
  }
  ["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_association_fee"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_association_fee_2"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(7) "Wahiawa"
  }
  ["rets_co_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(800) 370-3848"
  }
  ["rets_co_list_agent_email"]=>
  array(1) {
    [0]=>
    string(27) "johnclimaldi@hawaiilife.com"
  }
  ["rets_co_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(15) "John J Climaldi"
  }
  ["rets_co_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "41556"
  }
  ["rets_co_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3482681"
  }
  ["rets_co_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "HLRE"
  }
  ["rets_co_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3487136"
  }
  ["rets_co_list_office_name"]=>
  array(1) {
    [0]=>
    string(11) "Hawaii Life"
  }
  ["rets_co_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(800) 370-3848"
  }
  ["rets_crops_included_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(10) "1100000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(3) "138"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_elementary_school"]=>
  array(1) {
    [0]=>
    string(8) "Helemano"
  }
  ["rets_foreclosure_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_high_school"]=>
  array(1) {
    [0]=>
    string(8) "Leilehua"
  }
  ["rets_id"]=>
  array(1) {
    [0]=>
    string(8) "15996587"
  }
  ["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) "1495000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-06-23"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(9) "777067.00"
  }
  ["rets_lot_size_dimensions"]=>
  array(1) {
    [0]=>
    string(18) "638x1079x1386x2000"
  }
  ["rets_maintenance_expense"]=>
  array(1) {
    [0]=>
    string(4) "0.00"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-12-01T09:22:52.160"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "15996587"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202116162"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "GOVT/AG"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-06-23T10:38:44.557"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(10) "1595000.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-6-4-004-012-0002"
  }
  ["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) "9"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-06-23T10:38:44.557"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96786"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-03T10:56:40.793"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "15996587"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(285) "Call, email, or text Sean Ginella or John Climaldi for a property information package. Do not walk Please do not go on the property without Agent. Recommend wear hiking shoes. Zero discharge septic system required if Buyer is to build a residence. No HECO Power, off-grid options only."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(727) "Helemano Farms Unit 2 is nearly 18 acres land zoned AG-1 with stunning ocean, mountain and valley views! The Lot has about 2,000 ft of stream frontage. Access to the stream via ATV and hiking trails. Farm Dwelling (residence), AG Buildings, Barns, Stables, etc are allowed. Route to the property is via the paved Paala Uka Pupukea Rd and entry through private security gate. A Private Water Meter has been installed. No HECO only off grid options available.

There is about 4.5 acres mostly level land on the upper portion of the lot and about 1 acre mostly level land on the lower area next to the stream. Close to everything and away from it all. 10 minutes to Haleiwa beaches, 15 minutes to Costco and 40 minutes Honolulu."
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-12-01T09:22:52.160"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-27"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(18) "Paalaa Uka Pupukea"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(3) "000"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(62) "1$21.540868$-158.0322$306.18$13.33$1.00$ZIWER18klUpb-8d6yMU7Xw"
  }
  ["rets_structures_present_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(4) "2.5%"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "380.00"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "801000.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(4) "0.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "801000.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/15996587/c2c6d42b1569ce9e629abb3ac60e5376"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "164"
  }
  ["rets_tmk_condo_property_regime_number"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_tmk_division"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tmk_parcel"]=>
  array(1) {
    [0]=>
    string(2) "12"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["rets_virtual_tour_url_unbranded"]=>
  array(1) {
    [0]=>
    string(40) "https://player.vimeo.com/video/563022409"
  }
  ["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(46) "000 Paalaa Uka Pupukea Road, Wahiawa, HI 96786"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(18) "Paalaa Uka Pupukea"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(3) "000"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(4) "Road"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(32) "Cash,Conventional,USDA Financing"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-6-4-004-012-0002"
  }
  ["topography"]=>
  array(1) {
    [0]=>
    string(24) "Irregular,Rim Lot,Wooded"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(39) "Coastline,Mountain,Ocean,Sunrise,Sunset"
  }
  ["virtual_tour"]=>
  array(1) {
    [0]=>
    string(40) "https://player.vimeo.com/video/563022409"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "15996587"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202116162"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463079227"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1638386606"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(31) "51 - AG-1 Restricted Agricultur"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(861) "a:54:{i:0;i:19925960;i:1;i:19925961;i:2;i:19925962;i:3;i:19925963;i:4;i:19925964;i:5;i:19925965;i:6;i:19925966;i:7;i:19925967;i:8;i:19925968;i:9;i:20215164;i:10;i:20215165;i:11;i:20215166;i:12;i:20215167;i:13;i:20215168;i:14;i:20215169;i:15;i:20215170;i:16;i:20215171;i:17;i:20215172;i:18;i:20665412;i:19;i:20665413;i:20;i:20665414;i:21;i:20665415;i:22;i:20665416;i:23;i:20665417;i:24;i:20665418;i:25;i:20665419;i:26;i:20665420;i:27;i:20808304;i:28;i:20808305;i:29;i:20808306;i:30;i:20808307;i:31;i:20808308;i:32;i:20808309;i:33;i:20808310;i:34;i:20808311;i:35;i:20808312;i:36;i:21122951;i:37;i:21122952;i:38;i:21122953;i:39;i:21122954;i:40;i:21122955;i:41;i:21122956;i:42;i:21122957;i:43;i:21122958;i:44;i:21122959;i:45;i:21251754;i:46;i:21251755;i:47;i:21251756;i:48;i:21251757;i:49;i:21251758;i:50;i:21251759;i:51;i:21251760;i:52;i:21251761;i:53;i:21251762;}"
  }
  ["rets_expiration_date"]=>
  array(1) {
    [0]=>
    string(10) "2022-06-21"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-05"
  }
  ["rets_tax_annual_amount"]=>
  array(1) {
    [0]=>
    string(7) "4560.00"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-27"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(10) "1100000.00"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-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"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "21251754"
  }
}