201 Ohua Avenue Unit 3208
Honolulu, HI 96815

Listing
Overview

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

Welcome to one of Waikiki’s most popular condo resorts, and one of the finest condos on the property! 3208 has been meticulously remodeled and redesigned to capture the beauty of Hawaii and comforts of home. The incredible ocean views from every window are sure to take your breathe away. This high floor unit in desirable Tower 2 is the ideal location for all your wants. Just minutes from Waikiki Beach, shopping, dining, and entertainment, but also just a short elevator ride to an impressive offering of amenities. Onsite laundry, tennis court, swimming pool, sauna, play ground, and BBQ grills. And to top it off, the property comes fully furnished! The high end furnishings were strategically selected to maximize beauty and functionality. The pull-out couch is perfect for sleeping a few more guests! This condo is truly turn key and truly impressive. It is an incredibly successful short term rental, with extremely few openings! Sandwich lease has been paid off.

Listing by: Blue Mango

array(152) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "434100.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "106600.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "540700.00"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["building_name"]=>
  array(1) {
    [0]=>
    string(14) "Waikiki Banyan"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(20) "High-Rise 7+ Stories"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(38) "1031 Exchange,Property Disclosure Stmt"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(12) "Ceramic Tile"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["furnished"]=>
  array(1) {
    [0]=>
    string(4) "Full"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["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(19) "isi@gobluemango.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(9) "Isi M Nau"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 369-9654"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-02"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(10) "Blue Mango"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "699000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(3) "533"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(45) "201 Ohua Avenue Unit 3208, Honolulu, HI 96815"
  }
  ["maintenance_fees"]=>
  array(1) {
    [0]=>
    string(6) "507.00"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202123168"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKIKI"
  }
  ["number_of_parking_spaces"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "NAUP"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(11) "Covered - 1"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(26) "45 Days or Less,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_total"]=>
  array(1) {
    [0]=>
    string(3) "507"
  }
  ["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_condo_parking_unit"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(9) "690000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["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_id"]=>
  array(1) {
    [0]=>
    string(8) "16145017"
  }
  ["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) 369-9654"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(19) "isi@gobluemango.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(9) "Isi M Nau"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "33672"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3479877"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "NAUP"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "10913966"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(10) "Blue Mango"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 369-9654"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(9) "699000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-02"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(8) "99796.00"
  }
  ["rets_maintenance_expense"]=>
  array(1) {
    [0]=>
    string(6) "507.00"
  }
  ["rets_management_company_name"]=>
  array(1) {
    [0]=>
    string(9) "Hawaiiana"
  }
  ["rets_management_company_phone"]=>
  array(1) {
    [0]=>
    string(8) "593-9100"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-10-01T09:43:58.290"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "16145017"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202123168"
  }
  ["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-02T13:27:44.270"
  }
  ["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-0786"
  }
  ["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) "22"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-02T13:39:26.687"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96815"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-02T13:27:44.270"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "16145017"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(323) "Please text or email Isi for showings and property details.  The only showings in September are the 8th, 9th, 20th, 21st, and 22nd.  Financials provided after verification of buyer's preapproval.  We kindly request buyer to honor existing bookings.  The seller is willing to negotiate the payment of the special assessment."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(982) "Welcome to one of Waikiki's most popular condo resorts, and one of the finest condos on the property!  3208 has been meticulously remodeled and redesigned to capture the beauty of Hawaii and comforts of home.  The incredible ocean views from every window are sure to take your breathe away.  This high floor unit in desirable Tower 2 is the ideal location for all your wants.  Just minutes from Waikiki Beach, shopping, dining, and entertainment, but also just a short elevator ride to an impressive offering of amenities.  Onsite laundry, tennis court, swimming pool, sauna, play ground, and BBQ grills.  And to top it off, the property comes fully furnished!  The high end furnishings were strategically selected to maximize beauty and functionality.  The pull-out couch is perfect for sleeping a few more guests!  This condo is truly turn key and truly impressive.  It is an incredibly successful short term rental, with extremely few openings!  Sandwich lease has been paid off."
  }
  ["rets_room_count"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(3) "533"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(3) "533"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-10-01T09:43:58.290"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-10-01"
  }
  ["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(3) "2.5"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "178.00"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "540700.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "434100.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/16145017/9b82aeb67434d76a50e558d9a7f6f3e5"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "126"
  }
  ["rets_tmk_condo_property_regime_number"]=>
  array(1) {
    [0]=>
    string(3) "786"
  }
  ["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) "3208"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1977"
  }
  ["rets_year_remodeled"]=>
  array(1) {
    [0]=>
    string(4) "2017"
  }
  ["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-0786"
  }
  ["unit"]=>
  array(1) {
    [0]=>
    string(10) "Even# Unit"
  }
  ["unit_number"]=>
  array(1) {
    [0]=>
    string(4) "3208"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(15) "Coastline,Ocean"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "16145017"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202123168"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1633117453"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1977"
  }
  ["year_remodeled_"]=>
  array(1) {
    [0]=>
    string(4) "2017"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(23) "X2 - Apartment Precinct"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(2040) "a:126:{i:0;i:20659059;i:1;i:20659060;i:2;i:20659061;i:3;i:20659062;i:4;i:20659063;i:5;i:20659064;i:6;i:20659065;i:7;i:20659066;i:8;i:20659067;i:9;i:20659068;i:10;i:20659069;i:11;i:20659070;i:12;i:20659071;i:13;i:20659072;i:14;i:20659073;i:15;i:20659074;i:16;i:20659075;i:17;i:20659076;i:18;i:20659077;i:19;i:20659078;i:20;i:20659079;i:21;i:20659101;i:22;i:20659102;i:23;i:20659103;i:24;i:20659104;i:25;i:20659105;i:26;i:20659106;i:27;i:20659107;i:28;i:20659108;i:29;i:20659109;i:30;i:20659110;i:31;i:20659111;i:32;i:20659112;i:33;i:20659113;i:34;i:20659114;i:35;i:20659115;i:36;i:20659116;i:37;i:20659117;i:38;i:20659118;i:39;i:20659119;i:40;i:20659120;i:41;i:20659121;i:42;i:20659128;i:43;i:20659129;i:44;i:20659130;i:45;i:20659131;i:46;i:20659132;i:47;i:20659133;i:48;i:20659134;i:49;i:20659135;i:50;i:20659136;i:51;i:20659137;i:52;i:20659138;i:53;i:20659139;i:54;i:20659140;i:55;i:20659141;i:56;i:20659142;i:57;i:20659143;i:58;i:20659144;i:59;i:20659145;i:60;i:20659146;i:61;i:20659147;i:62;i:20659148;i:63;i:20665607;i:64;i:20665608;i:65;i:20665609;i:66;i:20665610;i:67;i:20665611;i:68;i:20665612;i:69;i:20665613;i:70;i:20665614;i:71;i:20665615;i:72;i:20665616;i:73;i:20665617;i:74;i:20665618;i:75;i:20665619;i:76;i:20665620;i:77;i:20665621;i:78;i:20665622;i:79;i:20665623;i:80;i:20665624;i:81;i:20665625;i:82;i:20665626;i:83;i:20665627;i:84;i:20699237;i:85;i:20699238;i:86;i:20699239;i:87;i:20699240;i:88;i:20699241;i:89;i:20699242;i:90;i:20699243;i:91;i:20699244;i:92;i:20699245;i:93;i:20699246;i:94;i:20699247;i:95;i:20699248;i:96;i:20699249;i:97;i:20699250;i:98;i:20699251;i:99;i:20699252;i:100;i:20699253;i:101;i:20699254;i:102;i:20699255;i:103;i:20699256;i:104;i:20699257;i:105;i:20879530;i:106;i:20879531;i:107;i:20879532;i:108;i:20879533;i:109;i:20879534;i:110;i:20879535;i:111;i:20879536;i:112;i:20879537;i:113;i:20879538;i:114;i:20879539;i:115;i:20879540;i:116;i:20879541;i:117;i:20879542;i:118;i:20879543;i:119;i:20879544;i:120;i:20879545;i:121;i:20879546;i:122;i:20879547;i:123;i:20879548;i:124;i:20879549;i:125;i:20879550;}"
  }
  ["rets_pending_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-07"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-10-01"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(9) "690000.00"
  }
  ["rets_concessions"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_expiration_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-10-31"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-10-01"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 254-1515"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(17) "melissa@stott.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(21) "Melissa Marie McGuire"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "35424"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3480547"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "SOLD"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3487550"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(23) "Stott Real Estate, Inc."
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 254-1515"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20879530"
  }
}
Array
(
    [assd_val_imprv] => Array
        (
            [0] => 434100.00
        )

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

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

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

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

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

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

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

    [disclosures] => Array
        (
            [0] => 1031 Exchange,Property Disclosure Stmt
        )

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

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

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

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

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

    [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] => isi@gobluemango.com
        )

    [list_agent_name] => Array
        (
            [0] => Isi M Nau
        )

    [list_agent_phone_number] => Array
        (
            [0] => (808) 369-9654
        )

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

    [list_office_name] => Array
        (
            [0] => Blue Mango
        )

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

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

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

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

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

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

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

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

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

    [possession] => Array
        (
            [0] => 45 Days or Less,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_total] => Array
        (
            [0] => 507
        )

    [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_condo_parking_unit] => Array
        (
            [0] => 1
        )

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

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

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

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

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

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

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

    [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) 369-9654
        )

    [rets_list_agent_email] => Array
        (
            [0] => isi@gobluemango.com
        )

    [rets_list_agent_full_name] => Array
        (
            [0] => Isi M Nau
        )

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

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

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

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

    [rets_list_office_name] => Array
        (
            [0] => Blue Mango
        )

    [rets_list_office_phone] => Array
        (
            [0] => (808) 369-9654
        )

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

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

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

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

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

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

    [rets_matrix_modified_dt] => Array
        (
            [0] => 2021-10-01T09:43:58.290
        )

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

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

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

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

    [rets_original_entry_timestamp] => Array
        (
            [0] => 2021-09-02T13:27:44.270
        )

    [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-0786
        )

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

    [rets_photo_modification_timestamp] => Array
        (
            [0] => 2021-09-02T13:39:26.687
        )

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

    [rets_price_change_timestamp] => Array
        (
            [0] => 2021-09-02T13:27:44.270
        )

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

    [rets_private_remarks] => Array
        (
            [0] => Please text or email Isi for showings and property details.  The only showings in September are the 8th, 9th, 20th, 21st, and 22nd.  Financials provided after verification of buyer's preapproval.  We kindly request buyer to honor existing bookings.  The seller is willing to negotiate the payment of the special assessment.
        )

    [rets_public_remarks] => Array
        (
            [0] => Welcome to one of Waikiki's most popular condo resorts, and one of the finest condos on the property!  3208 has been meticulously remodeled and redesigned to capture the beauty of Hawaii and comforts of home.  The incredible ocean views from every window are sure to take your breathe away.  This high floor unit in desirable Tower 2 is the ideal location for all your wants.  Just minutes from Waikiki Beach, shopping, dining, and entertainment, but also just a short elevator ride to an impressive offering of amenities.  Onsite laundry, tennis court, swimming pool, sauna, play ground, and BBQ grills.  And to top it off, the property comes fully furnished!  The high end furnishings were strategically selected to maximize beauty and functionality.  The pull-out couch is perfect for sleeping a few more guests!  This condo is truly turn key and truly impressive.  It is an incredibly successful short term rental, with extremely few openings!  Sandwich lease has been paid off.
        )

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

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

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

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

    [rets_status_change_timestamp] => Array
        (
            [0] => 2021-10-01T09:43:58.290
        )

    [rets_status_contractual_search_date] => Array
        (
            [0] => 2021-10-01
        )

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

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

    [rets_tax_assessed_value_improvements] => Array
        (
            [0] => 434100.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/16145017/9b82aeb67434d76a50e558d9a7f6f3e5
        )

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

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

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

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

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

    [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-0786
        )

    [unit] => Array
        (
            [0] => Even# Unit
        )

    [unit_number] => Array
        (
            [0] => 3208
        )

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

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

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

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

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

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

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

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

    [new_attached_media] => Array
        (
            [0] => a:126:{i:0;i:20659059;i:1;i:20659060;i:2;i:20659061;i:3;i:20659062;i:4;i:20659063;i:5;i:20659064;i:6;i:20659065;i:7;i:20659066;i:8;i:20659067;i:9;i:20659068;i:10;i:20659069;i:11;i:20659070;i:12;i:20659071;i:13;i:20659072;i:14;i:20659073;i:15;i:20659074;i:16;i:20659075;i:17;i:20659076;i:18;i:20659077;i:19;i:20659078;i:20;i:20659079;i:21;i:20659101;i:22;i:20659102;i:23;i:20659103;i:24;i:20659104;i:25;i:20659105;i:26;i:20659106;i:27;i:20659107;i:28;i:20659108;i:29;i:20659109;i:30;i:20659110;i:31;i:20659111;i:32;i:20659112;i:33;i:20659113;i:34;i:20659114;i:35;i:20659115;i:36;i:20659116;i:37;i:20659117;i:38;i:20659118;i:39;i:20659119;i:40;i:20659120;i:41;i:20659121;i:42;i:20659128;i:43;i:20659129;i:44;i:20659130;i:45;i:20659131;i:46;i:20659132;i:47;i:20659133;i:48;i:20659134;i:49;i:20659135;i:50;i:20659136;i:51;i:20659137;i:52;i:20659138;i:53;i:20659139;i:54;i:20659140;i:55;i:20659141;i:56;i:20659142;i:57;i:20659143;i:58;i:20659144;i:59;i:20659145;i:60;i:20659146;i:61;i:20659147;i:62;i:20659148;i:63;i:20665607;i:64;i:20665608;i:65;i:20665609;i:66;i:20665610;i:67;i:20665611;i:68;i:20665612;i:69;i:20665613;i:70;i:20665614;i:71;i:20665615;i:72;i:20665616;i:73;i:20665617;i:74;i:20665618;i:75;i:20665619;i:76;i:20665620;i:77;i:20665621;i:78;i:20665622;i:79;i:20665623;i:80;i:20665624;i:81;i:20665625;i:82;i:20665626;i:83;i:20665627;i:84;i:20699237;i:85;i:20699238;i:86;i:20699239;i:87;i:20699240;i:88;i:20699241;i:89;i:20699242;i:90;i:20699243;i:91;i:20699244;i:92;i:20699245;i:93;i:20699246;i:94;i:20699247;i:95;i:20699248;i:96;i:20699249;i:97;i:20699250;i:98;i:20699251;i:99;i:20699252;i:100;i:20699253;i:101;i:20699254;i:102;i:20699255;i:103;i:20699256;i:104;i:20699257;i:105;i:20879530;i:106;i:20879531;i:107;i:20879532;i:108;i:20879533;i:109;i:20879534;i:110;i:20879535;i:111;i:20879536;i:112;i:20879537;i:113;i:20879538;i:114;i:20879539;i:115;i:20879540;i:116;i:20879541;i:117;i:20879542;i:118;i:20879543;i:119;i:20879544;i:120;i:20879545;i:121;i:20879546;i:122;i:20879547;i:123;i:20879548;i:124;i:20879549;i:125;i:20879550;}
        )

    [rets_pending_date] => Array
        (
            [0] => 2021-09-07
        )

    [rets_close_date] => Array
        (
            [0] => 2021-10-01
        )

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

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

    [rets_expiration_date] => Array
        (
            [0] => 2021-10-31
        )

    [rets_off_market_date] => Array
        (
            [0] => 2021-10-01
        )

    [rets_selling_agent_direct_work_phone] => Array
        (
            [0] => (808) 254-1515
        )

    [rets_selling_agent_email] => Array
        (
            [0] => melissa@stott.com
        )

    [rets_selling_agent_full_name] => Array
        (
            [0] => Melissa Marie McGuire
        )

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

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

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

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

    [rets_selling_office_name] => Array
        (
            [0] => Stott Real Estate, Inc.
        )

    [rets_selling_office_phone] => Array
        (
            [0] => (808) 254-1515
        )

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

)

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

  • Property Condition: Excellent
  • Number of Parking Spaces: 1
  • View: Coastline,Ocean
  • Listing Office: Blue Mango

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

CONTACT US

Marcus Realty

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