62-170 B Emerson Road Unit B
Haleiwa, HI 96712

Listing
Overview

Price: $985,000
Area: HALEIWA
Status: Sold

Great opportunity to purchase move in ready 3 bedroom/2 bath single family home with spacious apprx. 600 SQFT furnished studio/rec room above the large four car garage/carport in rarely available and extremely convenient location on Emerson Rd. just outside of Haleiwa Town with access from the Joseph Leong Hwy (aka bypass rd). Live in the main house and use the studio/rec room as an in-law/guest unit, home office, etc.. Enjoy the feeling of living away from the busier Haleiwa town as well as the convenience of being just a short walk/bike ride to the shops/restaurants at the Haleiwa Plantation Store Lots and Haleiwa Shopping Plaza, Haleiwa Joe’s, and more. Launch your SUP/Kayak/Canoe/etc on the picturesque Anahulu Stream just a few steps from your home. Relax on the good size deck overlooking the Anahulu and new backyard while you BBQ or watch the sunset. Lots of covered storage area for your ocean/river equipment, jet skis, kayaks, SUPs, surfboards, bikes, etc. in the carport and under the house. Currently vacant, but has great rental history with most recent rental income of $5000/mo. Don’t wait, priced to sell.

Listing by: Team Real Estate, Inc.

