Paradise Found!!! Private beachfront living! One of only a few sandy beachfront properties on the North Shore. Calm waters front the house protected by two fringing reefs. Enjoy swimming, fishing and surfing, long beach walks, all in your backyard. Located within two minutes of the property you’ll find two shopping centers with groceries, doctor offices, restaurants, The Polynesian Cultural Center, BYU-Hawaii and gorgeous white sand beaches. Also nearby is the world famous North Shore of Oahu with the “7 mile miracle” of world class waves, and Turtle Bay Resort with golf, dining, and adventure. This 2 bedroom/2 bathroom, single level, beach style living is what it is all about! This is the property you have been waiting for.
Listing by: Hawaii Realty Group LLC
array(151) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "225000.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(10) "1229100.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(10) "1454100.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "2"
}
["building_style"]=>
array(1) {
[0]=>
string(20) "Detach Single Family"
}
["city"]=>
array(1) {
[0]=>
string(4) "Laie"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(43) "Non Resident Owner,Property Disclosure Stmt"
}
["easements"]=>
array(1) {
[0]=>
string(5) "Other"
}
["floor_covering"]=>
array(1) {
[0]=>
string(5) "Vinyl"
}
["frontage"]=>
array(1) {
[0]=>
string(41) "Ocean,Sandy Beach,Stream/Canal,Waterfront"
}
["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"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(8) "10942.00"
}
["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(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) "2022-04-25"
}
["list_office_name"]=>
array(1) {
[0]=>
string(23) "Hawaii Realty Group LLC"
}
["list_price"]=>
array(1) {
[0]=>
string(10) "2250000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "1097"
}
["location"]=>
array(1) {
[0]=>
string(41) "55-547 Kamehameha Highway, Laie, HI 96762"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202207769"
}
["neighborhood"]=>
array(1) {
[0]=>
string(4) "LAIE"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "2"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(3) "One"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "HGRP"
}
["parking_features"]=>
array(1) {
[0]=>
string(5) "2 Car"
}
["pool_"]=>
array(1) {
[0]=>
string(4) "None"
}
["possession"]=>
array(1) {
[0]=>
string(10) "At Closing"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96762"
}
["property_condition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["property_type"]=>
array(1) {
[0]=>
string(13) "single_family"
}
["property_type_label"]=>
array(1) {
[0]=>
string(13) "single_family"
}
["region"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["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_city"]=>
array(1) {
[0]=>
string(4) "Laie"
}
["rets_compensation_method"]=>
array(1) {
[0]=>
string(1) "%"
}
["rets_condo_property_regime_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(10) "2150000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(2) "17"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["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) "16608106"
}
["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) 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(10) "2250000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-04-25"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(8) "10942.00"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-08-01T13:18:54.743"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16608106"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202207769"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(4) "LAIE"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-25T08:44:20.940"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(10) "2250000.00"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-5-5-011-070-0000"
}
["rets_parking_total"]=>
array(1) {
[0]=>
string(1) "2"
}
["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) "20"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-25T08:44:20.940"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96762"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16608106"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(123) "For all showing request call/text/email Listing Agent Joseph "Kaleo" Ahina at 808-542-6744 or at kaleo@hawaiirealtygrp.com."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(735) "Paradise Found!!! Private beachfront living! One of only a few sandy beachfront properties on the North Shore. Calm waters front the house protected by two fringing reefs. Enjoy swimming, fishing and surfing, long beach walks, all in your backyard. Located within two minutes of the property you'll find two shopping centers with groceries, doctor offices, restaurants, The Polynesian Cultural Center, BYU-Hawaii and gorgeous white sand beaches. Also nearby is the world famous North Shore of Oahu with the "7 mile miracle" of world class waves, and Turtle Bay Resort with golf, dining, and adventure. This 2 bedroom/2 bathroom, single level, beach style living is what it is all about! This is the property you have been waiting for."
}
["rets_room_count"]=>
array(1) {
[0]=>
string(1) "7"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(3) "920"
}
["rets_sqft_roofed_other"]=>
array(1) {
[0]=>
string(3) "177"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "1097"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-08-01T13:18:54.743"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-08-01"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(10) "Kamehameha"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(6) "55-547"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(105) "1$21.648263$-157.922308$95.28$13.33$1.00$CAoSK0FGMVFpcE9iMVlYNUZFazh1bmFSdHF1aVdLZlp3ZUNtaDlxcHE0UndTLUk."
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(4) "2.5%"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "637.00"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "7644.00"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(10) "1454100.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "225000.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(10) "1229100.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) "2022"
}
["rets_thumbnail_url"]=>
array(1) {
[0]=>
string(81) "https://cdn.rets.ci/marcusrealty-images/16608106/3a06f5a465f1661dad0dc5aa229c6e54"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "155"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_tmk_division"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tmk_parcel"]=>
array(1) {
[0]=>
string(2) "70"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "5"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "5"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(2) "11"
}
["rets_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(28) "https://youtu.be/s5vAKUgYgB4"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1978"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(4) "2003"
}
["security"]=>
array(1) {
[0]=>
string(3) "Key"
}
["setbacks"]=>
array(1) {
[0]=>
string(9) "Of Record"
}
["state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["street_name"]=>
array(1) {
[0]=>
string(10) "Kamehameha"
}
["street_number"]=>
array(1) {
[0]=>
string(6) "55-547"
}
["street_suffix"]=>
array(1) {
[0]=>
string(7) "Highway"
}
["terms_accept"]=>
array(1) {
[0]=>
string(20) "Cash,Conventional,VA"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-5-5-011-070-0000"
}
["topography"]=>
array(1) {
[0]=>
string(14) "Clear,Flag Lot"
}
["view"]=>
array(1) {
[0]=>
string(32) "Coastline,Mountain,Ocean,Sunrise"
}
["virtual_tour"]=>
array(1) {
[0]=>
string(28) "https://youtu.be/s5vAKUgYgB4"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16608106"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202207769"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1659395987"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1978"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "2003"
}
["zoning"]=>
array(1) {
[0]=>
string(29) "05 - R-5 Residential District"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(1938) "a:120:{i:0;i:22084977;i:1;i:22084978;i:2;i:22084979;i:3;i:22084980;i:4;i:22084981;i:5;i:22084982;i:6;i:22084983;i:7;i:22084984;i:8;i:22084985;i:9;i:22084986;i:10;i:22084987;i:11;i:22084988;i:12;i:22084989;i:13;i:22084990;i:14;i:22084991;i:15;i:22084992;i:16;i:22084993;i:17;i:22084994;i:18;i:22084995;i:19;i:22084996;i:20;i:22085364;i:21;i:22085365;i:22;i:22085366;i:23;i:22085367;i:24;i:22085368;i:25;i:22085369;i:26;i:22085370;i:27;i:22085371;i:28;i:22085372;i:29;i:22085373;i:30;i:22085374;i:31;i:22085375;i:32;i:22085376;i:33;i:22085377;i:34;i:22085378;i:35;i:22085379;i:36;i:22085380;i:37;i:22085381;i:38;i:22085382;i:39;i:22085383;i:40;i:22085384;i:41;i:22085385;i:42;i:22085386;i:43;i:22085387;i:44;i:22085388;i:45;i:22085389;i:46;i:22085390;i:47;i:22085391;i:48;i:22085392;i:49;i:22085393;i:50;i:22085394;i:51;i:22085395;i:52;i:22085396;i:53;i:22085397;i:54;i:22085398;i:55;i:22085399;i:56;i:22085400;i:57;i:22085401;i:58;i:22085402;i:59;i:22085403;i:60;i:22085475;i:61;i:22085476;i:62;i:22085477;i:63;i:22085478;i:64;i:22085479;i:65;i:22085480;i:66;i:22085481;i:67;i:22085482;i:68;i:22085483;i:69;i:22085484;i:70;i:22085485;i:71;i:22085486;i:72;i:22085487;i:73;i:22085488;i:74;i:22085489;i:75;i:22085490;i:76;i:22085491;i:77;i:22085492;i:78;i:22085493;i:79;i:22085494;i:80;i:22207749;i:81;i:22207750;i:82;i:22207751;i:83;i:22207752;i:84;i:22207753;i:85;i:22207754;i:86;i:22207755;i:87;i:22207756;i:88;i:22207757;i:89;i:22207758;i:90;i:22207759;i:91;i:22207760;i:92;i:22207761;i:93;i:22207762;i:94;i:22207763;i:95;i:22207764;i:96;i:22207765;i:97;i:22207766;i:98;i:22207767;i:99;i:22207768;i:100;i:22912682;i:101;i:22912683;i:102;i:22912684;i:103;i:22912685;i:104;i:22912686;i:105;i:22912687;i:106;i:22912688;i:107;i:22912689;i:108;i:22912690;i:109;i:22912691;i:110;i:22912692;i:111;i:22912693;i:112;i:22912694;i:113;i:22912695;i:114;i:22912696;i:115;i:22912697;i:116;i:22912698;i:117;i:22912699;i:118;i:22912700;i:119;i:22912701;}"
}
["rets_supplement_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_supplement_modification_timestam"]=>
array(1) {
[0]=>
string(23) "2022-04-25T09:21:08.577"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-05-12"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-08-01"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(10) "2150000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-12-31"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-08-01"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 596-2888"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(35) "stephanie@waterfronthomeshawaii.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(19) "Stephanie R Andrews"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "51562"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(8) "16055746"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "KWPP"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(7) "8991040"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(24) "Keller Williams Honolulu"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 596-2888"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "22912682"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 225000.00
)
[assd_val_land] => Array
(
[0] => 1229100.00
)
[assd_val_total] => Array
(
[0] => 1454100.00
)
[bedrooms] => Array
(
[0] => 2
)
[building_style] => Array
(
[0] => Detach Single Family
)
[city] => Array
(
[0] => Laie
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Non Resident Owner,Property Disclosure Stmt
)
[easements] => Array
(
[0] => Other
)
[floor_covering] => Array
(
[0] => Vinyl
)
[frontage] => Array
(
[0] => Ocean,Sandy Beach,Stream/Canal,Waterfront
)
[full_baths] => Array
(
[0] => 2
)
[furnished] => Array
(
[0] => Negotiable
)
[half_baths] => Array
(
[0] => 0
)
[home_exampt] => Array
(
[0] => 0
)
[land_area_sf] => Array
(
[0] => 10942.00
)
[land_recorded] => Array
(
[0] => Regular System
)
[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] => 2022-04-25
)
[list_office_name] => Array
(
[0] => Hawaii Realty Group LLC
)
[list_price] => Array
(
[0] => 2250000.00
)
[living_sf] => Array
(
[0] => 1097
)
[location] => Array
(
[0] => 55-547 Kamehameha Highway, Laie, HI 96762
)
[mls_] => Array
(
[0] => 202207769
)
[neighborhood] => Array
(
[0] => LAIE
)
[number_of_parking_spaces] => Array
(
[0] => 2
)
[number_of_stories] => Array
(
[0] => One
)
[office_mls_id] => Array
(
[0] => HGRP
)
[parking_features] => Array
(
[0] => 2 Car
)
[pool_] => Array
(
[0] => None
)
[possession] => Array
(
[0] => At Closing
)
[postal_code] => Array
(
[0] => 96762
)
[property_condition] => Array
(
[0] => Average
)
[property_type] => Array
(
[0] => single_family
)
[property_type_label] => Array
(
[0] => single_family
)
[region] => Array
(
[0] => North Shore
)
[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_city] => Array
(
[0] => Laie
)
[rets_compensation_method] => Array
(
[0] => %
)
[rets_condo_property_regime_yn] => Array
(
[0] => 0
)
[rets_current_price] => Array
(
[0] => 2150000.00
)
[rets_dom] => Array
(
[0] => 17
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 1
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_id] => Array
(
[0] => 16608106
)
[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) 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] => 2250000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-04-25
)
[rets_lot_size_area] => Array
(
[0] => 10942.00
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-08-01T13:18:54.743
)
[rets_matrix_unique_id] => Array
(
[0] => 16608106
)
[rets_mls_number] => Array
(
[0] => 202207769
)
[rets_neighbourhood] => Array
(
[0] => LAIE
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-04-25T08:44:20.940
)
[rets_original_list_price] => Array
(
[0] => 2250000.00
)
[rets_parcel_number] => Array
(
[0] => 1-5-5-011-070-0000
)
[rets_parking_total] => Array
(
[0] => 2
)
[rets_permit_address_internet_yn] => Array
(
[0] => 1
)
[rets_permit_internet_yn] => Array
(
[0] => 1
)
[rets_photo_count] => Array
(
[0] => 20
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2022-04-25T08:44:20.940
)
[rets_postal_code] => Array
(
[0] => 96762
)
[rets_primary_key] => Array
(
[0] => 16608106
)
[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.
)
[rets_public_remarks] => Array
(
[0] => Paradise Found!!! Private beachfront living! One of only a few sandy beachfront properties on the North Shore. Calm waters front the house protected by two fringing reefs. Enjoy swimming, fishing and surfing, long beach walks, all in your backyard. Located within two minutes of the property you'll find two shopping centers with groceries, doctor offices, restaurants, The Polynesian Cultural Center, BYU-Hawaii and gorgeous white sand beaches. Also nearby is the world famous North Shore of Oahu with the "7 mile miracle" of world class waves, and Turtle Bay Resort with golf, dining, and adventure. This 2 bedroom/2 bathroom, single level, beach style living is what it is all about! This is the property you have been waiting for.
)
[rets_room_count] => Array
(
[0] => 7
)
[rets_sqft_roofed_living] => Array
(
[0] => 920
)
[rets_sqft_roofed_other] => Array
(
[0] => 177
)
[rets_sqft_total] => Array
(
[0] => 1097
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-08-01T13:18:54.743
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-08-01
)
[rets_street_name] => Array
(
[0] => Kamehameha
)
[rets_street_number] => Array
(
[0] => 55-547
)
[rets_street_view_param] => Array
(
[0] => 1$21.648263$-157.922308$95.28$13.33$1.00$CAoSK0FGMVFpcE9iMVlYNUZFazh1bmFSdHF1aVdLZlp3ZUNtaDlxcHE0UndTLUk.
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5%
)
[rets_tax_amount] => Array
(
[0] => 637.00
)
[rets_tax_annual_amount] => Array
(
[0] => 7644.00
)
[rets_tax_assessed_value] => Array
(
[0] => 1454100.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 225000.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 1229100.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 0
)
[rets_tax_paid_by_seller_yn] => Array
(
[0] => 0
)
[rets_tax_year] => Array
(
[0] => 2022
)
[rets_thumbnail_url] => Array
(
[0] => https://cdn.rets.ci/marcusrealty-images/16608106/3a06f5a465f1661dad0dc5aa229c6e54
)
[rets_tmk_area] => Array
(
[0] => 155
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 0
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 70
)
[rets_tmk_section] => Array
(
[0] => 5
)
[rets_tmk_zone] => Array
(
[0] => 5
)
[rets_tmkplat] => Array
(
[0] => 11
)
[rets_virtual_tour_url_unbranded] => Array
(
[0] => https://youtu.be/s5vAKUgYgB4
)
[rets_year_built] => Array
(
[0] => 1978
)
[rets_year_remodeled] => Array
(
[0] => 2003
)
[security] => Array
(
[0] => Key
)
[setbacks] => Array
(
[0] => Of Record
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Kamehameha
)
[street_number] => Array
(
[0] => 55-547
)
[street_suffix] => Array
(
[0] => Highway
)
[terms_accept] => Array
(
[0] => Cash,Conventional,VA
)
[tmk] => Array
(
[0] => 1-5-5-011-070-0000
)
[topography] => Array
(
[0] => Clear,Flag Lot
)
[view] => Array
(
[0] => Coastline,Mountain,Ocean,Sunrise
)
[virtual_tour] => Array
(
[0] => https://youtu.be/s5vAKUgYgB4
)
[wpp::rets_pk] => Array
(
[0] => 16608106
)
[wpp_gpid] => Array
(
[0] => 202207769
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1659395987
)
[year_built] => Array
(
[0] => 1978
)
[year_remodeled_] => Array
(
[0] => 2003
)
[zoning] => Array
(
[0] => 05 - R-5 Residential District
)
[new_attached_media] => Array
(
[0] => a:120:{i:0;i:22084977;i:1;i:22084978;i:2;i:22084979;i:3;i:22084980;i:4;i:22084981;i:5;i:22084982;i:6;i:22084983;i:7;i:22084984;i:8;i:22084985;i:9;i:22084986;i:10;i:22084987;i:11;i:22084988;i:12;i:22084989;i:13;i:22084990;i:14;i:22084991;i:15;i:22084992;i:16;i:22084993;i:17;i:22084994;i:18;i:22084995;i:19;i:22084996;i:20;i:22085364;i:21;i:22085365;i:22;i:22085366;i:23;i:22085367;i:24;i:22085368;i:25;i:22085369;i:26;i:22085370;i:27;i:22085371;i:28;i:22085372;i:29;i:22085373;i:30;i:22085374;i:31;i:22085375;i:32;i:22085376;i:33;i:22085377;i:34;i:22085378;i:35;i:22085379;i:36;i:22085380;i:37;i:22085381;i:38;i:22085382;i:39;i:22085383;i:40;i:22085384;i:41;i:22085385;i:42;i:22085386;i:43;i:22085387;i:44;i:22085388;i:45;i:22085389;i:46;i:22085390;i:47;i:22085391;i:48;i:22085392;i:49;i:22085393;i:50;i:22085394;i:51;i:22085395;i:52;i:22085396;i:53;i:22085397;i:54;i:22085398;i:55;i:22085399;i:56;i:22085400;i:57;i:22085401;i:58;i:22085402;i:59;i:22085403;i:60;i:22085475;i:61;i:22085476;i:62;i:22085477;i:63;i:22085478;i:64;i:22085479;i:65;i:22085480;i:66;i:22085481;i:67;i:22085482;i:68;i:22085483;i:69;i:22085484;i:70;i:22085485;i:71;i:22085486;i:72;i:22085487;i:73;i:22085488;i:74;i:22085489;i:75;i:22085490;i:76;i:22085491;i:77;i:22085492;i:78;i:22085493;i:79;i:22085494;i:80;i:22207749;i:81;i:22207750;i:82;i:22207751;i:83;i:22207752;i:84;i:22207753;i:85;i:22207754;i:86;i:22207755;i:87;i:22207756;i:88;i:22207757;i:89;i:22207758;i:90;i:22207759;i:91;i:22207760;i:92;i:22207761;i:93;i:22207762;i:94;i:22207763;i:95;i:22207764;i:96;i:22207765;i:97;i:22207766;i:98;i:22207767;i:99;i:22207768;i:100;i:22912682;i:101;i:22912683;i:102;i:22912684;i:103;i:22912685;i:104;i:22912686;i:105;i:22912687;i:106;i:22912688;i:107;i:22912689;i:108;i:22912690;i:109;i:22912691;i:110;i:22912692;i:111;i:22912693;i:112;i:22912694;i:113;i:22912695;i:114;i:22912696;i:115;i:22912697;i:116;i:22912698;i:117;i:22912699;i:118;i:22912700;i:119;i:22912701;}
)
[rets_supplement_count] => Array
(
[0] => 0
)
[rets_supplement_modification_timestam] => Array
(
[0] => 2022-04-25T09:21:08.577
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-05-12
)
[rets_close_date] => Array
(
[0] => 2022-08-01
)
[rets_close_price] => Array
(
[0] => 2150000.00
)
[rets_expiration_date] => Array
(
[0] => 2022-12-31
)
[rets_off_market_date] => Array
(
[0] => 2022-08-01
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 596-2888
)
[rets_selling_agent_email] => Array
(
[0] => stephanie@waterfronthomeshawaii.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Stephanie R Andrews
)
[rets_selling_agent_mlsid] => Array
(
[0] => 51562
)
[rets_selling_agent_mui] => Array
(
[0] => 16055746
)
[rets_selling_office_mlsid] => Array
(
[0] => KWPP
)
[rets_selling_office_mui] => Array
(
[0] => 8991040
)
[rets_selling_office_name] => Array
(
[0] => Keller Williams Honolulu
)
[rets_selling_office_phone] => Array
(
[0] => (808) 596-2888
)
[_thumbnail_id] => Array
(
[0] => 22912682
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446