68-041 Waialua Beach Road Unit 104
Waialua, HI 96791

Listing
Overview

Price: $410,000
Area: WAIALUA
Status: Sold

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!

  • Bedrooms: 2
  • Full Baths: 1
  • Land Area (sf): 14,636
  • Living (sf): 999
  • Year Built: 1975
  • Building Name: Mokuleia Shores

  • Property Condition: Excellent
  • Number of Parking Spaces: 1
  • View: Garden,Sunrise
  • Listing Office: Coldwell Banker Realty

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

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

CONTACT US

Marcus Realty

#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"
  }
}