57-020 Kuilima Drive Unit 313
Kahuku, HI 96731

Take a Virtual Tour

Listing
Overview

Price: $2,450,000
Area: KUILIMA
Status: Sold

Elevate your lifestyle with Resort Living on the North Shore of Oahu! The Ocean Villas at Turtle Bay is an exclusive, gated community at the 5-Star Turtle Bay Resort. This 3 Bedroom 2 Bath remodeled and upgraded Corner-End Villa, is a Furnished & Legal Short Term Vacation Rental. Located on the top 3rd Floor with high ceilings and ocean views from the Master, front and back lanai’s, & two guest bedrooms.  Swim in the warm, blue waters at Kuilima Cove or relax in the Cabanas next to Roy’s restaurant on the beach. Premier and Private, the Ocean Villas are conveniently located on Oahu’s Famous North Shore, the epicenter of world class surf. Turtle Bay Resort offers: Two Championship Golf Courses, Oceanfront Horse Trail Rides, Private Helicopter Tours, & Fine Dining. With acres of farmland & fresh produce, secluded beaches, and walking trails, there is plenty of wide-open spaces to roam, explore, pause, and breathe in the warm air.

  • Bedrooms: 3
  • Full Baths: 2
  • Living (sf): 1,546
  • Year Built: 2005
  • Building Name: Ocean Villas at Turtle Bay

  • Property Condition: Excellent
  • Number of Parking Spaces: 1
  • Number of Stories: One
  • View: Coastline,Garden,Ocean,Sunrise,Sunset
  • Listing Office: Compass

  • Maintenance Fees: $1,495
  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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

