Completely renovated top to bottom! Washer and dryer in-unit, dryer vents to exterior, private fenced yard, covered lanai, new windows and sliding glass doors w/ embedded blinds, ceiling fans w/ remotes, recessed lighting, solid wood cabinets, monkey pod wood, and stone countertops, all new vinyl plank flooring throughout, tiled walk-in shower, new sinks, faucets, toilet, and vanity. Bedroom with sliding glass door opens to private, fenced yard. One block to public beach access. Two block to Aweoweo Beach Park featuring showers/bathrooms/basketball court/playground w/ swings. Enjoy snorkeling with turtles or surfing your favorite break. Concrete and stucco construction, resistant to termites. New drywall finished interior, fresh paint, no popcorn ceilings! Pet friendly building with no weight limits (one dog and one cat allowed).
Listing by: Seaside Realty LLC
array(171) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "280000.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(8) "65000.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "345000.00"
}
["assn_fee_inclusions"]=>
array(1) {
[0]=>
string(1) "0"
}
["association_fees"]=>
array(1) {
[0]=>
string(1) "0"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "1"
}
["building_name"]=>
array(1) {
[0]=>
string(9) "Ono Vista"
}
["building_style"]=>
array(1) {
[0]=>
string(26) "Low-Rise 6 or Less Stories"
}
["city"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(74) "Licensed Owner,Listor Owner,Pets Allowed (Verify),Property Disclosure Stmt"
}
["elementary_school"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["exclusions"]=>
array(1) {
[0]=>
string(5) "Other"
}
["floor_covering"]=>
array(1) {
[0]=>
string(5) "Vinyl"
}
["frontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "1"
}
["furnished"]=>
array(1) {
[0]=>
string(4) "None"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["high_school"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["home_exampt"]=>
array(1) {
[0]=>
string(6) "140000"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(3) "250"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(8) "51662.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(23) "ericainhawaii@gmail.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(16) "Erica J Lehmkuhl"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 723-0953"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-06-08"
}
["list_office_name"]=>
array(1) {
[0]=>
string(18) "Seaside Realty LLC"
}
["list_price"]=>
array(1) {
[0]=>
string(9) "399999.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(3) "836"
}
["location"]=>
array(1) {
[0]=>
string(45) "68-090 Au Street Unit 103E, Waialua, HI 96791"
}
["maintenance_fees"]=>
array(1) {
[0]=>
string(6) "815.00"
}
["middle_school"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202210713"
}
["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(4) "SSRE"
}
["parking_features"]=>
array(1) {
[0]=>
string(15) "Open - 1,Street"
}
["possession"]=>
array(1) {
[0]=>
string(21) "At Closing,Negotiable"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96791"
}
["property_condition"]=>
array(1) {
[0]=>
string(23) "Above Average,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_active_open_house_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_association_fee"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_association_fee_total"]=>
array(1) {
[0]=>
string(3) "815"
}
["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(9) "Ono Vista"
}
["rets_city"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["rets_condo_parking_unit"]=>
array(1) {
[0]=>
string(3) "#23"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(9) "399999.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) "Waialua"
}
["rets_elevators_number_of"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_floor_number"]=>
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_high_school"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["rets_id"]=>
array(1) {
[0]=>
string(8) "16686342"
}
["rets_immoviewer_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_internet_automated_valuation_dis"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_internet_consumer_comment_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 723-0953"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(23) "ericainhawaii@gmail.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(16) "Erica J Lehmkuhl"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "47564"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(8) "11074635"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "SSRE"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(8) "16118386"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(18) "Seaside Realty LLC"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 723-0953"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(9) "399999.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-06-08"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(8) "51662.00"
}
["rets_maintenance_expense"]=>
array(1) {
[0]=>
string(6) "815.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) "2022-07-07T11:12:23.827"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16686342"
}
["rets_middle_or_junior_school"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202210713"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_open_house_count"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_open_house_upcoming"]=>
array(1) {
[0]=>
string(0) ""
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-04T14:33:24.657"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(9) "399999.00"
}
["rets_owner_occupancy_percentage"]=>
array(1) {
[0]=>
string(2) "61"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-6-8-011-058-0003"
}
["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) "2022-06-07T21:37:32.633"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96791"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-04T14:33:24.657"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16686342"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(271) "PLEASE SEND OFFERS TO SeasideOffers@gmail.com ; Vacant and easy to show! Please ShowingTime for showing requests. Please consider Kalia Goulette at Fidelity National Title, 808-724-0466, kalia.goulette@fnf.com for escrow. Please send all offers to SeasideOffers@gmail.com"
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(841) "Completely renovated top to bottom! Washer and dryer in-unit, dryer vents to exterior, private fenced yard, covered lanai, new windows and sliding glass doors w/ embedded blinds, ceiling fans w/ remotes, recessed lighting, solid wood cabinets, monkey pod wood, and stone countertops, all new vinyl plank flooring throughout, tiled walk-in shower, new sinks, faucets, toilet, and vanity. Bedroom with sliding glass door opens to private, fenced yard. One block to public beach access. Two block to Aweoweo Beach Park featuring showers/bathrooms/basketball court/playground w/ swings. Enjoy snorkeling with turtles or surfing your favorite break. Concrete and stucco construction, resistant to termites. New drywall finished interior, fresh paint, no popcorn ceilings! Pet friendly building with no weight limits (one dog and one cat allowed)."
}
["rets_sqft_garage_carport"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(3) "250"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(3) "586"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(3) "836"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-07-07T11:12:23.827"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-07-07"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(2) "Au"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(6) "68-090"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(64) "1$21.582712$-158.136754$356.48$13.33$1.00$HliFX6Y68Ub_gDR2j01p3A"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(2) "3%"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(5) "55.00"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(6) "660.00"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "345000.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "280000.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(8) "65000.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(6) "140000"
}
["rets_tax_paid_by_seller_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tax_year"]=>
array(1) {
[0]=>
string(4) "2020"
}
["rets_thumbnail_url"]=>
array(1) {
[0]=>
string(81) "https://cdn.rets.ci/marcusrealty-images/16686342/c54e23096154462d6392c24b34fc9e3a"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "168"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(1) "3"
}
["rets_tmk_division"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tmk_parcel"]=>
array(1) {
[0]=>
string(2) "58"
}
["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(4) "103E"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1975"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(4) "2022"
}
["security"]=>
array(1) {
[0]=>
string(3) "Key"
}
["state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["street_name"]=>
array(1) {
[0]=>
string(2) "Au"
}
["street_number"]=>
array(1) {
[0]=>
string(6) "68-090"
}
["street_suffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["terms_accept"]=>
array(1) {
[0]=>
string(39) "Cash,Conventional,FHA,USDA Financing,VA"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-6-8-011-058-0003"
}
["unit"]=>
array(1) {
[0]=>
string(89) "Bedroom on 1st Level,Full Bath on 1st Floor,Ground Floor Unit,Odd# Unit,Single Level,Yard"
}
["unit_number"]=>
array(1) {
[0]=>
string(4) "103E"
}
["view"]=>
array(1) {
[0]=>
string(15) "Garden,Mountain"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16686342"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202210713"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1657228407"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1975"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "2022"
}
["zoning"]=>
array(1) {
[0]=>
string(30) "11 - A-1 Low Density Apartment"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(1341) "a:84:{i:0;i:22387000;i:1;i:22387001;i:2;i:22387002;i:3;i:22387003;i:4;i:22387004;i:5;i:22387005;i:6;i:22387006;i:7;i:22387007;i:8;i:22387008;i:9;i:22387009;i:10;i:22387010;i:11;i:22387011;i:12;i:22387012;i:13;i:22387013;i:14;i:22387014;i:15;i:22387015;i:16;i:22387016;i:17;i:22387017;i:18;i:22387018;i:19;i:22387019;i:20;i:22387020;i:21;i:22400083;i:22;i:22400084;i:23;i:22400085;i:24;i:22400086;i:25;i:22400087;i:26;i:22400088;i:27;i:22400089;i:28;i:22400090;i:29;i:22400091;i:30;i:22400092;i:31;i:22400093;i:32;i:22400094;i:33;i:22400095;i:34;i:22400096;i:35;i:22400097;i:36;i:22400098;i:37;i:22400099;i:38;i:22400100;i:39;i:22400101;i:40;i:22400102;i:41;i:22400103;i:42;i:22427055;i:43;i:22427056;i:44;i:22427057;i:45;i:22427058;i:46;i:22427059;i:47;i:22427060;i:48;i:22427061;i:49;i:22427062;i:50;i:22427063;i:51;i:22427064;i:52;i:22427065;i:53;i:22427066;i:54;i:22427067;i:55;i:22427068;i:56;i:22427069;i:57;i:22427070;i:58;i:22427071;i:59;i:22427072;i:60;i:22427073;i:61;i:22427074;i:62;i:22427075;i:63;i:22652105;i:64;i:22652106;i:65;i:22652107;i:66;i:22652108;i:67;i:22652109;i:68;i:22652110;i:69;i:22652111;i:70;i:22652112;i:71;i:22652113;i:72;i:22652114;i:73;i:22652115;i:74;i:22652116;i:75;i:22652117;i:76;i:22652118;i:77;i:22652119;i:78;i:22652120;i:79;i:22652121;i:80;i:22652122;i:81;i:22652123;i:82;i:22652124;i:83;i:22652125;}"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-06-13"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-07-07"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(9) "399999.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-10-28"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-07-07"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 723-0953"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(23) "ericainhawaii@gmail.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(16) "Erica J Lehmkuhl"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "47564"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(8) "11074635"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "SSRE"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(8) "16118386"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(18) "Seaside Realty LLC"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 723-0953"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "22652105"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 280000.00
)
[assd_val_land] => Array
(
[0] => 65000.00
)
[assd_val_total] => Array
(
[0] => 345000.00
)
[assn_fee_inclusions] => Array
(
[0] => 0
)
[association_fees] => Array
(
[0] => 0
)
[bedrooms] => Array
(
[0] => 1
)
[building_name] => Array
(
[0] => Ono Vista
)
[building_style] => Array
(
[0] => Low-Rise 6 or Less Stories
)
[city] => Array
(
[0] => Waialua
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Licensed Owner,Listor Owner,Pets Allowed (Verify),Property Disclosure Stmt
)
[elementary_school] => Array
(
[0] => Waialua
)
[exclusions] => Array
(
[0] => Other
)
[floor_covering] => Array
(
[0] => Vinyl
)
[frontage] => Array
(
[0] => Other
)
[full_baths] => Array
(
[0] => 1
)
[furnished] => Array
(
[0] => None
)
[half_baths] => Array
(
[0] => 0
)
[high_school] => Array
(
[0] => Waialua
)
[home_exampt] => Array
(
[0] => 140000
)
[lanai_sf] => Array
(
[0] => 250
)
[land_area_sf] => Array
(
[0] => 51662.00
)
[land_recorded] => Array
(
[0] => Regular System
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => ericainhawaii@gmail.com
)
[list_agent_name] => Array
(
[0] => Erica J Lehmkuhl
)
[list_agent_phone_number] => Array
(
[0] => (808) 723-0953
)
[list_date] => Array
(
[0] => 2022-06-08
)
[list_office_name] => Array
(
[0] => Seaside Realty LLC
)
[list_price] => Array
(
[0] => 399999.00
)
[living_sf] => Array
(
[0] => 836
)
[location] => Array
(
[0] => 68-090 Au Street Unit 103E, Waialua, HI 96791
)
[maintenance_fees] => Array
(
[0] => 815.00
)
[middle_school] => Array
(
[0] => Waialua
)
[mls_] => Array
(
[0] => 202210713
)
[neighborhood] => Array
(
[0] => WAIALUA
)
[number_of_parking_spaces] => Array
(
[0] => 1
)
[number_of_stories] => Array
(
[0] => One
)
[office_mls_id] => Array
(
[0] => SSRE
)
[parking_features] => Array
(
[0] => Open - 1,Street
)
[possession] => Array
(
[0] => At Closing,Negotiable
)
[postal_code] => Array
(
[0] => 96791
)
[property_condition] => Array
(
[0] => Above Average,Excellent
)
[property_type] => Array
(
[0] => condo_townhouse
)
[property_type_label] => Array
(
[0] => Condo Townhouse
)
[region] => Array
(
[0] => North Shore
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_association_fee] => Array
(
[0] => 0
)
[rets_association_fee_total] => Array
(
[0] => 815
)
[rets_baths_full] => Array
(
[0] => 1
)
[rets_baths_half] => Array
(
[0] => 0
)
[rets_baths_total] => Array
(
[0] => 1.00
)
[rets_beds_total] => Array
(
[0] => 1
)
[rets_building_name] => Array
(
[0] => Ono Vista
)
[rets_city] => Array
(
[0] => Waialua
)
[rets_condo_parking_unit] => Array
(
[0] => #23
)
[rets_current_price] => Array
(
[0] => 399999.00
)
[rets_dom] => Array
(
[0] => 5
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_elementary_school] => Array
(
[0] => Waialua
)
[rets_elevators_number_of] => Array
(
[0] => 1
)
[rets_floor_number] => Array
(
[0] => 1
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_high_school] => Array
(
[0] => Waialua
)
[rets_id] => Array
(
[0] => 16686342
)
[rets_immoviewer_yn] => Array
(
[0] => 0
)
[rets_internet_automated_valuation_dis] => Array
(
[0] => 0
)
[rets_internet_consumer_comment_yn] => Array
(
[0] => 0
)
[rets_list_agent_direct_work_phone] => Array
(
[0] => (808) 723-0953
)
[rets_list_agent_email] => Array
(
[0] => ericainhawaii@gmail.com
)
[rets_list_agent_full_name] => Array
(
[0] => Erica J Lehmkuhl
)
[rets_list_agent_mlsid] => Array
(
[0] => 47564
)
[rets_list_agent_mui] => Array
(
[0] => 11074635
)
[rets_list_office_mlsid] => Array
(
[0] => SSRE
)
[rets_list_office_mui] => Array
(
[0] => 16118386
)
[rets_list_office_name] => Array
(
[0] => Seaside Realty LLC
)
[rets_list_office_phone] => Array
(
[0] => (808) 723-0953
)
[rets_list_price] => Array
(
[0] => 399999.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-06-08
)
[rets_lot_size_area] => Array
(
[0] => 51662.00
)
[rets_maintenance_expense] => Array
(
[0] => 815.00
)
[rets_management_company_name] => Array
(
[0] => Associa
)
[rets_management_company_phone] => Array
(
[0] => 808-836-0911
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-07-07T11:12:23.827
)
[rets_matrix_unique_id] => Array
(
[0] => 16686342
)
[rets_middle_or_junior_school] => Array
(
[0] => Waialua
)
[rets_mls_number] => Array
(
[0] => 202210713
)
[rets_neighbourhood] => Array
(
[0] => WAIALUA
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_open_house_count] => Array
(
[0] => 2
)
[rets_open_house_upcoming] => Array
(
[0] =>
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-06-04T14:33:24.657
)
[rets_original_list_price] => Array
(
[0] => 399999.00
)
[rets_owner_occupancy_percentage] => Array
(
[0] => 61
)
[rets_parcel_number] => Array
(
[0] => 1-6-8-011-058-0003
)
[rets_parking_additional] => Array
(
[0] => 0
)
[rets_parking_total] => Array
(
[0] => 1
)
[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] => 2022-06-07T21:37:32.633
)
[rets_postal_code] => Array
(
[0] => 96791
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-06-04T14:33:24.657
)
[rets_primary_key] => Array
(
[0] => 16686342
)
[rets_private_remarks] => Array
(
[0] => PLEASE SEND OFFERS TO SeasideOffers@gmail.com ; Vacant and easy to show! Please ShowingTime for showing requests. Please consider Kalia Goulette at Fidelity National Title, 808-724-0466, kalia.goulette@fnf.com for escrow. Please send all offers to SeasideOffers@gmail.com
)
[rets_public_remarks] => Array
(
[0] => Completely renovated top to bottom! Washer and dryer in-unit, dryer vents to exterior, private fenced yard, covered lanai, new windows and sliding glass doors w/ embedded blinds, ceiling fans w/ remotes, recessed lighting, solid wood cabinets, monkey pod wood, and stone countertops, all new vinyl plank flooring throughout, tiled walk-in shower, new sinks, faucets, toilet, and vanity. Bedroom with sliding glass door opens to private, fenced yard. One block to public beach access. Two block to Aweoweo Beach Park featuring showers/bathrooms/basketball court/playground w/ swings. Enjoy snorkeling with turtles or surfing your favorite break. Concrete and stucco construction, resistant to termites. New drywall finished interior, fresh paint, no popcorn ceilings! Pet friendly building with no weight limits (one dog and one cat allowed).
)
[rets_sqft_garage_carport] => Array
(
[0] => 0
)
[rets_sqft_lanai_open] => Array
(
[0] => 250
)
[rets_sqft_roofed_living] => Array
(
[0] => 586
)
[rets_sqft_total] => Array
(
[0] => 836
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-07-07T11:12:23.827
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-07-07
)
[rets_street_name] => Array
(
[0] => Au
)
[rets_street_number] => Array
(
[0] => 68-090
)
[rets_street_view_param] => Array
(
[0] => 1$21.582712$-158.136754$356.48$13.33$1.00$HliFX6Y68Ub_gDR2j01p3A
)
[rets_sub_agency_compensation] => Array
(
[0] => 3%
)
[rets_tax_amount] => Array
(
[0] => 55.00
)
[rets_tax_annual_amount] => Array
(
[0] => 660.00
)
[rets_tax_assessed_value] => Array
(
[0] => 345000.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 280000.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 65000.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 140000
)
[rets_tax_paid_by_seller_yn] => Array
(
[0] => 1
)
[rets_tax_year] => Array
(
[0] => 2020
)
[rets_thumbnail_url] => Array
(
[0] => https://cdn.rets.ci/marcusrealty-images/16686342/c54e23096154462d6392c24b34fc9e3a
)
[rets_tmk_area] => Array
(
[0] => 168
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 3
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 58
)
[rets_tmk_section] => Array
(
[0] => 8
)
[rets_tmk_zone] => Array
(
[0] => 6
)
[rets_tmkplat] => Array
(
[0] => 11
)
[rets_unit_number] => Array
(
[0] => 103E
)
[rets_year_built] => Array
(
[0] => 1975
)
[rets_year_remodeled] => Array
(
[0] => 2022
)
[security] => Array
(
[0] => Key
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Au
)
[street_number] => Array
(
[0] => 68-090
)
[street_suffix] => Array
(
[0] => Street
)
[terms_accept] => Array
(
[0] => Cash,Conventional,FHA,USDA Financing,VA
)
[tmk] => Array
(
[0] => 1-6-8-011-058-0003
)
[unit] => Array
(
[0] => Bedroom on 1st Level,Full Bath on 1st Floor,Ground Floor Unit,Odd# Unit,Single Level,Yard
)
[unit_number] => Array
(
[0] => 103E
)
[view] => Array
(
[0] => Garden,Mountain
)
[wpp::rets_pk] => Array
(
[0] => 16686342
)
[wpp_gpid] => Array
(
[0] => 202210713
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1657228407
)
[year_built] => Array
(
[0] => 1975
)
[year_remodeled_] => Array
(
[0] => 2022
)
[zoning] => Array
(
[0] => 11 - A-1 Low Density Apartment
)
[new_attached_media] => Array
(
[0] => a:84:{i:0;i:22387000;i:1;i:22387001;i:2;i:22387002;i:3;i:22387003;i:4;i:22387004;i:5;i:22387005;i:6;i:22387006;i:7;i:22387007;i:8;i:22387008;i:9;i:22387009;i:10;i:22387010;i:11;i:22387011;i:12;i:22387012;i:13;i:22387013;i:14;i:22387014;i:15;i:22387015;i:16;i:22387016;i:17;i:22387017;i:18;i:22387018;i:19;i:22387019;i:20;i:22387020;i:21;i:22400083;i:22;i:22400084;i:23;i:22400085;i:24;i:22400086;i:25;i:22400087;i:26;i:22400088;i:27;i:22400089;i:28;i:22400090;i:29;i:22400091;i:30;i:22400092;i:31;i:22400093;i:32;i:22400094;i:33;i:22400095;i:34;i:22400096;i:35;i:22400097;i:36;i:22400098;i:37;i:22400099;i:38;i:22400100;i:39;i:22400101;i:40;i:22400102;i:41;i:22400103;i:42;i:22427055;i:43;i:22427056;i:44;i:22427057;i:45;i:22427058;i:46;i:22427059;i:47;i:22427060;i:48;i:22427061;i:49;i:22427062;i:50;i:22427063;i:51;i:22427064;i:52;i:22427065;i:53;i:22427066;i:54;i:22427067;i:55;i:22427068;i:56;i:22427069;i:57;i:22427070;i:58;i:22427071;i:59;i:22427072;i:60;i:22427073;i:61;i:22427074;i:62;i:22427075;i:63;i:22652105;i:64;i:22652106;i:65;i:22652107;i:66;i:22652108;i:67;i:22652109;i:68;i:22652110;i:69;i:22652111;i:70;i:22652112;i:71;i:22652113;i:72;i:22652114;i:73;i:22652115;i:74;i:22652116;i:75;i:22652117;i:76;i:22652118;i:77;i:22652119;i:78;i:22652120;i:79;i:22652121;i:80;i:22652122;i:81;i:22652123;i:82;i:22652124;i:83;i:22652125;}
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-06-13
)
[rets_close_date] => Array
(
[0] => 2022-07-07
)
[rets_close_price] => Array
(
[0] => 399999.00
)
[rets_expiration_date] => Array
(
[0] => 2022-10-28
)
[rets_off_market_date] => Array
(
[0] => 2022-07-07
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 723-0953
)
[rets_selling_agent_email] => Array
(
[0] => ericainhawaii@gmail.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Erica J Lehmkuhl
)
[rets_selling_agent_mlsid] => Array
(
[0] => 47564
)
[rets_selling_agent_mui] => Array
(
[0] => 11074635
)
[rets_selling_office_mlsid] => Array
(
[0] => SSRE
)
[rets_selling_office_mui] => Array
(
[0] => 16118386
)
[rets_selling_office_name] => Array
(
[0] => Seaside Realty LLC
)
[rets_selling_office_phone] => Array
(
[0] => (808) 723-0953
)
[_thumbnail_id] => Array
(
[0] => 22652105
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446