PRIVATE FARMHOUSE ESTATE – one of a kind opportunity to purchase a beautiful two-story 2,519 SF home along
with a certified organic farm. Located at the world renowned North Shore of Oahu. Just minutes away from popular
Haleiwa Town in a quiet secluded gated community “Poamoho Estates”. Enjoy living in privacy at the end of the
culde-sac with a beautiful 100′ ravine as your neighbor. Includes an enclosed 1,250sf Barn which can be converted
to a Game Room, Exercise Room, or Utility Shed. The Organic Farm has adult trees in full bloom with a variety of
Vegetables & Fruits, Avocados, Oranges, Mangoes, Limes, Breadfruit, and More!
array(139) { ["assd_val_imprv"]=> array(1) { [0]=> string(9) "889400.00" } ["assd_val_land"]=> array(1) { [0]=> string(10) "1301700.00" } ["assd_val_total"]=> array(1) { [0]=> string(10) "1192900.00" } ["bedrooms"]=> array(1) { [0]=> string(1) "3" } ["building_style"]=> array(1) { [0]=> string(20) "Detach Single Family" } ["city"]=> array(1) { [0]=> string(7) "Waialua" } ["county"]=> array(1) { [0]=> string(4) "Oahu" } ["disclosures"]=> array(1) { [0]=> string(24) "Property Disclosure Stmt" } ["easements"]=> array(1) { [0]=> string(8) "Electric" } ["floor_covering"]=> array(1) { [0]=> string(8) "Hardwood" } ["full_baths"]=> array(1) { [0]=> string(1) "2" } ["half_baths"]=> array(1) { [0]=> string(1) "1" } ["home_exampt"]=> array(1) { [0]=> string(1) "0" } ["land_area_sf"]=> array(1) { [0]=> string(9) "308012.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(31) "alan.christopher@cbi-hawaii.com" } ["list_agent_name"]=> array(1) { [0]=> string(18) "Alan J Christopher" } ["list_agent_phone_number"]=> array(1) { [0]=> string(14) "(808) 942-7100" } ["list_date"]=> array(1) { [0]=> string(10) "2022-03-07" } ["list_office_name"]=> array(1) { [0]=> string(28) "CBI Residential Advisory Svc" } ["list_price"]=> array(1) { [0]=> string(10) "3499888.00" } ["living_sf"]=> array(1) { [0]=> string(4) "2519" } ["location"]=> array(1) { [0]=> string(39) "65-200 Poamoho Place, Waialua, HI 96791" } ["mls_"]=> array(1) { [0]=> string(9) "202204403" } ["neighborhood"]=> array(1) { [0]=> string(7) "WAIALUA" } ["number_of_parking_spaces"]=> array(1) { [0]=> string(1) "5" } ["number_of_stories"]=> array(1) { [0]=> string(3) "Two" } ["office_mls_id"]=> array(1) { [0]=> string(4) "AGNC" } ["parking_features"]=> array(1) { [0]=> string(6) "3 Car+" } ["pool_"]=> array(1) { [0]=> string(4) "None" } ["possession"]=> array(1) { [0]=> string(10) "Negotiable" } ["postal_code"]=> array(1) { [0]=> string(5) "96791" } ["property_condition"]=> array(1) { [0]=> string(7) "Average" } ["property_type"]=> array(1) { [0]=> string(13) "single_family" } ["property_type_label"]=> array(1) { [0]=> string(13) "single_family" } ["region"]=> array(1) { [0]=> string(11) "North Shore" } ["rets_baths_full"]=> array(1) { [0]=> string(1) "2" } ["rets_baths_half"]=> array(1) { [0]=> string(1) "1" } ["rets_baths_total"]=> array(1) { [0]=> string(4) "2.01" } ["rets_beds_total"]=> array(1) { [0]=> string(1) "3" } ["rets_city"]=> array(1) { [0]=> string(7) "Waialua" } ["rets_condo_property_regime_yn"]=> array(1) { [0]=> string(1) "0" } ["rets_current_price"]=> array(1) { [0]=> string(10) "3470000.00" } ["rets_dom"]=> array(1) { [0]=> string(1) "0" } ["rets_dual_variable_compensation_yn"]=> array(1) { [0]=> string(1) "0" } ["rets_foreclosure_yn"]=> array(1) { [0]=> string(1) "0" } ["rets_fractional_ownership_yn"]=> array(1) { [0]=> string(1) "0" } ["rets_id"]=> array(1) { [0]=> string(8) "16487345" } ["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) "0" } ["rets_list_agent_direct_work_phone"]=> array(1) { [0]=> string(14) "(808) 942-7100" } ["rets_list_agent_email"]=> array(1) { [0]=> string(31) "alan.christopher@cbi-hawaii.com" } ["rets_list_agent_full_name"]=> array(1) { [0]=> string(18) "Alan J Christopher" } ["rets_list_agent_mlsid"]=> array(1) { [0]=> string(5) "31424" } ["rets_list_agent_mui"]=> array(1) { [0]=> string(7) "3478951" } ["rets_list_office_mlsid"]=> array(1) { [0]=> string(4) "AGNC" } ["rets_list_office_mui"]=> array(1) { [0]=> string(8) "16410094" } ["rets_list_office_name"]=> array(1) { [0]=> string(28) "CBI Residential Advisory Svc" } ["rets_list_office_phone"]=> array(1) { [0]=> string(14) "(808) 942-7100" } ["rets_list_price"]=> array(1) { [0]=> string(10) "3499888.00" } ["rets_listing_contract_date"]=> array(1) { [0]=> string(10) "2022-03-07" } ["rets_lot_size_area"]=> array(1) { [0]=> string(9) "308012.00" } ["rets_matrix_modified_dt"]=> array(1) { [0]=> string(23) "2022-04-02T13:54:00.890" } ["rets_matrix_unique_id"]=> array(1) { [0]=> string(8) "16487345" } ["rets_mls_number"]=> array(1) { [0]=> string(9) "202204403" } ["rets_neighbourhood"]=> array(1) { [0]=> string(7) "WAIALUA" } ["rets_new_development_construction_yn"]=> array(1) { [0]=> string(1) "0" } ["rets_original_entry_timestamp"]=> array(1) { [0]=> string(23) "2022-03-07T18:04:58.010" } ["rets_original_list_price"]=> array(1) { [0]=> string(10) "3499888.00" } ["rets_parcel_number"]=> array(1) { [0]=> string(18) "1-6-5-004-010-0000" } ["rets_parking_total"]=> array(1) { [0]=> string(1) "5" } ["rets_pending_date"]=> array(1) { [0]=> string(10) "2022-03-07" } ["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) "7" } ["rets_photo_modification_timestamp"]=> array(1) { [0]=> string(23) "2022-03-07T18:04:58.010" } ["rets_postal_code"]=> array(1) { [0]=> string(5) "96791" } ["rets_price_change_timestamp"]=> array(1) { [0]=> string(23) "2022-03-07T18:04:58.010" } ["rets_primary_key"]=> array(1) { [0]=> string(8) "16487345" } ["rets_private_remarks"]=> array(1) { [0]=> string(204) "Contact Co-Listing Agent Daniel Jarrett 808-256-3506/dj@cbi-hawaii.com for more info or showings. Co-Listed with NAI CBI Hawaii Please allow 48 hours notice for a tour of the property. No weekend showing" } ["rets_public_remarks"]=> array(1) { [0]=> string(643) "PRIVATE FARMHOUSE ESTATE - one of a kind opportunity to purchase a beautiful two-story 2,519 SF home along with a certified organic farm. Located at the world renowned North Shore of Oahu. Just minutes away from popular Haleiwa Town in a quiet secluded gated community “Poamoho Estates”. Enjoy living in privacy at the end of the culde-sac with a beautiful 100' ravine as your neighbor. Includes an enclosed 1,250sf Barn which can be converted to a Game Room, Exercise Room, or Utility Shed. The Organic Farm has adult trees in full bloom with a variety of Vegetables & Fruits, Avocados, Oranges, Mangoes, Limes, Breadfruit, and More!" } ["rets_sqft_roofed_living"]=> array(1) { [0]=> string(4) "2519" } ["rets_sqft_total"]=> array(1) { [0]=> string(4) "2519" } ["rets_state_or_province"]=> array(1) { [0]=> string(2) "HI" } ["rets_status_change_timestamp"]=> array(1) { [0]=> string(23) "2022-04-02T13:54:00.890" } ["rets_status_contractual_search_date"]=> array(1) { [0]=> string(10) "2022-04-01" } ["rets_street_name"]=> array(1) { [0]=> string(7) "Poamoho" } ["rets_street_number"]=> array(1) { [0]=> string(6) "65-200" } ["rets_sub_agency_compensation"]=> array(1) { [0]=> string(4) "2.5%" } ["rets_tax_amount"]=> array(1) { [0]=> string(6) "585.00" } ["rets_tax_annual_amount"]=> array(1) { [0]=> string(7) "7020.00" } ["rets_tax_assessed_value"]=> array(1) { [0]=> string(10) "1192900.00" } ["rets_tax_assessed_value_improvements"]=> array(1) { [0]=> string(9) "889400.00" } ["rets_tax_assessed_value_land"]=> array(1) { [0]=> string(10) "1301700.00" } ["rets_tax_excemption_owner_occupancy"]=> array(1) { [0]=> string(1) "0" } ["rets_tax_paid_by_seller_yn"]=> array(1) { [0]=> string(1) "0" } ["rets_tax_year"]=> array(1) { [0]=> string(4) "2021" } ["rets_thumbnail_url"]=> array(1) { [0]=> string(81) "https://cdn.rets.ci/marcusrealty-images/16487345/cbc726b28e7b1675acd3e4060d521fbb" } ["rets_tmk_area"]=> array(1) { [0]=> string(3) "165" } ["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) "10" } ["rets_tmk_section"]=> array(1) { [0]=> string(1) "5" } ["rets_tmk_zone"]=> array(1) { [0]=> string(1) "6" } ["rets_tmkplat"]=> array(1) { [0]=> string(1) "4" } ["rets_year_built"]=> array(1) { [0]=> string(4) "2000" } ["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_name"]=> array(1) { [0]=> string(7) "Poamoho" } ["street_number"]=> array(1) { [0]=> string(6) "65-200" } ["street_suffix"]=> array(1) { [0]=> string(5) "Place" } ["terms_accept"]=> array(1) { [0]=> string(34) "A/S,Cash,Conventional,Exchange,FHA" } ["tmk"]=> array(1) { [0]=> string(18) "1-6-5-004-010-0000" } ["topography"]=> array(1) { [0]=> string(23) "Clear,Irregular,Rim Lot" } ["view"]=> array(1) { [0]=> string(24) "Coastline,Mountain,Ocean" } ["wpp::rets_pk"]=> array(1) { [0]=> string(8) "16487345" } ["wpp_gpid"]=> array(1) { [0]=> string(9) "202204403" } ["wpp_import_schedule_id"]=> array(1) { [0]=> string(10) "1463343682" } ["wpp_import_time"]=> array(1) { [0]=> string(10) "1648943668" } ["year_built"]=> array(1) { [0]=> string(4) "2000" } ["zoning"]=> array(1) { [0]=> string(31) "51 - AG-1 Restricted Agricultur" } ["new_attached_media"]=> array(1) { [0]=> string(333) "a:21:{i:0;i:21776365;i:1;i:21776366;i:2;i:21776367;i:3;i:21776368;i:4;i:21776369;i:5;i:21776370;i:6;i:21776371;i:7;i:21921329;i:8;i:21921330;i:9;i:21921331;i:10;i:21921332;i:11;i:21921333;i:12;i:21921334;i:13;i:21921335;i:14;i:21940063;i:15;i:21940064;i:16;i:21940065;i:17;i:21940066;i:18;i:21940067;i:19;i:21940068;i:20;i:21940069;}" } ["rets_close_date"]=> array(1) { [0]=> string(10) "2022-04-01" } ["rets_close_price"]=> array(1) { [0]=> string(10) "3470000.00" } ["rets_expiration_date"]=> array(1) { [0]=> string(10) "2022-04-30" } ["rets_off_market_date"]=> array(1) { [0]=> string(10) "2022-04-01" } ["rets_selling_agent_direct_work_phone"]=> array(1) { [0]=> string(14) "(808) 729-7643" } ["rets_selling_agent_email"]=> array(1) { [0]=> string(18) "pmjavier@gmail.com" } ["rets_selling_agent_full_name"]=> array(1) { [0]=> string(13) "Paul M Javier" } ["rets_selling_agent_mlsid"]=> array(1) { [0]=> string(5) "34149" } ["rets_selling_agent_mui"]=> array(1) { [0]=> string(7) "3480062" } ["rets_selling_office_mlsid"]=> array(1) { [0]=> string(4) "HSIH" } ["rets_selling_office_mui"]=> array(1) { [0]=> string(8) "13236725" } ["rets_selling_office_name"]=> array(1) { [0]=> string(22) "HomeSmart Island Homes" } ["rets_selling_office_phone"]=> array(1) { [0]=> string(14) "(808) 729-7643" } ["_thumbnail_id"]=> array(1) { [0]=> string(8) "21940063" } } Array ( [assd_val_imprv] => Array ( [0] => 889400.00 ) [assd_val_land] => Array ( [0] => 1301700.00 ) [assd_val_total] => Array ( [0] => 1192900.00 ) [bedrooms] => Array ( [0] => 3 ) [building_style] => Array ( [0] => Detach Single Family ) [city] => Array ( [0] => Waialua ) [county] => Array ( [0] => Oahu ) [disclosures] => Array ( [0] => Property Disclosure Stmt ) [easements] => Array ( [0] => Electric ) [floor_covering] => Array ( [0] => Hardwood ) [full_baths] => Array ( [0] => 2 ) [half_baths] => Array ( [0] => 1 ) [home_exampt] => Array ( [0] => 0 ) [land_area_sf] => Array ( [0] => 308012.00 ) [land_recorded] => Array ( [0] => Regular System ) [land_tenure] => Array ( [0] => FS - Fee Simple ) [list_agent_email] => Array ( [0] => alan.christopher@cbi-hawaii.com ) [list_agent_name] => Array ( [0] => Alan J Christopher ) [list_agent_phone_number] => Array ( [0] => (808) 942-7100 ) [list_date] => Array ( [0] => 2022-03-07 ) [list_office_name] => Array ( [0] => CBI Residential Advisory Svc ) [list_price] => Array ( [0] => 3499888.00 ) [living_sf] => Array ( [0] => 2519 ) [location] => Array ( [0] => 65-200 Poamoho Place, Waialua, HI 96791 ) [mls_] => Array ( [0] => 202204403 ) [neighborhood] => Array ( [0] => WAIALUA ) [number_of_parking_spaces] => Array ( [0] => 5 ) [number_of_stories] => Array ( [0] => Two ) [office_mls_id] => Array ( [0] => AGNC ) [parking_features] => Array ( [0] => 3 Car+ ) [pool_] => Array ( [0] => None ) [possession] => Array ( [0] => Negotiable ) [postal_code] => Array ( [0] => 96791 ) [property_condition] => Array ( [0] => Average ) [property_type] => Array ( [0] => single_family ) [property_type_label] => Array ( [0] => single_family ) [region] => Array ( [0] => North Shore ) [rets_baths_full] => Array ( [0] => 2 ) [rets_baths_half] => Array ( [0] => 1 ) [rets_baths_total] => Array ( [0] => 2.01 ) [rets_beds_total] => Array ( [0] => 3 ) [rets_city] => Array ( [0] => Waialua ) [rets_condo_property_regime_yn] => Array ( [0] => 0 ) [rets_current_price] => Array ( [0] => 3470000.00 ) [rets_dom] => Array ( [0] => 0 ) [rets_dual_variable_compensation_yn] => Array ( [0] => 0 ) [rets_foreclosure_yn] => Array ( [0] => 0 ) [rets_fractional_ownership_yn] => Array ( [0] => 0 ) [rets_id] => Array ( [0] => 16487345 ) [rets_immoviewer_yn] => Array ( [0] => 0 ) [rets_internet_automated_valuation_dis] => Array ( [0] => 1 ) [rets_internet_consumer_comment_yn] => Array ( [0] => 0 ) [rets_list_agent_direct_work_phone] => Array ( [0] => (808) 942-7100 ) [rets_list_agent_email] => Array ( [0] => alan.christopher@cbi-hawaii.com ) [rets_list_agent_full_name] => Array ( [0] => Alan J Christopher ) [rets_list_agent_mlsid] => Array ( [0] => 31424 ) [rets_list_agent_mui] => Array ( [0] => 3478951 ) [rets_list_office_mlsid] => Array ( [0] => AGNC ) [rets_list_office_mui] => Array ( [0] => 16410094 ) [rets_list_office_name] => Array ( [0] => CBI Residential Advisory Svc ) [rets_list_office_phone] => Array ( [0] => (808) 942-7100 ) [rets_list_price] => Array ( [0] => 3499888.00 ) [rets_listing_contract_date] => Array ( [0] => 2022-03-07 ) [rets_lot_size_area] => Array ( [0] => 308012.00 ) [rets_matrix_modified_dt] => Array ( [0] => 2022-04-02T13:54:00.890 ) [rets_matrix_unique_id] => Array ( [0] => 16487345 ) [rets_mls_number] => Array ( [0] => 202204403 ) [rets_neighbourhood] => Array ( [0] => WAIALUA ) [rets_new_development_construction_yn] => Array ( [0] => 0 ) [rets_original_entry_timestamp] => Array ( [0] => 2022-03-07T18:04:58.010 ) [rets_original_list_price] => Array ( [0] => 3499888.00 ) [rets_parcel_number] => Array ( [0] => 1-6-5-004-010-0000 ) [rets_parking_total] => Array ( [0] => 5 ) [rets_pending_date] => Array ( [0] => 2022-03-07 ) [rets_permit_address_internet_yn] => Array ( [0] => 1 ) [rets_permit_internet_yn] => Array ( [0] => 1 ) [rets_photo_count] => Array ( [0] => 7 ) [rets_photo_modification_timestamp] => Array ( [0] => 2022-03-07T18:04:58.010 ) [rets_postal_code] => Array ( [0] => 96791 ) [rets_price_change_timestamp] => Array ( [0] => 2022-03-07T18:04:58.010 ) [rets_primary_key] => Array ( [0] => 16487345 ) [rets_private_remarks] => Array ( [0] => Contact Co-Listing Agent Daniel Jarrett 808-256-3506/dj@cbi-hawaii.com for more info or showings. Co-Listed with NAI CBI Hawaii Please allow 48 hours notice for a tour of the property. No weekend showing ) [rets_public_remarks] => Array ( [0] => PRIVATE FARMHOUSE ESTATE - one of a kind opportunity to purchase a beautiful two-story 2,519 SF home along with a certified organic farm. Located at the world renowned North Shore of Oahu. Just minutes away from popular Haleiwa Town in a quiet secluded gated community “Poamoho Estates”. Enjoy living in privacy at the end of the culde-sac with a beautiful 100' ravine as your neighbor. Includes an enclosed 1,250sf Barn which can be converted to a Game Room, Exercise Room, or Utility Shed. The Organic Farm has adult trees in full bloom with a variety of Vegetables & Fruits, Avocados, Oranges, Mangoes, Limes, Breadfruit, and More! ) [rets_sqft_roofed_living] => Array ( [0] => 2519 ) [rets_sqft_total] => Array ( [0] => 2519 ) [rets_state_or_province] => Array ( [0] => HI ) [rets_status_change_timestamp] => Array ( [0] => 2022-04-02T13:54:00.890 ) [rets_status_contractual_search_date] => Array ( [0] => 2022-04-01 ) [rets_street_name] => Array ( [0] => Poamoho ) [rets_street_number] => Array ( [0] => 65-200 ) [rets_sub_agency_compensation] => Array ( [0] => 2.5% ) [rets_tax_amount] => Array ( [0] => 585.00 ) [rets_tax_annual_amount] => Array ( [0] => 7020.00 ) [rets_tax_assessed_value] => Array ( [0] => 1192900.00 ) [rets_tax_assessed_value_improvements] => Array ( [0] => 889400.00 ) [rets_tax_assessed_value_land] => Array ( [0] => 1301700.00 ) [rets_tax_excemption_owner_occupancy] => Array ( [0] => 0 ) [rets_tax_paid_by_seller_yn] => Array ( [0] => 0 ) [rets_tax_year] => Array ( [0] => 2021 ) [rets_thumbnail_url] => Array ( [0] => https://cdn.rets.ci/marcusrealty-images/16487345/cbc726b28e7b1675acd3e4060d521fbb ) [rets_tmk_area] => Array ( [0] => 165 ) [rets_tmk_condo_property_regime_number] => Array ( [0] => 0 ) [rets_tmk_division] => Array ( [0] => 1 ) [rets_tmk_parcel] => Array ( [0] => 10 ) [rets_tmk_section] => Array ( [0] => 5 ) [rets_tmk_zone] => Array ( [0] => 6 ) [rets_tmkplat] => Array ( [0] => 4 ) [rets_year_built] => Array ( [0] => 2000 ) [setbacks] => Array ( [0] => C&C ) [state_or_province] => Array ( [0] => HI ) [status] => Array ( [0] => Sold ) [street_name] => Array ( [0] => Poamoho ) [street_number] => Array ( [0] => 65-200 ) [street_suffix] => Array ( [0] => Place ) [terms_accept] => Array ( [0] => A/S,Cash,Conventional,Exchange,FHA ) [tmk] => Array ( [0] => 1-6-5-004-010-0000 ) [topography] => Array ( [0] => Clear,Irregular,Rim Lot ) [view] => Array ( [0] => Coastline,Mountain,Ocean ) [wpp::rets_pk] => Array ( [0] => 16487345 ) [wpp_gpid] => Array ( [0] => 202204403 ) [wpp_import_schedule_id] => Array ( [0] => 1463343682 ) [wpp_import_time] => Array ( [0] => 1648943668 ) [year_built] => Array ( [0] => 2000 ) [zoning] => Array ( [0] => 51 - AG-1 Restricted Agricultur ) [new_attached_media] => Array ( [0] => a:21:{i:0;i:21776365;i:1;i:21776366;i:2;i:21776367;i:3;i:21776368;i:4;i:21776369;i:5;i:21776370;i:6;i:21776371;i:7;i:21921329;i:8;i:21921330;i:9;i:21921331;i:10;i:21921332;i:11;i:21921333;i:12;i:21921334;i:13;i:21921335;i:14;i:21940063;i:15;i:21940064;i:16;i:21940065;i:17;i:21940066;i:18;i:21940067;i:19;i:21940068;i:20;i:21940069;} ) [rets_close_date] => Array ( [0] => 2022-04-01 ) [rets_close_price] => Array ( [0] => 3470000.00 ) [rets_expiration_date] => Array ( [0] => 2022-04-30 ) [rets_off_market_date] => Array ( [0] => 2022-04-01 ) [rets_selling_agent_direct_work_phone] => Array ( [0] => (808) 729-7643 ) [rets_selling_agent_email] => Array ( [0] => pmjavier@gmail.com ) [rets_selling_agent_full_name] => Array ( [0] => Paul M Javier ) [rets_selling_agent_mlsid] => Array ( [0] => 34149 ) [rets_selling_agent_mui] => Array ( [0] => 3480062 ) [rets_selling_office_mlsid] => Array ( [0] => HSIH ) [rets_selling_office_mui] => Array ( [0] => 13236725 ) [rets_selling_office_name] => Array ( [0] => HomeSmart Island Homes ) [rets_selling_office_phone] => Array ( [0] => (808) 729-7643 ) [_thumbnail_id] => Array ( [0] => 21940063 ) )
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446