47-341 Ahuimanu Road
Kaneohe, HI 96744

Listing
Overview

Price: $975,000
Area: AHUIMANU AREA
Status: Active

This property screams potential! Bring your ideas and contractor with you to make this your ultimate dream home! Large level lot with room for expansion. Huge open carport with high ceilings which makes it great for parking your boat or doing mechanic projects from home. Tons of parking. You will appreciate what this property has to offer. Enjoy living in the highly sought-after Ahuimanu neighborhood. Easy accessibility to major freeways, beaches, parks, boat harbors, restaurants, Windward Mall, shopping centers, schools, businesses, bus stops, military bases, and so much more! Property description may not match tax records, buyers to do their own due diligence.

  • Bedrooms: 4
  • Full Baths: 2
  • Land Area (sf): 10,012
  • Living (sf): 1,474
  • Year Built: 1988

  • Property Condition: Average
  • Number of Parking Spaces: 5
  • Pool: None
  • Number of Stories: One
  • View: Mountain,Other
  • Listing Office: Kailua Beach Realty, Ltd.

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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

array(137) {
  ["agency"]=>
  array(1) {
    [0]=>
    string(25) "Kailua Beach Realty, Ltd."
  }
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "289700.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "603200.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "892900.00"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(20) "Detach Single Family"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(11) "See Remarks"
  }
  ["easements"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(16) "Other,W/W Carpet"
  }
  ["frontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(7) "100,000"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(8) "10012.00"
  }
  ["land_recorded"]=>
  array(1) {
    [0]=>
    string(12) "Dual Systems"
  }
  ["land_tenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["list_agent_email"]=>
  array(1) {
    [0]=>
    string(21) "yukiepakele@gmail.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(14) "Yukie M Pakele"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 263-6000"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-10-13"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(25) "Kailua Beach Realty, Ltd."
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "975000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(4) "1474"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(39) "47-341 Ahuimanu Road, Kaneohe, HI 96744"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202123445"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(13) "AHUIMANU AREA"
  }
  ["number_of_parking_spaces"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["number_of_stories"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "KAIL"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(28) "3 Car+,Boat,Carport,Driveway"
  }
  ["pool_"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(16) "Negotiable,Other"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96744"
  }
  ["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(7) "Kaneohe"
  }
  ["rets_baths_full"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_baths_half"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_baths_total"]=>
  array(1) {
    [0]=>
    string(4) "2.00"
  }
  ["rets_beds_total"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["rets_co_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 263-6000"
  }
  ["rets_co_list_agent_email"]=>
  array(1) {
    [0]=>
    string(18) "timsells@gmail.com"
  }
  ["rets_co_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(16) "Timothy J Murray"
  }
  ["rets_co_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "25331"
  }
  ["rets_co_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3475317"
  }
  ["rets_co_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "KAIL"
  }
  ["rets_co_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3485137"
  }
  ["rets_co_list_office_name"]=>
  array(1) {
    [0]=>
    string(25) "Kailua Beach Realty, Ltd."
  }
  ["rets_co_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 263-6000"
  }
  ["rets_condo_property_regime_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(9) "975000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["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) "16152427"
  }
  ["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) 263-6000"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(21) "yukiepakele@gmail.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(14) "Yukie M Pakele"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "36996"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3481136"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "KAIL"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3485137"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(25) "Kailua Beach Realty, Ltd."
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 263-6000"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(9) "975000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-10-13"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(8) "10012.00"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-10-18T15:31:18.287"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "16152427"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202123445"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(13) "AHUIMANU AREA"
  }
  ["rets_new_development_construction_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-10-13T17:10:33.547"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(9) "975000.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-4-7-025-042-0000"
  }
  ["rets_parking_total"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["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-10-13T17:10:33.547"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96744"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-10-13T17:10:33.547"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "16152427"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(159) "Showings are by appointment only.  Please email showing requests and questions to yukiepakele@gmail.com.  Send your offers to:  kailuabeachrealty@teamimua.com."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(678) "This property screams potential!  Bring your ideas and contractor with you to make this your ultimate dream home!  Large level lot with room for expansion.  Huge open carport with high ceilings which makes it great for parking your boat or doing mechanic projects from home.  Tons of parking.  You will appreciate what this property has to offer.  Enjoy living in the highly sought-after Ahuimanu neighborhood.  Easy accessibility to major freeways, beaches, parks, boat harbors, restaurants, Windward Mall, shopping centers, schools, businesses, bus stops, military bases, and so much more!  Property description may not match tax records, buyers to do their own due diligence."
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(4) "1474"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(4) "1474"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-10-13T17:10:33.547"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-10-13"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(8) "Ahuimanu"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(6) "47-341"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(61) "1$21.448353$-157.83438$9.28$13.33$1.00$Wvo1qHp9ocZHpxrgZQ2smQ"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(4) "2.5%"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "116.00"
  }
  ["rets_tax_annual_amount"]=>
  array(1) {
    [0]=>
    string(7) "1392.00"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "892900.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "289700.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "603200.00"
  }
  ["rets_tax_excemption_owner_occupancy"]=>
  array(1) {
    [0]=>
    string(7) "100,000"
  }
  ["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/16152427/5c94cf2516a3fc58e14f0ecec404d8df"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "147"
  }
  ["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) "42"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "7"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(2) "25"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1988"
  }
  ["setbacks"]=>
  array(1) {
    [0]=>
    string(9) "Of Record"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(8) "Ahuimanu"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(6) "47-341"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(4) "Road"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(17) "Cash,Conventional"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-4-7-025-042-0000"
  }
  ["topography"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(14) "Mountain,Other"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "16152427"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202123445"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1634607102"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1988"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(30) "52 - AG-2 General Agricultural"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(253) "a:16:{i:0;i:20960343;i:1;i:20960344;i:2;i:20960345;i:3;i:20960346;i:4;i:20960347;i:5;i:20960348;i:6;i:20960349;i:7;i:20960350;i:8;i:20987007;i:9;i:20987008;i:10;i:20987009;i:11;i:20987010;i:12;i:20987011;i:13;i:20987012;i:14;i:20987013;i:15;i:20987014;}"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20987007"
  }
}