68-078 Au Street Unit 203
Waialua, HI 96791

Listing
Overview

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

Puuiki Beach in Waialua is close to historic Haleiwa and near iconic Aweoweo Beach/ Park (basketball, playground, BBQ). This is a lovely and serene community located on Oahu’s North shore. This hidden paradise is an affordable investment or second home option with this unheard of LOW monthly fee, currently $125 per month. This building is solid yet simple and is low maintenance ( 1 parking stall and community laundry). If you have been looking for an affordable option in today’s desirable market, look no further. The interior of this 1 bed/1 bath unit features ceramic tile throughout and remodeled (open concept) kitchen complete with granite countertops and eat in bar. Don’t miss this opportunity to own in this wonderful beach community (beach access). Unit faces east to enjoy cool trades.

  • Bedrooms: 1
  • Full Baths: 1
  • Land Area (sf): 11,543
  • Living (sf): 381
  • Year Built: 1974

  • Property Condition: Above Average
  • Number of Parking Spaces: 1
  • Number of Stories: One
  • View: None
  • Listing Office: Keller Williams Honolulu

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

CONTACT US

Marcus Realty

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

array(163) {
  ["address_is_formatted"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "138800.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(8) "83700.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "222500.00"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["building_name"]=>
  array(1) {
    [0]=>
    string(17) "Puuiki Beach Apts"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(7) "Walk-Up"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(24) "Property Disclosure Stmt"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(12) "Ceramic Tile"
  }
  ["formatted_address"]=>
  array(1) {
    [0]=>
    string(35) "68-78 Au St, Waialua, HI 96791, USA"
  }
  ["formatted_address_simple"]=>
  array(1) {
    [0]=>
    string(24) "68-78 Au St, Waialua, HI"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["furnished"]=>
  array(1) {
    [0]=>
    string(7) "Partial"
  }
  ["google_place_id"]=>
  array(1) {
    [0]=>
    string(27) "ChIJR0CG3VlfAHwR2ueYLVHfPEU"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(8) "11543.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(20) "erin@erin-cooper.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(11) "Erin Cooper"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 439-8250"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2020-10-16"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(24) "Keller Williams Honolulu"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "259000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(3) "381"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(44) "68-078 Au Street Unit 203, Waialua, HI 96791"
  }
  ["maintenance_fees"]=>
  array(1) {
    [0]=>
    string(6) "125.00"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202027313"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIALUA"
  }
  ["number_of_parking_spaces"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["number_of_stories"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(6) "KWPP04"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(15) "Assigned,Street"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(26) "45 Days or More,Negotiable"
  }
  ["property_condition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["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_total"]=>
  array(1) {
    [0]=>
    string(3) "125"
  }
  ["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) "1"
  }
  ["rets_building_name"]=>
  array(1) {
    [0]=>
    string(17) "Puuiki Beach Apts"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["rets_condo_parking_unit"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(9) "247500.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(2) "84"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_floor_number"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["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) "15497064"
  }
  ["rets_immoviewer_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 439-8250"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(20) "erin@erin-cooper.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(11) "Erin Cooper"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "26038"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "8843317"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(6) "KWPP04"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "10703481"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(24) "Keller Williams Honolulu"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 439-8250"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(9) "259000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2020-10-16"
  }
  ["rets_lock_box_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(8) "11543.00"
  }
  ["rets_maintenance_expense"]=>
  array(1) {
    [0]=>
    string(6) "125.00"
  }
  ["rets_management_company_name"]=>
  array(1) {
    [0]=>
    string(4) "SELF"
  }
  ["rets_management_company_phone"]=>
  array(1) {
    [0]=>
    string(8) "637-6186"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-04-26T11:48:51.350"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "15497064"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202027313"
  }
  ["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) "2020-10-16T15:44:02.617"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(9) "259000.00"
  }
  ["rets_owner_occupancy_percentage"]=>
  array(1) {
    [0]=>
    string(2) "25"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-6-8-011-057-0007"
  }
  ["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(1) "8"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2020-10-16T15:44:02.617"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96791"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2020-10-16T15:44:02.617"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "15497064"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(400) "Tenant occupied (lease expires end of November), 48 hr notice. Please schedule via showing time. Showings available Tuesdays and weekends only please. Strict covid procedures apply. Please consider Fidelity  (Kailua) Jasmine Bishaw. Photos were taken prior to tenant occupancy. Building is self managed (limited condo docs) may require portfolio lending. Check w buyers lender prior to showing please"
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(800) "Puuiki Beach in Waialua is close to historic Haleiwa and near iconic Aweoweo Beach/ Park (basketball, playground, BBQ). This is a lovely and serene community located on Oahu's North shore. This hidden paradise is an affordable investment or second home option with this unheard of LOW monthly fee, currently $125 per month. This building is solid yet simple and is low maintenance ( 1 parking stall and community laundry). If you have been looking for an affordable option in today's desirable market, look no further. The interior of this 1 bed/1 bath unit features ceramic tile throughout and remodeled (open concept) kitchen complete with granite countertops and eat in bar. Don't miss this opportunity to own in this wonderful beach community (beach access). Unit faces east to enjoy cool trades."
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(3) "381"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(3) "381"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-04-26T11:48:51.350"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-04-22"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(2) "Au"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(6) "68-078"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(63) "1$21.582448$-158.136976$11.99$13.33$1.00$sczP_g8n4Kw0kxsl-OKGJA"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(3) "2.5"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(5) "65.00"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "222500.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "138800.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(8) "83700.00"
  }
  ["rets_tax_excemption_owner_occupancy"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["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/15497064/92523a798004fdd49c50cd7e9005bd12"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "168"
  }
  ["rets_tmk_condo_property_regime_number"]=>
  array(1) {
    [0]=>
    string(1) "7"
  }
  ["rets_tmk_division"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tmk_parcel"]=>
  array(1) {
    [0]=>
    string(2) "57"
  }
  ["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) "203"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1974"
  }
  ["security"]=>
  array(1) {
    [0]=>
    string(3) "Key"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(17) "Cash,Conventional"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-6-8-011-057-0007"
  }
  ["unit"]=>
  array(1) {
    [0]=>
    string(20) "Bedroom on 1st Level"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "15497064"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202027313"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1628990819"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1974"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(30) "11 - A-1 Low Density Apartment"
  }
  ["latitude"]=>
  array(1) {
    [0]=>
    string(8) "21.58168"
  }
  ["longitude"]=>
  array(1) {
    [0]=>
    string(11) "-158.138687"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(1149) "a:72:{i:0;i:16831654;i:1;i:16831655;i:2;i:16831656;i:3;i:16831657;i:4;i:16831658;i:5;i:16831659;i:6;i:16831660;i:7;i:16831661;i:8;i:16846157;i:9;i:16846158;i:10;i:16846159;i:11;i:16846160;i:12;i:16846161;i:13;i:16846162;i:14;i:16846163;i:15;i:16846164;i:16;i:16888271;i:17;i:16888272;i:18;i:16888273;i:19;i:16888274;i:20;i:16888275;i:21;i:16888276;i:22;i:16888277;i:23;i:16888278;i:24;i:16903220;i:25;i:16903221;i:26;i:16903222;i:27;i:16903223;i:28;i:16903224;i:29;i:16903225;i:30;i:16903226;i:31;i:16903227;i:32;i:17326889;i:33;i:17326890;i:34;i:17326891;i:35;i:17326892;i:36;i:17326893;i:37;i:17326894;i:38;i:17326895;i:39;i:17326896;i:40;i:17559974;i:41;i:17559975;i:42;i:17559976;i:43;i:17559977;i:44;i:17559978;i:45;i:17559979;i:46;i:17559980;i:47;i:17559981;i:48;i:19874210;i:49;i:19874211;i:50;i:19874212;i:51;i:19874213;i:52;i:19874214;i:53;i:19874215;i:54;i:19874216;i:55;i:19874217;i:56;i:20145482;i:57;i:20145483;i:58;i:20145484;i:59;i:20145485;i:60;i:20145486;i:61;i:20145487;i:62;i:20145488;i:63;i:20145489;i:64;i:20388428;i:65;i:20388429;i:66;i:20388430;i:67;i:20388431;i:68;i:20388432;i:69;i:20388433;i:70;i:20388434;i:71;i:20388435;}"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-01-05"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-04-22"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(9) "247500.00"
  }
  ["rets_co_selling_agent_direct_work_pho"]=>
  array(1) {
    [0]=>
    string(14) "(808) 825-4277"
  }
  ["rets_co_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(24) "jared.musser@compass.com"
  }
  ["rets_co_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(14) "Jared O Musser"
  }
  ["rets_co_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "51010"
  }
  ["rets_co_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(8) "15668617"
  }
  ["rets_co_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "COHI"
  }
  ["rets_co_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "15465233"
  }
  ["rets_co_selling_office_name"]=>
  array(1) {
    [0]=>
    string(7) "Compass"
  }
  ["rets_co_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 825-4277"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-04-22"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 825-4277"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(23) "jason.carey@compass.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(13) "Jason M Carey"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "45105"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "9512016"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "COHI"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "15465233"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(7) "Compass"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 825-4277"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96791"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(2) "Au"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(6) "68-078"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["unit_number"]=>
  array(1) {
    [0]=>
    string(3) "203"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20388428"
  }
}