array(169) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "389400.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "506600.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "896000.00"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(39) "CPR,Detach Single Family,Studio Cottage"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(7) "Haleiwa"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(36) "Property Disclosure Stmt,See Remarks"
  }
  ["easements"]=>
  array(1) {
    [0]=>
    string(14) "Driveway,Other"
  }
  ["elementary_school"]=>
  array(1) {
    [0]=>
    string(7) "Haleiwa"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(8) "Laminate"
  }
  ["frontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["furnished"]=>
  array(1) {
    [0]=>
    string(7) "Partial"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["high_school"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(3) "Yes"
  }
  ["lanai_sf"]=>
  array(1) {
    [0]=>
    string(3) "377"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(7) "4936.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(22) "dougcole@hawaii.rr.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(9) "Doug Cole"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 637-3507"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-08"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(22) "Team Real Estate, Inc."
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "985000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(4) "1830"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(47) "62-170 B Emerson Road Unit B, Haleiwa, HI 96712"
  }
  ["middle_school"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202123386"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(7) "HALEIWA"
  }
  ["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) "TEAM"
  }
  ["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) "96712"
  }
  ["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(11) "North Shore"
  }
  ["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) "3"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(7) "Haleiwa"
  }
  ["rets_condo_property_regime_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(9) "999000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_elementary_school"]=>
  array(1) {
    [0]=>
    string(7) "Haleiwa"
  }
  ["rets_foreclosure_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_fractional_ownership_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_high_school"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["rets_id"]=>
  array(1) {
    [0]=>
    string(8) "16151281"
  }
  ["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) 637-3507"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(22) "dougcole@hawaii.rr.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(9) "Doug Cole"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "26740"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3476387"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "TEAM"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3485712"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(22) "Team Real Estate, Inc."
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 637-3507"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(9) "985000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-08"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(7) "4936.00"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-10-11T10:00:59.330"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "16151281"
  }
  ["rets_middle_or_junior_school"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202123386"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "HALEIWA"
  }
  ["rets_new_development_construction_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-07T19:26:14.280"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(9) "985000.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-6-2-012-004-0002"
  }
  ["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-09-08T08:18:24.533"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96712"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "16151281"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(159) "Vacant and easy to see.  Just call or text Doug at (808) 497-0036 to schedule a showing.  

Listing agent license recently changed from RS-62712 to RB-23551."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(1133) "Great opportunity to purchase move in ready 3 bedroom/2 bath single family home with spacious apprx. 600 SQFT furnished studio/rec room above the large four car garage/carport in rarely available and extremely convenient location on Emerson Rd. just outside of Haleiwa Town with access from the Joseph Leong Hwy (aka bypass rd). Live in the main house and use the studio/rec room as an in-law/guest unit, home office, etc.. Enjoy the feeling of living away from the busier Haleiwa town as well as the convenience of being just a short walk/bike ride to the shops/restaurants at the Haleiwa Plantation Store Lots and Haleiwa Shopping Plaza, Haleiwa Joe's, and more. Launch your SUP/Kayak/Canoe/etc on the picturesque Anahulu Stream just a few steps from your home. Relax on the good size deck overlooking the Anahulu and new backyard while you BBQ or watch the sunset.  Lots of covered storage area for your ocean/river equipment, jet skis, kayaks, SUPs, surfboards, bikes, etc. in the carport and under the house. Currently vacant, but has great rental history with most recent rental income of $5000/mo.  Don't wait, priced to sell."
  }
  ["rets_public_report_number"]=>
  array(1) {
    [0]=>
    string(4) "7318"
  }
  ["rets_room_count"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_sqft_garage_carport"]=>
  array(1) {
    [0]=>
    string(3) "759"
  }
  ["rets_sqft_lanai_open"]=>
  array(1) {
    [0]=>
    string(3) "377"
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(3) "853"
  }
  ["rets_sqft_roofed_other"]=>
  array(1) {
    [0]=>
    string(3) "600"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(4) "1830"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-10-11T10:00:59.330"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-10-11"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(7) "Emerson"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(8) "62-170 B"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(63) "1$21.592049$-158.099671$40.33$13.33$1.00$vlNtzPtO_6WU7JHkhT2S6w"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(4) "2.5%"
  }
  ["rets_supplement_count"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_supplement_modification_timestam"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-07T16:40:18.670"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "261.33"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "896000.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "389400.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "506600.00"
  }
  ["rets_tax_excemption_owner_occupancy"]=>
  array(1) {
    [0]=>
    string(3) "Yes"
  }
  ["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/16151281/1d7bcfcb5a5f24d0f751f55854063867"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "162"
  }
  ["rets_tmk_condo_property_regime_number"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_tmk_division"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tmk_parcel"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(2) "12"
  }
  ["rets_unit_number"]=>
  array(1) {
    [0]=>
    string(1) "B"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1961"
  }
  ["rets_year_remodeled"]=>
  array(1) {
    [0]=>
    string(4) "2001"
  }
  ["security"]=>
  array(1) {
    [0]=>
    string(3) "Key"
  }
  ["setbacks"]=>
  array(1) {
    [0]=>
    string(7) "Special"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(7) "Emerson"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(8) "62-170 B"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(4) "Road"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(23) "Cash,Conventional,Other"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-6-2-012-004-0002"
  }
  ["topography"]=>
  array(1) {
    [0]=>
    string(5) "Clear"
  }
  ["unit_number"]=>
  array(1) {
    [0]=>
    string(1) "B"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(25) "Garden,Ocean,Other,Sunset"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "16151281"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202123386"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1633982498"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1961"
  }
  ["year_remodeled_"]=>
  array(1) {
    [0]=>
    string(4) "2001"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(29) "05 - R-5 Residential District"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(2754) "a:168:{i:0;i:20698264;i:1;i:20698265;i:2;i:20698266;i:3;i:20698267;i:4;i:20698268;i:5;i:20698269;i:6;i:20698270;i:7;i:20698271;i:8;i:20698272;i:9;i:20698273;i:10;i:20698274;i:11;i:20698275;i:12;i:20698276;i:13;i:20698277;i:14;i:20698278;i:15;i:20698279;i:16;i:20698280;i:17;i:20698281;i:18;i:20698282;i:19;i:20698283;i:20;i:20698284;i:21;i:20698613;i:22;i:20698614;i:23;i:20698615;i:24;i:20698616;i:25;i:20698617;i:26;i:20698618;i:27;i:20698619;i:28;i:20698620;i:29;i:20698621;i:30;i:20698622;i:31;i:20698623;i:32;i:20698624;i:33;i:20698625;i:34;i:20698626;i:35;i:20698627;i:36;i:20698628;i:37;i:20698629;i:38;i:20698630;i:39;i:20698631;i:40;i:20698632;i:41;i:20698633;i:42;i:20698653;i:43;i:20698654;i:44;i:20698655;i:45;i:20698656;i:46;i:20698657;i:47;i:20698658;i:48;i:20698659;i:49;i:20698660;i:50;i:20698661;i:51;i:20698662;i:52;i:20698663;i:53;i:20698664;i:54;i:20698665;i:55;i:20698666;i:56;i:20698667;i:57;i:20698668;i:58;i:20698669;i:59;i:20698670;i:60;i:20698671;i:61;i:20698672;i:62;i:20698673;i:63;i:20698675;i:64;i:20698676;i:65;i:20698677;i:66;i:20698678;i:67;i:20698679;i:68;i:20698680;i:69;i:20698681;i:70;i:20698682;i:71;i:20698683;i:72;i:20698684;i:73;i:20698685;i:74;i:20698686;i:75;i:20698687;i:76;i:20698688;i:77;i:20698689;i:78;i:20698690;i:79;i:20698691;i:80;i:20698692;i:81;i:20698693;i:82;i:20698694;i:83;i:20698695;i:84;i:20704838;i:85;i:20704839;i:86;i:20704840;i:87;i:20704841;i:88;i:20704842;i:89;i:20704843;i:90;i:20704844;i:91;i:20704845;i:92;i:20704846;i:93;i:20704847;i:94;i:20704848;i:95;i:20704849;i:96;i:20704850;i:97;i:20704851;i:98;i:20704852;i:99;i:20704853;i:100;i:20704854;i:101;i:20704855;i:102;i:20704856;i:103;i:20704857;i:104;i:20704858;i:105;i:20727954;i:106;i:20727955;i:107;i:20727956;i:108;i:20727957;i:109;i:20727958;i:110;i:20727959;i:111;i:20727960;i:112;i:20727961;i:113;i:20727962;i:114;i:20727963;i:115;i:20727964;i:116;i:20727965;i:117;i:20727966;i:118;i:20727967;i:119;i:20727968;i:120;i:20727969;i:121;i:20727970;i:122;i:20727971;i:123;i:20727972;i:124;i:20727973;i:125;i:20727974;i:126;i:20727975;i:127;i:20727976;i:128;i:20727977;i:129;i:20727978;i:130;i:20727979;i:131;i:20727980;i:132;i:20727981;i:133;i:20727982;i:134;i:20727983;i:135;i:20727984;i:136;i:20727985;i:137;i:20727986;i:138;i:20727987;i:139;i:20727988;i:140;i:20727989;i:141;i:20727990;i:142;i:20727991;i:143;i:20727992;i:144;i:20727993;i:145;i:20727994;i:146;i:20727995;i:147;i:20943346;i:148;i:20943347;i:149;i:20943348;i:150;i:20943349;i:151;i:20943350;i:152;i:20943351;i:153;i:20943352;i:154;i:20943353;i:155;i:20943354;i:156;i:20943355;i:157;i:20943356;i:158;i:20943357;i:159;i:20943358;i:160;i:20943359;i:161;i:20943360;i:162;i:20943361;i:163;i:20943362;i:164;i:20943363;i:165;i:20943364;i:166;i:20943365;i:167;i:20943366;}"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-12"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-10-11"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(9) "999000.00"
  }
  ["rets_co_selling_agent_direct_work_pho"]=>
  array(1) {
    [0]=>
    string(14) "(808) 725-2794"
  }
  ["rets_co_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(18) "tony@alohatony.com"
  }
  ["rets_co_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(14) "Tony Kawaguchi"
  }
  ["rets_co_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "30802"
  }
  ["rets_co_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3478693"
  }
  ["rets_co_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "EXPI"
  }
  ["rets_co_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "10013908"
  }
  ["rets_co_selling_office_name"]=>
  array(1) {
    [0]=>
    string(10) "eXp Realty"
  }
  ["rets_co_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 725-2794"
  }
  ["rets_expiration_date"]=>
  array(1) {
    [0]=>
    string(10) "2022-03-31"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-10-11"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 725-2794"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(26) "lex.ferguson@exprealty.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(12) "Lex Ferguson"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "50729"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(8) "15433402"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "EXPI"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "10013908"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(10) "eXp Realty"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 725-2794"
  }
  ["rets_tax_annual_amount"]=>
  array(1) {
    [0]=>
    string(7) "3135.96"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20943346"
  }
}
Array
(
    [assd_val_imprv] => Array
        (
            [0] => 389400.00
        )

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

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

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

    [building_style] => Array
        (
            [0] => CPR,Detach Single Family,Studio Cottage
        )

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

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

    [disclosures] => Array
        (
            [0] => Property Disclosure Stmt,See Remarks
        )

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

    [elementary_school] => Array
        (
            [0] => Haleiwa
        )

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

    [frontage] => Array
        (
            [0] => Other
        )

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

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

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

    [high_school] => Array
        (
            [0] => Waialua
        )

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

    [lanai_sf] => Array
        (
            [0] => 377
        )

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

    [land_recorded] => Array
        (
            [0] => Regular System
        )

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

    [list_agent_email] => Array
        (
            [0] => dougcole@hawaii.rr.com
        )

    [list_agent_name] => Array
        (
            [0] => Doug Cole
        )

    [list_agent_phone_number] => Array
        (
            [0] => (808) 637-3507
        )

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

    [list_office_name] => Array
        (
            [0] => Team Real Estate, Inc.
        )

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

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

    [location] => Array
        (
            [0] => 62-170 B Emerson Road Unit B, Haleiwa, HI 96712
        )

    [middle_school] => Array
        (
            [0] => Waialua
        )

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

    [neighborhood] => Array
        (
            [0] => HALEIWA
        )

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

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

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

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

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

    [possession] => Array
        (
            [0] => At Closing
        )

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

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

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

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

    [region] => Array
        (
            [0] => North Shore
        )

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

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

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

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

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

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

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

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

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

    [rets_elementary_school] => Array
        (
            [0] => Haleiwa
        )

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

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

    [rets_high_school] => Array
        (
            [0] => Waialua
        )

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

    [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) 637-3507
        )

    [rets_list_agent_email] => Array
        (
            [0] => dougcole@hawaii.rr.com
        )

    [rets_list_agent_full_name] => Array
        (
            [0] => Doug Cole
        )

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

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

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

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

    [rets_list_office_name] => Array
        (
            [0] => Team Real Estate, Inc.
        )

    [rets_list_office_phone] => Array
        (
            [0] => (808) 637-3507
        )

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

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

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

    [rets_matrix_modified_dt] => Array
        (
            [0] => 2021-10-11T10:00:59.330
        )

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

    [rets_middle_or_junior_school] => Array
        (
            [0] => Waialua
        )

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

    [rets_neighbourhood] => Array
        (
            [0] => HALEIWA
        )

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

    [rets_original_entry_timestamp] => Array
        (
            [0] => 2021-09-07T19:26:14.280
        )

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

    [rets_parcel_number] => Array
        (
            [0] => 1-6-2-012-004-0002
        )

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

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

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

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

    [rets_photo_modification_timestamp] => Array
        (
            [0] => 2021-09-08T08:18:24.533
        )

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

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

    [rets_private_remarks] => Array
        (
            [0] => Vacant and easy to see.  Just call or text Doug at (808) 497-0036 to schedule a showing.  

Listing agent license recently changed from RS-62712 to RB-23551.
        )

    [rets_public_remarks] => Array
        (
            [0] => Great opportunity to purchase move in ready 3 bedroom/2 bath single family home with spacious apprx. 600 SQFT furnished studio/rec room above the large four car garage/carport in rarely available and extremely convenient location on Emerson Rd. just outside of Haleiwa Town with access from the Joseph Leong Hwy (aka bypass rd). Live in the main house and use the studio/rec room as an in-law/guest unit, home office, etc.. Enjoy the feeling of living away from the busier Haleiwa town as well as the convenience of being just a short walk/bike ride to the shops/restaurants at the Haleiwa Plantation Store Lots and Haleiwa Shopping Plaza, Haleiwa Joe's, and more. Launch your SUP/Kayak/Canoe/etc on the picturesque Anahulu Stream just a few steps from your home. Relax on the good size deck overlooking the Anahulu and new backyard while you BBQ or watch the sunset.  Lots of covered storage area for your ocean/river equipment, jet skis, kayaks, SUPs, surfboards, bikes, etc. in the carport and under the house. Currently vacant, but has great rental history with most recent rental income of $5000/mo.  Don't wait, priced to sell.
        )

    [rets_public_report_number] => Array
        (
            [0] => 7318
        )

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

    [rets_sqft_garage_carport] => Array
        (
            [0] => 759
        )

    [rets_sqft_lanai_open] => Array
        (
            [0] => 377
        )

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

    [rets_sqft_roofed_other] => Array
        (
            [0] => 600
        )

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

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

    [rets_status_change_timestamp] => Array
        (
            [0] => 2021-10-11T10:00:59.330
        )

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

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

    [rets_street_number] => Array
        (
            [0] => 62-170 B
        )

    [rets_street_view_param] => Array
        (
            [0] => 1$21.592049$-158.099671$40.33$13.33$1.00$vlNtzPtO_6WU7JHkhT2S6w
        )

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

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

    [rets_supplement_modification_timestam] => Array
        (
            [0] => 2021-09-07T16:40:18.670
        )

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

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

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

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

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

    [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/16151281/1d7bcfcb5a5f24d0f751f55854063867
        )

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

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

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

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

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

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

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

    [rets_unit_number] => Array
        (
            [0] => B
        )

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

    [rets_year_remodeled] => Array
        (
            [0] => 2001
        )

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

    [setbacks] => Array
        (
            [0] => Special
        )

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

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

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

    [street_number] => Array
        (
            [0] => 62-170 B
        )

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

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

    [tmk] => Array
        (
            [0] => 1-6-2-012-004-0002
        )

    [topography] => Array
        (
            [0] => Clear
        )

    [unit_number] => Array
        (
            [0] => B
        )

    [view] => Array
        (
            [0] => Garden,Ocean,Other,Sunset
        )

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

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

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

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

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

    [year_remodeled_] => Array
        (
            [0] => 2001
        )

    [zoning] => Array
        (
            [0] => 05 - R-5 Residential District
        )

    [new_attached_media] => Array
        (
            [0] => a:168:{i:0;i:20698264;i:1;i:20698265;i:2;i:20698266;i:3;i:20698267;i:4;i:20698268;i:5;i:20698269;i:6;i:20698270;i:7;i:20698271;i:8;i:20698272;i:9;i:20698273;i:10;i:20698274;i:11;i:20698275;i:12;i:20698276;i:13;i:20698277;i:14;i:20698278;i:15;i:20698279;i:16;i:20698280;i:17;i:20698281;i:18;i:20698282;i:19;i:20698283;i:20;i:20698284;i:21;i:20698613;i:22;i:20698614;i:23;i:20698615;i:24;i:20698616;i:25;i:20698617;i:26;i:20698618;i:27;i:20698619;i:28;i:20698620;i:29;i:20698621;i:30;i:20698622;i:31;i:20698623;i:32;i:20698624;i:33;i:20698625;i:34;i:20698626;i:35;i:20698627;i:36;i:20698628;i:37;i:20698629;i:38;i:20698630;i:39;i:20698631;i:40;i:20698632;i:41;i:20698633;i:42;i:20698653;i:43;i:20698654;i:44;i:20698655;i:45;i:20698656;i:46;i:20698657;i:47;i:20698658;i:48;i:20698659;i:49;i:20698660;i:50;i:20698661;i:51;i:20698662;i:52;i:20698663;i:53;i:20698664;i:54;i:20698665;i:55;i:20698666;i:56;i:20698667;i:57;i:20698668;i:58;i:20698669;i:59;i:20698670;i:60;i:20698671;i:61;i:20698672;i:62;i:20698673;i:63;i:20698675;i:64;i:20698676;i:65;i:20698677;i:66;i:20698678;i:67;i:20698679;i:68;i:20698680;i:69;i:20698681;i:70;i:20698682;i:71;i:20698683;i:72;i:20698684;i:73;i:20698685;i:74;i:20698686;i:75;i:20698687;i:76;i:20698688;i:77;i:20698689;i:78;i:20698690;i:79;i:20698691;i:80;i:20698692;i:81;i:20698693;i:82;i:20698694;i:83;i:20698695;i:84;i:20704838;i:85;i:20704839;i:86;i:20704840;i:87;i:20704841;i:88;i:20704842;i:89;i:20704843;i:90;i:20704844;i:91;i:20704845;i:92;i:20704846;i:93;i:20704847;i:94;i:20704848;i:95;i:20704849;i:96;i:20704850;i:97;i:20704851;i:98;i:20704852;i:99;i:20704853;i:100;i:20704854;i:101;i:20704855;i:102;i:20704856;i:103;i:20704857;i:104;i:20704858;i:105;i:20727954;i:106;i:20727955;i:107;i:20727956;i:108;i:20727957;i:109;i:20727958;i:110;i:20727959;i:111;i:20727960;i:112;i:20727961;i:113;i:20727962;i:114;i:20727963;i:115;i:20727964;i:116;i:20727965;i:117;i:20727966;i:118;i:20727967;i:119;i:20727968;i:120;i:20727969;i:121;i:20727970;i:122;i:20727971;i:123;i:20727972;i:124;i:20727973;i:125;i:20727974;i:126;i:20727975;i:127;i:20727976;i:128;i:20727977;i:129;i:20727978;i:130;i:20727979;i:131;i:20727980;i:132;i:20727981;i:133;i:20727982;i:134;i:20727983;i:135;i:20727984;i:136;i:20727985;i:137;i:20727986;i:138;i:20727987;i:139;i:20727988;i:140;i:20727989;i:141;i:20727990;i:142;i:20727991;i:143;i:20727992;i:144;i:20727993;i:145;i:20727994;i:146;i:20727995;i:147;i:20943346;i:148;i:20943347;i:149;i:20943348;i:150;i:20943349;i:151;i:20943350;i:152;i:20943351;i:153;i:20943352;i:154;i:20943353;i:155;i:20943354;i:156;i:20943355;i:157;i:20943356;i:158;i:20943357;i:159;i:20943358;i:160;i:20943359;i:161;i:20943360;i:162;i:20943361;i:163;i:20943362;i:164;i:20943363;i:165;i:20943364;i:166;i:20943365;i:167;i:20943366;}
        )

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

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

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

    [rets_co_selling_agent_direct_work_pho] => Array
        (
            [0] => (808) 725-2794
        )

    [rets_co_selling_agent_email] => Array
        (
            [0] => tony@alohatony.com
        )

    [rets_co_selling_agent_full_name] => Array
        (
            [0] => Tony Kawaguchi
        )

    [rets_co_selling_agent_mlsid] => Array
        (
            [0] => 30802
        )

    [rets_co_selling_agent_mui] => Array
        (
            [0] => 3478693
        )

    [rets_co_selling_office_mlsid] => Array
        (
            [0] => EXPI
        )

    [rets_co_selling_office_mui] => Array
        (
            [0] => 10013908
        )

    [rets_co_selling_office_name] => Array
        (
            [0] => eXp Realty
        )

    [rets_co_selling_office_phone] => Array
        (
            [0] => (808) 725-2794
        )

    [rets_expiration_date] => Array
        (
            [0] => 2022-03-31
        )

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

    [rets_selling_agent_direct_work_phone] => Array
        (
            [0] => (808) 725-2794
        )

    [rets_selling_agent_email] => Array
        (
            [0] => lex.ferguson@exprealty.com
        )

    [rets_selling_agent_full_name] => Array
        (
            [0] => Lex Ferguson
        )

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

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

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

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

    [rets_selling_office_name] => Array
        (
            [0] => eXp Realty
        )

    [rets_selling_office_phone] => Array
        (
            [0] => (808) 725-2794
        )

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

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

)

  • Bedrooms: 3
  • Full Baths: 3
  • Land Area (sf): 4,936
  • Living (sf): 1,830
  • Year Built: 1961

  • Property Condition: Above Average
  • Number of Parking Spaces: 4
  • Pool: None
  • Number of Stories: One
  • View: Garden,Ocean,Other,Sunset
  • Listing Office: Team Real Estate, Inc.

  • Land Tenure: FS - Fee Simple

  • Elementary School: Haleiwa
  • Middle School: Waialua
  • High School: Waialua

CONTACT US

Marcus Realty

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