201 Ohua Avenue Unit 2902 Tower 2
Honolulu, HI 96815

Listing
Overview

Price: $699,000
Area: WAIKIKI
Status: Sold

A fully furnished 1-bedroom condo at the Waikiki Banyan, in the preferred 02-stack of the Tower 2 (Mauka). Located just one block away from Waikiki Beach, this luxury South-West facing corner unit offers beautiful ocean views from each room and the lanai, and city views from the additional bedroom window. Remodeling in July 2021 included new luxury vinyl flooring, new kitchen, bathroom, quartz countertops, repainted walls. The shower wall, bathroom and lanai flooring feature new porcelain tiles. The brand new open kitchen is fully equipped, has new stainless steel appliances, a dishwasher, and a kitchen island with 4 chairs. The living room features a queen-size pull-out sleeper sofa, chair, coffee table, new 50” smart TV, and a window AC. The bedroom comes with a king-size bed and can be separated from the living room by a sliding door. A tastefully remodeled bathroom features a bathtub, hand-held shower wand, and rain shower head. The large recreation deck on the 6th floor offers a large pool, jet spa, tennis court, sauna, gas BBQ, children’s playground, and a snack bar. Sold “As Is”. The unit doesn’t have NUC. Special assessment till Dec 2021 to be assumed by Buyer, $683/month.

Listing by: Midway Realty LLC (808) 389-4004

