Resort living on The North Shore of Oahu! Island style living! Surf & Golf Retreat best describes this excellent condition condo located in the highly desirable Kuilima Estates East. Just a short walk to beautiful beaches, surf breaks, restaurants, golf, tropical walking paths, and the Turtle Bay Resort. Through years of ownership, the owners have constantly maintained and improved this property. Unit has a second bedroom area for additional living. Located in a gated community with manicured grounds that includes two pools, tennis courts, BBQ areas, 24 hour security, on site management. Sale includes a deeded parking stall. Lots of guest parking as well. Kuilima is located a short drive to the “7 mile miracle” of famous North Shore of Oahu waves including,: Sunset Beach, Pipeline, Keiki Beach, Waimea Bay & Haleiwa.
Listing by: Hawaii Realty Group LLC
array(164) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "388000.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "194600.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "582600.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "1"
}
["building_name"]=>
array(1) {
[0]=>
string(17) "Kuilima Ests East"
}
["building_style"]=>
array(1) {
[0]=>
string(26) "Low-Rise 6 or Less Stories"
}
["city"]=>
array(1) {
[0]=>
string(6) "Kahuku"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(24) "Property Disclosure Stmt"
}
["floor_covering"]=>
array(1) {
[0]=>
string(18) "Ceramic Tile,Vinyl"
}
["frontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "2"
}
["furnished"]=>
array(1) {
[0]=>
string(10) "Negotiable"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["home_exampt"]=>
array(1) {
[0]=>
string(1) "0"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(3) "137"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(9) "647519.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(25) "kaleo@hawaiirealtygrp.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(18) "Joseph Kaleo Ahina"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 261-4747"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2021-09-13"
}
["list_office_name"]=>
array(1) {
[0]=>
string(23) "Hawaii Realty Group LLC"
}
["list_price"]=>
array(1) {
[0]=>
string(9) "950000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(3) "875"
}
["location"]=>
array(1) {
[0]=>
string(52) "57-091 Lalo Kuilima Place Unit 770, Kahuku, HI 96731"
}
["maintenance_fees"]=>
array(1) {
[0]=>
string(6) "676.00"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202123781"
}
["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) "HGRP"
}
["parking_features"]=>
array(1) {
[0]=>
string(37) "Assigned,Guest,Open - 1,Secured Entry"
}
["possession"]=>
array(1) {
[0]=>
string(10) "At Closing"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96731"
}
["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_total"]=>
array(1) {
[0]=>
string(3) "676"
}
["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) "1"
}
["rets_building_name"]=>
array(1) {
[0]=>
string(17) "Kuilima Ests East"
}
["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) "70"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(9) "986500.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) "16161562"
}
["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) "0"
}
["rets_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 261-4747"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(25) "kaleo@hawaiirealtygrp.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(18) "Joseph Kaleo Ahina"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "38082"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "3481518"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "HGRP"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(7) "9647176"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(23) "Hawaii Realty Group LLC"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 261-4747"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(9) "950000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2021-09-13"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(9) "647519.00"
}
["rets_maintenance_expense"]=>
array(1) {
[0]=>
string(6) "676.00"
}
["rets_management_company_name"]=>
array(1) {
[0]=>
string(9) "Hawaiiana"
}
["rets_management_company_phone"]=>
array(1) {
[0]=>
string(12) "808-593-9100"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2021-12-02T10:53:56.680"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16161562"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202123781"
}
["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-09-13T13:58:05.300"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(9) "950000.00"
}
["rets_owner_occupancy_percentage"]=>
array(1) {
[0]=>
string(2) "23"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-5-7-001-027-0069"
}
["rets_parking_additional"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_parking_total"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_permit_address_internet_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_permit_internet_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_photo_count"]=>
array(1) {
[0]=>
string(2) "25"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2021-09-13T13:58:05.300"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96731"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16161562"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(153) "For all showing request call/text/email Listing Agent Joseph "Kaleo" Ahina at 808-542-6744 or at kaleo@hawaiirealtygrp.com. Showings by appointment only."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(827) "Resort living on The North Shore of Oahu! Island style living! Surf & Golf Retreat best describes this excellent condition condo located in the highly desirable Kuilima Estates East. Just a short walk to beautiful beaches, surf breaks, restaurants, golf, tropical walking paths, and the Turtle Bay Resort. Through years of ownership, the owners have constantly maintained and improved this property. Unit has a second bedroom area for additional living. Located in a gated community with manicured grounds that includes two pools, tennis courts, BBQ areas, 24 hour security, on site management. Sale includes a deeded parking stall. Lots of guest parking as well. Kuilima is located a short drive to the "7 mile miracle" of famous North Shore of Oahu waves including,: Sunset Beach, Pipeline, Keiki Beach, Waimea Bay & Haleiwa."
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(3) "137"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(3) "738"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(3) "875"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2021-12-02T10:53:56.680"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2021-12-02"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(12) "Lalo Kuilima"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(6) "57-091"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(63) "1$21.699872$-157.993214$47.55$13.33$1.00$eppL3Iq8nQBfjRAhCvPClw"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(4) "2.5%"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "169.00"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "582600.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "388000.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "194600.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/16161562/060e2d01a6ffe766e0dd73a92f77c560"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "157"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(2) "69"
}
["rets_tmk_division"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tmk_parcel"]=>
array(1) {
[0]=>
string(2) "27"
}
["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) "770"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1975"
}
["security"]=>
array(1) {
[0]=>
string(35) "Gated Community,Key,Security Patrol"
}
["state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["street_name"]=>
array(1) {
[0]=>
string(12) "Lalo Kuilima"
}
["street_number"]=>
array(1) {
[0]=>
string(6) "57-091"
}
["street_suffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["terms_accept"]=>
array(1) {
[0]=>
string(17) "Cash,Conventional"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-5-7-001-027-0069"
}
["unit"]=>
array(1) {
[0]=>
string(66) "Bedroom on 1st Level,Even# Unit,Full Bath on 1st Floor,Multi Level"
}
["unit_number"]=>
array(1) {
[0]=>
string(3) "770"
}
["view"]=>
array(1) {
[0]=>
string(4) "None"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16161562"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202123781"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1638478485"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1975"
}
["zoning"]=>
array(1) {
[0]=>
string(30) "11 - A-1 Low Density Apartment"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(2040) "a:126:{i:0;i:20732112;i:1;i:20732113;i:2;i:20732114;i:3;i:20732115;i:4;i:20732116;i:5;i:20732117;i:6;i:20732118;i:7;i:20732119;i:8;i:20732120;i:9;i:20732121;i:10;i:20732122;i:11;i:20732123;i:12;i:20732124;i:13;i:20732125;i:14;i:20732126;i:15;i:20732127;i:16;i:20732128;i:17;i:20732129;i:18;i:20732130;i:19;i:20732131;i:20;i:20732132;i:21;i:20737850;i:22;i:20737851;i:23;i:20737852;i:24;i:20737853;i:25;i:20737854;i:26;i:20737855;i:27;i:20737856;i:28;i:20737857;i:29;i:20737858;i:30;i:20737859;i:31;i:20737860;i:32;i:20737861;i:33;i:20737862;i:34;i:20737863;i:35;i:20737864;i:36;i:20737865;i:37;i:20737866;i:38;i:20737867;i:39;i:20737868;i:40;i:20737869;i:41;i:20737870;i:42;i:20783512;i:43;i:20783513;i:44;i:20783514;i:45;i:20783515;i:46;i:20783516;i:47;i:20783517;i:48;i:20783518;i:49;i:20783519;i:50;i:20783520;i:51;i:20783521;i:52;i:20783522;i:53;i:20783523;i:54;i:20783524;i:55;i:20783525;i:56;i:20783526;i:57;i:20783527;i:58;i:20783528;i:59;i:20783529;i:60;i:20783530;i:61;i:20783531;i:62;i:20783532;i:63;i:20783549;i:64;i:20783550;i:65;i:20783551;i:66;i:20783552;i:67;i:20783553;i:68;i:20783554;i:69;i:20783555;i:70;i:20783556;i:71;i:20783557;i:72;i:20783558;i:73;i:20783559;i:74;i:20783560;i:75;i:20783561;i:76;i:20783562;i:77;i:20783563;i:78;i:20783564;i:79;i:20783565;i:80;i:20783566;i:81;i:20783567;i:82;i:20783568;i:83;i:20783569;i:84;i:20862290;i:85;i:20862291;i:86;i:20862292;i:87;i:20862293;i:88;i:20862294;i:89;i:20862295;i:90;i:20862296;i:91;i:20862297;i:92;i:20862298;i:93;i:20862299;i:94;i:20862300;i:95;i:20862301;i:96;i:20862302;i:97;i:20862303;i:98;i:20862304;i:99;i:20862305;i:100;i:20862306;i:101;i:20862307;i:102;i:20862308;i:103;i:20862309;i:104;i:20862310;i:105;i:21259853;i:106;i:21259854;i:107;i:21259855;i:108;i:21259856;i:109;i:21259857;i:110;i:21259858;i:111;i:21259859;i:112;i:21259860;i:113;i:21259861;i:114;i:21259862;i:115;i:21259863;i:116;i:21259864;i:117;i:21259865;i:118;i:21259866;i:119;i:21259867;i:120;i:21259868;i:121;i:21259869;i:122;i:21259870;i:123;i:21259871;i:124;i:21259872;i:125;i:21259873;}"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2021-09-18"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2021-12-02"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(9) "986500.00"
}
["rets_co_selling_agent_direct_work_pho"]=>
array(1) {
[0]=>
string(14) "(808) 732-1414"
}
["rets_co_selling_agent_email"]=>
array(1) {
[0]=>
string(19) "lisah@cbpacific.com"
}
["rets_co_selling_agent_full_name"]=>
array(1) {
[0]=>
string(14) "Lisa Haeringer"
}
["rets_co_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "25408"
}
["rets_co_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "8843261"
}
["rets_co_selling_office_mlsid"]=>
array(1) {
[0]=>
string(6) "CBPP02"
}
["rets_co_selling_office_mui"]=>
array(1) {
[0]=>
string(7) "3485238"
}
["rets_co_selling_office_name"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["rets_co_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 732-1414"
}
["rets_concessions"]=>
array(1) {
[0]=>
string(5) "11000"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-02-28"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2021-12-02"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 596-0456"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(19) "MaliaK@cbrealty.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(16) "Malia Kakos J.D."
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "43549"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "3483675"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "CBPP"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(7) "3485212"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 596-0456"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "2028.00"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "21259853"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 388000.00
)
[assd_val_land] => Array
(
[0] => 194600.00
)
[assd_val_total] => Array
(
[0] => 582600.00
)
[bedrooms] => Array
(
[0] => 1
)
[building_name] => Array
(
[0] => Kuilima Ests East
)
[building_style] => Array
(
[0] => Low-Rise 6 or Less Stories
)
[city] => Array
(
[0] => Kahuku
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Property Disclosure Stmt
)
[floor_covering] => Array
(
[0] => Ceramic Tile,Vinyl
)
[frontage] => Array
(
[0] => Other
)
[full_baths] => Array
(
[0] => 2
)
[furnished] => Array
(
[0] => Negotiable
)
[half_baths] => Array
(
[0] => 0
)
[home_exampt] => Array
(
[0] => 0
)
[lanai_sf] => Array
(
[0] => 137
)
[land_area_sf] => Array
(
[0] => 647519.00
)
[land_recorded] => Array
(
[0] => Land Court
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => kaleo@hawaiirealtygrp.com
)
[list_agent_name] => Array
(
[0] => Joseph Kaleo Ahina
)
[list_agent_phone_number] => Array
(
[0] => (808) 261-4747
)
[list_date] => Array
(
[0] => 2021-09-13
)
[list_office_name] => Array
(
[0] => Hawaii Realty Group LLC
)
[list_price] => Array
(
[0] => 950000.00
)
[living_sf] => Array
(
[0] => 875
)
[location] => Array
(
[0] => 57-091 Lalo Kuilima Place Unit 770, Kahuku, HI 96731
)
[maintenance_fees] => Array
(
[0] => 676.00
)
[mls_] => Array
(
[0] => 202123781
)
[neighborhood] => Array
(
[0] => KUILIMA
)
[number_of_parking_spaces] => Array
(
[0] => 1
)
[number_of_stories] => Array
(
[0] => Two
)
[office_mls_id] => Array
(
[0] => HGRP
)
[parking_features] => Array
(
[0] => Assigned,Guest,Open - 1,Secured Entry
)
[possession] => Array
(
[0] => At Closing
)
[postal_code] => Array
(
[0] => 96731
)
[property_condition] => Array
(
[0] => Excellent
)
[property_type] => Array
(
[0] => condo_townhouse
)
[property_type_label] => Array
(
[0] => Condo Townhouse
)
[region] => Array
(
[0] => North Shore
)
[rets_association_fee_total] => Array
(
[0] => 676
)
[rets_baths_full] => Array
(
[0] => 2
)
[rets_baths_half] => Array
(
[0] => 0
)
[rets_baths_total] => Array
(
[0] => 2.00
)
[rets_beds_total] => Array
(
[0] => 1
)
[rets_building_name] => Array
(
[0] => Kuilima Ests East
)
[rets_city] => Array
(
[0] => Kahuku
)
[rets_compensation_method] => Array
(
[0] => %
)
[rets_condo_parking_unit] => Array
(
[0] => 70
)
[rets_current_price] => Array
(
[0] => 986500.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] => 16161562
)
[rets_immoviewer_yn] => Array
(
[0] => 0
)
[rets_internet_automated_valuation_dis] => Array
(
[0] => 1
)
[rets_internet_consumer_comment_yn] => Array
(
[0] => 0
)
[rets_list_agent_direct_work_phone] => Array
(
[0] => (808) 261-4747
)
[rets_list_agent_email] => Array
(
[0] => kaleo@hawaiirealtygrp.com
)
[rets_list_agent_full_name] => Array
(
[0] => Joseph Kaleo Ahina
)
[rets_list_agent_mlsid] => Array
(
[0] => 38082
)
[rets_list_agent_mui] => Array
(
[0] => 3481518
)
[rets_list_office_mlsid] => Array
(
[0] => HGRP
)
[rets_list_office_mui] => Array
(
[0] => 9647176
)
[rets_list_office_name] => Array
(
[0] => Hawaii Realty Group LLC
)
[rets_list_office_phone] => Array
(
[0] => (808) 261-4747
)
[rets_list_price] => Array
(
[0] => 950000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2021-09-13
)
[rets_lot_size_area] => Array
(
[0] => 647519.00
)
[rets_maintenance_expense] => Array
(
[0] => 676.00
)
[rets_management_company_name] => Array
(
[0] => Hawaiiana
)
[rets_management_company_phone] => Array
(
[0] => 808-593-9100
)
[rets_matrix_modified_dt] => Array
(
[0] => 2021-12-02T10:53:56.680
)
[rets_matrix_unique_id] => Array
(
[0] => 16161562
)
[rets_mls_number] => Array
(
[0] => 202123781
)
[rets_neighbourhood] => Array
(
[0] => KUILIMA
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2021-09-13T13:58:05.300
)
[rets_original_list_price] => Array
(
[0] => 950000.00
)
[rets_owner_occupancy_percentage] => Array
(
[0] => 23
)
[rets_parcel_number] => Array
(
[0] => 1-5-7-001-027-0069
)
[rets_parking_additional] => Array
(
[0] => 0
)
[rets_parking_total] => Array
(
[0] => 1
)
[rets_permit_address_internet_yn] => Array
(
[0] => 1
)
[rets_permit_internet_yn] => Array
(
[0] => 1
)
[rets_photo_count] => Array
(
[0] => 25
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2021-09-13T13:58:05.300
)
[rets_postal_code] => Array
(
[0] => 96731
)
[rets_primary_key] => Array
(
[0] => 16161562
)
[rets_private_remarks] => Array
(
[0] => For all showing request call/text/email Listing Agent Joseph "Kaleo" Ahina at 808-542-6744 or at kaleo@hawaiirealtygrp.com. Showings by appointment only.
)
[rets_public_remarks] => Array
(
[0] => Resort living on The North Shore of Oahu! Island style living! Surf & Golf Retreat best describes this excellent condition condo located in the highly desirable Kuilima Estates East. Just a short walk to beautiful beaches, surf breaks, restaurants, golf, tropical walking paths, and the Turtle Bay Resort. Through years of ownership, the owners have constantly maintained and improved this property. Unit has a second bedroom area for additional living. Located in a gated community with manicured grounds that includes two pools, tennis courts, BBQ areas, 24 hour security, on site management. Sale includes a deeded parking stall. Lots of guest parking as well. Kuilima is located a short drive to the "7 mile miracle" of famous North Shore of Oahu waves including,: Sunset Beach, Pipeline, Keiki Beach, Waimea Bay & Haleiwa.
)
[rets_sqft_lanai_open] => Array
(
[0] => 137
)
[rets_sqft_roofed_living] => Array
(
[0] => 738
)
[rets_sqft_total] => Array
(
[0] => 875
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2021-12-02T10:53:56.680
)
[rets_status_contractual_search_date] => Array
(
[0] => 2021-12-02
)
[rets_street_name] => Array
(
[0] => Lalo Kuilima
)
[rets_street_number] => Array
(
[0] => 57-091
)
[rets_street_view_param] => Array
(
[0] => 1$21.699872$-157.993214$47.55$13.33$1.00$eppL3Iq8nQBfjRAhCvPClw
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5%
)
[rets_tax_amount] => Array
(
[0] => 169.00
)
[rets_tax_assessed_value] => Array
(
[0] => 582600.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 388000.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 194600.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/16161562/060e2d01a6ffe766e0dd73a92f77c560
)
[rets_tmk_area] => Array
(
[0] => 157
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 69
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 27
)
[rets_tmk_section] => Array
(
[0] => 7
)
[rets_tmk_zone] => Array
(
[0] => 5
)
[rets_tmkplat] => Array
(
[0] => 1
)
[rets_unit_number] => Array
(
[0] => 770
)
[rets_year_built] => Array
(
[0] => 1975
)
[security] => Array
(
[0] => Gated Community,Key,Security Patrol
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Lalo Kuilima
)
[street_number] => Array
(
[0] => 57-091
)
[street_suffix] => Array
(
[0] => Place
)
[terms_accept] => Array
(
[0] => Cash,Conventional
)
[tmk] => Array
(
[0] => 1-5-7-001-027-0069
)
[unit] => Array
(
[0] => Bedroom on 1st Level,Even# Unit,Full Bath on 1st Floor,Multi Level
)
[unit_number] => Array
(
[0] => 770
)
[view] => Array
(
[0] => None
)
[wpp::rets_pk] => Array
(
[0] => 16161562
)
[wpp_gpid] => Array
(
[0] => 202123781
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1638478485
)
[year_built] => Array
(
[0] => 1975
)
[zoning] => Array
(
[0] => 11 - A-1 Low Density Apartment
)
[new_attached_media] => Array
(
[0] => a:126:{i:0;i:20732112;i:1;i:20732113;i:2;i:20732114;i:3;i:20732115;i:4;i:20732116;i:5;i:20732117;i:6;i:20732118;i:7;i:20732119;i:8;i:20732120;i:9;i:20732121;i:10;i:20732122;i:11;i:20732123;i:12;i:20732124;i:13;i:20732125;i:14;i:20732126;i:15;i:20732127;i:16;i:20732128;i:17;i:20732129;i:18;i:20732130;i:19;i:20732131;i:20;i:20732132;i:21;i:20737850;i:22;i:20737851;i:23;i:20737852;i:24;i:20737853;i:25;i:20737854;i:26;i:20737855;i:27;i:20737856;i:28;i:20737857;i:29;i:20737858;i:30;i:20737859;i:31;i:20737860;i:32;i:20737861;i:33;i:20737862;i:34;i:20737863;i:35;i:20737864;i:36;i:20737865;i:37;i:20737866;i:38;i:20737867;i:39;i:20737868;i:40;i:20737869;i:41;i:20737870;i:42;i:20783512;i:43;i:20783513;i:44;i:20783514;i:45;i:20783515;i:46;i:20783516;i:47;i:20783517;i:48;i:20783518;i:49;i:20783519;i:50;i:20783520;i:51;i:20783521;i:52;i:20783522;i:53;i:20783523;i:54;i:20783524;i:55;i:20783525;i:56;i:20783526;i:57;i:20783527;i:58;i:20783528;i:59;i:20783529;i:60;i:20783530;i:61;i:20783531;i:62;i:20783532;i:63;i:20783549;i:64;i:20783550;i:65;i:20783551;i:66;i:20783552;i:67;i:20783553;i:68;i:20783554;i:69;i:20783555;i:70;i:20783556;i:71;i:20783557;i:72;i:20783558;i:73;i:20783559;i:74;i:20783560;i:75;i:20783561;i:76;i:20783562;i:77;i:20783563;i:78;i:20783564;i:79;i:20783565;i:80;i:20783566;i:81;i:20783567;i:82;i:20783568;i:83;i:20783569;i:84;i:20862290;i:85;i:20862291;i:86;i:20862292;i:87;i:20862293;i:88;i:20862294;i:89;i:20862295;i:90;i:20862296;i:91;i:20862297;i:92;i:20862298;i:93;i:20862299;i:94;i:20862300;i:95;i:20862301;i:96;i:20862302;i:97;i:20862303;i:98;i:20862304;i:99;i:20862305;i:100;i:20862306;i:101;i:20862307;i:102;i:20862308;i:103;i:20862309;i:104;i:20862310;i:105;i:21259853;i:106;i:21259854;i:107;i:21259855;i:108;i:21259856;i:109;i:21259857;i:110;i:21259858;i:111;i:21259859;i:112;i:21259860;i:113;i:21259861;i:114;i:21259862;i:115;i:21259863;i:116;i:21259864;i:117;i:21259865;i:118;i:21259866;i:119;i:21259867;i:120;i:21259868;i:121;i:21259869;i:122;i:21259870;i:123;i:21259871;i:124;i:21259872;i:125;i:21259873;}
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2021-09-18
)
[rets_close_date] => Array
(
[0] => 2021-12-02
)
[rets_close_price] => Array
(
[0] => 986500.00
)
[rets_co_selling_agent_direct_work_pho] => Array
(
[0] => (808) 732-1414
)
[rets_co_selling_agent_email] => Array
(
[0] => lisah@cbpacific.com
)
[rets_co_selling_agent_full_name] => Array
(
[0] => Lisa Haeringer
)
[rets_co_selling_agent_mlsid] => Array
(
[0] => 25408
)
[rets_co_selling_agent_mui] => Array
(
[0] => 8843261
)
[rets_co_selling_office_mlsid] => Array
(
[0] => CBPP02
)
[rets_co_selling_office_mui] => Array
(
[0] => 3485238
)
[rets_co_selling_office_name] => Array
(
[0] => Coldwell Banker Realty
)
[rets_co_selling_office_phone] => Array
(
[0] => (808) 732-1414
)
[rets_concessions] => Array
(
[0] => 11000
)
[rets_expiration_date] => Array
(
[0] => 2022-02-28
)
[rets_off_market_date] => Array
(
[0] => 2021-12-02
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 596-0456
)
[rets_selling_agent_email] => Array
(
[0] => MaliaK@cbrealty.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Malia Kakos J.D.
)
[rets_selling_agent_mlsid] => Array
(
[0] => 43549
)
[rets_selling_agent_mui] => Array
(
[0] => 3483675
)
[rets_selling_office_mlsid] => Array
(
[0] => CBPP
)
[rets_selling_office_mui] => Array
(
[0] => 3485212
)
[rets_selling_office_name] => Array
(
[0] => Coldwell Banker Realty
)
[rets_selling_office_phone] => Array
(
[0] => (808) 596-0456
)
[rets_tax_annual_amount] => Array
(
[0] => 2028.00
)
[_thumbnail_id] => Array
(
[0] => 21259853
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446