Enjoy beach living in this fabulous and newly remodeled, kitchen, bathroom, corner end ground floor unit condominium on the beautiful North Shore of Oahu! With your own large outdoor grass yard and platform wood deck to entertain guest, along with tons of storage. This beautiful 2-bedroom, 1 bathroom unit, in a pet friendly bldg. with 1 dedicated parking stall. Stay cool with a split AC unit on those hot summer days. Incredible location for an ultra-convenient beach lifestyle, near bike path and steps to a beautiful white sandy beach. Close to Schofield Barracks. Just minutes to Historic Haleiwa Town. Live the island lifestyle & play in Hawaii!
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446
array(157) { ["assd_val_imprv"]=> array(1) { [0]=> string(9) "186000.00" } ["assd_val_land"]=> array(1) { [0]=> string(8) "98200.00" } ["assd_val_total"]=> array(1) { [0]=> string(9) "284200.00" } ["bedrooms"]=> array(1) { [0]=> string(1) "2" } ["building_name"]=> array(1) { [0]=> string(15) "Mokuleia Shores" } ["building_style"]=> array(1) { [0]=> string(26) "Low-Rise 6 or Less Stories" } ["county"]=> array(1) { [0]=> string(4) "Oahu" } ["disclosures"]=> array(1) { [0]=> string(4) "None" } ["elementary_school"]=> array(1) { [0]=> string(7) "Waialua" } ["floor_covering"]=> array(1) { [0]=> string(12) "Ceramic Tile" } ["full_baths"]=> array(1) { [0]=> string(1) "1" } ["furnished"]=> array(1) { [0]=> string(10) "Negotiable" } ["half_baths"]=> array(1) { [0]=> string(1) "0" } ["high_school"]=> array(1) { [0]=> string(7) "Waialua" } ["home_exampt"]=> array(1) { [0]=> string(6) "100000" } ["lanai_sf"]=> array(1) { [0]=> string(3) "300" } ["land_area_sf"]=> array(1) { [0]=> string(8) "14636.00" } ["land_recorded"]=> array(1) { [0]=> string(14) "Regular System" } ["land_tenure"]=> array(1) { [0]=> string(15) "FS - Fee Simple" } ["list_agent_email"]=> array(1) { [0]=> string(25) "MattyLiu.Hawaii@gmail.com" } ["list_agent_name"]=> array(1) { [0]=> string(9) "Matty Liu" } ["list_agent_phone_number"]=> array(1) { [0]=> string(14) "(808) 596-0456" } ["list_date"]=> array(1) { [0]=> string(10) "2021-04-01" } ["list_office_name"]=> array(1) { [0]=> string(22) "Coldwell Banker Realty" } ["list_price"]=> array(1) { [0]=> string(9) "410000.00" } ["living_sf"]=> array(1) { [0]=> string(3) "999" } ["location"]=> array(1) { [0]=> string(53) "68-041 Waialua Beach Road Unit 104, Waialua, HI 96791" } ["maintenance_fees"]=> array(1) { [0]=> string(6) "651.00" } ["middle_school"]=> array(1) { [0]=> string(7) "Waialua" } ["mls_"]=> array(1) { [0]=> string(9) "202107634" } ["neighborhood"]=> array(1) { [0]=> string(7) "WAIALUA" } ["number_of_parking_spaces"]=> array(1) { [0]=> string(1) "1" } ["office_mls_id"]=> array(1) { [0]=> string(4) "CBPP" } ["parking_features"]=> array(1) { [0]=> string(8) "Assigned" } ["possession"]=> array(1) { [0]=> string(15) "45 Days or Less" } ["property_condition"]=> array(1) { [0]=> string(9) "Excellent" } ["property_type"]=> array(1) { [0]=> string(15) "condo_townhouse" } ["property_type_label"]=> array(1) { [0]=> string(15) "Condo Townhouse" } ["region"]=> array(1) { [0]=> string(11) "North Shore" } ["rets_association_fee_2"]=> array(1) { [0]=> string(3) "227" } ["rets_association_fee_total"]=> array(1) { [0]=> string(3) "878" } ["rets_baths_full"]=> array(1) { [0]=> string(1) "1" } ["rets_baths_half"]=> array(1) { [0]=> string(1) "0" } ["rets_baths_total"]=> array(1) { [0]=> string(4) "1.00" } ["rets_beds_total"]=> array(1) { [0]=> string(1) "2" } ["rets_building_name"]=> array(1) { [0]=> string(15) "Mokuleia Shores" } ["rets_city"]=> array(1) { [0]=> string(7) "Waialua" } ["rets_condo_parking_unit"]=> array(1) { [0]=> string(3) "104" } ["rets_current_price"]=> array(1) { [0]=> string(9) "410000.00" } ["rets_dom"]=> array(1) { [0]=> string(1) "7" } ["rets_dual_variable_compensation_yn"]=> array(1) { [0]=> string(1) "0" } ["rets_elementary_school"]=> array(1) { [0]=> string(7) "Waialua" } ["rets_floor_number"]=> 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_high_school"]=> array(1) { [0]=> string(7) "Waialua" } ["rets_id"]=> array(1) { [0]=> string(8) "15796508" } ["rets_immoviewer_yn"]=> array(1) { [0]=> string(1) "0" } ["rets_list_agent_direct_work_phone"]=> array(1) { [0]=> string(14) "(808) 596-0456" } ["rets_list_agent_email"]=> array(1) { [0]=> string(25) "MattyLiu.Hawaii@gmail.com" } ["rets_list_agent_full_name"]=> array(1) { [0]=> string(9) "Matty Liu" } ["rets_list_agent_mlsid"]=> array(1) { [0]=> string(5) "44317" } ["rets_list_agent_mui"]=> array(1) { [0]=> string(7) "9030516" } ["rets_list_office_mlsid"]=> array(1) { [0]=> string(4) "CBPP" } ["rets_list_office_mui"]=> array(1) { [0]=> string(7) "3485212" } ["rets_list_office_name"]=> array(1) { [0]=> string(22) "Coldwell Banker Realty" } ["rets_list_office_phone"]=> array(1) { [0]=> string(14) "(808) 596-0456" } ["rets_list_price"]=> array(1) { [0]=> string(9) "410000.00" } ["rets_listing_contract_date"]=> array(1) { [0]=> string(10) "2021-04-01" } ["rets_lot_size_area"]=> array(1) { [0]=> string(8) "14636.00" } ["rets_maintenance_expense"]=> array(1) { [0]=> string(6) "651.00" } ["rets_management_company_name"]=> array(1) { [0]=> string(7) "Associa" } ["rets_management_company_phone"]=> array(1) { [0]=> string(12) "808-836-0911" } ["rets_matrix_modified_dt"]=> array(1) { [0]=> string(23) "2021-05-20T15:00:11.400" } ["rets_matrix_unique_id"]=> array(1) { [0]=> string(8) "15796508" } ["rets_middle_or_junior_school"]=> array(1) { [0]=> string(7) "Waialua" } ["rets_mls_number"]=> array(1) { [0]=> string(9) "202107634" } ["rets_neighbourhood"]=> array(1) { [0]=> string(7) "WAIALUA" } ["rets_new_development_construction_yn"]=> array(1) { [0]=> string(1) "0" } ["rets_original_entry_timestamp"]=> array(1) { [0]=> string(23) "2021-04-01T10:06:23.983" } ["rets_original_list_price"]=> array(1) { [0]=> string(9) "410000.00" } ["rets_owner_occupancy_percentage"]=> array(1) { [0]=> string(1) "8" } ["rets_parcel_number"]=> array(1) { [0]=> string(18) "1-6-8-011-001-0004" } ["rets_parking_additional"]=> array(1) { [0]=> string(1) "0" } ["rets_parking_total"]=> array(1) { [0]=> string(1) "1" } ["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-01T14:41:29.307" } ["rets_postal_code"]=> array(1) { [0]=> string(5) "96791" } ["rets_price_change_timestamp"]=> array(1) { [0]=> string(23) "2021-04-01T10:06:23.983" } ["rets_primary_key"]=> array(1) { [0]=> string(8) "15796508" } ["rets_private_remarks"]=> array(1) { [0]=> string(193) "For all showings please use "Showing Time" or call/text listing agent Matty Liu at 808-778-2373. Seller prefers to use TG at Mililani office with Briar Nakamoto. Lockbox on front door Apt #104." } ["rets_public_remarks"]=> array(1) { [0]=> string(652) "Enjoy beach living in this fabulous and newly remodeled, kitchen, bathroom, corner end ground floor unit condominium on the beautiful North Shore of Oahu! With your own large outdoor grass yard and platform wood deck to entertain guest, along with tons of storage. This beautiful 2-bedroom, 1 bathroom unit, in a pet friendly bldg. with 1 dedicated parking stall. Stay cool with a split AC unit on those hot summer days. Incredible location for an ultra-convenient beach lifestyle, near bike path and steps to a beautiful white sandy beach. Close to Schofield Barracks. Just minutes to Historic Haleiwa Town. Live the island lifestyle & play in Hawaii!" } ["rets_sqft_lanai_open"]=> array(1) { [0]=> string(3) "300" } ["rets_sqft_roofed_living"]=> array(1) { [0]=> string(3) "699" } ["rets_sqft_total"]=> array(1) { [0]=> string(3) "999" } ["rets_state_or_province"]=> array(1) { [0]=> string(2) "HI" } ["rets_status_change_timestamp"]=> array(1) { [0]=> string(23) "2021-05-20T15:00:11.400" } ["rets_status_contractual_search_date"]=> array(1) { [0]=> string(10) "2021-05-20" } ["rets_street_name"]=> array(1) { [0]=> string(13) "Waialua Beach" } ["rets_street_number"]=> array(1) { [0]=> string(6) "68-041" } ["rets_street_view_param"]=> array(1) { [0]=> string(64) "1$21.581663$-158.137949$218.27$13.33$1.00$b9pDVfan9gTjxyEz3nBm8A" } ["rets_sub_agency_compensation"]=> array(1) { [0]=> string(1) "3" } ["rets_tax_amount"]=> array(1) { [0]=> string(5) "53.75" } ["rets_tax_assessed_value"]=> array(1) { [0]=> string(9) "284200.00" } ["rets_tax_assessed_value_improvements"]=> array(1) { [0]=> string(9) "186000.00" } ["rets_tax_assessed_value_land"]=> array(1) { [0]=> string(8) "98200.00" } ["rets_tax_excemption_owner_occupancy"]=> array(1) { [0]=> string(6) "100000" } ["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/15796508/185464f98544eee4cd86826a3cb01506" } ["rets_tmk_area"]=> array(1) { [0]=> string(3) "168" } ["rets_tmk_condo_property_regime_number"]=> array(1) { [0]=> string(1) "4" } ["rets_tmk_division"]=> array(1) { [0]=> string(1) "1" } ["rets_tmk_parcel"]=> array(1) { [0]=> string(1) "1" } ["rets_tmk_section"]=> array(1) { [0]=> string(1) "8" } ["rets_tmk_zone"]=> array(1) { [0]=> string(1) "6" } ["rets_tmkplat"]=> array(1) { [0]=> string(2) "11" } ["rets_unit_number"]=> array(1) { [0]=> string(3) "104" } ["rets_year_built"]=> array(1) { [0]=> string(4) "1975" } ["rets_year_remodeled"]=> array(1) { [0]=> string(4) "2021" } ["security"]=> array(1) { [0]=> string(5) "Video" } ["status"]=> array(1) { [0]=> string(4) "Sold" } ["terms_accept"]=> array(1) { [0]=> string(35) "Cash,Conventional,USDA Financing,VA" } ["tmk"]=> array(1) { [0]=> string(18) "1-6-8-011-001-0004" } ["unit"]=> array(1) { [0]=> string(64) "Corner/End,Full Bath on 1st Floor,Ground Floor Unit,Storage,Yard" } ["view"]=> array(1) { [0]=> string(14) "Garden,Sunrise" } ["wpp::rets_pk"]=> array(1) { [0]=> string(8) "15796508" } ["wpp_gpid"]=> array(1) { [0]=> string(9) "202107634" } ["wpp_import_schedule_id"]=> array(1) { [0]=> string(10) "1463343682" } ["wpp_import_time"]=> array(1) { [0]=> string(10) "1628925419" } ["year_built"]=> array(1) { [0]=> string(4) "1975" } ["year_remodeled_"]=> array(1) { [0]=> string(4) "2021" } ["zoning"]=> array(1) { [0]=> string(30) "11 - A-1 Low Density Apartment" } ["new_attached_media"]=> array(1) { [0]=> string(2040) "a:126:{i:0;i:19709594;i:1;i:19709595;i:2;i:19709596;i:3;i:19709597;i:4;i:19709598;i:5;i:19709599;i:6;i:19709600;i:7;i:19709601;i:8;i:19709602;i:9;i:19709603;i:10;i:19709604;i:11;i:19709605;i:12;i:19709606;i:13;i:19709607;i:14;i:19709608;i:15;i:19709609;i:16;i:19709610;i:17;i:19709611;i:18;i:19709612;i:19;i:19709613;i:20;i:19709614;i:21;i:19712340;i:22;i:19712341;i:23;i:19712342;i:24;i:19712343;i:25;i:19712344;i:26;i:19712345;i:27;i:19712346;i:28;i:19712347;i:29;i:19712348;i:30;i:19712349;i:31;i:19712350;i:32;i:19712351;i:33;i:19712352;i:34;i:19712353;i:35;i:19712354;i:36;i:19712355;i:37;i:19712356;i:38;i:19712357;i:39;i:19712358;i:40;i:19712359;i:41;i:19712360;i:42;i:19712361;i:43;i:19712362;i:44;i:19712363;i:45;i:19712364;i:46;i:19712365;i:47;i:19712366;i:48;i:19712367;i:49;i:19712368;i:50;i:19712369;i:51;i:19712370;i:52;i:19712371;i:53;i:19712372;i:54;i:19712373;i:55;i:19712374;i:56;i:19712375;i:57;i:19712376;i:58;i:19712377;i:59;i:19712378;i:60;i:19712379;i:61;i:19712380;i:62;i:19712381;i:63;i:19754141;i:64;i:19754142;i:65;i:19754143;i:66;i:19754144;i:67;i:19754145;i:68;i:19754146;i:69;i:19754147;i:70;i:19754148;i:71;i:19754149;i:72;i:19754150;i:73;i:19754151;i:74;i:19754152;i:75;i:19754153;i:76;i:19754154;i:77;i:19754155;i:78;i:19754156;i:79;i:19754157;i:80;i:19754158;i:81;i:19754159;i:82;i:19754160;i:83;i:19754161;i:84;i:20056245;i:85;i:20056246;i:86;i:20056247;i:87;i:20056248;i:88;i:20056249;i:89;i:20056250;i:90;i:20056251;i:91;i:20056252;i:92;i:20056253;i:93;i:20056254;i:94;i:20056255;i:95;i:20056256;i:96;i:20056257;i:97;i:20056258;i:98;i:20056259;i:99;i:20056260;i:100;i:20056261;i:101;i:20056262;i:102;i:20056263;i:103;i:20056264;i:104;i:20056265;i:105;i:20304604;i:106;i:20304605;i:107;i:20304606;i:108;i:20304607;i:109;i:20304608;i:110;i:20304609;i:111;i:20304610;i:112;i:20304611;i:113;i:20304612;i:114;i:20304613;i:115;i:20304614;i:116;i:20304615;i:117;i:20304616;i:118;i:20304617;i:119;i:20304618;i:120;i:20304619;i:121;i:20304620;i:122;i:20304621;i:123;i:20304622;i:124;i:20304623;i:125;i:20304624;}" } ["rets_active_continue_to_show_date"]=> array(1) { [0]=> string(10) "2021-04-07" } ["city"]=> array(1) { [0]=> string(7) "Waialua" } ["postal_code"]=> array(1) { [0]=> string(5) "96791" } ["rets_close_date"]=> array(1) { [0]=> string(10) "2021-05-20" } ["rets_close_price"]=> array(1) { [0]=> string(9) "410000.00" } ["rets_off_market_date"]=> array(1) { [0]=> string(10) "2021-05-20" } ["rets_selling_agent_direct_work_phone"]=> array(1) { [0]=> string(14) "(808) 738-3600" } ["rets_selling_agent_email"]=> array(1) { [0]=> string(25) "hokuleaA@betterhawaii.com" } ["rets_selling_agent_full_name"]=> array(1) { [0]=> string(16) "Hokule'a Atoigue" } ["rets_selling_agent_mlsid"]=> array(1) { [0]=> string(5) "50104" } ["rets_selling_agent_mui"]=> array(1) { [0]=> string(8) "14926338" } ["rets_selling_office_mlsid"]=> array(1) { [0]=> string(4) "ADVG" } ["rets_selling_office_mui"]=> array(1) { [0]=> string(7) "9695164" } ["rets_selling_office_name"]=> array(1) { [0]=> string(22) "BHGRE Advantage Realty" } ["rets_selling_office_phone"]=> array(1) { [0]=> string(14) "(808) 738-3600" } ["state_or_province"]=> array(1) { [0]=> string(2) "HI" } ["street_name"]=> array(1) { [0]=> string(13) "Waialua Beach" } ["street_number"]=> array(1) { [0]=> string(6) "68-041" } ["street_suffix"]=> array(1) { [0]=> string(4) "Road" } ["unit_number"]=> array(1) { [0]=> string(3) "104" } ["_thumbnail_id"]=> array(1) { [0]=> string(8) "20304604" } }