array(165) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(10) "1604100.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "406400.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(10) "2010500.00"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["building_name"]=>
  array(1) {
    [0]=>
    string(26) "Ocean Villas at Turtle Bay"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(45) "Condotel,Low-Rise 6 or Less Stories,Townhouse"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(11) "Call Listor"
  }
  ["exclusions"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(21) "Ceramic Tile,Hardwood"
  }
  ["frontage"]=>
  array(1) {
    [0]=>
    string(17) "Ocean,Sandy Beach"
  }
  ["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"
  }
  ["lanai_sf"]=>
  array(1) {
    [0]=>
    string(3) "135"
  }
  ["land_recorded"]=>
  array(1) {
    [0]=>
    string(14) "Regular System"
  }
  ["land_tenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["list_agent_email"]=>
  array(1) {
    [0]=>
    string(23) "jason.carey@compass.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(13) "Jason M Carey"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 825-4277"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-04-24"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(7) "Compass"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(10) "2450000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(4) "1546"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(47) "57-020 Kuilima Drive Unit 313, Kahuku, HI 96731"
  }
  ["maintenance_fees"]=>
  array(1) {
    [0]=>
    string(7) "1495.00"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202109599"
  }
  ["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) "One"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "COHI"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(23) "Assigned,Guest,Open - 1"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(34) "At Closing,Subject to Rental Lease"
  }
  ["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(11) "North Shore"
  }
  ["rets_association_fee_2"]=>
  array(1) {
    [0]=>
    string(2) "38"
  }
  ["rets_association_fee_total"]=>
  array(1) {
    [0]=>
    string(4) "1533"
  }
  ["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) "3"
  }
  ["rets_building_name"]=>
  array(1) {
    [0]=>
    string(26) "Ocean Villas at Turtle Bay"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(6) "Kahuku"
  }
  ["rets_compensation_method"]=>
  array(1) {
    [0]=>
    string(1) "%"
  }
  ["rets_condo_parking_unit"]=>
  array(1) {
    [0]=>
    string(3) "313"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(10) "2400000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_elevators_number_of"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_floor_number"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["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) "15860221"
  }
  ["rets_immoviewer_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 825-4277"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(23) "jason.carey@compass.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(13) "Jason M Carey"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "45105"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "9512016"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "COHI"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "15465233"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(7) "Compass"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 825-4277"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(10) "2450000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-04-24"
  }
  ["rets_maintenance_expense"]=>
  array(1) {
    [0]=>
    string(7) "1495.00"
  }
  ["rets_management_company_name"]=>
  array(1) {
    [0]=>
    string(9) "Hawaiiana"
  }
  ["rets_management_company_phone"]=>
  array(1) {
    [0]=>
    string(12) "808-593-9100"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-06-23T15:33:24.690"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "15860221"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202109599"
  }
  ["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) "2021-04-24T13:11:27.120"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(10) "2450000.00"
  }
  ["rets_owner_occupancy_percentage"]=>
  array(1) {
    [0]=>
    string(2) "68"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-5-7-001-013-0052"
  }
  ["rets_parking_additional"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_parking_total"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_permit_address_internet_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_permit_internet_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_photo_count"]=>
  array(1) {
    [0]=>
    string(2) "25"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-04-26T10:14:41.347"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96731"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-04-24T13:11:27.120"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "15860221"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(124) "Please contact listing agent Jason Carey for all showing requests and availability at 808-679-0698, jason.carey@compass.com."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(942) "Elevate your lifestyle with Resort Living on the North Shore of Oahu! The Ocean Villas at Turtle Bay is an exclusive, gated community at the 5-Star Turtle Bay Resort. This 3 Bedroom 2 Bath remodeled and upgraded Corner-End Villa, is a Furnished & Legal Short Term Vacation Rental. Located on the top 3rd Floor with high ceilings and ocean views from the Master, front and back lanai's, & two guest bedrooms.  Swim in the warm, blue waters at Kuilima Cove or relax in the Cabanas next to Roy's restaurant on the beach. Premier and Private, the Ocean Villas are conveniently located on Oahu's Famous North Shore, the epicenter of world class surf. Turtle Bay Resort offers: Two Championship Golf Courses, Oceanfront Horse Trail Rides, Private Helicopter Tours, & Fine Dining. With acres of farmland & fresh produce, secluded beaches, and walking trails, there is plenty of wide-open spaces to roam, explore, pause, and breathe in the warm air."
  }
  ["rets_sqft_lanai_open"]=>
  array(1) {
    [0]=>
    string(3) "135"
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(4) "1411"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(4) "1546"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-06-23T15:33:24.690"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-06-23"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(7) "Kuilima"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(6) "57-020"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(108) "1$21.7051591$-157.9967175$112.23$13.33$1.00$CAoSLEFGMVFpcE5qdVI3UVI3MXpsWHF6N2dlUTJSYXl0WkZhX2UtMnBubFB3T0Vs"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(3) "2.5"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(7) "2220.00"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(10) "2010500.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(10) "1604100.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "406400.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/15860221/6625beb15e9ea4a965b760870f6f094f"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "157"
  }
  ["rets_tmk_condo_property_regime_number"]=>
  array(1) {
    [0]=>
    string(2) "52"
  }
  ["rets_tmk_division"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tmk_parcel"]=>
  array(1) {
    [0]=>
    string(2) "13"
  }
  ["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_unit_number"]=>
  array(1) {
    [0]=>
    string(3) "313"
  }
  ["rets_virtual_tour_url_unbranded"]=>
  array(1) {
    [0]=>
    string(40) "https://player.vimeo.com/video/537627366"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "2005"
  }
  ["rets_year_remodeled"]=>
  array(1) {
    [0]=>
    string(4) "2020"
  }
  ["security"]=>
  array(1) {
    [0]=>
    string(19) "Gated Community,Key"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(17) "Cash,Conventional"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-5-7-001-013-0052"
  }
  ["unit"]=>
  array(1) {
    [0]=>
    string(29) "Central AC,Corner/End,Storage"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(37) "Coastline,Garden,Ocean,Sunrise,Sunset"
  }
  ["virtual_tour"]=>
  array(1) {
    [0]=>
    string(40) "https://player.vimeo.com/video/537627366"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "15860221"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202109599"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1628914659"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "2005"
  }
  ["year_remodeled_"]=>
  array(1) {
    [0]=>
    string(4) "2020"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(20) "21 - Resort District"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(2040) "a:126:{i:0;i:19866575;i:1;i:19866576;i:2;i:19866577;i:3;i:19866578;i:4;i:19866579;i:5;i:19866580;i:6;i:19866581;i:7;i:19866582;i:8;i:19866583;i:9;i:19866584;i:10;i:19866585;i:11;i:19866586;i:12;i:19866587;i:13;i:19866588;i:14;i:19866589;i:15;i:19866590;i:16;i:19866591;i:17;i:19866592;i:18;i:19866593;i:19;i:19866594;i:20;i:19866595;i:21;i:19871357;i:22;i:19871358;i:23;i:19871359;i:24;i:19871360;i:25;i:19871361;i:26;i:19871362;i:27;i:19871363;i:28;i:19871364;i:29;i:19871365;i:30;i:19871366;i:31;i:19871367;i:32;i:19871368;i:33;i:19871369;i:34;i:19871370;i:35;i:19871371;i:36;i:19871372;i:37;i:19871373;i:38;i:19871374;i:39;i:19871375;i:40;i:19871376;i:41;i:19871377;i:42;i:19873292;i:43;i:19873293;i:44;i:19873294;i:45;i:19873295;i:46;i:19873296;i:47;i:19873297;i:48;i:19873298;i:49;i:19873299;i:50;i:19873300;i:51;i:19873301;i:52;i:19873302;i:53;i:19873303;i:54;i:19873304;i:55;i:19873305;i:56;i:19873306;i:57;i:19873307;i:58;i:19873308;i:59;i:19873309;i:60;i:19873310;i:61;i:19873311;i:62;i:19873312;i:63;i:19882221;i:64;i:19882222;i:65;i:19882223;i:66;i:19882224;i:67;i:19882225;i:68;i:19882226;i:69;i:19882227;i:70;i:19882228;i:71;i:19882229;i:72;i:19882230;i:73;i:19882231;i:74;i:19882232;i:75;i:19882233;i:76;i:19882234;i:77;i:19882235;i:78;i:19882236;i:79;i:19882237;i:80;i:19882238;i:81;i:19882239;i:82;i:19882240;i:83;i:19882241;i:84;i:20041569;i:85;i:20041570;i:86;i:20041571;i:87;i:20041572;i:88;i:20041573;i:89;i:20041574;i:90;i:20041575;i:91;i:20041576;i:92;i:20041577;i:93;i:20041578;i:94;i:20041579;i:95;i:20041580;i:96;i:20041581;i:97;i:20041582;i:98;i:20041583;i:99;i:20041584;i:100;i:20041585;i:101;i:20041586;i:102;i:20041587;i:103;i:20041588;i:104;i:20041589;i:105;i:20289644;i:106;i:20289645;i:107;i:20289646;i:108;i:20289647;i:109;i:20289648;i:110;i:20289649;i:111;i:20289650;i:112;i:20289651;i:113;i:20289652;i:114;i:20289653;i:115;i:20289654;i:116;i:20289655;i:117;i:20289656;i:118;i:20289657;i:119;i:20289658;i:120;i:20289659;i:121;i:20289660;i:122;i:20289661;i:123;i:20289662;i:124;i:20289663;i:125;i:20289664;}"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-04-25"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(6) "Kahuku"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96731"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-06-23"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(10) "2400000.00"
  }
  ["rets_co_selling_agent_direct_work_pho"]=>
  array(1) {
    [0]=>
    string(14) "(808) 825-4277"
  }
  ["rets_co_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(20) "kwodehouse@gmail.com"
  }
  ["rets_co_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(15) "Kalei Wodehouse"
  }
  ["rets_co_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "49733"
  }
  ["rets_co_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(8) "14656912"
  }
  ["rets_co_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "COHI"
  }
  ["rets_co_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "15465233"
  }
  ["rets_co_selling_office_name"]=>
  array(1) {
    [0]=>
    string(7) "Compass"
  }
  ["rets_co_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 825-4277"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-06-23"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 825-4277"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(23) "alesia@barneshawaii.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(15) "Alesia D Barnes"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "43678"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3483745"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "COHI"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "15465233"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(7) "Compass"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 825-4277"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(7) "Kuilima"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(6) "57-020"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(5) "Drive"
  }
  ["unit_number"]=>
  array(1) {
    [0]=>
    string(3) "313"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20289644"
  }
}