45-659 Haamaile Street
Kaneohe, HI 96744

Listing
Overview

Price: $1,199,000
Area: KANEOHE WOODS
Status: Sold

RARELY AVAILABLE 3 stories, 4 bedrooms, 3 bathrooms totally remodeled home in a private neighborhood, Kaneohe Woods! 2 lanais overlooking the beautiful Koolau Mountains as well as landscaped backyard and porch! More than $100,000 remodeling done updating all flooring, bathrooms, paint, and so much more! Owner made extra bedroom and full bathroom for more space! Maintenance fee includes water, sewer, and maintenance of all common elements and basketball court. Amazingly convenient location nearby the entrances to all H-3, Pali and Likelike Hwys, as well as many stores, shops, and restaurants at the Winward shopping Center! Won’t last long, to be sold As Is.

  • Bedrooms: 4
  • Full Baths: 3
  • Land Area (sf): 3,918
  • Living (sf): 1,838
  • Year Built: 1986

  • Property Condition: Above Average
  • Number of Parking Spaces: 4
  • Pool: None
  • Number of Stories: Three+
  • View: Mountain
  • Listing Office: New Star Hawaii Top Realty

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

CONTACT US

Marcus Realty

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

array(153) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "273800.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "612800.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "886600.00"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(20) "Detach Single Family"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(24) "Property Disclosure Stmt"
  }
  ["easements"]=>
  array(1) {
    [0]=>
    string(11) "Other,Sewer"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(18) "Ceramic Tile,Vinyl"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["furnished"]=>
  array(1) {
    [0]=>
    string(7) "Partial"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(4) "0.00"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(7) "3918.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(28) "danbikim@hawaiitoprealty.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(10) "Dan Bi Kim"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 955-4985"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-04-29"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(26) "New Star Hawaii Top Realty"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(10) "1199000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(4) "1838"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(41) "45-659 Haamaile Street, Kaneohe, HI 96744"
  }
  ["maintenance_fees"]=>
  array(1) {
    [0]=>
    string(6) "300.00"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202110118"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(13) "KANEOHE WOODS"
  }
  ["number_of_parking_spaces"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["number_of_stories"]=>
  array(1) {
    [0]=>
    string(6) "Three+"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "HTOP"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(6) "Garage"
  }
  ["pool_"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(10) "At Closing"
  }
  ["property_condition"]=>
  array(1) {
    [0]=>
    string(13) "Above 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_association_fee_total"]=>
  array(1) {
    [0]=>
    string(3) "300"
  }
  ["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(7) "Kaneohe"
  }
  ["rets_compensation_method"]=>
  array(1) {
    [0]=>
    string(6) "Escrow"
  }
  ["rets_condo_property_regime_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(10) "1306000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(1) "7"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["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) "15872507"
  }
  ["rets_immoviewer_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 955-4985"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(28) "danbikim@hawaiitoprealty.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(10) "Dan Bi Kim"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "48639"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(8) "12814234"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "HTOP"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "9448752"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(26) "New Star Hawaii Top Realty"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 955-4985"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(10) "1199000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-04-29"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(7) "3918.00"
  }
  ["rets_maintenance_expense"]=>
  array(1) {
    [0]=>
    string(6) "300.00"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-07-07T09:30:03.753"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "15872507"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202110118"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(13) "KANEOHE WOODS"
  }
  ["rets_new_development_construction_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_open_house_count"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-04-29T12:47:19.030"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(10) "1199000.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-4-5-105-014-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) "25"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-04-30T11:07:18.803"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96744"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-04-29T12:47:19.030"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "15872507"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(225) "No showings or open houses at the moment. Please call/text/email listing agent at 808-203-7557 or danbikim@hawaiitoprealty.com. Please kindly consider using Jin Yu from First Hawaii Title for escrow service. To be sold As Is."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(664) "RARELY AVAILABLE 3 stories, 4 bedrooms, 3 bathrooms totally remodeled home in a private neighborhood, Kaneohe Woods! 2 lanais overlooking the beautiful Koolau Mountains as well as landscaped backyard and porch! More than $100,000 remodeling done updating all flooring, bathrooms, paint, and so much more! Owner made extra bedroom and full bathroom for more space! Maintenance fee includes water, sewer, and maintenance of all common elements and basketball court. Amazingly convenient location nearby the entrances to all H-3, Pali and Likelike Hwys, as well as many stores, shops, and restaurants at the Winward shopping Center! Won't last long, to be sold As Is."
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(4) "1838"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(4) "1838"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-07-07T09:30:03.753"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-07-06"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(8) "Haamaile"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(6) "45-659"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(79) "1$21.38973653606097$-157.8009509082673$183.18$13.33$1.00$HcEhlk8pEmeFNo3bHnJeFw"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(4) "2.5%"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "223.17"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "886600.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "273800.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "612800.00"
  }
  ["rets_tax_excemption_owner_occupancy"]=>
  array(1) {
    [0]=>
    string(4) "0.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/15872507/0d2c973003b2c670dcdf67a4bd71cf07"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "145"
  }
  ["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) "14"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(3) "105"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1986"
  }
  ["setbacks"]=>
  array(1) {
    [0]=>
    string(9) "Of Record"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(20) "Cash,Conventional,VA"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-4-5-105-014-0000"
  }
  ["topography"]=>
  array(1) {
    [0]=>
    string(5) "Clear"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(8) "Mountain"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "15872507"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202110118"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1628912146"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1986"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(29) "05 - R-5 Residential District"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(1683) "a:105:{i:0;i:19897533;i:1;i:19897534;i:2;i:19897535;i:3;i:19897536;i:4;i:19897537;i:5;i:19897538;i:6;i:19897539;i:7;i:19897540;i:8;i:19897541;i:9;i:19897542;i:10;i:19897543;i:11;i:19897544;i:12;i:19897545;i:13;i:19897546;i:14;i:19897547;i:15;i:19897548;i:16;i:19897549;i:17;i:19897550;i:18;i:19897551;i:19;i:19897552;i:20;i:19897553;i:21;i:19904288;i:22;i:19904289;i:23;i:19904290;i:24;i:19904291;i:25;i:19904292;i:26;i:19904293;i:27;i:19904294;i:28;i:19904295;i:29;i:19904296;i:30;i:19904297;i:31;i:19904298;i:32;i:19904299;i:33;i:19904300;i:34;i:19904301;i:35;i:19904302;i:36;i:19904303;i:37;i:19904304;i:38;i:19904305;i:39;i:19904306;i:40;i:19904307;i:41;i:19904308;i:42;i:19912122;i:43;i:19912123;i:44;i:19912124;i:45;i:19912125;i:46;i:19912126;i:47;i:19912127;i:48;i:19912128;i:49;i:19912129;i:50;i:19912130;i:51;i:19912131;i:52;i:19912132;i:53;i:19912133;i:54;i:19912134;i:55;i:19912135;i:56;i:19912136;i:57;i:19912137;i:58;i:19912138;i:59;i:19912139;i:60;i:19912140;i:61;i:19912141;i:62;i:19912142;i:63;i:20038157;i:64;i:20038158;i:65;i:20038159;i:66;i:20038160;i:67;i:20038161;i:68;i:20038162;i:69;i:20038163;i:70;i:20038164;i:71;i:20038165;i:72;i:20038166;i:73;i:20038167;i:74;i:20038168;i:75;i:20038169;i:76;i:20038170;i:77;i:20038171;i:78;i:20038172;i:79;i:20038173;i:80;i:20038174;i:81;i:20038175;i:82;i:20038176;i:83;i:20038177;i:84;i:20286015;i:85;i:20286016;i:86;i:20286017;i:87;i:20286018;i:88;i:20286019;i:89;i:20286020;i:90;i:20286021;i:91;i:20286022;i:92;i:20286023;i:93;i:20286024;i:94;i:20286025;i:95;i:20286026;i:96;i:20286027;i:97;i:20286028;i:98;i:20286029;i:99;i:20286030;i:100;i:20286031;i:101;i:20286032;i:102;i:20286033;i:103;i:20286034;i:104;i:20286035;}"
  }
  ["rets_active_open_house_count"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_open_house_upcoming"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96744"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-05-06"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-07-06"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(10) "1306000.00"
  }
  ["rets_co_selling_agent_direct_work_pho"]=>
  array(1) {
    [0]=>
    string(14) "(808) 597-5550"
  }
  ["rets_co_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(28) "chantelle.awana@cbrealty.com"
  }
  ["rets_co_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(17) "Chantelle M Awana"
  }
  ["rets_co_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "38973"
  }
  ["rets_co_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3481828"
  }
  ["rets_co_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(6) "CBPP09"
  }
  ["rets_co_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3487755"
  }
  ["rets_co_selling_office_name"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["rets_co_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 597-5550"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-07-06"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 597-5550"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(25) "tess.dejesus@cbrealty.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(15) "Tess C de Jesus"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "45988"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "9918085"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(6) "CBPP09"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3487755"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 597-5550"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(8) "Haamaile"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(6) "45-659"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20286015"
  }
}