Very spacious and fully furnished 1 bedroom 1 bath corner unit with 1 covered parking stall available in Tower 2 of the popular Waikiki Banyan. Enjoy an amazing mountain and sunrise view. The unit is nicely decorated and upgraded, with no popcorn ceiling. The unit doesn’t have NUC, but currently Banyan has a court order letter that allows to do STR (less than 30 days) in the building. It’s managed by Midway Realty LLC as a vacation rental, great potential income, best for investing. The condo is located within walking distance to the ocean, beach, nearby lots of restaurants, shopping centers, and entertainment. Enjoy great resort amenities such as a large pool, 2-jacuzzies, BBQ area, a playground, sauna, coffee shop, minimart, and more. Very reasonable HOA fees include electricity, cable TV, Internet, Water, and Sewer. Special assessment for recreation deck upgrades is currently $460 per month till the end of 2022 (12 months). The recreation deck is partially under the renovation. This unit doesn’t have Becker Sandwich Lease, the seller paid off the whole amount.
Listing by: Midway Realty LLC (808) 226-1604
array(178) {
["agency"]=>
array(1) {
[0]=>
string(17) "Midway Realty LLC"
}
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "423400.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "106600.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "530000.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(21) "Pets Allowed (Verify)"
}
["elementary_school"]=>
array(1) {
[0]=>
string(9) "Jefferson"
}
["floor_covering"]=>
array(1) {
[0]=>
string(21) "Ceramic Tile,Laminate"
}
["frontage"]=>
array(1) {
[0]=>
string(5) "Ocean"
}
["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(10) "Land Court"
}
["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) "2022-03-27"
}
["list_office_name"]=>
array(1) {
[0]=>
string(17) "Midway Realty LLC"
}
["list_price"]=>
array(1) {
[0]=>
string(9) "630000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(3) "661"
}
["location"]=>
array(1) {
[0]=>
string(45) "201 Ohua Avenue Unit 3213, Honolulu, HI 96815"
}
["maintenance_fees"]=>
array(1) {
[0]=>
string(6) "593.00"
}
["middle_school"]=>
array(1) {
[0]=>
string(10) "Washington"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202205615"
}
["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(36) "Covered - 1,Secured Entry,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_community_name"]=>
array(1) {
[0]=>
string(19) "AOAO Waikiki Banyan"
}
["rets_association_fee_2"]=>
array(1) {
[0]=>
string(3) "460"
}
["rets_association_fee_total"]=>
array(1) {
[0]=>
string(4) "1053"
}
["rets_association_phone"]=>
array(1) {
[0]=>
string(12) "808-922-7172"
}
["rets_auction_date"]=>
array(1) {
[0]=>
string(10) "2022-03-27"
}
["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) 226-1604"
}
["rets_co_list_agent_email"]=>
array(1) {
[0]=>
string(26) "aiuna.realestate@gmail.com"
}
["rets_co_list_agent_full_name"]=>
array(1) {
[0]=>
string(14) "Aiuna Radnaeva"
}
["rets_co_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "51417"
}
["rets_co_list_agent_mui"]=>
array(1) {
[0]=>
string(8) "15946734"
}
["rets_co_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "GHIS"
}
["rets_co_list_office_mui"]=>
array(1) {
[0]=>
string(7) "3486530"
}
["rets_co_list_office_name"]=>
array(1) {
[0]=>
string(17) "Midway Realty LLC"
}
["rets_co_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 226-1604"
}
["rets_condo_parking_unit"]=>
array(1) {
[0]=>
string(10) "unassigned"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(9) "630000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(2) "35"
}
["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) "4"
}
["rets_floor_number"]=>
array(1) {
[0]=>
string(2) "32"
}
["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) "16528266"
}
["rets_immoviewer_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_internet_automated_valuation_dis"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_internet_consumer_comment_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["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) "630000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-03-27"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(8) "99796.00"
}
["rets_maintenance_expense"]=>
array(1) {
[0]=>
string(6) "593.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) "2022-06-29T09:14:33.420"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16528266"
}
["rets_middle_or_junior_school"]=>
array(1) {
[0]=>
string(10) "Washington"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202205615"
}
["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) "2022-03-27T07:03:31.173"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(9) "630000.00"
}
["rets_owner_occupancy_percentage"]=>
array(1) {
[0]=>
string(2) "19"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-2-6-025-005-0791"
}
["rets_parking_additional"]=>
array(1) {
[0]=>
string(1) "1"
}
["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) "24"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-03-27T07:03:31.173"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96815"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-03-27T07:03:31.173"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16528266"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(684) "Please email/text Aiuna for all showing requests and questions. The unit is managed by Midway Realty LLC, interested in continuing to manage it. Showings will be available between guest check-in and check-out. This particular unit is constantly booked out. Please add As Is and Short-term Rentals Disclosure addendums. The unit doesn't have NUC, but currently, Banyan has a court order letter that allows doing STR (less than 30 days) in the building. For more detailed information, send an email to the co-listing agent or can also verify with Banyan Management Office. Please consider Kelena Palencia from Title Guaranty Kailua Branch, (808) 373-6188 / Kelena.Palencia@tghawaii.com."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(1081) "Very spacious and fully furnished 1 bedroom 1 bath corner unit with 1 covered parking stall available in Tower 2 of the popular Waikiki Banyan. Enjoy an amazing mountain and sunrise view. The unit is nicely decorated and upgraded, with no popcorn ceiling. The unit doesn't have NUC, but currently Banyan has a court order letter that allows to do STR (less than 30 days) in the building. It's managed by Midway Realty LLC as a vacation rental, great potential income, best for investing. The condo is located within walking distance to the ocean, beach, nearby lots of restaurants, shopping centers, and entertainment. Enjoy great resort amenities such as a large pool, 2-jacuzzies, BBQ area, a playground, sauna, coffee shop, minimart, and more. Very reasonable HOA fees include electricity, cable TV, Internet, Water, and Sewer. Special assessment for recreation deck upgrades is currently $460 per month till the end of 2022 (12 months). The recreation deck is partially under the renovation. This unit doesn't have Becker Sandwich Lease, the seller paid off the whole amount."
}
["rets_room_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(2) "67"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(3) "594"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(3) "661"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-29T09:14:33.420"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-06-29"
}
["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.821078$94.97$13.33$1.00$CAoSLEFGMVFpcFBITWN3TWFUQU1uUXAyQXJEVEh3dmliejRyWFFiUDBUSVFkdmE3"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(2) "3%"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "155.00"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "1860.00"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "530000.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "423400.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) "2021"
}
["rets_thumbnail_url"]=>
array(1) {
[0]=>
string(81) "https://cdn.rets.ci/marcusrealty-images/16528266/3c60b6133bc32b915b1114cc55fbb265"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "126"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(3) "791"
}
["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(4) "3213"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1977"
}
["security"]=>
array(1) {
[0]=>
string(21) "Security Patrol,Video"
}
["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-0791"
}
["unit"]=>
array(1) {
[0]=>
string(20) "Corner/End,Odd# Unit"
}
["unit_number"]=>
array(1) {
[0]=>
string(4) "3213"
}
["view"]=>
array(1) {
[0]=>
string(46) "City,Golf Course,Marina/Canal,Mountain,Sunrise"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16528266"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202205615"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1656530119"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1977"
}
["zoning"]=>
array(1) {
[0]=>
string(23) "X2 - Apartment Precinct"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(5253) "a:315:{i:0;i:21898650;i:1;i:21898651;i:2;i:21898652;i:3;i:21898653;i:4;i:21898654;i:5;i:21898655;i:6;i:21898656;i:7;i:21898657;i:8;i:21898658;i:9;i:21898659;i:10;i:21898660;i:11;i:21898661;i:12;i:21898662;i:13;i:21898663;i:14;i:21898664;i:15;i:21898665;i:16;i:21898666;i:17;i:21898667;i:18;i:21898668;i:19;i:21898669;i:20;i:21898670;i:21;i:21902996;i:22;i:21902997;i:23;i:21902998;i:24;i:21902999;i:25;i:21903000;i:26;i:21903001;i:27;i:21903002;i:28;i:21903003;i:29;i:21903004;i:30;i:21903005;i:31;i:21903006;i:32;i:21903007;i:33;i:21903008;i:34;i:21903009;i:35;i:21903010;i:36;i:21903011;i:37;i:21903012;i:38;i:21903013;i:39;i:21903014;i:40;i:21903015;i:41;i:21903016;i:42;i:21908461;i:43;i:21908462;i:44;i:21908463;i:45;i:21908464;i:46;i:21908465;i:47;i:21908466;i:48;i:21908467;i:49;i:21908468;i:50;i:21908469;i:51;i:21908470;i:52;i:21908471;i:53;i:21908472;i:54;i:21908473;i:55;i:21908474;i:56;i:21908475;i:57;i:21908476;i:58;i:21908477;i:59;i:21908478;i:60;i:21908479;i:61;i:21908480;i:62;i:21908481;i:63;i:21914598;i:64;i:21914599;i:65;i:21914600;i:66;i:21914601;i:67;i:21914602;i:68;i:21914603;i:69;i:21914604;i:70;i:21914605;i:71;i:21914606;i:72;i:21914607;i:73;i:21914608;i:74;i:21914609;i:75;i:21914610;i:76;i:21914611;i:77;i:21914612;i:78;i:21914613;i:79;i:21914614;i:80;i:21914615;i:81;i:21914616;i:82;i:21914617;i:83;i:21914618;i:84;i:21914619;i:85;i:21914620;i:86;i:21914621;i:87;i:21914622;i:88;i:21914623;i:89;i:21914624;i:90;i:21914625;i:91;i:21914626;i:92;i:21914627;i:93;i:21914628;i:94;i:21914629;i:95;i:21914630;i:96;i:21914631;i:97;i:21914632;i:98;i:21914633;i:99;i:21914634;i:100;i:21914635;i:101;i:21914636;i:102;i:21914637;i:103;i:21914638;i:104;i:21914639;i:105;i:21921488;i:106;i:21921489;i:107;i:21921490;i:108;i:21921491;i:109;i:21921492;i:110;i:21921493;i:111;i:21921494;i:112;i:21921495;i:113;i:21921496;i:114;i:21921497;i:115;i:21921498;i:116;i:21921499;i:117;i:21921500;i:118;i:21921501;i:119;i:21921502;i:120;i:21921503;i:121;i:21921504;i:122;i:21921505;i:123;i:21921506;i:124;i:21921507;i:125;i:21921508;i:126;i:21931755;i:127;i:21931756;i:128;i:21931757;i:129;i:21931758;i:130;i:21931759;i:131;i:21931760;i:132;i:21931761;i:133;i:21931762;i:134;i:21931763;i:135;i:21931764;i:136;i:21931765;i:137;i:21931766;i:138;i:21931767;i:139;i:21931768;i:140;i:21931769;i:141;i:21931770;i:142;i:21931771;i:143;i:21931772;i:144;i:21931773;i:145;i:21931774;i:146;i:21931775;i:147;i:21942588;i:148;i:21942589;i:149;i:21942590;i:150;i:21942591;i:151;i:21942592;i:152;i:21942593;i:153;i:21942594;i:154;i:21942595;i:155;i:21942596;i:156;i:21942597;i:157;i:21942598;i:158;i:21942599;i:159;i:21942600;i:160;i:21942601;i:161;i:21942602;i:162;i:21942603;i:163;i:21942604;i:164;i:21942605;i:165;i:21942606;i:166;i:21942607;i:167;i:21942608;i:168;i:21986074;i:169;i:21986075;i:170;i:21986076;i:171;i:21986077;i:172;i:21986078;i:173;i:21986079;i:174;i:21986080;i:175;i:21986081;i:176;i:21986082;i:177;i:21986083;i:178;i:21986084;i:179;i:21986085;i:180;i:21986086;i:181;i:21986087;i:182;i:21986088;i:183;i:21986089;i:184;i:21986090;i:185;i:21986091;i:186;i:21986092;i:187;i:21986093;i:188;i:21986094;i:189;i:21993625;i:190;i:21993626;i:191;i:21993627;i:192;i:21993628;i:193;i:21993629;i:194;i:21993630;i:195;i:21993631;i:196;i:21993632;i:197;i:21993633;i:198;i:21993634;i:199;i:21993635;i:200;i:21993636;i:201;i:21993637;i:202;i:21993638;i:203;i:21993639;i:204;i:21993640;i:205;i:21993641;i:206;i:21993642;i:207;i:21993643;i:208;i:21993644;i:209;i:21993645;i:210;i:22034878;i:211;i:22034879;i:212;i:22034880;i:213;i:22034881;i:214;i:22034882;i:215;i:22034883;i:216;i:22034884;i:217;i:22034885;i:218;i:22034886;i:219;i:22034887;i:220;i:22034888;i:221;i:22034889;i:222;i:22034890;i:223;i:22034891;i:224;i:22034892;i:225;i:22034893;i:226;i:22034894;i:227;i:22034895;i:228;i:22034896;i:229;i:22034897;i:230;i:22034898;i:231;i:22064435;i:232;i:22064436;i:233;i:22064437;i:234;i:22064438;i:235;i:22064439;i:236;i:22064440;i:237;i:22064441;i:238;i:22064442;i:239;i:22064443;i:240;i:22064444;i:241;i:22064445;i:242;i:22064446;i:243;i:22064447;i:244;i:22064448;i:245;i:22064449;i:246;i:22064450;i:247;i:22064451;i:248;i:22064452;i:249;i:22064453;i:250;i:22064454;i:251;i:22064455;i:252;i:22116801;i:253;i:22116802;i:254;i:22116803;i:255;i:22116804;i:256;i:22116805;i:257;i:22116806;i:258;i:22116807;i:259;i:22116808;i:260;i:22116809;i:261;i:22116810;i:262;i:22116811;i:263;i:22116812;i:264;i:22116813;i:265;i:22116814;i:266;i:22116815;i:267;i:22116816;i:268;i:22116817;i:269;i:22116818;i:270;i:22116819;i:271;i:22116820;i:272;i:22116821;i:273;i:22130766;i:274;i:22130767;i:275;i:22130768;i:276;i:22130769;i:277;i:22130770;i:278;i:22130771;i:279;i:22130772;i:280;i:22130773;i:281;i:22130774;i:282;i:22130775;i:283;i:22130776;i:284;i:22130777;i:285;i:22130778;i:286;i:22130779;i:287;i:22130780;i:288;i:22130781;i:289;i:22130782;i:290;i:22130783;i:291;i:22130784;i:292;i:22130785;i:293;i:22130786;i:294;i:22572977;i:295;i:22572978;i:296;i:22572979;i:297;i:22572980;i:298;i:22572981;i:299;i:22572982;i:300;i:22572983;i:301;i:22572984;i:302;i:22572985;i:303;i:22572986;i:304;i:22572987;i:305;i:22572988;i:306;i:22572989;i:307;i:22572990;i:308;i:22572991;i:309;i:22572992;i:310;i:22572993;i:311;i:22572994;i:312;i:22572995;i:313;i:22572996;i:314;i:22572997;}"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(4) "2016"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "2016"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-04-30"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-06-29"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(9) "630000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-07-31"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-06-29"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 792-3910"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(19) "lizb@bhhshawaii.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(9) "Liz Bills"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "50474"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(8) "15250534"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(6) "BHHR02"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(8) "10102444"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(30) "Berkshire Hathaway HmSvc HI RE"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 792-3910"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "22572977"
}
}
Array
(
[agency] => Array
(
[0] => Midway Realty LLC
)
[assd_val_imprv] => Array
(
[0] => 423400.00
)
[assd_val_land] => Array
(
[0] => 106600.00
)
[assd_val_total] => Array
(
[0] => 530000.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] => Pets Allowed (Verify)
)
[elementary_school] => Array
(
[0] => Jefferson
)
[floor_covering] => Array
(
[0] => Ceramic Tile,Laminate
)
[frontage] => Array
(
[0] => Ocean
)
[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] => Land Court
)
[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] => 2022-03-27
)
[list_office_name] => Array
(
[0] => Midway Realty LLC
)
[list_price] => Array
(
[0] => 630000.00
)
[living_sf] => Array
(
[0] => 661
)
[location] => Array
(
[0] => 201 Ohua Avenue Unit 3213, Honolulu, HI 96815
)
[maintenance_fees] => Array
(
[0] => 593.00
)
[middle_school] => Array
(
[0] => Washington
)
[mls_] => Array
(
[0] => 202205615
)
[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,Secured Entry,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_community_name] => Array
(
[0] => AOAO Waikiki Banyan
)
[rets_association_fee_2] => Array
(
[0] => 460
)
[rets_association_fee_total] => Array
(
[0] => 1053
)
[rets_association_phone] => Array
(
[0] => 808-922-7172
)
[rets_auction_date] => Array
(
[0] => 2022-03-27
)
[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) 226-1604
)
[rets_co_list_agent_email] => Array
(
[0] => aiuna.realestate@gmail.com
)
[rets_co_list_agent_full_name] => Array
(
[0] => Aiuna Radnaeva
)
[rets_co_list_agent_mlsid] => Array
(
[0] => 51417
)
[rets_co_list_agent_mui] => Array
(
[0] => 15946734
)
[rets_co_list_office_mlsid] => Array
(
[0] => GHIS
)
[rets_co_list_office_mui] => Array
(
[0] => 3486530
)
[rets_co_list_office_name] => Array
(
[0] => Midway Realty LLC
)
[rets_co_list_office_phone] => Array
(
[0] => (808) 226-1604
)
[rets_condo_parking_unit] => Array
(
[0] => unassigned
)
[rets_current_price] => Array
(
[0] => 630000.00
)
[rets_dom] => Array
(
[0] => 35
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_elementary_school] => Array
(
[0] => Jefferson
)
[rets_elevators_number_of] => Array
(
[0] => 4
)
[rets_floor_number] => Array
(
[0] => 32
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_high_school] => Array
(
[0] => Kaimuki
)
[rets_id] => Array
(
[0] => 16528266
)
[rets_immoviewer_yn] => Array
(
[0] => 0
)
[rets_internet_automated_valuation_dis] => Array
(
[0] => 1
)
[rets_internet_consumer_comment_yn] => Array
(
[0] => 1
)
[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] => 630000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-03-27
)
[rets_lot_size_area] => Array
(
[0] => 99796.00
)
[rets_maintenance_expense] => Array
(
[0] => 593.00
)
[rets_management_company_name] => Array
(
[0] => Hawaiiana
)
[rets_management_company_phone] => Array
(
[0] => 808-593-9100
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-06-29T09:14:33.420
)
[rets_matrix_unique_id] => Array
(
[0] => 16528266
)
[rets_middle_or_junior_school] => Array
(
[0] => Washington
)
[rets_mls_number] => Array
(
[0] => 202205615
)
[rets_neighbourhood] => Array
(
[0] => WAIKIKI
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-03-27T07:03:31.173
)
[rets_original_list_price] => Array
(
[0] => 630000.00
)
[rets_owner_occupancy_percentage] => Array
(
[0] => 19
)
[rets_parcel_number] => Array
(
[0] => 1-2-6-025-005-0791
)
[rets_parking_additional] => Array
(
[0] => 1
)
[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] => 24
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2022-03-27T07:03:31.173
)
[rets_postal_code] => Array
(
[0] => 96815
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-03-27T07:03:31.173
)
[rets_primary_key] => Array
(
[0] => 16528266
)
[rets_private_remarks] => Array
(
[0] => Please email/text Aiuna for all showing requests and questions. The unit is managed by Midway Realty LLC, interested in continuing to manage it. Showings will be available between guest check-in and check-out. This particular unit is constantly booked out. Please add As Is and Short-term Rentals Disclosure addendums. The unit doesn't have NUC, but currently, Banyan has a court order letter that allows doing STR (less than 30 days) in the building. For more detailed information, send an email to the co-listing agent or can also verify with Banyan Management Office. Please consider Kelena Palencia from Title Guaranty Kailua Branch, (808) 373-6188 / Kelena.Palencia@tghawaii.com.
)
[rets_public_remarks] => Array
(
[0] => Very spacious and fully furnished 1 bedroom 1 bath corner unit with 1 covered parking stall available in Tower 2 of the popular Waikiki Banyan. Enjoy an amazing mountain and sunrise view. The unit is nicely decorated and upgraded, with no popcorn ceiling. The unit doesn't have NUC, but currently Banyan has a court order letter that allows to do STR (less than 30 days) in the building. It's managed by Midway Realty LLC as a vacation rental, great potential income, best for investing. The condo is located within walking distance to the ocean, beach, nearby lots of restaurants, shopping centers, and entertainment. Enjoy great resort amenities such as a large pool, 2-jacuzzies, BBQ area, a playground, sauna, coffee shop, minimart, and more. Very reasonable HOA fees include electricity, cable TV, Internet, Water, and Sewer. Special assessment for recreation deck upgrades is currently $460 per month till the end of 2022 (12 months). The recreation deck is partially under the renovation. This unit doesn't have Becker Sandwich Lease, the seller paid off the whole amount.
)
[rets_room_count] => Array
(
[0] => 0
)
[rets_sqft_lanai_open] => Array
(
[0] => 67
)
[rets_sqft_roofed_living] => Array
(
[0] => 594
)
[rets_sqft_total] => Array
(
[0] => 661
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-06-29T09:14:33.420
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-06-29
)
[rets_street_name] => Array
(
[0] => Ohua
)
[rets_street_number] => Array
(
[0] => 201
)
[rets_street_view_param] => Array
(
[0] => 1$21.274757$-157.821078$94.97$13.33$1.00$CAoSLEFGMVFpcFBITWN3TWFUQU1uUXAyQXJEVEh3dmliejRyWFFiUDBUSVFkdmE3
)
[rets_sub_agency_compensation] => Array
(
[0] => 3%
)
[rets_tax_amount] => Array
(
[0] => 155.00
)
[rets_tax_annual_amount] => Array
(
[0] => 1860.00
)
[rets_tax_assessed_value] => Array
(
[0] => 530000.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 423400.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] => 2021
)
[rets_thumbnail_url] => Array
(
[0] => https://cdn.rets.ci/marcusrealty-images/16528266/3c60b6133bc32b915b1114cc55fbb265
)
[rets_tmk_area] => Array
(
[0] => 126
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 791
)
[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] => 3213
)
[rets_year_built] => Array
(
[0] => 1977
)
[security] => Array
(
[0] => Security Patrol,Video
)
[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-0791
)
[unit] => Array
(
[0] => Corner/End,Odd# Unit
)
[unit_number] => Array
(
[0] => 3213
)
[view] => Array
(
[0] => City,Golf Course,Marina/Canal,Mountain,Sunrise
)
[wpp::rets_pk] => Array
(
[0] => 16528266
)
[wpp_gpid] => Array
(
[0] => 202205615
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1656530119
)
[year_built] => Array
(
[0] => 1977
)
[zoning] => Array
(
[0] => X2 - Apartment Precinct
)
[new_attached_media] => Array
(
[0] => a:315:{i:0;i:21898650;i:1;i:21898651;i:2;i:21898652;i:3;i:21898653;i:4;i:21898654;i:5;i:21898655;i:6;i:21898656;i:7;i:21898657;i:8;i:21898658;i:9;i:21898659;i:10;i:21898660;i:11;i:21898661;i:12;i:21898662;i:13;i:21898663;i:14;i:21898664;i:15;i:21898665;i:16;i:21898666;i:17;i:21898667;i:18;i:21898668;i:19;i:21898669;i:20;i:21898670;i:21;i:21902996;i:22;i:21902997;i:23;i:21902998;i:24;i:21902999;i:25;i:21903000;i:26;i:21903001;i:27;i:21903002;i:28;i:21903003;i:29;i:21903004;i:30;i:21903005;i:31;i:21903006;i:32;i:21903007;i:33;i:21903008;i:34;i:21903009;i:35;i:21903010;i:36;i:21903011;i:37;i:21903012;i:38;i:21903013;i:39;i:21903014;i:40;i:21903015;i:41;i:21903016;i:42;i:21908461;i:43;i:21908462;i:44;i:21908463;i:45;i:21908464;i:46;i:21908465;i:47;i:21908466;i:48;i:21908467;i:49;i:21908468;i:50;i:21908469;i:51;i:21908470;i:52;i:21908471;i:53;i:21908472;i:54;i:21908473;i:55;i:21908474;i:56;i:21908475;i:57;i:21908476;i:58;i:21908477;i:59;i:21908478;i:60;i:21908479;i:61;i:21908480;i:62;i:21908481;i:63;i:21914598;i:64;i:21914599;i:65;i:21914600;i:66;i:21914601;i:67;i:21914602;i:68;i:21914603;i:69;i:21914604;i:70;i:21914605;i:71;i:21914606;i:72;i:21914607;i:73;i:21914608;i:74;i:21914609;i:75;i:21914610;i:76;i:21914611;i:77;i:21914612;i:78;i:21914613;i:79;i:21914614;i:80;i:21914615;i:81;i:21914616;i:82;i:21914617;i:83;i:21914618;i:84;i:21914619;i:85;i:21914620;i:86;i:21914621;i:87;i:21914622;i:88;i:21914623;i:89;i:21914624;i:90;i:21914625;i:91;i:21914626;i:92;i:21914627;i:93;i:21914628;i:94;i:21914629;i:95;i:21914630;i:96;i:21914631;i:97;i:21914632;i:98;i:21914633;i:99;i:21914634;i:100;i:21914635;i:101;i:21914636;i:102;i:21914637;i:103;i:21914638;i:104;i:21914639;i:105;i:21921488;i:106;i:21921489;i:107;i:21921490;i:108;i:21921491;i:109;i:21921492;i:110;i:21921493;i:111;i:21921494;i:112;i:21921495;i:113;i:21921496;i:114;i:21921497;i:115;i:21921498;i:116;i:21921499;i:117;i:21921500;i:118;i:21921501;i:119;i:21921502;i:120;i:21921503;i:121;i:21921504;i:122;i:21921505;i:123;i:21921506;i:124;i:21921507;i:125;i:21921508;i:126;i:21931755;i:127;i:21931756;i:128;i:21931757;i:129;i:21931758;i:130;i:21931759;i:131;i:21931760;i:132;i:21931761;i:133;i:21931762;i:134;i:21931763;i:135;i:21931764;i:136;i:21931765;i:137;i:21931766;i:138;i:21931767;i:139;i:21931768;i:140;i:21931769;i:141;i:21931770;i:142;i:21931771;i:143;i:21931772;i:144;i:21931773;i:145;i:21931774;i:146;i:21931775;i:147;i:21942588;i:148;i:21942589;i:149;i:21942590;i:150;i:21942591;i:151;i:21942592;i:152;i:21942593;i:153;i:21942594;i:154;i:21942595;i:155;i:21942596;i:156;i:21942597;i:157;i:21942598;i:158;i:21942599;i:159;i:21942600;i:160;i:21942601;i:161;i:21942602;i:162;i:21942603;i:163;i:21942604;i:164;i:21942605;i:165;i:21942606;i:166;i:21942607;i:167;i:21942608;i:168;i:21986074;i:169;i:21986075;i:170;i:21986076;i:171;i:21986077;i:172;i:21986078;i:173;i:21986079;i:174;i:21986080;i:175;i:21986081;i:176;i:21986082;i:177;i:21986083;i:178;i:21986084;i:179;i:21986085;i:180;i:21986086;i:181;i:21986087;i:182;i:21986088;i:183;i:21986089;i:184;i:21986090;i:185;i:21986091;i:186;i:21986092;i:187;i:21986093;i:188;i:21986094;i:189;i:21993625;i:190;i:21993626;i:191;i:21993627;i:192;i:21993628;i:193;i:21993629;i:194;i:21993630;i:195;i:21993631;i:196;i:21993632;i:197;i:21993633;i:198;i:21993634;i:199;i:21993635;i:200;i:21993636;i:201;i:21993637;i:202;i:21993638;i:203;i:21993639;i:204;i:21993640;i:205;i:21993641;i:206;i:21993642;i:207;i:21993643;i:208;i:21993644;i:209;i:21993645;i:210;i:22034878;i:211;i:22034879;i:212;i:22034880;i:213;i:22034881;i:214;i:22034882;i:215;i:22034883;i:216;i:22034884;i:217;i:22034885;i:218;i:22034886;i:219;i:22034887;i:220;i:22034888;i:221;i:22034889;i:222;i:22034890;i:223;i:22034891;i:224;i:22034892;i:225;i:22034893;i:226;i:22034894;i:227;i:22034895;i:228;i:22034896;i:229;i:22034897;i:230;i:22034898;i:231;i:22064435;i:232;i:22064436;i:233;i:22064437;i:234;i:22064438;i:235;i:22064439;i:236;i:22064440;i:237;i:22064441;i:238;i:22064442;i:239;i:22064443;i:240;i:22064444;i:241;i:22064445;i:242;i:22064446;i:243;i:22064447;i:244;i:22064448;i:245;i:22064449;i:246;i:22064450;i:247;i:22064451;i:248;i:22064452;i:249;i:22064453;i:250;i:22064454;i:251;i:22064455;i:252;i:22116801;i:253;i:22116802;i:254;i:22116803;i:255;i:22116804;i:256;i:22116805;i:257;i:22116806;i:258;i:22116807;i:259;i:22116808;i:260;i:22116809;i:261;i:22116810;i:262;i:22116811;i:263;i:22116812;i:264;i:22116813;i:265;i:22116814;i:266;i:22116815;i:267;i:22116816;i:268;i:22116817;i:269;i:22116818;i:270;i:22116819;i:271;i:22116820;i:272;i:22116821;i:273;i:22130766;i:274;i:22130767;i:275;i:22130768;i:276;i:22130769;i:277;i:22130770;i:278;i:22130771;i:279;i:22130772;i:280;i:22130773;i:281;i:22130774;i:282;i:22130775;i:283;i:22130776;i:284;i:22130777;i:285;i:22130778;i:286;i:22130779;i:287;i:22130780;i:288;i:22130781;i:289;i:22130782;i:290;i:22130783;i:291;i:22130784;i:292;i:22130785;i:293;i:22130786;i:294;i:22572977;i:295;i:22572978;i:296;i:22572979;i:297;i:22572980;i:298;i:22572981;i:299;i:22572982;i:300;i:22572983;i:301;i:22572984;i:302;i:22572985;i:303;i:22572986;i:304;i:22572987;i:305;i:22572988;i:306;i:22572989;i:307;i:22572990;i:308;i:22572991;i:309;i:22572992;i:310;i:22572993;i:311;i:22572994;i:312;i:22572995;i:313;i:22572996;i:314;i:22572997;}
)
[rets_year_remodeled] => Array
(
[0] => 2016
)
[year_remodeled_] => Array
(
[0] => 2016
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-04-30
)
[rets_close_date] => Array
(
[0] => 2022-06-29
)
[rets_close_price] => Array
(
[0] => 630000.00
)
[rets_expiration_date] => Array
(
[0] => 2022-07-31
)
[rets_off_market_date] => Array
(
[0] => 2022-06-29
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 792-3910
)
[rets_selling_agent_email] => Array
(
[0] => lizb@bhhshawaii.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Liz Bills
)
[rets_selling_agent_mlsid] => Array
(
[0] => 50474
)
[rets_selling_agent_mui] => Array
(
[0] => 15250534
)
[rets_selling_office_mlsid] => Array
(
[0] => BHHR02
)
[rets_selling_office_mui] => Array
(
[0] => 10102444
)
[rets_selling_office_name] => Array
(
[0] => Berkshire Hathaway HmSvc HI RE
)
[rets_selling_office_phone] => Array
(
[0] => (808) 792-3910
)
[_thumbnail_id] => Array
(
[0] => 22572977
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446