47-523 Melekula Road
Kaneohe, HI 96744

Listing
Overview

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

Come home to this peaceful Ahuimanu kama’aina oasis! 3 bedrooms and 2 full bathrooms, plus a flexible bonus room could be an office, play room, or exercise room with breezes and a view! Kitchen, dining and living rooms all have a delightful open feeling, with picture window views of the forest, and cool breezes with the sounds of the stream. Lots of storage (separate storage shed next to carport) and lots of parking in carport and separate driveway. Set off from Melekula road, this is a one level home with easy accessibility with just a half a step up from the carport to the front door. You would never think it’s just minutes away from Haiku Valley and freeway access. Please schedule a private appointment starting Thu 9/9. DO NOT WALK OR DRIVE ON DRIVEWAY OR PROPERTY without an appointment.

Listing by: Redfin Corporation

array(145) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "162800.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "569400.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "732200.00"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["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(36) "Call Listor,Property Disclosure Stmt"
  }
  ["easements"]=>
  array(1) {
    [0]=>
    string(8) "Driveway"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(5) "Vinyl"
  }
  ["frontage"]=>
  array(1) {
    [0]=>
    string(12) "Stream/Canal"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["furnished"]=>
  array(1) {
    [0]=>
    string(7) "Partial"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(6) "140000"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(8) "11168.00"
  }
  ["land_recorded"]=>
  array(1) {
    [0]=>
    string(10) "Land Court"
  }
  ["land_tenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["list_agent_email"]=>
  array(1) {
    [0]=>
    string(20) "aliban1012@gmail.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(7) "Ali Ban"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 518-3429"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-08"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(18) "Redfin Corporation"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "975000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(4) "1328"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(39) "47-523 Melekula Road, Kaneohe, HI 96744"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202123127"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(13) "AHUIMANU AREA"
  }
  ["number_of_parking_spaces"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["number_of_stories"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "RFIN"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(23) "3 Car+,Carport,Driveway"
  }
  ["pool_"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(10) "Negotiable"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96744"
  }
  ["property_condition"]=>
  array(1) {
    [0]=>
    string(21) "Above Average,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) "3"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["rets_compensation_method"]=>
  array(1) {
    [0]=>
    string(1) "%"
  }
  ["rets_condo_property_regime_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(9) "999999.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(2) "12"
  }
  ["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) "16143838"
  }
  ["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) 518-3429"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(20) "aliban1012@gmail.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(7) "Ali Ban"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "43351"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3483525"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "RFIN"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "9626004"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(18) "Redfin Corporation"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 518-3429"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(9) "975000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-08"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(8) "11168.00"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-11-15T16:38:35.547"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "16143838"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202123127"
  }
  ["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-09-03T17:24:52.537"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(9) "975000.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-4-7-046-040-0000"
  }
  ["rets_parking_total"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["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) "24"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-07T15:40:36.123"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96744"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-08T09:25:44.677"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "16143838"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(231) "Please request a showing in Showing Time by appointment, need at least 24 hours' notice. Any questions and before preparing offer please contact Ali BY EMAIL. Bonus room is unpermitted (originally an open lanai, slab is permitted)."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(801) "Come home to this peaceful Ahuimanu kama'aina oasis! 3 bedrooms and 2 full bathrooms, plus a flexible bonus room could be an office, play room, or exercise room with breezes and a view! Kitchen, dining and living rooms all have a delightful open feeling, with picture window views of the forest, and cool breezes with the sounds of the stream. Lots of storage (separate storage shed next to carport) and lots of parking in carport and separate driveway. Set off from Melekula road, this is a one level home with easy accessibility with just a half a step up from the carport to the front door. You would never think it's just minutes away from Haiku Valley and freeway access. Please schedule a private appointment starting Thu 9/9. DO NOT WALK OR DRIVE ON DRIVEWAY OR PROPERTY without an appointment."
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(4) "1328"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(4) "1328"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-11-15T16:38:35.547"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-15"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(8) "Melekula"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(6) "47-523"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(63) "1$21.438478$-157.843695$76.84$13.33$1.00$vuQQOplQBjQ_YzrCynIwEw"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(3) "2.5"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "172.73"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "732200.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "162800.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "569400.00"
  }
  ["rets_tax_excemption_owner_occupancy"]=>
  array(1) {
    [0]=>
    string(6) "140000"
  }
  ["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/16143838/cdc841ea2d3856830460cb5d9cdbd92b"
  }
  ["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) "40"
  }
  ["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) "46"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1961"
  }
  ["security"]=>
  array(1) {
    [0]=>
    string(9) "Key,Video"
  }
  ["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(8) "Melekula"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(6) "47-523"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(4) "Road"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(26) "Cash,Conventional,Exchange"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-4-7-046-040-0000"
  }
  ["topography"]=>
  array(1) {
    [0]=>
    string(15) "Flag Lot,Wooded"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(15) "Garden,Mountain"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "16143838"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202123127"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1637030338"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1961"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(31) "03 - R10 - Residential District"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(3468) "a:210:{i:0;i:20699360;i:1;i:20699361;i:2;i:20699362;i:3;i:20699363;i:4;i:20699364;i:5;i:20699365;i:6;i:20699366;i:7;i:20699367;i:8;i:20699368;i:9;i:20699369;i:10;i:20699370;i:11;i:20699371;i:12;i:20699372;i:13;i:20699373;i:14;i:20699374;i:15;i:20699375;i:16;i:20699376;i:17;i:20699377;i:18;i:20699378;i:19;i:20699379;i:20;i:20699380;i:21;i:20701154;i:22;i:20701155;i:23;i:20701156;i:24;i:20701157;i:25;i:20701158;i:26;i:20701159;i:27;i:20701160;i:28;i:20701161;i:29;i:20701162;i:30;i:20701163;i:31;i:20701164;i:32;i:20701165;i:33;i:20701166;i:34;i:20701167;i:35;i:20701168;i:36;i:20701169;i:37;i:20701170;i:38;i:20701171;i:39;i:20701172;i:40;i:20701173;i:41;i:20701174;i:42;i:20706656;i:43;i:20706657;i:44;i:20706658;i:45;i:20706659;i:46;i:20706660;i:47;i:20706661;i:48;i:20706662;i:49;i:20706663;i:50;i:20706664;i:51;i:20706665;i:52;i:20706666;i:53;i:20706667;i:54;i:20706668;i:55;i:20706669;i:56;i:20706670;i:57;i:20706671;i:58;i:20706672;i:59;i:20706673;i:60;i:20706674;i:61;i:20706675;i:62;i:20706676;i:63;i:20706698;i:64;i:20706699;i:65;i:20706700;i:66;i:20706701;i:67;i:20706702;i:68;i:20706703;i:69;i:20706704;i:70;i:20706705;i:71;i:20706706;i:72;i:20706707;i:73;i:20706708;i:74;i:20706709;i:75;i:20706710;i:76;i:20706711;i:77;i:20706712;i:78;i:20706713;i:79;i:20706714;i:80;i:20706715;i:81;i:20706716;i:82;i:20706717;i:83;i:20706718;i:84;i:20715401;i:85;i:20715402;i:86;i:20715403;i:87;i:20715404;i:88;i:20715405;i:89;i:20715406;i:90;i:20715407;i:91;i:20715408;i:92;i:20715409;i:93;i:20715410;i:94;i:20715411;i:95;i:20715412;i:96;i:20715413;i:97;i:20715414;i:98;i:20715415;i:99;i:20715416;i:100;i:20715417;i:101;i:20715418;i:102;i:20715419;i:103;i:20715420;i:104;i:20715421;i:105;i:20717692;i:106;i:20717693;i:107;i:20717694;i:108;i:20717695;i:109;i:20717696;i:110;i:20717697;i:111;i:20717698;i:112;i:20717699;i:113;i:20717700;i:114;i:20717701;i:115;i:20717702;i:116;i:20717703;i:117;i:20717704;i:118;i:20717705;i:119;i:20717706;i:120;i:20717707;i:121;i:20717708;i:122;i:20717709;i:123;i:20717710;i:124;i:20717711;i:125;i:20717712;i:126;i:20770097;i:127;i:20770098;i:128;i:20770099;i:129;i:20770100;i:130;i:20770101;i:131;i:20770102;i:132;i:20770103;i:133;i:20770104;i:134;i:20770105;i:135;i:20770106;i:136;i:20770107;i:137;i:20770108;i:138;i:20770109;i:139;i:20770110;i:140;i:20770111;i:141;i:20770112;i:142;i:20770113;i:143;i:20770114;i:144;i:20770115;i:145;i:20770116;i:146;i:20770117;i:147;i:20783460;i:148;i:20783461;i:149;i:20783462;i:150;i:20783463;i:151;i:20783464;i:152;i:20783465;i:153;i:20783466;i:154;i:20783467;i:155;i:20783468;i:156;i:20783469;i:157;i:20783470;i:158;i:20783471;i:159;i:20783472;i:160;i:20783473;i:161;i:20783474;i:162;i:20783475;i:163;i:20783476;i:164;i:20783477;i:165;i:20783478;i:166;i:20783479;i:167;i:20783480;i:168;i:20836377;i:169;i:20836378;i:170;i:20836379;i:171;i:20836380;i:172;i:20836381;i:173;i:20836382;i:174;i:20836383;i:175;i:20836384;i:176;i:20836385;i:177;i:20836386;i:178;i:20836387;i:179;i:20836388;i:180;i:20836389;i:181;i:20836390;i:182;i:20836391;i:183;i:20836392;i:184;i:20836393;i:185;i:20836394;i:186;i:20836395;i:187;i:20836396;i:188;i:20836397;i:189;i:21164543;i:190;i:21164544;i:191;i:21164545;i:192;i:21164546;i:193;i:21164547;i:194;i:21164548;i:195;i:21164549;i:196;i:21164550;i:197;i:21164551;i:198;i:21164552;i:199;i:21164553;i:200;i:21164554;i:201;i:21164555;i:202;i:21164556;i:203;i:21164557;i:204;i:21164558;i:205;i:21164559;i:206;i:21164560;i:207;i:21164561;i:208;i:21164562;i:209;i:21164563;}"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-16"
  }
  ["rets_pending_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-16"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-15"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(9) "999999.00"
  }
  ["rets_expiration_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-12-31"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-15"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 744-0340"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(18) "iambelindab@me.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(16) "Belinda B Barnes"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "25735"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3475565"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "HHFS"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "9678707"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(26) "Hawaii Homes For Sale, LLC"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 744-0340"
  }
  ["rets_tax_annual_amount"]=>
  array(1) {
    [0]=>
    string(7) "2072.76"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "21164543"
  }
}
Array
(
    [assd_val_imprv] => Array
        (
            [0] => 162800.00
        )

    [assd_val_land] => Array
        (
            [0] => 569400.00
        )

    [assd_val_total] => Array
        (
            [0] => 732200.00
        )

    [bedrooms] => Array
        (
            [0] => 3
        )

    [building_style] => Array
        (
            [0] => Detach Single Family
        )

    [city] => Array
        (
            [0] => Kaneohe
        )

    [county] => Array
        (
            [0] => Oahu
        )

    [disclosures] => Array
        (
            [0] => Call Listor,Property Disclosure Stmt
        )

    [easements] => Array
        (
            [0] => Driveway
        )

    [floor_covering] => Array
        (
            [0] => Vinyl
        )

    [frontage] => Array
        (
            [0] => Stream/Canal
        )

    [full_baths] => Array
        (
            [0] => 2
        )

    [furnished] => Array
        (
            [0] => Partial
        )

    [half_baths] => Array
        (
            [0] => 0
        )

    [home_exampt] => Array
        (
            [0] => 140000
        )

    [land_area_sf] => Array
        (
            [0] => 11168.00
        )

    [land_recorded] => Array
        (
            [0] => Land Court
        )

    [land_tenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [list_agent_email] => Array
        (
            [0] => aliban1012@gmail.com
        )

    [list_agent_name] => Array
        (
            [0] => Ali Ban
        )

    [list_agent_phone_number] => Array
        (
            [0] => (808) 518-3429
        )

    [list_date] => Array
        (
            [0] => 2021-09-08
        )

    [list_office_name] => Array
        (
            [0] => Redfin Corporation
        )

    [list_price] => Array
        (
            [0] => 975000.00
        )

    [living_sf] => Array
        (
            [0] => 1328
        )

    [location] => Array
        (
            [0] => 47-523 Melekula Road, Kaneohe, HI 96744
        )

    [mls_] => Array
        (
            [0] => 202123127
        )

    [neighborhood] => Array
        (
            [0] => AHUIMANU AREA
        )

    [number_of_parking_spaces] => Array
        (
            [0] => 3
        )

    [number_of_stories] => Array
        (
            [0] => One
        )

    [office_mls_id] => Array
        (
            [0] => RFIN
        )

    [parking_features] => Array
        (
            [0] => 3 Car+,Carport,Driveway
        )

    [pool_] => Array
        (
            [0] => None
        )

    [possession] => Array
        (
            [0] => Negotiable
        )

    [postal_code] => Array
        (
            [0] => 96744
        )

    [property_condition] => Array
        (
            [0] => Above Average,Average
        )

    [property_type] => Array
        (
            [0] => single_family
        )

    [property_type_label] => Array
        (
            [0] => single_family
        )

    [region] => Array
        (
            [0] => Kaneohe
        )

    [rets_baths_full] => Array
        (
            [0] => 2
        )

    [rets_baths_half] => Array
        (
            [0] => 0
        )

    [rets_baths_total] => Array
        (
            [0] => 2.00
        )

    [rets_beds_total] => Array
        (
            [0] => 3
        )

    [rets_city] => Array
        (
            [0] => Kaneohe
        )

    [rets_compensation_method] => Array
        (
            [0] => %
        )

    [rets_condo_property_regime_yn] => Array
        (
            [0] => 0
        )

    [rets_current_price] => Array
        (
            [0] => 999999.00
        )

    [rets_dom] => Array
        (
            [0] => 12
        )

    [rets_dual_variable_compensation_yn] => Array
        (
            [0] => 1
        )

    [rets_foreclosure_yn] => Array
        (
            [0] => 0
        )

    [rets_fractional_ownership_yn] => Array
        (
            [0] => 0
        )

    [rets_id] => Array
        (
            [0] => 16143838
        )

    [rets_immoviewer_yn] => Array
        (
            [0] => 0
        )

    [rets_internet_automated_valuation_dis] => Array
        (
            [0] => 1
        )

    [rets_internet_consumer_comment_yn] => Array
        (
            [0] => 1
        )

    [rets_list_agent_direct_work_phone] => Array
        (
            [0] => (808) 518-3429
        )

    [rets_list_agent_email] => Array
        (
            [0] => aliban1012@gmail.com
        )

    [rets_list_agent_full_name] => Array
        (
            [0] => Ali Ban
        )

    [rets_list_agent_mlsid] => Array
        (
            [0] => 43351
        )

    [rets_list_agent_mui] => Array
        (
            [0] => 3483525
        )

    [rets_list_office_mlsid] => Array
        (
            [0] => RFIN
        )

    [rets_list_office_mui] => Array
        (
            [0] => 9626004
        )

    [rets_list_office_name] => Array
        (
            [0] => Redfin Corporation
        )

    [rets_list_office_phone] => Array
        (
            [0] => (808) 518-3429
        )

    [rets_list_price] => Array
        (
            [0] => 975000.00
        )

    [rets_listing_contract_date] => Array
        (
            [0] => 2021-09-08
        )

    [rets_lot_size_area] => Array
        (
            [0] => 11168.00
        )

    [rets_matrix_modified_dt] => Array
        (
            [0] => 2021-11-15T16:38:35.547
        )

    [rets_matrix_unique_id] => Array
        (
            [0] => 16143838
        )

    [rets_mls_number] => Array
        (
            [0] => 202123127
        )

    [rets_neighbourhood] => Array
        (
            [0] => AHUIMANU AREA
        )

    [rets_new_development_construction_yn] => Array
        (
            [0] => 0
        )

    [rets_original_entry_timestamp] => Array
        (
            [0] => 2021-09-03T17:24:52.537
        )

    [rets_original_list_price] => Array
        (
            [0] => 975000.00
        )

    [rets_parcel_number] => Array
        (
            [0] => 1-4-7-046-040-0000
        )

    [rets_parking_total] => Array
        (
            [0] => 3
        )

    [rets_permit_address_internet_yn] => Array
        (
            [0] => 1
        )

    [rets_permit_internet_yn] => Array
        (
            [0] => 1
        )

    [rets_photo_count] => Array
        (
            [0] => 24
        )

    [rets_photo_modification_timestamp] => Array
        (
            [0] => 2021-09-07T15:40:36.123
        )

    [rets_postal_code] => Array
        (
            [0] => 96744
        )

    [rets_price_change_timestamp] => Array
        (
            [0] => 2021-09-08T09:25:44.677
        )

    [rets_primary_key] => Array
        (
            [0] => 16143838
        )

    [rets_private_remarks] => Array
        (
            [0] => Please request a showing in Showing Time by appointment, need at least 24 hours' notice. Any questions and before preparing offer please contact Ali BY EMAIL. Bonus room is unpermitted (originally an open lanai, slab is permitted).
        )

    [rets_public_remarks] => Array
        (
            [0] => Come home to this peaceful Ahuimanu kama'aina oasis! 3 bedrooms and 2 full bathrooms, plus a flexible bonus room could be an office, play room, or exercise room with breezes and a view! Kitchen, dining and living rooms all have a delightful open feeling, with picture window views of the forest, and cool breezes with the sounds of the stream. Lots of storage (separate storage shed next to carport) and lots of parking in carport and separate driveway. Set off from Melekula road, this is a one level home with easy accessibility with just a half a step up from the carport to the front door. You would never think it's just minutes away from Haiku Valley and freeway access. Please schedule a private appointment starting Thu 9/9. DO NOT WALK OR DRIVE ON DRIVEWAY OR PROPERTY without an appointment.
        )

    [rets_sqft_roofed_living] => Array
        (
            [0] => 1328
        )

    [rets_sqft_total] => Array
        (
            [0] => 1328
        )

    [rets_state_or_province] => Array
        (
            [0] => HI
        )

    [rets_status_change_timestamp] => Array
        (
            [0] => 2021-11-15T16:38:35.547
        )

    [rets_status_contractual_search_date] => Array
        (
            [0] => 2021-11-15
        )

    [rets_street_name] => Array
        (
            [0] => Melekula
        )

    [rets_street_number] => Array
        (
            [0] => 47-523
        )

    [rets_street_view_param] => Array
        (
            [0] => 1$21.438478$-157.843695$76.84$13.33$1.00$vuQQOplQBjQ_YzrCynIwEw
        )

    [rets_sub_agency_compensation] => Array
        (
            [0] => 2.5
        )

    [rets_tax_amount] => Array
        (
            [0] => 172.73
        )

    [rets_tax_assessed_value] => Array
        (
            [0] => 732200.00
        )

    [rets_tax_assessed_value_improvements] => Array
        (
            [0] => 162800.00
        )

    [rets_tax_assessed_value_land] => Array
        (
            [0] => 569400.00
        )

    [rets_tax_excemption_owner_occupancy] => Array
        (
            [0] => 140000
        )

    [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/16143838/cdc841ea2d3856830460cb5d9cdbd92b
        )

    [rets_tmk_area] => Array
        (
            [0] => 147
        )

    [rets_tmk_condo_property_regime_number] => Array
        (
            [0] => 0
        )

    [rets_tmk_division] => Array
        (
            [0] => 1
        )

    [rets_tmk_parcel] => Array
        (
            [0] => 40
        )

    [rets_tmk_section] => Array
        (
            [0] => 7
        )

    [rets_tmk_zone] => Array
        (
            [0] => 4
        )

    [rets_tmkplat] => Array
        (
            [0] => 46
        )

    [rets_year_built] => Array
        (
            [0] => 1961
        )

    [security] => Array
        (
            [0] => Key,Video
        )

    [setbacks] => Array
        (
            [0] => C&C
        )

    [state_or_province] => Array
        (
            [0] => HI
        )

    [status] => Array
        (
            [0] => Sold
        )

    [street_name] => Array
        (
            [0] => Melekula
        )

    [street_number] => Array
        (
            [0] => 47-523
        )

    [street_suffix] => Array
        (
            [0] => Road
        )

    [terms_accept] => Array
        (
            [0] => Cash,Conventional,Exchange
        )

    [tmk] => Array
        (
            [0] => 1-4-7-046-040-0000
        )

    [topography] => Array
        (
            [0] => Flag Lot,Wooded
        )

    [view] => Array
        (
            [0] => Garden,Mountain
        )

    [wpp::rets_pk] => Array
        (
            [0] => 16143838
        )

    [wpp_gpid] => Array
        (
            [0] => 202123127
        )

    [wpp_import_schedule_id] => Array
        (
            [0] => 1463343682
        )

    [wpp_import_time] => Array
        (
            [0] => 1637030338
        )

    [year_built] => Array
        (
            [0] => 1961
        )

    [zoning] => Array
        (
            [0] => 03 - R10 - Residential District
        )

    [new_attached_media] => Array
        (
            [0] => a:210:{i:0;i:20699360;i:1;i:20699361;i:2;i:20699362;i:3;i:20699363;i:4;i:20699364;i:5;i:20699365;i:6;i:20699366;i:7;i:20699367;i:8;i:20699368;i:9;i:20699369;i:10;i:20699370;i:11;i:20699371;i:12;i:20699372;i:13;i:20699373;i:14;i:20699374;i:15;i:20699375;i:16;i:20699376;i:17;i:20699377;i:18;i:20699378;i:19;i:20699379;i:20;i:20699380;i:21;i:20701154;i:22;i:20701155;i:23;i:20701156;i:24;i:20701157;i:25;i:20701158;i:26;i:20701159;i:27;i:20701160;i:28;i:20701161;i:29;i:20701162;i:30;i:20701163;i:31;i:20701164;i:32;i:20701165;i:33;i:20701166;i:34;i:20701167;i:35;i:20701168;i:36;i:20701169;i:37;i:20701170;i:38;i:20701171;i:39;i:20701172;i:40;i:20701173;i:41;i:20701174;i:42;i:20706656;i:43;i:20706657;i:44;i:20706658;i:45;i:20706659;i:46;i:20706660;i:47;i:20706661;i:48;i:20706662;i:49;i:20706663;i:50;i:20706664;i:51;i:20706665;i:52;i:20706666;i:53;i:20706667;i:54;i:20706668;i:55;i:20706669;i:56;i:20706670;i:57;i:20706671;i:58;i:20706672;i:59;i:20706673;i:60;i:20706674;i:61;i:20706675;i:62;i:20706676;i:63;i:20706698;i:64;i:20706699;i:65;i:20706700;i:66;i:20706701;i:67;i:20706702;i:68;i:20706703;i:69;i:20706704;i:70;i:20706705;i:71;i:20706706;i:72;i:20706707;i:73;i:20706708;i:74;i:20706709;i:75;i:20706710;i:76;i:20706711;i:77;i:20706712;i:78;i:20706713;i:79;i:20706714;i:80;i:20706715;i:81;i:20706716;i:82;i:20706717;i:83;i:20706718;i:84;i:20715401;i:85;i:20715402;i:86;i:20715403;i:87;i:20715404;i:88;i:20715405;i:89;i:20715406;i:90;i:20715407;i:91;i:20715408;i:92;i:20715409;i:93;i:20715410;i:94;i:20715411;i:95;i:20715412;i:96;i:20715413;i:97;i:20715414;i:98;i:20715415;i:99;i:20715416;i:100;i:20715417;i:101;i:20715418;i:102;i:20715419;i:103;i:20715420;i:104;i:20715421;i:105;i:20717692;i:106;i:20717693;i:107;i:20717694;i:108;i:20717695;i:109;i:20717696;i:110;i:20717697;i:111;i:20717698;i:112;i:20717699;i:113;i:20717700;i:114;i:20717701;i:115;i:20717702;i:116;i:20717703;i:117;i:20717704;i:118;i:20717705;i:119;i:20717706;i:120;i:20717707;i:121;i:20717708;i:122;i:20717709;i:123;i:20717710;i:124;i:20717711;i:125;i:20717712;i:126;i:20770097;i:127;i:20770098;i:128;i:20770099;i:129;i:20770100;i:130;i:20770101;i:131;i:20770102;i:132;i:20770103;i:133;i:20770104;i:134;i:20770105;i:135;i:20770106;i:136;i:20770107;i:137;i:20770108;i:138;i:20770109;i:139;i:20770110;i:140;i:20770111;i:141;i:20770112;i:142;i:20770113;i:143;i:20770114;i:144;i:20770115;i:145;i:20770116;i:146;i:20770117;i:147;i:20783460;i:148;i:20783461;i:149;i:20783462;i:150;i:20783463;i:151;i:20783464;i:152;i:20783465;i:153;i:20783466;i:154;i:20783467;i:155;i:20783468;i:156;i:20783469;i:157;i:20783470;i:158;i:20783471;i:159;i:20783472;i:160;i:20783473;i:161;i:20783474;i:162;i:20783475;i:163;i:20783476;i:164;i:20783477;i:165;i:20783478;i:166;i:20783479;i:167;i:20783480;i:168;i:20836377;i:169;i:20836378;i:170;i:20836379;i:171;i:20836380;i:172;i:20836381;i:173;i:20836382;i:174;i:20836383;i:175;i:20836384;i:176;i:20836385;i:177;i:20836386;i:178;i:20836387;i:179;i:20836388;i:180;i:20836389;i:181;i:20836390;i:182;i:20836391;i:183;i:20836392;i:184;i:20836393;i:185;i:20836394;i:186;i:20836395;i:187;i:20836396;i:188;i:20836397;i:189;i:21164543;i:190;i:21164544;i:191;i:21164545;i:192;i:21164546;i:193;i:21164547;i:194;i:21164548;i:195;i:21164549;i:196;i:21164550;i:197;i:21164551;i:198;i:21164552;i:199;i:21164553;i:200;i:21164554;i:201;i:21164555;i:202;i:21164556;i:203;i:21164557;i:204;i:21164558;i:205;i:21164559;i:206;i:21164560;i:207;i:21164561;i:208;i:21164562;i:209;i:21164563;}
        )

    [rets_active_continue_to_show_date] => Array
        (
            [0] => 2021-09-16
        )

    [rets_pending_date] => Array
        (
            [0] => 2021-09-16
        )

    [rets_close_date] => Array
        (
            [0] => 2021-11-15
        )

    [rets_close_price] => Array
        (
            [0] => 999999.00
        )

    [rets_expiration_date] => Array
        (
            [0] => 2021-12-31
        )

    [rets_off_market_date] => Array
        (
            [0] => 2021-11-15
        )

    [rets_selling_agent_direct_work_phone] => Array
        (
            [0] => (808) 744-0340
        )

    [rets_selling_agent_email] => Array
        (
            [0] => iambelindab@me.com
        )

    [rets_selling_agent_full_name] => Array
        (
            [0] => Belinda B Barnes
        )

    [rets_selling_agent_mlsid] => Array
        (
            [0] => 25735
        )

    [rets_selling_agent_mui] => Array
        (
            [0] => 3475565
        )

    [rets_selling_office_mlsid] => Array
        (
            [0] => HHFS
        )

    [rets_selling_office_mui] => Array
        (
            [0] => 9678707
        )

    [rets_selling_office_name] => Array
        (
            [0] => Hawaii Homes For Sale, LLC
        )

    [rets_selling_office_phone] => Array
        (
            [0] => (808) 744-0340
        )

    [rets_tax_annual_amount] => Array
        (
            [0] => 2072.76
        )

    [_thumbnail_id] => Array
        (
            [0] => 21164543
        )

)

  • Bedrooms: 3
  • Full Baths: 2
  • Land Area (sf): 11,168
  • Living (sf): 1,328
  • Year Built: 1961

  • Property Condition: Above Average,Average
  • Number of Parking Spaces: 3
  • Pool: None
  • Number of Stories: One
  • View: Garden,Mountain
  • Listing Office: Redfin Corporation

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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