Highly desired turnkey Legal Vacation Rental Investment Townhome at Turtle Bay Resort in Kuilima Estates West. Townhome is located in the “Gold Coast of the property” at the first hole of Turtle Bay Golf Course on the world famous North Shore of Oahu. This 2 bedroom 2 bath 1 parking with loft that has been enclosed and may serve as a den/office/bedroom, was last remodeled and refurbished in 2010 with three air conditioned bedrooms sleeps up to 8 in beds (6 in framed beds, two twin floor mattresses). Kuilima Estates West offers 3 Pools, Charcoal BBQ’s, Two Tennis Courts, Visitor Parking, gated community and 24 hour security. Property is Turnkey and comes with all furnishings and future bookings. Details to be provided with approved buyer.
Listing by: Corcoran Pacific Properties
array(163) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "552100.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "226600.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "778700.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "2"
}
["building_name"]=>
array(1) {
[0]=>
string(17) "Kuilima Ests West"
}
["building_style"]=>
array(1) {
[0]=>
string(9) "Townhouse"
}
["city"]=>
array(1) {
[0]=>
string(6) "Kahuku"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(4) "None"
}
["floor_covering"]=>
array(1) {
[0]=>
string(16) "Other,W/W Carpet"
}
["frontage"]=>
array(1) {
[0]=>
string(11) "Golf Course"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "2"
}
["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(9) "765523.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(29) "rich@goldenpineapplegroup.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(17) "Richard M DeGutis"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 589-2040"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-03-08"
}
["list_office_name"]=>
array(1) {
[0]=>
string(27) "Corcoran Pacific Properties"
}
["list_price"]=>
array(1) {
[0]=>
string(10) "1700000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "1199"
}
["location"]=>
array(1) {
[0]=>
string(46) "57-101 Kuilima Drive Unit 45, Kahuku, HI 96731"
}
["maintenance_fees"]=>
array(1) {
[0]=>
string(6) "831.11"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202204495"
}
["neighborhood"]=>
array(1) {
[0]=>
string(7) "KUILIMA"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "1"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(3) "Two"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "ELIT"
}
["parking_features"]=>
array(1) {
[0]=>
string(28) "Assigned,Guest,Secured Entry"
}
["possession"]=>
array(1) {
[0]=>
string(10) "At Closing"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96731"
}
["property_condition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["property_type"]=>
array(1) {
[0]=>
string(15) "condo_townhouse"
}
["property_type_label"]=>
array(1) {
[0]=>
string(15) "Condo Townhouse"
}
["region"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["rets_association_fee_total"]=>
array(1) {
[0]=>
string(3) "831"
}
["rets_baths_full"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_baths_half"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_baths_total"]=>
array(1) {
[0]=>
string(4) "2.00"
}
["rets_beds_total"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_building_name"]=>
array(1) {
[0]=>
string(17) "Kuilima Ests West"
}
["rets_city"]=>
array(1) {
[0]=>
string(6) "Kahuku"
}
["rets_compensation_method"]=>
array(1) {
[0]=>
string(1) "%"
}
["rets_condo_parking_unit"]=>
array(1) {
[0]=>
string(2) "45"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(10) "1700000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(1) "7"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_floor_number"]=>
array(1) {
[0]=>
string(1) "2"
}
["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) "16489154"
}
["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) 589-2040"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(29) "rich@goldenpineapplegroup.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(17) "Richard M DeGutis"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "44673"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "9215498"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "ELIT"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(7) "3486767"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(27) "Corcoran Pacific Properties"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 589-2040"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(10) "1700000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-03-08"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(9) "765523.00"
}
["rets_maintenance_expense"]=>
array(1) {
[0]=>
string(6) "831.11"
}
["rets_management_company_name"]=>
array(1) {
[0]=>
string(14) "Associa Hawaii"
}
["rets_management_company_phone"]=>
array(1) {
[0]=>
string(10) "8088360911"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-05-09T09:08:25.410"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16489154"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202204495"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(7) "KUILIMA"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-03-08T16:28:55.787"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(10) "1700000.00"
}
["rets_owner_occupancy_percentage"]=>
array(1) {
[0]=>
string(2) "18"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-5-7-001-029-0045"
}
["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) "17"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-03-08T16:28:55.787"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96731"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-03-08T16:28:55.787"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16489154"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(440) "Property is occupied with Tenants. Showing on Sunday March 13 between 2pm-4pm. Please call and confirm the appointment. Qualified buyers only with proof. Please include 'As Is' addendum, and consider Briar Nakamoto of TG Hawaii Mililani Branch bnakamoto@tghawaii.com 808-294-3589. Offer's to be received by Monday 3/14 at 5pm. Seller will respond by Tuesday 3/15. Please do not have a deadline for response sooner than Tuesday 3/15 5pm."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(749) "Highly desired turnkey Legal Vacation Rental Investment Townhome at Turtle Bay Resort in Kuilima Estates West. Townhome is located in the "Gold Coast of the property" at the first hole of Turtle Bay Golf Course on the world famous North Shore of Oahu. This 2 bedroom 2 bath 1 parking with loft that has been enclosed and may serve as a den/office/bedroom, was last remodeled and refurbished in 2010 with three air conditioned bedrooms sleeps up to 8 in beds (6 in framed beds, two twin floor mattresses). Kuilima Estates West offers 3 Pools, Charcoal BBQ's, Two Tennis Courts, Visitor Parking, gated community and 24 hour security. Property is Turnkey and comes with all furnishings and future bookings. Details to be provided with approved buyer."
}
["rets_room_count"]=>
array(1) {
[0]=>
string(1) "5"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "1199"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "1199"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-05-09T09:08:25.410"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-05-09"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(7) "Kuilima"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(6) "57-101"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(106) "1$21.704359$-157.997923$125.18$13.33$1.00$CAoSLEFGMVFpcE52SHJxcEo1eG83VTdQRW1IZ0cxS2NidkZJekVNNkk5TTktc1d4"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(3) "2.5"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "215.58"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "2586.96"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "778700.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "552100.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "226600.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/16489154/472aeabcb07f28b7eb691aed0ae83e77"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "157"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(2) "45"
}
["rets_tmk_division"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tmk_parcel"]=>
array(1) {
[0]=>
string(2) "29"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "7"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "5"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_total_actual_rent"]=>
array(1) {
[0]=>
string(8) "12000.00"
}
["rets_unit_number"]=>
array(1) {
[0]=>
string(2) "45"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1973"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(4) "2010"
}
["security"]=>
array(1) {
[0]=>
string(31) "Gated Community,Security Patrol"
}
["state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["street_name"]=>
array(1) {
[0]=>
string(7) "Kuilima"
}
["street_number"]=>
array(1) {
[0]=>
string(6) "57-101"
}
["street_suffix"]=>
array(1) {
[0]=>
string(5) "Drive"
}
["terms_accept"]=>
array(1) {
[0]=>
string(17) "Cash,Conventional"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-5-7-001-029-0045"
}
["unit"]=>
array(1) {
[0]=>
string(55) "Bedroom on 1st Level,Full Bath on 1st Floor,Multi Level"
}
["unit_number"]=>
array(1) {
[0]=>
string(2) "45"
}
["view"]=>
array(1) {
[0]=>
string(24) "Golf Course,Ocean,Sunset"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16489154"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202204495"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1652123340"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1973"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "2010"
}
["zoning"]=>
array(1) {
[0]=>
string(30) "11 - A-1 Low Density Apartment"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(2788) "a:170:{i:0;i:21782742;i:1;i:21782743;i:2;i:21782744;i:3;i:21782745;i:4;i:21782746;i:5;i:21782747;i:6;i:21782748;i:7;i:21782749;i:8;i:21782750;i:9;i:21782751;i:10;i:21782752;i:11;i:21782753;i:12;i:21782754;i:13;i:21782755;i:14;i:21782756;i:15;i:21782757;i:16;i:21782758;i:17;i:21783042;i:18;i:21783043;i:19;i:21783044;i:20;i:21783045;i:21;i:21783046;i:22;i:21783047;i:23;i:21783048;i:24;i:21783049;i:25;i:21783050;i:26;i:21783051;i:27;i:21783052;i:28;i:21783053;i:29;i:21783054;i:30;i:21783055;i:31;i:21783056;i:32;i:21783057;i:33;i:21783058;i:34;i:21788637;i:35;i:21788638;i:36;i:21788639;i:37;i:21788640;i:38;i:21788641;i:39;i:21788642;i:40;i:21788643;i:41;i:21788644;i:42;i:21788645;i:43;i:21788646;i:44;i:21788647;i:45;i:21788648;i:46;i:21788649;i:47;i:21788650;i:48;i:21788651;i:49;i:21788652;i:50;i:21788653;i:51;i:21796771;i:52;i:21796772;i:53;i:21796773;i:54;i:21796774;i:55;i:21796775;i:56;i:21796776;i:57;i:21796777;i:58;i:21796778;i:59;i:21796779;i:60;i:21796780;i:61;i:21796781;i:62;i:21796782;i:63;i:21796783;i:64;i:21796784;i:65;i:21796785;i:66;i:21796786;i:67;i:21796787;i:68;i:21797609;i:69;i:21797610;i:70;i:21797611;i:71;i:21797612;i:72;i:21797613;i:73;i:21797614;i:74;i:21797615;i:75;i:21797616;i:76;i:21797617;i:77;i:21797618;i:78;i:21797619;i:79;i:21797620;i:80;i:21797621;i:81;i:21797622;i:82;i:21797623;i:83;i:21797624;i:84;i:21797625;i:85;i:21802217;i:86;i:21802218;i:87;i:21802219;i:88;i:21802220;i:89;i:21802221;i:90;i:21802222;i:91;i:21802223;i:92;i:21802224;i:93;i:21802225;i:94;i:21802226;i:95;i:21802227;i:96;i:21802228;i:97;i:21802229;i:98;i:21802230;i:99;i:21802231;i:100;i:21802232;i:101;i:21802233;i:102;i:21809884;i:103;i:21809885;i:104;i:21809886;i:105;i:21809887;i:106;i:21809888;i:107;i:21809889;i:108;i:21809890;i:109;i:21809891;i:110;i:21809892;i:111;i:21809893;i:112;i:21809894;i:113;i:21809895;i:114;i:21809896;i:115;i:21809897;i:116;i:21809898;i:117;i:21809899;i:118;i:21809900;i:119;i:21823692;i:120;i:21823693;i:121;i:21823694;i:122;i:21823695;i:123;i:21823696;i:124;i:21823697;i:125;i:21823698;i:126;i:21823699;i:127;i:21823700;i:128;i:21823701;i:129;i:21823702;i:130;i:21823703;i:131;i:21823704;i:132;i:21823705;i:133;i:21823706;i:134;i:21823707;i:135;i:21823708;i:136;i:22160957;i:137;i:22160958;i:138;i:22160959;i:139;i:22160960;i:140;i:22160961;i:141;i:22160962;i:142;i:22160963;i:143;i:22160964;i:144;i:22160965;i:145;i:22160966;i:146;i:22160967;i:147;i:22160968;i:148;i:22160969;i:149;i:22160970;i:150;i:22160971;i:151;i:22160972;i:152;i:22160973;i:153;i:22180838;i:154;i:22180839;i:155;i:22180840;i:156;i:22180841;i:157;i:22180842;i:158;i:22180843;i:159;i:22180844;i:160;i:22180845;i:161;i:22180846;i:162;i:22180847;i:163;i:22180848;i:164;i:22180849;i:165;i:22180850;i:166;i:22180851;i:167;i:22180852;i:168;i:22180853;i:169;i:22180854;}"
}
["rets_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["virtual_tour"]=>
array(1) {
[0]=>
string(28) "https://youtu.be/VsSMF1I-syk"
}
["rets_open_house_count"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_active_open_house_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_open_house_upcoming"]=>
array(1) {
[0]=>
string(0) ""
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-03-14"
}
["rets_pending_date"]=>
array(1) {
[0]=>
string(10) "2022-03-14"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-05-09"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(10) "1700000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-09-07"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-05-09"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 729-7643"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(18) "pmjavier@gmail.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(13) "Paul M Javier"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "34149"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "3480062"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "HSIH"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(8) "13236725"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(22) "HomeSmart Island Homes"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 729-7643"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "22180838"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 552100.00
)
[assd_val_land] => Array
(
[0] => 226600.00
)
[assd_val_total] => Array
(
[0] => 778700.00
)
[bedrooms] => Array
(
[0] => 2
)
[building_name] => Array
(
[0] => Kuilima Ests West
)
[building_style] => Array
(
[0] => Townhouse
)
[city] => Array
(
[0] => Kahuku
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => None
)
[floor_covering] => Array
(
[0] => Other,W/W Carpet
)
[frontage] => Array
(
[0] => Golf Course
)
[full_baths] => Array
(
[0] => 2
)
[furnished] => Array
(
[0] => Full
)
[half_baths] => Array
(
[0] => 0
)
[home_exampt] => Array
(
[0] => 0
)
[land_area_sf] => Array
(
[0] => 765523.00
)
[land_recorded] => Array
(
[0] => Land Court
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => rich@goldenpineapplegroup.com
)
[list_agent_name] => Array
(
[0] => Richard M DeGutis
)
[list_agent_phone_number] => Array
(
[0] => (808) 589-2040
)
[list_date] => Array
(
[0] => 2022-03-08
)
[list_office_name] => Array
(
[0] => Corcoran Pacific Properties
)
[list_price] => Array
(
[0] => 1700000.00
)
[living_sf] => Array
(
[0] => 1199
)
[location] => Array
(
[0] => 57-101 Kuilima Drive Unit 45, Kahuku, HI 96731
)
[maintenance_fees] => Array
(
[0] => 831.11
)
[mls_] => Array
(
[0] => 202204495
)
[neighborhood] => Array
(
[0] => KUILIMA
)
[number_of_parking_spaces] => Array
(
[0] => 1
)
[number_of_stories] => Array
(
[0] => Two
)
[office_mls_id] => Array
(
[0] => ELIT
)
[parking_features] => Array
(
[0] => Assigned,Guest,Secured Entry
)
[possession] => Array
(
[0] => At Closing
)
[postal_code] => Array
(
[0] => 96731
)
[property_condition] => Array
(
[0] => Above Average
)
[property_type] => Array
(
[0] => condo_townhouse
)
[property_type_label] => Array
(
[0] => Condo Townhouse
)
[region] => Array
(
[0] => North Shore
)
[rets_association_fee_total] => Array
(
[0] => 831
)
[rets_baths_full] => Array
(
[0] => 2
)
[rets_baths_half] => Array
(
[0] => 0
)
[rets_baths_total] => Array
(
[0] => 2.00
)
[rets_beds_total] => Array
(
[0] => 2
)
[rets_building_name] => Array
(
[0] => Kuilima Ests West
)
[rets_city] => Array
(
[0] => Kahuku
)
[rets_compensation_method] => Array
(
[0] => %
)
[rets_condo_parking_unit] => Array
(
[0] => 45
)
[rets_current_price] => Array
(
[0] => 1700000.00
)
[rets_dom] => Array
(
[0] => 7
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 1
)
[rets_floor_number] => Array
(
[0] => 2
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_id] => Array
(
[0] => 16489154
)
[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) 589-2040
)
[rets_list_agent_email] => Array
(
[0] => rich@goldenpineapplegroup.com
)
[rets_list_agent_full_name] => Array
(
[0] => Richard M DeGutis
)
[rets_list_agent_mlsid] => Array
(
[0] => 44673
)
[rets_list_agent_mui] => Array
(
[0] => 9215498
)
[rets_list_office_mlsid] => Array
(
[0] => ELIT
)
[rets_list_office_mui] => Array
(
[0] => 3486767
)
[rets_list_office_name] => Array
(
[0] => Corcoran Pacific Properties
)
[rets_list_office_phone] => Array
(
[0] => (808) 589-2040
)
[rets_list_price] => Array
(
[0] => 1700000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-03-08
)
[rets_lot_size_area] => Array
(
[0] => 765523.00
)
[rets_maintenance_expense] => Array
(
[0] => 831.11
)
[rets_management_company_name] => Array
(
[0] => Associa Hawaii
)
[rets_management_company_phone] => Array
(
[0] => 8088360911
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-05-09T09:08:25.410
)
[rets_matrix_unique_id] => Array
(
[0] => 16489154
)
[rets_mls_number] => Array
(
[0] => 202204495
)
[rets_neighbourhood] => Array
(
[0] => KUILIMA
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-03-08T16:28:55.787
)
[rets_original_list_price] => Array
(
[0] => 1700000.00
)
[rets_owner_occupancy_percentage] => Array
(
[0] => 18
)
[rets_parcel_number] => Array
(
[0] => 1-5-7-001-029-0045
)
[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] => 17
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2022-03-08T16:28:55.787
)
[rets_postal_code] => Array
(
[0] => 96731
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-03-08T16:28:55.787
)
[rets_primary_key] => Array
(
[0] => 16489154
)
[rets_private_remarks] => Array
(
[0] => Property is occupied with Tenants. Showing on Sunday March 13 between 2pm-4pm. Please call and confirm the appointment. Qualified buyers only with proof. Please include 'As Is' addendum, and consider Briar Nakamoto of TG Hawaii Mililani Branch bnakamoto@tghawaii.com 808-294-3589. Offer's to be received by Monday 3/14 at 5pm. Seller will respond by Tuesday 3/15. Please do not have a deadline for response sooner than Tuesday 3/15 5pm.
)
[rets_public_remarks] => Array
(
[0] => Highly desired turnkey Legal Vacation Rental Investment Townhome at Turtle Bay Resort in Kuilima Estates West. Townhome is located in the "Gold Coast of the property" at the first hole of Turtle Bay Golf Course on the world famous North Shore of Oahu. This 2 bedroom 2 bath 1 parking with loft that has been enclosed and may serve as a den/office/bedroom, was last remodeled and refurbished in 2010 with three air conditioned bedrooms sleeps up to 8 in beds (6 in framed beds, two twin floor mattresses). Kuilima Estates West offers 3 Pools, Charcoal BBQ's, Two Tennis Courts, Visitor Parking, gated community and 24 hour security. Property is Turnkey and comes with all furnishings and future bookings. Details to be provided with approved buyer.
)
[rets_room_count] => Array
(
[0] => 5
)
[rets_sqft_roofed_living] => Array
(
[0] => 1199
)
[rets_sqft_total] => Array
(
[0] => 1199
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-05-09T09:08:25.410
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-05-09
)
[rets_street_name] => Array
(
[0] => Kuilima
)
[rets_street_number] => Array
(
[0] => 57-101
)
[rets_street_view_param] => Array
(
[0] => 1$21.704359$-157.997923$125.18$13.33$1.00$CAoSLEFGMVFpcE52SHJxcEo1eG83VTdQRW1IZ0cxS2NidkZJekVNNkk5TTktc1d4
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5
)
[rets_tax_amount] => Array
(
[0] => 215.58
)
[rets_tax_annual_amount] => Array
(
[0] => 2586.96
)
[rets_tax_assessed_value] => Array
(
[0] => 778700.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 552100.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 226600.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/16489154/472aeabcb07f28b7eb691aed0ae83e77
)
[rets_tmk_area] => Array
(
[0] => 157
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 45
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 29
)
[rets_tmk_section] => Array
(
[0] => 7
)
[rets_tmk_zone] => Array
(
[0] => 5
)
[rets_tmkplat] => Array
(
[0] => 1
)
[rets_total_actual_rent] => Array
(
[0] => 12000.00
)
[rets_unit_number] => Array
(
[0] => 45
)
[rets_year_built] => Array
(
[0] => 1973
)
[rets_year_remodeled] => Array
(
[0] => 2010
)
[security] => Array
(
[0] => Gated Community,Security Patrol
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Kuilima
)
[street_number] => Array
(
[0] => 57-101
)
[street_suffix] => Array
(
[0] => Drive
)
[terms_accept] => Array
(
[0] => Cash,Conventional
)
[tmk] => Array
(
[0] => 1-5-7-001-029-0045
)
[unit] => Array
(
[0] => Bedroom on 1st Level,Full Bath on 1st Floor,Multi Level
)
[unit_number] => Array
(
[0] => 45
)
[view] => Array
(
[0] => Golf Course,Ocean,Sunset
)
[wpp::rets_pk] => Array
(
[0] => 16489154
)
[wpp_gpid] => Array
(
[0] => 202204495
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1652123340
)
[year_built] => Array
(
[0] => 1973
)
[year_remodeled_] => Array
(
[0] => 2010
)
[zoning] => Array
(
[0] => 11 - A-1 Low Density Apartment
)
[new_attached_media] => Array
(
[0] => a:170:{i:0;i:21782742;i:1;i:21782743;i:2;i:21782744;i:3;i:21782745;i:4;i:21782746;i:5;i:21782747;i:6;i:21782748;i:7;i:21782749;i:8;i:21782750;i:9;i:21782751;i:10;i:21782752;i:11;i:21782753;i:12;i:21782754;i:13;i:21782755;i:14;i:21782756;i:15;i:21782757;i:16;i:21782758;i:17;i:21783042;i:18;i:21783043;i:19;i:21783044;i:20;i:21783045;i:21;i:21783046;i:22;i:21783047;i:23;i:21783048;i:24;i:21783049;i:25;i:21783050;i:26;i:21783051;i:27;i:21783052;i:28;i:21783053;i:29;i:21783054;i:30;i:21783055;i:31;i:21783056;i:32;i:21783057;i:33;i:21783058;i:34;i:21788637;i:35;i:21788638;i:36;i:21788639;i:37;i:21788640;i:38;i:21788641;i:39;i:21788642;i:40;i:21788643;i:41;i:21788644;i:42;i:21788645;i:43;i:21788646;i:44;i:21788647;i:45;i:21788648;i:46;i:21788649;i:47;i:21788650;i:48;i:21788651;i:49;i:21788652;i:50;i:21788653;i:51;i:21796771;i:52;i:21796772;i:53;i:21796773;i:54;i:21796774;i:55;i:21796775;i:56;i:21796776;i:57;i:21796777;i:58;i:21796778;i:59;i:21796779;i:60;i:21796780;i:61;i:21796781;i:62;i:21796782;i:63;i:21796783;i:64;i:21796784;i:65;i:21796785;i:66;i:21796786;i:67;i:21796787;i:68;i:21797609;i:69;i:21797610;i:70;i:21797611;i:71;i:21797612;i:72;i:21797613;i:73;i:21797614;i:74;i:21797615;i:75;i:21797616;i:76;i:21797617;i:77;i:21797618;i:78;i:21797619;i:79;i:21797620;i:80;i:21797621;i:81;i:21797622;i:82;i:21797623;i:83;i:21797624;i:84;i:21797625;i:85;i:21802217;i:86;i:21802218;i:87;i:21802219;i:88;i:21802220;i:89;i:21802221;i:90;i:21802222;i:91;i:21802223;i:92;i:21802224;i:93;i:21802225;i:94;i:21802226;i:95;i:21802227;i:96;i:21802228;i:97;i:21802229;i:98;i:21802230;i:99;i:21802231;i:100;i:21802232;i:101;i:21802233;i:102;i:21809884;i:103;i:21809885;i:104;i:21809886;i:105;i:21809887;i:106;i:21809888;i:107;i:21809889;i:108;i:21809890;i:109;i:21809891;i:110;i:21809892;i:111;i:21809893;i:112;i:21809894;i:113;i:21809895;i:114;i:21809896;i:115;i:21809897;i:116;i:21809898;i:117;i:21809899;i:118;i:21809900;i:119;i:21823692;i:120;i:21823693;i:121;i:21823694;i:122;i:21823695;i:123;i:21823696;i:124;i:21823697;i:125;i:21823698;i:126;i:21823699;i:127;i:21823700;i:128;i:21823701;i:129;i:21823702;i:130;i:21823703;i:131;i:21823704;i:132;i:21823705;i:133;i:21823706;i:134;i:21823707;i:135;i:21823708;i:136;i:22160957;i:137;i:22160958;i:138;i:22160959;i:139;i:22160960;i:140;i:22160961;i:141;i:22160962;i:142;i:22160963;i:143;i:22160964;i:144;i:22160965;i:145;i:22160966;i:146;i:22160967;i:147;i:22160968;i:148;i:22160969;i:149;i:22160970;i:150;i:22160971;i:151;i:22160972;i:152;i:22160973;i:153;i:22180838;i:154;i:22180839;i:155;i:22180840;i:156;i:22180841;i:157;i:22180842;i:158;i:22180843;i:159;i:22180844;i:160;i:22180845;i:161;i:22180846;i:162;i:22180847;i:163;i:22180848;i:164;i:22180849;i:165;i:22180850;i:166;i:22180851;i:167;i:22180852;i:168;i:22180853;i:169;i:22180854;}
)
[rets_virtual_tour_url_unbranded] => Array
(
[0] =>
)
[virtual_tour] => Array
(
[0] => https://youtu.be/VsSMF1I-syk
)
[rets_open_house_count] => Array
(
[0] => 1
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_open_house_upcoming] => Array
(
[0] =>
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-03-14
)
[rets_pending_date] => Array
(
[0] => 2022-03-14
)
[rets_close_date] => Array
(
[0] => 2022-05-09
)
[rets_close_price] => Array
(
[0] => 1700000.00
)
[rets_expiration_date] => Array
(
[0] => 2022-09-07
)
[rets_off_market_date] => Array
(
[0] => 2022-05-09
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 729-7643
)
[rets_selling_agent_email] => Array
(
[0] => pmjavier@gmail.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Paul M Javier
)
[rets_selling_agent_mlsid] => Array
(
[0] => 34149
)
[rets_selling_agent_mui] => Array
(
[0] => 3480062
)
[rets_selling_office_mlsid] => Array
(
[0] => HSIH
)
[rets_selling_office_mui] => Array
(
[0] => 13236725
)
[rets_selling_office_name] => Array
(
[0] => HomeSmart Island Homes
)
[rets_selling_office_phone] => Array
(
[0] => (808) 729-7643
)
[_thumbnail_id] => Array
(
[0] => 22180838
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446