array(175) {
  ["agency"]=>
  array(1) {
    [0]=>
    string(28) "Town and Country Real Estate"
  }
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "431500.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "106600.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "538100.00"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["building_name"]=>
  array(1) {
    [0]=>
    string(14) "Waikiki Banyan"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(29) "Condotel,High-Rise 7+ Stories"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(73) "Licensed Owner,Pets Allowed (Verify),Property Disclosure Stmt,See Remarks"
  }
  ["elementary_school"]=>
  array(1) {
    [0]=>
    string(9) "Jefferson"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(18) "Ceramic Tile,Vinyl"
  }
  ["frontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["furnished"]=>
  array(1) {
    [0]=>
    string(4) "Full"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["high_school"]=>
  array(1) {
    [0]=>
    string(7) "Kaimuki"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["lanai_sf"]=>
  array(1) {
    [0]=>
    string(2) "67"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(8) "99796.00"
  }
  ["land_recorded"]=>
  array(1) {
    [0]=>
    string(12) "Dual Systems"
  }
  ["land_tenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["list_agent_email"]=>
  array(1) {
    [0]=>
    string(27) "christian@midway-realty.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(20) "Christian Brandalise"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 226-1604"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-13"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(17) "Midway Realty LLC"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "699000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(3) "600"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(53) "201 Ohua Avenue Unit 2902 Tower 2, Honolulu, HI 96815"
  }
  ["maintenance_fees"]=>
  array(1) {
    [0]=>
    string(6) "575.00"
  }
  ["middle_school"]=>
  array(1) {
    [0]=>
    string(10) "Washington"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202123736"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKIKI"
  }
  ["number_of_parking_spaces"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["number_of_stories"]=>
  array(1) {
    [0]=>
    string(3) "21+"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "GHIS"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(22) "Covered - 1,Unassigned"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(10) "At Closing"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96815"
  }
  ["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(5) "Metro"
  }
  ["rets_association_fee_2"]=>
  array(1) {
    [0]=>
    string(3) "683"
  }
  ["rets_association_fee_total"]=>
  array(1) {
    [0]=>
    string(4) "1258"
  }
  ["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(14) "Waikiki Banyan"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["rets_co_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 389-4004"
  }
  ["rets_co_list_agent_email"]=>
  array(1) {
    [0]=>
    string(23) "evelinahawaii@gmail.com"
  }
  ["rets_co_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(22) "Evelina Zivatkauskaite"
  }
  ["rets_co_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "46810"
  }
  ["rets_co_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(8) "10599276"
  }
  ["rets_co_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "TCRE"
  }
  ["rets_co_list_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "11011029"
  }
  ["rets_co_list_office_name"]=>
  array(1) {
    [0]=>
    string(28) "Town and Country Real Estate"
  }
  ["rets_co_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 389-4004"
  }
  ["rets_condo_parking_unit"]=>
  array(1) {
    [0]=>
    string(10) "Unassigned"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(9) "699000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_elementary_school"]=>
  array(1) {
    [0]=>
    string(9) "Jefferson"
  }
  ["rets_elevators_number_of"]=>
  array(1) {
    [0]=>
    string(1) "8"
  }
  ["rets_floor_number"]=>
  array(1) {
    [0]=>
    string(2) "29"
  }
  ["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) "Kaimuki"
  }
  ["rets_id"]=>
  array(1) {
    [0]=>
    string(8) "16160375"
  }
  ["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) 226-1604"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(27) "christian@midway-realty.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(20) "Christian Brandalise"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "46001"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "9920895"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "GHIS"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3486530"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(17) "Midway Realty LLC"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 226-1604"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(9) "699000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-13"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(8) "99796.00"
  }
  ["rets_maintenance_expense"]=>
  array(1) {
    [0]=>
    string(6) "575.00"
  }
  ["rets_management_company_name"]=>
  array(1) {
    [0]=>
    string(9) "Hawaiiana"
  }
  ["rets_management_company_phone"]=>
  array(1) {
    [0]=>
    string(12) "808-593-9100"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-12-20T15:38:55.493"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "16160375"
  }
  ["rets_middle_or_junior_school"]=>
  array(1) {
    [0]=>
    string(10) "Washington"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202123736"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKIKI"
  }
  ["rets_new_development_construction_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-13T12:44:33.407"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(9) "699000.00"
  }
  ["rets_owner_occupancy_percentage"]=>
  array(1) {
    [0]=>
    string(2) "19"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-2-6-025-005-0738"
  }
  ["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-09-13T12:44:33.407"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96815"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "16160375"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(573) "Unit is being rented as a vacation rental, managed by Midway Realty LLC, interested in continuing to manage it. Next available showing is Saturday 9/18 at 2pm. Please email listor and CC co-listor to schedule the showing. For escrow, please use Old Republic Title, Kailua branch, Donna Uemura, (808) 266-0150, duemura@ortc.com. One of the owners is a licensed real estate broker and listing agent (please add to R-6a). Please add As Is and Short-term Rentals Disclosure addendums. Offers to be presented as they come in, please allow at least 48 hours to respond to offers."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(1202) "A fully furnished 1-bedroom condo at the Waikiki Banyan, in the preferred 02-stack of the Tower 2 (Mauka). Located just one block away from Waikiki Beach, this luxury South-West facing corner unit offers beautiful ocean views from each room and the lanai, and city views from the additional bedroom window. Remodeling in July 2021 included new luxury vinyl flooring, new kitchen, bathroom, quartz countertops, repainted walls. The shower wall, bathroom and lanai flooring feature new porcelain tiles. The brand new open kitchen is fully equipped, has new stainless steel appliances, a dishwasher, and a kitchen island with 4 chairs. The living room features a queen-size pull-out sleeper sofa, chair, coffee table, new 50” smart TV, and a window AC. The bedroom comes with a king-size bed and can be separated from the living room by a sliding door. A tastefully remodeled bathroom features a bathtub, hand-held shower wand, and rain shower head. The large recreation deck on the 6th floor offers a large pool, jet spa, tennis court, sauna, gas BBQ, children's playground, and a snack bar. Sold "As Is". The unit doesn't have NUC. Special assessment till Dec 2021 to be assumed by Buyer, $683/month."
  }
  ["rets_sqft_lanai_open"]=>
  array(1) {
    [0]=>
    string(2) "67"
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(3) "533"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(3) "600"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-12-20T15:38:55.493"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-12-20"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(4) "Ohua"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(3) "201"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(105) "1$21.274757$-157.821077$94.96$13.33$1.00$CAoSLEFGMVFpcFBITWN3TWFUQU1uUXAyQXJEVEh3dmliejRyWFFiUDBUSVFkdmE3"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(4) "2.5%"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "156.94"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "538100.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "431500.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "106600.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/16160375/91f8bf17b56304f07e7d1c39fb6202fb"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "126"
  }
  ["rets_tmk_condo_property_regime_number"]=>
  array(1) {
    [0]=>
    string(3) "738"
  }
  ["rets_tmk_division"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tmk_parcel"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(2) "25"
  }
  ["rets_unit_number"]=>
  array(1) {
    [0]=>
    string(12) "2902 Tower 2"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1977"
  }
  ["rets_year_remodeled"]=>
  array(1) {
    [0]=>
    string(4) "2021"
  }
  ["security"]=>
  array(1) {
    [0]=>
    string(15) "Security Patrol"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(4) "Ohua"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(3) "201"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(6) "Avenue"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(17) "Cash,Conventional"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-2-6-025-005-0738"
  }
  ["unit"]=>
  array(1) {
    [0]=>
    string(34) "Corner/End,Even# Unit,Single Level"
  }
  ["unit_number"]=>
  array(1) {
    [0]=>
    string(12) "2902 Tower 2"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(12) "Ocean,Sunset"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "16160375"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202123736"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1640050763"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1977"
  }
  ["year_remodeled_"]=>
  array(1) {
    [0]=>
    string(4) "2021"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(23) "X2 - Apartment Precinct"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(1683) "a:105:{i:0;i:20731450;i:1;i:20731451;i:2;i:20731452;i:3;i:20731453;i:4;i:20731454;i:5;i:20731455;i:6;i:20731456;i:7;i:20731457;i:8;i:20731458;i:9;i:20731459;i:10;i:20731460;i:11;i:20731461;i:12;i:20731462;i:13;i:20731463;i:14;i:20731464;i:15;i:20731465;i:16;i:20731466;i:17;i:20731467;i:18;i:20731468;i:19;i:20731469;i:20;i:20731470;i:21;i:20732995;i:22;i:20732996;i:23;i:20732997;i:24;i:20732998;i:25;i:20732999;i:26;i:20733000;i:27;i:20733001;i:28;i:20733002;i:29;i:20733003;i:30;i:20733004;i:31;i:20733005;i:32;i:20733006;i:33;i:20733007;i:34;i:20733008;i:35;i:20733009;i:36;i:20733010;i:37;i:20733011;i:38;i:20733012;i:39;i:20733013;i:40;i:20733014;i:41;i:20733015;i:42;i:20733016;i:43;i:20733017;i:44;i:20733018;i:45;i:20733019;i:46;i:20733020;i:47;i:20733021;i:48;i:20733022;i:49;i:20733023;i:50;i:20733024;i:51;i:20733025;i:52;i:20733026;i:53;i:20733027;i:54;i:20733028;i:55;i:20733029;i:56;i:20733030;i:57;i:20733031;i:58;i:20733032;i:59;i:20733033;i:60;i:20733034;i:61;i:20733035;i:62;i:20733036;i:63;i:20753284;i:64;i:20753285;i:65;i:20753286;i:66;i:20753287;i:67;i:20753288;i:68;i:20753289;i:69;i:20753290;i:70;i:20753291;i:71;i:20753292;i:72;i:20753293;i:73;i:20753294;i:74;i:20753295;i:75;i:20753296;i:76;i:20753297;i:77;i:20753298;i:78;i:20753299;i:79;i:20753300;i:80;i:20753301;i:81;i:20753302;i:82;i:20753303;i:83;i:20753304;i:84;i:21355276;i:85;i:21355277;i:86;i:21355278;i:87;i:21355279;i:88;i:21355280;i:89;i:21355281;i:90;i:21355282;i:91;i:21355283;i:92;i:21355284;i:93;i:21355285;i:94;i:21355286;i:95;i:21355287;i:96;i:21355288;i:97;i:21355289;i:98;i:21355290;i:99;i:21355291;i:100;i:21355292;i:101;i:21355293;i:102;i:21355294;i:103;i:21355295;i:104;i:21355296;}"
  }
  ["rets_supplement_count"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_supplement_modification_timestam"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-13T15:17:43.187"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-15"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-12-20"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(9) "699000.00"
  }
  ["rets_expiration_date"]=>
  array(1) {
    [0]=>
    string(10) "2022-03-12"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-12-20"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 735-4200"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(34) "rina.shinagawa@locationshawaii.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(14) "Rina Shinagawa"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "26315"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3476008"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "LOCA"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3485305"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(13) "Locations LLC"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 735-4200"
  }
  ["rets_tax_annual_amount"]=>
  array(1) {
    [0]=>
    string(7) "1883.28"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "21355276"
  }
}
Array
(
    [agency] => Array
        (
            [0] => Town and Country Real Estate
        )

    [assd_val_imprv] => Array
        (
            [0] => 431500.00
        )

    [assd_val_land] => Array
        (
            [0] => 106600.00
        )

    [assd_val_total] => Array
        (
            [0] => 538100.00
        )

    [bedrooms] => Array
        (
            [0] => 1
        )

    [building_name] => Array
        (
            [0] => Waikiki Banyan
        )

    [building_style] => Array
        (
            [0] => Condotel,High-Rise 7+ Stories
        )

    [city] => Array
        (
            [0] => Honolulu
        )

    [county] => Array
        (
            [0] => Oahu
        )

    [disclosures] => Array
        (
            [0] => Licensed Owner,Pets Allowed (Verify),Property Disclosure Stmt,See Remarks
        )

    [elementary_school] => Array
        (
            [0] => Jefferson
        )

    [floor_covering] => Array
        (
            [0] => Ceramic Tile,Vinyl
        )

    [frontage] => Array
        (
            [0] => Other
        )

    [full_baths] => Array
        (
            [0] => 1
        )

    [furnished] => Array
        (
            [0] => Full
        )

    [half_baths] => Array
        (
            [0] => 0
        )

    [high_school] => Array
        (
            [0] => Kaimuki
        )

    [home_exampt] => Array
        (
            [0] => 0
        )

    [lanai_sf] => Array
        (
            [0] => 67
        )

    [land_area_sf] => Array
        (
            [0] => 99796.00
        )

    [land_recorded] => Array
        (
            [0] => Dual Systems
        )

    [land_tenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [list_agent_email] => Array
        (
            [0] => christian@midway-realty.com
        )

    [list_agent_name] => Array
        (
            [0] => Christian Brandalise
        )

    [list_agent_phone_number] => Array
        (
            [0] => (808) 226-1604
        )

    [list_date] => Array
        (
            [0] => 2021-09-13
        )

    [list_office_name] => Array
        (
            [0] => Midway Realty LLC
        )

    [list_price] => Array
        (
            [0] => 699000.00
        )

    [living_sf] => Array
        (
            [0] => 600
        )

    [location] => Array
        (
            [0] => 201 Ohua Avenue Unit 2902 Tower 2, Honolulu, HI 96815
        )

    [maintenance_fees] => Array
        (
            [0] => 575.00
        )

    [middle_school] => Array
        (
            [0] => Washington
        )

    [mls_] => Array
        (
            [0] => 202123736
        )

    [neighborhood] => Array
        (
            [0] => WAIKIKI
        )

    [number_of_parking_spaces] => Array
        (
            [0] => 1
        )

    [number_of_stories] => Array
        (
            [0] => 21+
        )

    [office_mls_id] => Array
        (
            [0] => GHIS
        )

    [parking_features] => Array
        (
            [0] => Covered - 1,Unassigned
        )

    [possession] => Array
        (
            [0] => At Closing
        )

    [postal_code] => Array
        (
            [0] => 96815
        )

    [property_condition] => Array
        (
            [0] => Excellent
        )

    [property_type] => Array
        (
            [0] => condo_townhouse
        )

    [property_type_label] => Array
        (
            [0] => Condo Townhouse
        )

    [region] => Array
        (
            [0] => Metro
        )

    [rets_association_fee_2] => Array
        (
            [0] => 683
        )

    [rets_association_fee_total] => Array
        (
            [0] => 1258
        )

    [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] => Waikiki Banyan
        )

    [rets_city] => Array
        (
            [0] => Honolulu
        )

    [rets_co_list_agent_direct_work_phone] => Array
        (
            [0] => (808) 389-4004
        )

    [rets_co_list_agent_email] => Array
        (
            [0] => evelinahawaii@gmail.com
        )

    [rets_co_list_agent_full_name] => Array
        (
            [0] => Evelina Zivatkauskaite
        )

    [rets_co_list_agent_mlsid] => Array
        (
            [0] => 46810
        )

    [rets_co_list_agent_mui] => Array
        (
            [0] => 10599276
        )

    [rets_co_list_office_mlsid] => Array
        (
            [0] => TCRE
        )

    [rets_co_list_office_mui] => Array
        (
            [0] => 11011029
        )

    [rets_co_list_office_name] => Array
        (
            [0] => Town and Country Real Estate
        )

    [rets_co_list_office_phone] => Array
        (
            [0] => (808) 389-4004
        )

    [rets_condo_parking_unit] => Array
        (
            [0] => Unassigned
        )

    [rets_current_price] => Array
        (
            [0] => 699000.00
        )

    [rets_dom] => Array
        (
            [0] => 3
        )

    [rets_dual_variable_compensation_yn] => Array
        (
            [0] => 0
        )

    [rets_elementary_school] => Array
        (
            [0] => Jefferson
        )

    [rets_elevators_number_of] => Array
        (
            [0] => 8
        )

    [rets_floor_number] => Array
        (
            [0] => 29
        )

    [rets_foreclosure_yn] => Array
        (
            [0] => 0
        )

    [rets_fractional_ownership_yn] => Array
        (
            [0] => 0
        )

    [rets_high_school] => Array
        (
            [0] => Kaimuki
        )

    [rets_id] => Array
        (
            [0] => 16160375
        )

    [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) 226-1604
        )

    [rets_list_agent_email] => Array
        (
            [0] => christian@midway-realty.com
        )

    [rets_list_agent_full_name] => Array
        (
            [0] => Christian Brandalise
        )

    [rets_list_agent_mlsid] => Array
        (
            [0] => 46001
        )

    [rets_list_agent_mui] => Array
        (
            [0] => 9920895
        )

    [rets_list_office_mlsid] => Array
        (
            [0] => GHIS
        )

    [rets_list_office_mui] => Array
        (
            [0] => 3486530
        )

    [rets_list_office_name] => Array
        (
            [0] => Midway Realty LLC
        )

    [rets_list_office_phone] => Array
        (
            [0] => (808) 226-1604
        )

    [rets_list_price] => Array
        (
            [0] => 699000.00
        )

    [rets_listing_contract_date] => Array
        (
            [0] => 2021-09-13
        )

    [rets_lot_size_area] => Array
        (
            [0] => 99796.00
        )

    [rets_maintenance_expense] => Array
        (
            [0] => 575.00
        )

    [rets_management_company_name] => Array
        (
            [0] => Hawaiiana
        )

    [rets_management_company_phone] => Array
        (
            [0] => 808-593-9100
        )

    [rets_matrix_modified_dt] => Array
        (
            [0] => 2021-12-20T15:38:55.493
        )

    [rets_matrix_unique_id] => Array
        (
            [0] => 16160375
        )

    [rets_middle_or_junior_school] => Array
        (
            [0] => Washington
        )

    [rets_mls_number] => Array
        (
            [0] => 202123736
        )

    [rets_neighbourhood] => Array
        (
            [0] => WAIKIKI
        )

    [rets_new_development_construction_yn] => Array
        (
            [0] => 0
        )

    [rets_original_entry_timestamp] => Array
        (
            [0] => 2021-09-13T12:44:33.407
        )

    [rets_original_list_price] => Array
        (
            [0] => 699000.00
        )

    [rets_owner_occupancy_percentage] => Array
        (
            [0] => 19
        )

    [rets_parcel_number] => Array
        (
            [0] => 1-2-6-025-005-0738
        )

    [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] => 2021-09-13T12:44:33.407
        )

    [rets_postal_code] => Array
        (
            [0] => 96815
        )

    [rets_primary_key] => Array
        (
            [0] => 16160375
        )

    [rets_private_remarks] => Array
        (
            [0] => Unit is being rented as a vacation rental, managed by Midway Realty LLC, interested in continuing to manage it. Next available showing is Saturday 9/18 at 2pm. Please email listor and CC co-listor to schedule the showing. For escrow, please use Old Republic Title, Kailua branch, Donna Uemura, (808) 266-0150, duemura@ortc.com. One of the owners is a licensed real estate broker and listing agent (please add to R-6a). Please add As Is and Short-term Rentals Disclosure addendums. Offers to be presented as they come in, please allow at least 48 hours to respond to offers.
        )

    [rets_public_remarks] => Array
        (
            [0] => A fully furnished 1-bedroom condo at the Waikiki Banyan, in the preferred 02-stack of the Tower 2 (Mauka). Located just one block away from Waikiki Beach, this luxury South-West facing corner unit offers beautiful ocean views from each room and the lanai, and city views from the additional bedroom window. Remodeling in July 2021 included new luxury vinyl flooring, new kitchen, bathroom, quartz countertops, repainted walls. The shower wall, bathroom and lanai flooring feature new porcelain tiles. The brand new open kitchen is fully equipped, has new stainless steel appliances, a dishwasher, and a kitchen island with 4 chairs. The living room features a queen-size pull-out sleeper sofa, chair, coffee table, new 50” smart TV, and a window AC. The bedroom comes with a king-size bed and can be separated from the living room by a sliding door. A tastefully remodeled bathroom features a bathtub, hand-held shower wand, and rain shower head. The large recreation deck on the 6th floor offers a large pool, jet spa, tennis court, sauna, gas BBQ, children's playground, and a snack bar. Sold "As Is". The unit doesn't have NUC. Special assessment till Dec 2021 to be assumed by Buyer, $683/month.
        )

    [rets_sqft_lanai_open] => Array
        (
            [0] => 67
        )

    [rets_sqft_roofed_living] => Array
        (
            [0] => 533
        )

    [rets_sqft_total] => Array
        (
            [0] => 600
        )

    [rets_state_or_province] => Array
        (
            [0] => HI
        )

    [rets_status_change_timestamp] => Array
        (
            [0] => 2021-12-20T15:38:55.493
        )

    [rets_status_contractual_search_date] => Array
        (
            [0] => 2021-12-20
        )

    [rets_street_name] => Array
        (
            [0] => Ohua
        )

    [rets_street_number] => Array
        (
            [0] => 201
        )

    [rets_street_view_param] => Array
        (
            [0] => 1$21.274757$-157.821077$94.96$13.33$1.00$CAoSLEFGMVFpcFBITWN3TWFUQU1uUXAyQXJEVEh3dmliejRyWFFiUDBUSVFkdmE3
        )

    [rets_sub_agency_compensation] => Array
        (
            [0] => 2.5%
        )

    [rets_tax_amount] => Array
        (
            [0] => 156.94
        )

    [rets_tax_assessed_value] => Array
        (
            [0] => 538100.00
        )

    [rets_tax_assessed_value_improvements] => Array
        (
            [0] => 431500.00
        )

    [rets_tax_assessed_value_land] => Array
        (
            [0] => 106600.00
        )

    [rets_tax_excemption_owner_occupancy] => Array
        (
            [0] => 0
        )

    [rets_tax_paid_by_seller_yn] => Array
        (
            [0] => 0
        )

    [rets_tax_year] => Array
        (
            [0] => 2020
        )

    [rets_thumbnail_url] => Array
        (
            [0] => https://cdn.rets.ci/marcusrealty-images/16160375/91f8bf17b56304f07e7d1c39fb6202fb
        )

    [rets_tmk_area] => Array
        (
            [0] => 126
        )

    [rets_tmk_condo_property_regime_number] => Array
        (
            [0] => 738
        )

    [rets_tmk_division] => Array
        (
            [0] => 1
        )

    [rets_tmk_parcel] => Array
        (
            [0] => 5
        )

    [rets_tmk_section] => Array
        (
            [0] => 6
        )

    [rets_tmk_zone] => Array
        (
            [0] => 2
        )

    [rets_tmkplat] => Array
        (
            [0] => 25
        )

    [rets_unit_number] => Array
        (
            [0] => 2902 Tower 2
        )

    [rets_year_built] => Array
        (
            [0] => 1977
        )

    [rets_year_remodeled] => Array
        (
            [0] => 2021
        )

    [security] => Array
        (
            [0] => Security Patrol
        )

    [state_or_province] => Array
        (
            [0] => HI
        )

    [status] => Array
        (
            [0] => Sold
        )

    [street_name] => Array
        (
            [0] => Ohua
        )

    [street_number] => Array
        (
            [0] => 201
        )

    [street_suffix] => Array
        (
            [0] => Avenue
        )

    [terms_accept] => Array
        (
            [0] => Cash,Conventional
        )

    [tmk] => Array
        (
            [0] => 1-2-6-025-005-0738
        )

    [unit] => Array
        (
            [0] => Corner/End,Even# Unit,Single Level
        )

    [unit_number] => Array
        (
            [0] => 2902 Tower 2
        )

    [view] => Array
        (
            [0] => Ocean,Sunset
        )

    [wpp::rets_pk] => Array
        (
            [0] => 16160375
        )

    [wpp_gpid] => Array
        (
            [0] => 202123736
        )

    [wpp_import_schedule_id] => Array
        (
            [0] => 1463343682
        )

    [wpp_import_time] => Array
        (
            [0] => 1640050763
        )

    [year_built] => Array
        (
            [0] => 1977
        )

    [year_remodeled_] => Array
        (
            [0] => 2021
        )

    [zoning] => Array
        (
            [0] => X2 - Apartment Precinct
        )

    [new_attached_media] => Array
        (
            [0] => a:105:{i:0;i:20731450;i:1;i:20731451;i:2;i:20731452;i:3;i:20731453;i:4;i:20731454;i:5;i:20731455;i:6;i:20731456;i:7;i:20731457;i:8;i:20731458;i:9;i:20731459;i:10;i:20731460;i:11;i:20731461;i:12;i:20731462;i:13;i:20731463;i:14;i:20731464;i:15;i:20731465;i:16;i:20731466;i:17;i:20731467;i:18;i:20731468;i:19;i:20731469;i:20;i:20731470;i:21;i:20732995;i:22;i:20732996;i:23;i:20732997;i:24;i:20732998;i:25;i:20732999;i:26;i:20733000;i:27;i:20733001;i:28;i:20733002;i:29;i:20733003;i:30;i:20733004;i:31;i:20733005;i:32;i:20733006;i:33;i:20733007;i:34;i:20733008;i:35;i:20733009;i:36;i:20733010;i:37;i:20733011;i:38;i:20733012;i:39;i:20733013;i:40;i:20733014;i:41;i:20733015;i:42;i:20733016;i:43;i:20733017;i:44;i:20733018;i:45;i:20733019;i:46;i:20733020;i:47;i:20733021;i:48;i:20733022;i:49;i:20733023;i:50;i:20733024;i:51;i:20733025;i:52;i:20733026;i:53;i:20733027;i:54;i:20733028;i:55;i:20733029;i:56;i:20733030;i:57;i:20733031;i:58;i:20733032;i:59;i:20733033;i:60;i:20733034;i:61;i:20733035;i:62;i:20733036;i:63;i:20753284;i:64;i:20753285;i:65;i:20753286;i:66;i:20753287;i:67;i:20753288;i:68;i:20753289;i:69;i:20753290;i:70;i:20753291;i:71;i:20753292;i:72;i:20753293;i:73;i:20753294;i:74;i:20753295;i:75;i:20753296;i:76;i:20753297;i:77;i:20753298;i:78;i:20753299;i:79;i:20753300;i:80;i:20753301;i:81;i:20753302;i:82;i:20753303;i:83;i:20753304;i:84;i:21355276;i:85;i:21355277;i:86;i:21355278;i:87;i:21355279;i:88;i:21355280;i:89;i:21355281;i:90;i:21355282;i:91;i:21355283;i:92;i:21355284;i:93;i:21355285;i:94;i:21355286;i:95;i:21355287;i:96;i:21355288;i:97;i:21355289;i:98;i:21355290;i:99;i:21355291;i:100;i:21355292;i:101;i:21355293;i:102;i:21355294;i:103;i:21355295;i:104;i:21355296;}
        )

    [rets_supplement_count] => Array
        (
            [0] => 1
        )

    [rets_supplement_modification_timestam] => Array
        (
            [0] => 2021-09-13T15:17:43.187
        )

    [rets_active_continue_to_show_date] => Array
        (
            [0] => 2021-09-15
        )

    [rets_close_date] => Array
        (
            [0] => 2021-12-20
        )

    [rets_close_price] => Array
        (
            [0] => 699000.00
        )

    [rets_expiration_date] => Array
        (
            [0] => 2022-03-12
        )

    [rets_off_market_date] => Array
        (
            [0] => 2021-12-20
        )

    [rets_selling_agent_direct_work_phone] => Array
        (
            [0] => (808) 735-4200
        )

    [rets_selling_agent_email] => Array
        (
            [0] => rina.shinagawa@locationshawaii.com
        )

    [rets_selling_agent_full_name] => Array
        (
            [0] => Rina Shinagawa
        )

    [rets_selling_agent_mlsid] => Array
        (
            [0] => 26315
        )

    [rets_selling_agent_mui] => Array
        (
            [0] => 3476008
        )

    [rets_selling_office_mlsid] => Array
        (
            [0] => LOCA
        )

    [rets_selling_office_mui] => Array
        (
            [0] => 3485305
        )

    [rets_selling_office_name] => Array
        (
            [0] => Locations LLC
        )

    [rets_selling_office_phone] => Array
        (
            [0] => (808) 735-4200
        )

    [rets_tax_annual_amount] => Array
        (
            [0] => 1883.28
        )

    [_thumbnail_id] => Array
        (
            [0] => 21355276
        )

)

  • Bedrooms: 1
  • Full Baths: 1
  • Land Area (sf): 99,796
  • Living (sf): 600
  • Year Built: 1977
  • Building Name: Waikiki Banyan

  • Property Condition: Excellent
  • Number of Parking Spaces: 1
  • Number of Stories: 21+
  • View: Ocean,Sunset
  • Listing Office: Midway Realty LLC

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

  • Elementary School: Jefferson
  • Middle School: Washington
  • High School: Kaimuki

CONTACT US

Marcus Realty

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