Bring your ideas for this lovely, Wailua one bedroom condo with private yard. Contractors special with much of the work already done. Open concept kitchen and living room with large monkey pod wood island. Bedroom with sliding glass door opens to private, fenced yard. Washer and Dryer In-Unit, tankless on-demand hot water, no popcorn ceiling! One block to public beach access. Building features private, salt water pool and sauna. 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. Pet friendly building with no weight limits (one dog and one cat allowed).
Listing by: Seaside Realty LLC
array(166) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "280300.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(8) "60600.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "340900.00"
}
["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(21) "Pets Allowed (Verify)"
}
["elementary_school"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["floor_covering"]=>
array(1) {
[0]=>
string(12) "Ceramic Tile"
}
["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(7) "100,000"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(3) "210"
}
["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-14"
}
["list_office_name"]=>
array(1) {
[0]=>
string(18) "Seaside Realty LLC"
}
["list_price"]=>
array(1) {
[0]=>
string(9) "390000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(3) "796"
}
["location"]=>
array(1) {
[0]=>
string(45) "68-090 Au Street Unit 102E, 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) "202211304"
}
["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(10) "Negotiable"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96791"
}
["property_condition"]=>
array(1) {
[0]=>
string(12) "Average,Fair"
}
["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) "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(2) "22"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(9) "385000.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_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) "16702256"
}
["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) "390000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-06-14"
}
["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-21T09:03:50.770"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16702256"
}
["rets_middle_or_junior_school"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202211304"
}
["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) "2022-06-14T07:27:51.290"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(9) "390000.00"
}
["rets_owner_occupancy_percentage"]=>
array(1) {
[0]=>
string(2) "58"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-6-8-011-058-0002"
}
["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) "12"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-14T07:27:51.290"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96791"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16702256"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(381) "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 include "as-is" addendum and STR disclosure. This unit is NOT zoned or approved for short term rental. This unit is not in the 3.2' sea level rise zone."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(725) "Bring your ideas for this lovely, Wailua one bedroom condo with private yard. Contractors special with much of the work already done. Open concept kitchen and living room with large monkey pod wood island. Bedroom with sliding glass door opens to private, fenced yard. Washer and Dryer In-Unit, tankless on-demand hot water, no popcorn ceiling! One block to public beach access. Building features private, salt water pool and sauna. 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. Pet friendly building with no weight limits (one dog and one cat allowed)."
}
["rets_room_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(3) "210"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(3) "586"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(3) "796"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-07-21T09:03:50.770"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-07-21"
}
["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(4) "2.5%"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(5) "95.00"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "1140.00"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "340900.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "280300.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(8) "60600.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(7) "100,000"
}
["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/16702256/1f39cfa47005799d685d759e903f102f"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "168"
}
["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(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) "102E"
}
["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(44) "Cash,Conventional,Exchange,USDA Financing,VA"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-6-8-011-058-0002"
}
["unit"]=>
array(1) {
[0]=>
string(90) "Bedroom on 1st Level,Even# Unit,Full Bath on 1st Floor,Ground Floor Unit,Single Level,Yard"
}
["unit_number"]=>
array(1) {
[0]=>
string(4) "102E"
}
["view"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16702256"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202211304"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1658430271"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1975"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "2022"
}
["zoning"]=>
array(1) {
[0]=>
string(31) "12 - A-2 Medium Density Apartme"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(1533) "a:96:{i:0;i:22432306;i:1;i:22432307;i:2;i:22432308;i:3;i:22432309;i:4;i:22432310;i:5;i:22432311;i:6;i:22432312;i:7;i:22432313;i:8;i:22432314;i:9;i:22432315;i:10;i:22432316;i:11;i:22432317;i:12;i:22432318;i:13;i:22432319;i:14;i:22432320;i:15;i:22432321;i:16;i:22432322;i:17;i:22432323;i:18;i:22432324;i:19;i:22432325;i:20;i:22432326;i:21;i:22432327;i:22;i:22432328;i:23;i:22432329;i:24;i:22438532;i:25;i:22438533;i:26;i:22438534;i:27;i:22438535;i:28;i:22438536;i:29;i:22438537;i:30;i:22438538;i:31;i:22438539;i:32;i:22438540;i:33;i:22438541;i:34;i:22438542;i:35;i:22438543;i:36;i:22438631;i:37;i:22438632;i:38;i:22438633;i:39;i:22438634;i:40;i:22438635;i:41;i:22438636;i:42;i:22438637;i:43;i:22438638;i:44;i:22438639;i:45;i:22438640;i:46;i:22438641;i:47;i:22438642;i:48;i:22473457;i:49;i:22473458;i:50;i:22473459;i:51;i:22473460;i:52;i:22473461;i:53;i:22473462;i:54;i:22473463;i:55;i:22473464;i:56;i:22473465;i:57;i:22473466;i:58;i:22473467;i:59;i:22473468;i:60;i:22495571;i:61;i:22495572;i:62;i:22495573;i:63;i:22495574;i:64;i:22495575;i:65;i:22495576;i:66;i:22495577;i:67;i:22495578;i:68;i:22495579;i:69;i:22495580;i:70;i:22495581;i:71;i:22495582;i:72;i:22495605;i:73;i:22495606;i:74;i:22495607;i:75;i:22495608;i:76;i:22495609;i:77;i:22495610;i:78;i:22495611;i:79;i:22495612;i:80;i:22495613;i:81;i:22495614;i:82;i:22495615;i:83;i:22495616;i:84;i:22792848;i:85;i:22792849;i:86;i:22792850;i:87;i:22792851;i:88;i:22792852;i:89;i:22792853;i:90;i:22792854;i:91;i:22792855;i:92;i:22792856;i:93;i:22792857;i:94;i:22792858;i:95;i:22792859;}"
}
["rets_open_house_count"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_active_open_house_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_open_house_upcoming"]=>
array(1) {
[0]=>
string(0) ""
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-06-19"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-07-21"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(9) "385000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-11-30"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-07-21"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 791-1020"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(26) "kendelleyamamoto@gmail.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(23) "Kendelle Yamamoto-Moran"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "50586"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(8) "15330840"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "IPHI"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(7) "3487616"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(29) "Century 21 iProperties Hawaii"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 791-1020"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "22792848"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 280300.00
)
[assd_val_land] => Array
(
[0] => 60600.00
)
[assd_val_total] => Array
(
[0] => 340900.00
)
[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] => Pets Allowed (Verify)
)
[elementary_school] => Array
(
[0] => Waialua
)
[floor_covering] => Array
(
[0] => Ceramic Tile
)
[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] => 100,000
)
[lanai_sf] => Array
(
[0] => 210
)
[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-14
)
[list_office_name] => Array
(
[0] => Seaside Realty LLC
)
[list_price] => Array
(
[0] => 390000.00
)
[living_sf] => Array
(
[0] => 796
)
[location] => Array
(
[0] => 68-090 Au Street Unit 102E, Waialua, HI 96791
)
[maintenance_fees] => Array
(
[0] => 815.00
)
[middle_school] => Array
(
[0] => Waialua
)
[mls_] => Array
(
[0] => 202211304
)
[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] => Negotiable
)
[postal_code] => Array
(
[0] => 96791
)
[property_condition] => Array
(
[0] => Average,Fair
)
[property_type] => Array
(
[0] => condo_townhouse
)
[property_type_label] => Array
(
[0] => Condo Townhouse
)
[region] => Array
(
[0] => North Shore
)
[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] => 22
)
[rets_current_price] => Array
(
[0] => 385000.00
)
[rets_dom] => Array
(
[0] => 7
)
[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] => 16702256
)
[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] => 390000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-06-14
)
[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-21T09:03:50.770
)
[rets_matrix_unique_id] => Array
(
[0] => 16702256
)
[rets_middle_or_junior_school] => Array
(
[0] => Waialua
)
[rets_mls_number] => Array
(
[0] => 202211304
)
[rets_neighbourhood] => Array
(
[0] => WAIALUA
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-06-14T07:27:51.290
)
[rets_original_list_price] => Array
(
[0] => 390000.00
)
[rets_owner_occupancy_percentage] => Array
(
[0] => 58
)
[rets_parcel_number] => Array
(
[0] => 1-6-8-011-058-0002
)
[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] => 12
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2022-06-14T07:27:51.290
)
[rets_postal_code] => Array
(
[0] => 96791
)
[rets_primary_key] => Array
(
[0] => 16702256
)
[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 include "as-is" addendum and STR disclosure. This unit is NOT zoned or approved for short term rental. This unit is not in the 3.2' sea level rise zone.
)
[rets_public_remarks] => Array
(
[0] => Bring your ideas for this lovely, Wailua one bedroom condo with private yard. Contractors special with much of the work already done. Open concept kitchen and living room with large monkey pod wood island. Bedroom with sliding glass door opens to private, fenced yard. Washer and Dryer In-Unit, tankless on-demand hot water, no popcorn ceiling! One block to public beach access. Building features private, salt water pool and sauna. 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. Pet friendly building with no weight limits (one dog and one cat allowed).
)
[rets_room_count] => Array
(
[0] => 0
)
[rets_sqft_lanai_open] => Array
(
[0] => 210
)
[rets_sqft_roofed_living] => Array
(
[0] => 586
)
[rets_sqft_total] => Array
(
[0] => 796
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-07-21T09:03:50.770
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-07-21
)
[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] => 2.5%
)
[rets_tax_amount] => Array
(
[0] => 95.00
)
[rets_tax_annual_amount] => Array
(
[0] => 1140.00
)
[rets_tax_assessed_value] => Array
(
[0] => 340900.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 280300.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 60600.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 100,000
)
[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/16702256/1f39cfa47005799d685d759e903f102f
)
[rets_tmk_area] => Array
(
[0] => 168
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 2
)
[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] => 102E
)
[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,Exchange,USDA Financing,VA
)
[tmk] => Array
(
[0] => 1-6-8-011-058-0002
)
[unit] => Array
(
[0] => Bedroom on 1st Level,Even# Unit,Full Bath on 1st Floor,Ground Floor Unit,Single Level,Yard
)
[unit_number] => Array
(
[0] => 102E
)
[view] => Array
(
[0] => Mountain
)
[wpp::rets_pk] => Array
(
[0] => 16702256
)
[wpp_gpid] => Array
(
[0] => 202211304
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1658430271
)
[year_built] => Array
(
[0] => 1975
)
[year_remodeled_] => Array
(
[0] => 2022
)
[zoning] => Array
(
[0] => 12 - A-2 Medium Density Apartme
)
[new_attached_media] => Array
(
[0] => a:96:{i:0;i:22432306;i:1;i:22432307;i:2;i:22432308;i:3;i:22432309;i:4;i:22432310;i:5;i:22432311;i:6;i:22432312;i:7;i:22432313;i:8;i:22432314;i:9;i:22432315;i:10;i:22432316;i:11;i:22432317;i:12;i:22432318;i:13;i:22432319;i:14;i:22432320;i:15;i:22432321;i:16;i:22432322;i:17;i:22432323;i:18;i:22432324;i:19;i:22432325;i:20;i:22432326;i:21;i:22432327;i:22;i:22432328;i:23;i:22432329;i:24;i:22438532;i:25;i:22438533;i:26;i:22438534;i:27;i:22438535;i:28;i:22438536;i:29;i:22438537;i:30;i:22438538;i:31;i:22438539;i:32;i:22438540;i:33;i:22438541;i:34;i:22438542;i:35;i:22438543;i:36;i:22438631;i:37;i:22438632;i:38;i:22438633;i:39;i:22438634;i:40;i:22438635;i:41;i:22438636;i:42;i:22438637;i:43;i:22438638;i:44;i:22438639;i:45;i:22438640;i:46;i:22438641;i:47;i:22438642;i:48;i:22473457;i:49;i:22473458;i:50;i:22473459;i:51;i:22473460;i:52;i:22473461;i:53;i:22473462;i:54;i:22473463;i:55;i:22473464;i:56;i:22473465;i:57;i:22473466;i:58;i:22473467;i:59;i:22473468;i:60;i:22495571;i:61;i:22495572;i:62;i:22495573;i:63;i:22495574;i:64;i:22495575;i:65;i:22495576;i:66;i:22495577;i:67;i:22495578;i:68;i:22495579;i:69;i:22495580;i:70;i:22495581;i:71;i:22495582;i:72;i:22495605;i:73;i:22495606;i:74;i:22495607;i:75;i:22495608;i:76;i:22495609;i:77;i:22495610;i:78;i:22495611;i:79;i:22495612;i:80;i:22495613;i:81;i:22495614;i:82;i:22495615;i:83;i:22495616;i:84;i:22792848;i:85;i:22792849;i:86;i:22792850;i:87;i:22792851;i:88;i:22792852;i:89;i:22792853;i:90;i:22792854;i:91;i:22792855;i:92;i:22792856;i:93;i:22792857;i:94;i:22792858;i:95;i:22792859;}
)
[rets_open_house_count] => Array
(
[0] => 1
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_open_house_upcoming] => Array
(
[0] =>
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-06-19
)
[rets_close_date] => Array
(
[0] => 2022-07-21
)
[rets_close_price] => Array
(
[0] => 385000.00
)
[rets_expiration_date] => Array
(
[0] => 2022-11-30
)
[rets_off_market_date] => Array
(
[0] => 2022-07-21
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 791-1020
)
[rets_selling_agent_email] => Array
(
[0] => kendelleyamamoto@gmail.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Kendelle Yamamoto-Moran
)
[rets_selling_agent_mlsid] => Array
(
[0] => 50586
)
[rets_selling_agent_mui] => Array
(
[0] => 15330840
)
[rets_selling_office_mlsid] => Array
(
[0] => IPHI
)
[rets_selling_office_mui] => Array
(
[0] => 3487616
)
[rets_selling_office_name] => Array
(
[0] => Century 21 iProperties Hawaii
)
[rets_selling_office_phone] => Array
(
[0] => (808) 791-1020
)
[_thumbnail_id] => Array
(
[0] => 22792848
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446