96-189 Waiawa Road
Pearl City, HI 96782

Listing
Overview

Price: $1,500,000
Area: PEARL CITY-LOWER
Status: Active

Amazing opportunity with many possibilities. These parcels are grandfathered for Agricultural use, it has multiple wells and existing watercress. Two dwellings currently being rented, and the farmland is leased as well. Two TMK’s to be sold together, R-5 zoning with over two acres. See City LUO for any land use questions. Buyer to do any due diligence. outlines are approximate.

  • Bedrooms: 4
  • Full Baths: 3
  • Land Area (sf): 100,737
  • Living (sf): 1,718
  • Year Built: 1985

  • Property Condition: Average
  • Number of Parking Spaces: 4
  • Pool: None
  • Number of Stories: One
  • View: Garden
  • Listing Office: List Sotheby's Int'l Realty

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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

array(135) {
  ["agency"]=>
  array(1) {
    [0]=>
    string(27) "List Sotheby's Int'l Realty"
  }
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "116300.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(10) "1483300.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(10) "1589600.00"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(39) "Detach Single Family,Multiple Dwellings"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(10) "Pearl City"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(24) "Property Disclosure Stmt"
  }
  ["easements"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(9) "100737.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(25) "jeffhughes96743@gmail.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(16) "Jeffrey A Hughes"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 735-2411"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-14"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(27) "List Sotheby's Int'l Realty"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(10) "1500000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(4) "1718"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(40) "96-189 Waiawa Road, Pearl City, HI 96782"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202123537"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(16) "PEARL CITY-LOWER"
  }
  ["number_of_parking_spaces"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["number_of_stories"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "LIST"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(6) "3 Car+"
  }
  ["pool_"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(10) "At Closing"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96782"
  }
  ["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(9) "PearlCity"
  }
  ["rets_baths_full"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["rets_baths_half"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_baths_total"]=>
  array(1) {
    [0]=>
    string(4) "3.00"
  }
  ["rets_beds_total"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(10) "Pearl City"
  }
  ["rets_co_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 735-2411"
  }
  ["rets_co_list_agent_email"]=>
  array(1) {
    [0]=>
    string(19) "mhirano@listsir.com"
  }
  ["rets_co_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(11) "Mari Hirano"
  }
  ["rets_co_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "43893"
  }
  ["rets_co_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3483884"
  }
  ["rets_co_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "LIST"
  }
  ["rets_co_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "9066313"
  }
  ["rets_co_list_office_name"]=>
  array(1) {
    [0]=>
    string(27) "List Sotheby's Int'l Realty"
  }
  ["rets_co_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 735-2411"
  }
  ["rets_condo_property_regime_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(10) "1500000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["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) "16155221"
  }
  ["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) "(808) 735-2411"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(25) "jeffhughes96743@gmail.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(16) "Jeffrey A Hughes"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "25917"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "8843301"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "LIST"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "9066313"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(27) "List Sotheby's Int'l Realty"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 735-2411"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(10) "1500000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-14"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(9) "100737.00"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-15T11:15:18.483"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "16155221"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202123537"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(16) "PEARL CITY-LOWER"
  }
  ["rets_new_development_construction_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-14T17:25:22.370"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(10) "1500000.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-9-6-002-002-0000"
  }
  ["rets_parking_total"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["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) "10"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-14T17:25:22.370"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96782"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-14T17:25:22.370"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "16155221"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(146) "Minimum two day notice to show. Both units are tenant occupied, do not disturb tenants and please don’t send clients to drive by without notice."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(382) "Amazing opportunity with many possibilities. These parcels are grandfathered for Agricultural use, it has multiple wells and existing watercress. Two dwellings currently being rented, and the farmland is leased as well. Two TMK’s to be sold together, R-5 zoning with over two acres. See City LUO for any land use questions. Buyer to do any due diligence. outlines are approximate."
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(4) "1718"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(4) "1718"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-14T17:25:22.370"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-14"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(6) "Waiawa"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(6) "96-189"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(79) "1$21.39182555297677$-157.9772565914178$101.99$13.33$1.00$3iBGjY3IZ9uDGl0WtguB_A"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(4) "2.5%"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "788.18"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(10) "1589600.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "116300.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(10) "1483300.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/16155221/d4c427ab9e3ecbdf4fbde9fea763fc93"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "196"
  }
  ["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) "2"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "9"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1985"
  }
  ["setbacks"]=>
  array(1) {
    [0]=>
    string(11) "C&C,Special"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(6) "Waiawa"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(6) "96-189"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(4) "Road"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(17) "Cash,Conventional"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-9-6-002-002-0000"
  }
  ["topography"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(6) "Garden"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "16155221"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202123537"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1631740609"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1985"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(29) "05 - R-5 Residential District"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(317) "a:20:{i:0;i:20743081;i:1;i:20743082;i:2;i:20743083;i:3;i:20743084;i:4;i:20743085;i:5;i:20743086;i:6;i:20743087;i:7;i:20743088;i:8;i:20743089;i:9;i:20743090;i:10;i:20747193;i:11;i:20747194;i:12;i:20747195;i:13;i:20747196;i:14;i:20747197;i:15;i:20747198;i:16;i:20747199;i:17;i:20747200;i:18;i:20747201;i:19;i:20747202;}"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20747193"
  }
}