A VERY RARE OPPORTUNITY to own on the coveted and limited ocean front of Oahu.. Currently the best priced ocean front lot from Sunset Beach to Laie, under $2M with the largest square footage on the SANDY BEACH. Bring your contractor and your dreams to develop on this gorgeous sandy beachfront lot with steps to heavenly “BATHTUB BEACH”. Well known for a crystal blue natural reef formation that is truly majestic, right out your door… BUILDING PLANS AND PERMIT ARE IN PROCESS. The home is a teardown. SOLD AS IS, Owner will offer breakdown and removal of the dwelling upon favorable price/terms. DO NOT drive into this property without an appointment. ZONED R-5, this lot has many possibilities… Buyer to do their due diligence with information and disclosures provided. Across the street from the Polynesian Cultural Center. Nearby BYU, shopping, and hip local eateries. Please watch the video for a magic tour of the area. BONUS: Connected to Laie Sewer. DO NOT DISTURB TENANTS OR DRIVE/WALK ON PROPERTY WITHOUT AN APPOINTMENT PLEASE..
Listing by: Hawaii Life
array(136) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "220700.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(10) "1196900.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(10) "1417600.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "3"
}
["building_style"]=>
array(1) {
[0]=>
string(8) "Attached"
}
["city"]=>
array(1) {
[0]=>
string(4) "Laie"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(48) "Call Listor,Property Disclosure Stmt,See Remarks"
}
["easements"]=>
array(1) {
[0]=>
string(18) "Beach Access,Sewer"
}
["floor_covering"]=>
array(1) {
[0]=>
string(5) "Other"
}
["frontage"]=>
array(1) {
[0]=>
string(5) "Ocean"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "1"
}
["furnished"]=>
array(1) {
[0]=>
string(4) "None"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["home_exampt"]=>
array(1) {
[0]=>
string(7) "100,000"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(8) "13280.00"
}
["land_recorded"]=>
array(1) {
[0]=>
string(12) "Dual Systems"
}
["land_tenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["list_agent_email"]=>
array(1) {
[0]=>
string(28) "dianaricciuti@hawaiilife.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(14) "Diana Ricciuti"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(800) 370-3848"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-07-14"
}
["list_office_name"]=>
array(1) {
[0]=>
string(11) "Hawaii Life"
}
["list_price"]=>
array(1) {
[0]=>
string(10) "1750000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "1104"
}
["location"]=>
array(1) {
[0]=>
string(41) "55-349 Kamehameha Highway, Laie, HI 96762"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202213604"
}
["neighborhood"]=>
array(1) {
[0]=>
string(4) "LAIE"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "6"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(3) "One"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "HLRE"
}
["parking_features"]=>
array(1) {
[0]=>
string(6) "3 Car+"
}
["pool_"]=>
array(1) {
[0]=>
string(4) "None"
}
["possession"]=>
array(1) {
[0]=>
string(21) "At Closing,Negotiable"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96762"
}
["property_condition"]=>
array(1) {
[0]=>
string(9) "Tear Down"
}
["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) "1"
}
["rets_baths_half"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_baths_total"]=>
array(1) {
[0]=>
string(4) "1.00"
}
["rets_beds_total"]=>
array(1) {
[0]=>
string(1) "3"
}
["rets_city"]=>
array(1) {
[0]=>
string(4) "Laie"
}
["rets_condo_property_regime_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(10) "1750000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(3) "228"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["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) "16764573"
}
["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) "(800) 370-3848"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(28) "dianaricciuti@hawaiilife.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(14) "Diana Ricciuti"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "24713"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "3474983"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "HLRE"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(7) "3487136"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(11) "Hawaii Life"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(800) 370-3848"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(10) "1750000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-07-14"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(8) "13280.00"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2023-02-27T09:30:52.770"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16764573"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202213604"
}
["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-07-18T05:30:23.777"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(10) "1780000.00"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-5-5-002-095-0000"
}
["rets_parking_total"]=>
array(1) {
[0]=>
string(1) "6"
}
["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) "24"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-10-25T05:48:02.220"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96762"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-09-23T09:26:09.970"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16764573"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(244) "By appointment. Please call listing agent Diana Ricciuti #808-386-2126, or email dianaricciuti@hawaiilife.com with your request. Qualified inquires only, Pre-Approval letter or proof of funds will be required prior to scheduling a site visit."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(1055) "A VERY RARE OPPORTUNITY to own on the coveted and limited ocean front of Oahu.. Currently the best priced ocean front lot from Sunset Beach to Laie, under $2M with the largest square footage on the SANDY BEACH. Bring your contractor and your dreams to develop on this gorgeous sandy beachfront lot with steps to heavenly "BATHTUB BEACH". Well known for a crystal blue natural reef formation that is truly majestic, right out your door... BUILDING PLANS AND PERMIT ARE IN PROCESS. The home is a teardown. SOLD AS IS, Owner will offer breakdown and removal of the dwelling upon favorable price/terms. DO NOT drive into this property without an appointment. ZONED R-5, this lot has many possibilities... Buyer to do their due diligence with information and disclosures provided. Across the street from the Polynesian Cultural Center. Nearby BYU, shopping, and hip local eateries. Please watch the video for a magic tour of the area. BONUS: Connected to Laie Sewer. DO NOT DISTURB TENANTS OR DRIVE/WALK ON PROPERTY WITHOUT AN APPOINTMENT PLEASE.."
}
["rets_room_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "1104"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "1104"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-07-18T05:30:23.777"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-07-14"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(10) "Kamehameha"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(6) "55-349"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(64) "1$21.638429$-157.918674$116.58$13.33$1.00$yiH3Ano22RiT0SwfJgN4BA"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(3) "2.5"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "384.30"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "4611.60"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(10) "1417600.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "220700.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(10) "1196900.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(7) "100,000"
}
["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/16764573/0b8d22550d126292d427cf4ffca6b21a"
}
["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) "95"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "5"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "5"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1956"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(4) "1966"
}
["security"]=>
array(1) {
[0]=>
string(3) "Key"
}
["setbacks"]=>
array(1) {
[0]=>
string(3) "C&C"
}
["state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["street_name"]=>
array(1) {
[0]=>
string(10) "Kamehameha"
}
["street_number"]=>
array(1) {
[0]=>
string(6) "55-349"
}
["street_suffix"]=>
array(1) {
[0]=>
string(7) "Highway"
}
["terms_accept"]=>
array(1) {
[0]=>
string(34) "Cash,Conventional,Seller Financing"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-5-5-002-095-0000"
}
["topography"]=>
array(1) {
[0]=>
string(8) "Flag Lot"
}
["view"]=>
array(1) {
[0]=>
string(39) "Coastline,Mountain,Ocean,Sunrise,Sunset"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16764573"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202213604"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1677526278"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1956"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "1966"
}
["zoning"]=>
array(1) {
[0]=>
string(29) "05 - R-5 Residential District"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(6358) "a:380:{i:0;i:22759581;i:1;i:22759582;i:2;i:22759583;i:3;i:22759584;i:4;i:22759585;i:5;i:22759586;i:6;i:22759587;i:7;i:22759588;i:8;i:22759589;i:9;i:22759590;i:10;i:22759591;i:11;i:22759592;i:12;i:22759593;i:13;i:22759594;i:14;i:22759595;i:15;i:22759596;i:16;i:22759597;i:17;i:22759598;i:18;i:22767697;i:19;i:22767698;i:20;i:22767699;i:21;i:22767700;i:22;i:22767701;i:23;i:22767702;i:24;i:22767703;i:25;i:22767704;i:26;i:22767705;i:27;i:22767706;i:28;i:22767707;i:29;i:22771644;i:30;i:22771645;i:31;i:22771646;i:32;i:22771647;i:33;i:22771648;i:34;i:22771649;i:35;i:22771650;i:36;i:22771651;i:37;i:22771652;i:38;i:22771653;i:39;i:22771654;i:40;i:22771655;i:41;i:22771698;i:42;i:22771699;i:43;i:22771700;i:44;i:22771701;i:45;i:22771702;i:46;i:22771703;i:47;i:22771704;i:48;i:22771705;i:49;i:22771706;i:50;i:22771707;i:51;i:22771708;i:52;i:22771709;i:53;i:22784314;i:54;i:22784315;i:55;i:22784316;i:56;i:22784317;i:57;i:22784318;i:58;i:22784319;i:59;i:22784320;i:60;i:22784321;i:61;i:22784322;i:62;i:22784323;i:63;i:22784324;i:64;i:22784325;i:65;i:22880827;i:66;i:22880828;i:67;i:22880829;i:68;i:22880830;i:69;i:22880831;i:70;i:22880832;i:71;i:22880833;i:72;i:22880834;i:73;i:22880835;i:74;i:22880836;i:75;i:22880837;i:76;i:22880838;i:77;i:22880839;i:78;i:22880840;i:79;i:22880841;i:80;i:22880842;i:81;i:22880843;i:82;i:22880844;i:83;i:22880845;i:84;i:22880846;i:85;i:22880847;i:86;i:22880848;i:87;i:22880849;i:88;i:22880850;i:89;i:22880851;i:90;i:22880852;i:91;i:22880853;i:92;i:22880854;i:93;i:22880855;i:94;i:22880856;i:95;i:22880857;i:96;i:22880858;i:97;i:22880859;i:98;i:22880860;i:99;i:22880861;i:100;i:22880862;i:101;i:22880863;i:102;i:22880864;i:103;i:22880865;i:104;i:22880866;i:105;i:22880867;i:106;i:22880868;i:107;i:23073068;i:108;i:23073069;i:109;i:23073070;i:110;i:23073071;i:111;i:23073072;i:112;i:23073073;i:113;i:23073074;i:114;i:23073075;i:115;i:23073076;i:116;i:23073077;i:117;i:23073078;i:118;i:23073079;i:119;i:23073080;i:120;i:23073081;i:121;i:23073082;i:122;i:23073083;i:123;i:23073084;i:124;i:23073085;i:125;i:23073086;i:126;i:23073087;i:127;i:23073088;i:128;i:23073089;i:129;i:23073090;i:130;i:23073091;i:131;i:23073092;i:132;i:23073093;i:133;i:23073094;i:134;i:23073095;i:135;i:23073096;i:136;i:23073097;i:137;i:23073098;i:138;i:23073099;i:139;i:23073100;i:140;i:23073101;i:141;i:23073102;i:142;i:23073103;i:143;i:23073104;i:144;i:23073105;i:145;i:23073106;i:146;i:23073107;i:147;i:23073108;i:148;i:23073109;i:149;i:23073398;i:150;i:23073399;i:151;i:23073400;i:152;i:23073401;i:153;i:23073402;i:154;i:23073403;i:155;i:23073404;i:156;i:23073405;i:157;i:23073406;i:158;i:23073407;i:159;i:23073408;i:160;i:23073409;i:161;i:23073410;i:162;i:23073411;i:163;i:23073412;i:164;i:23073413;i:165;i:23073414;i:166;i:23073415;i:167;i:23073416;i:168;i:23073417;i:169;i:23073418;i:170;i:23073440;i:171;i:23073441;i:172;i:23073442;i:173;i:23073443;i:174;i:23073444;i:175;i:23073445;i:176;i:23073446;i:177;i:23073447;i:178;i:23073448;i:179;i:23073449;i:180;i:23073450;i:181;i:23073451;i:182;i:23073452;i:183;i:23073453;i:184;i:23073454;i:185;i:23073455;i:186;i:23073456;i:187;i:23073457;i:188;i:23073458;i:189;i:23073459;i:190;i:23073460;i:191;i:23074796;i:192;i:23074797;i:193;i:23074798;i:194;i:23074799;i:195;i:23074800;i:196;i:23074801;i:197;i:23074802;i:198;i:23074803;i:199;i:23074804;i:200;i:23074805;i:201;i:23074806;i:202;i:23074807;i:203;i:23074808;i:204;i:23074809;i:205;i:23074810;i:206;i:23074811;i:207;i:23074812;i:208;i:23074813;i:209;i:23074814;i:210;i:23074815;i:211;i:23074816;i:212;i:23400162;i:213;i:23400163;i:214;i:23400164;i:215;i:23400165;i:216;i:23400166;i:217;i:23400167;i:218;i:23400168;i:219;i:23400169;i:220;i:23400170;i:221;i:23400171;i:222;i:23400172;i:223;i:23400173;i:224;i:23400174;i:225;i:23400175;i:226;i:23400176;i:227;i:23400177;i:228;i:23400178;i:229;i:23400179;i:230;i:23400180;i:231;i:23400181;i:232;i:23400182;i:233;i:23400337;i:234;i:23400338;i:235;i:23400339;i:236;i:23400340;i:237;i:23400341;i:238;i:23400342;i:239;i:23400343;i:240;i:23400344;i:241;i:23400345;i:242;i:23400346;i:243;i:23400347;i:244;i:23400348;i:245;i:23400349;i:246;i:23400350;i:247;i:23400351;i:248;i:23400352;i:249;i:23400353;i:250;i:23400354;i:251;i:23400355;i:252;i:23400356;i:253;i:23400357;i:254;i:23421648;i:255;i:23421649;i:256;i:23421650;i:257;i:23421651;i:258;i:23421652;i:259;i:23421653;i:260;i:23421654;i:261;i:23421655;i:262;i:23421656;i:263;i:23421657;i:264;i:23421658;i:265;i:23421659;i:266;i:23421660;i:267;i:23421661;i:268;i:23421662;i:269;i:23421663;i:270;i:23421664;i:271;i:23421665;i:272;i:23421666;i:273;i:23421667;i:274;i:23421668;i:275;i:23713014;i:276;i:23713015;i:277;i:23713016;i:278;i:23713017;i:279;i:23713018;i:280;i:23713019;i:281;i:23713020;i:282;i:23713021;i:283;i:23713022;i:284;i:23713023;i:285;i:23713024;i:286;i:23713025;i:287;i:23713026;i:288;i:23713027;i:289;i:23713028;i:290;i:23713029;i:291;i:23713030;i:292;i:23713031;i:293;i:23713032;i:294;i:23713033;i:295;i:23713034;i:296;i:24295747;i:297;i:24295748;i:298;i:24295749;i:299;i:24295750;i:300;i:24295751;i:301;i:24295752;i:302;i:24295753;i:303;i:24295754;i:304;i:24295755;i:305;i:24295756;i:306;i:24295757;i:307;i:24295758;i:308;i:24295759;i:309;i:24295760;i:310;i:24295761;i:311;i:24295762;i:312;i:24295763;i:313;i:24295764;i:314;i:24295765;i:315;i:24295766;i:316;i:24295767;i:317;i:24295834;i:318;i:24295835;i:319;i:24295836;i:320;i:24295837;i:321;i:24295838;i:322;i:24295839;i:323;i:24295840;i:324;i:24295841;i:325;i:24295842;i:326;i:24295843;i:327;i:24295844;i:328;i:24295845;i:329;i:24295846;i:330;i:24295847;i:331;i:24295848;i:332;i:24295849;i:333;i:24295850;i:334;i:24295851;i:335;i:24295852;i:336;i:24295853;i:337;i:24295854;i:338;i:24559291;i:339;i:24559292;i:340;i:24559293;i:341;i:24559294;i:342;i:24559295;i:343;i:24559296;i:344;i:24559297;i:345;i:24559298;i:346;i:24559299;i:347;i:24559300;i:348;i:24559301;i:349;i:24559302;i:350;i:24559303;i:351;i:24559304;i:352;i:24559305;i:353;i:24559306;i:354;i:24559307;i:355;i:24559308;i:356;i:24559309;i:357;i:24559310;i:358;i:24559311;i:359;i:24678087;i:360;i:24678088;i:361;i:24678089;i:362;i:24678090;i:363;i:24678091;i:364;i:24678092;i:365;i:24678093;i:366;i:24678094;i:367;i:24678095;i:368;i:24678096;i:369;i:24678097;i:370;i:24678098;i:371;i:24678099;i:372;i:24678100;i:373;i:24678101;i:374;i:24678102;i:375;i:24678103;i:376;i:24678104;i:377;i:24678105;i:378;i:24678106;i:379;i:24678107;}"
}
["rets_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(82) "https://drive.google.com/file/d/1f15nVA3wHbz5sEucftVeO0fGJMPuPGXP/view?usp=sharing"
}
["virtual_tour"]=>
array(1) {
[0]=>
string(82) "https://drive.google.com/file/d/1f15nVA3wHbz5sEucftVeO0fGJMPuPGXP/view?usp=sharing"
}
["rets_attribution_contact"]=>
array(1) {
[0]=>
string(14) "(808) 386-2126"
}
["rets_exempt_listing_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "24678087"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 220700.00
)
[assd_val_land] => Array
(
[0] => 1196900.00
)
[assd_val_total] => Array
(
[0] => 1417600.00
)
[bedrooms] => Array
(
[0] => 3
)
[building_style] => Array
(
[0] => Attached
)
[city] => Array
(
[0] => Laie
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Call Listor,Property Disclosure Stmt,See Remarks
)
[easements] => Array
(
[0] => Beach Access,Sewer
)
[floor_covering] => Array
(
[0] => Other
)
[frontage] => Array
(
[0] => Ocean
)
[full_baths] => Array
(
[0] => 1
)
[furnished] => Array
(
[0] => None
)
[half_baths] => Array
(
[0] => 0
)
[home_exampt] => Array
(
[0] => 100,000
)
[land_area_sf] => Array
(
[0] => 13280.00
)
[land_recorded] => Array
(
[0] => Dual Systems
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => dianaricciuti@hawaiilife.com
)
[list_agent_name] => Array
(
[0] => Diana Ricciuti
)
[list_agent_phone_number] => Array
(
[0] => (800) 370-3848
)
[list_date] => Array
(
[0] => 2022-07-14
)
[list_office_name] => Array
(
[0] => Hawaii Life
)
[list_price] => Array
(
[0] => 1750000.00
)
[living_sf] => Array
(
[0] => 1104
)
[location] => Array
(
[0] => 55-349 Kamehameha Highway, Laie, HI 96762
)
[mls_] => Array
(
[0] => 202213604
)
[neighborhood] => Array
(
[0] => LAIE
)
[number_of_parking_spaces] => Array
(
[0] => 6
)
[number_of_stories] => Array
(
[0] => One
)
[office_mls_id] => Array
(
[0] => HLRE
)
[parking_features] => Array
(
[0] => 3 Car+
)
[pool_] => Array
(
[0] => None
)
[possession] => Array
(
[0] => At Closing,Negotiable
)
[postal_code] => Array
(
[0] => 96762
)
[property_condition] => Array
(
[0] => Tear Down
)
[property_type] => Array
(
[0] => single_family
)
[property_type_label] => Array
(
[0] => single_family
)
[region] => Array
(
[0] => North Shore
)
[rets_baths_full] => Array
(
[0] => 1
)
[rets_baths_half] => Array
(
[0] => 0
)
[rets_baths_total] => Array
(
[0] => 1.00
)
[rets_beds_total] => Array
(
[0] => 3
)
[rets_city] => Array
(
[0] => Laie
)
[rets_condo_property_regime_yn] => Array
(
[0] => 0
)
[rets_current_price] => Array
(
[0] => 1750000.00
)
[rets_dom] => Array
(
[0] => 228
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_id] => Array
(
[0] => 16764573
)
[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] => (800) 370-3848
)
[rets_list_agent_email] => Array
(
[0] => dianaricciuti@hawaiilife.com
)
[rets_list_agent_full_name] => Array
(
[0] => Diana Ricciuti
)
[rets_list_agent_mlsid] => Array
(
[0] => 24713
)
[rets_list_agent_mui] => Array
(
[0] => 3474983
)
[rets_list_office_mlsid] => Array
(
[0] => HLRE
)
[rets_list_office_mui] => Array
(
[0] => 3487136
)
[rets_list_office_name] => Array
(
[0] => Hawaii Life
)
[rets_list_office_phone] => Array
(
[0] => (800) 370-3848
)
[rets_list_price] => Array
(
[0] => 1750000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-07-14
)
[rets_lot_size_area] => Array
(
[0] => 13280.00
)
[rets_matrix_modified_dt] => Array
(
[0] => 2023-02-27T09:30:52.770
)
[rets_matrix_unique_id] => Array
(
[0] => 16764573
)
[rets_mls_number] => Array
(
[0] => 202213604
)
[rets_neighbourhood] => Array
(
[0] => LAIE
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-07-18T05:30:23.777
)
[rets_original_list_price] => Array
(
[0] => 1780000.00
)
[rets_parcel_number] => Array
(
[0] => 1-5-5-002-095-0000
)
[rets_parking_total] => Array
(
[0] => 6
)
[rets_permit_address_internet_yn] => Array
(
[0] => 1
)
[rets_permit_internet_yn] => Array
(
[0] => 1
)
[rets_photo_count] => Array
(
[0] => 24
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2022-10-25T05:48:02.220
)
[rets_postal_code] => Array
(
[0] => 96762
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-09-23T09:26:09.970
)
[rets_primary_key] => Array
(
[0] => 16764573
)
[rets_private_remarks] => Array
(
[0] => By appointment. Please call listing agent Diana Ricciuti #808-386-2126, or email dianaricciuti@hawaiilife.com with your request. Qualified inquires only, Pre-Approval letter or proof of funds will be required prior to scheduling a site visit.
)
[rets_public_remarks] => Array
(
[0] => A VERY RARE OPPORTUNITY to own on the coveted and limited ocean front of Oahu.. Currently the best priced ocean front lot from Sunset Beach to Laie, under $2M with the largest square footage on the SANDY BEACH. Bring your contractor and your dreams to develop on this gorgeous sandy beachfront lot with steps to heavenly "BATHTUB BEACH". Well known for a crystal blue natural reef formation that is truly majestic, right out your door... BUILDING PLANS AND PERMIT ARE IN PROCESS. The home is a teardown. SOLD AS IS, Owner will offer breakdown and removal of the dwelling upon favorable price/terms. DO NOT drive into this property without an appointment. ZONED R-5, this lot has many possibilities... Buyer to do their due diligence with information and disclosures provided. Across the street from the Polynesian Cultural Center. Nearby BYU, shopping, and hip local eateries. Please watch the video for a magic tour of the area. BONUS: Connected to Laie Sewer. DO NOT DISTURB TENANTS OR DRIVE/WALK ON PROPERTY WITHOUT AN APPOINTMENT PLEASE..
)
[rets_room_count] => Array
(
[0] => 0
)
[rets_sqft_roofed_living] => Array
(
[0] => 1104
)
[rets_sqft_total] => Array
(
[0] => 1104
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-07-18T05:30:23.777
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-07-14
)
[rets_street_name] => Array
(
[0] => Kamehameha
)
[rets_street_number] => Array
(
[0] => 55-349
)
[rets_street_view_param] => Array
(
[0] => 1$21.638429$-157.918674$116.58$13.33$1.00$yiH3Ano22RiT0SwfJgN4BA
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5
)
[rets_tax_amount] => Array
(
[0] => 384.30
)
[rets_tax_annual_amount] => Array
(
[0] => 4611.60
)
[rets_tax_assessed_value] => Array
(
[0] => 1417600.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 220700.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 1196900.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 100,000
)
[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/16764573/0b8d22550d126292d427cf4ffca6b21a
)
[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] => 95
)
[rets_tmk_section] => Array
(
[0] => 5
)
[rets_tmk_zone] => Array
(
[0] => 5
)
[rets_tmkplat] => Array
(
[0] => 2
)
[rets_year_built] => Array
(
[0] => 1956
)
[rets_year_remodeled] => Array
(
[0] => 1966
)
[security] => Array
(
[0] => Key
)
[setbacks] => Array
(
[0] => C&C
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Active
)
[street_name] => Array
(
[0] => Kamehameha
)
[street_number] => Array
(
[0] => 55-349
)
[street_suffix] => Array
(
[0] => Highway
)
[terms_accept] => Array
(
[0] => Cash,Conventional,Seller Financing
)
[tmk] => Array
(
[0] => 1-5-5-002-095-0000
)
[topography] => Array
(
[0] => Flag Lot
)
[view] => Array
(
[0] => Coastline,Mountain,Ocean,Sunrise,Sunset
)
[wpp::rets_pk] => Array
(
[0] => 16764573
)
[wpp_gpid] => Array
(
[0] => 202213604
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1677526278
)
[year_built] => Array
(
[0] => 1956
)
[year_remodeled_] => Array
(
[0] => 1966
)
[zoning] => Array
(
[0] => 05 - R-5 Residential District
)
[new_attached_media] => Array
(
[0] => a:380:{i:0;i:22759581;i:1;i:22759582;i:2;i:22759583;i:3;i:22759584;i:4;i:22759585;i:5;i:22759586;i:6;i:22759587;i:7;i:22759588;i:8;i:22759589;i:9;i:22759590;i:10;i:22759591;i:11;i:22759592;i:12;i:22759593;i:13;i:22759594;i:14;i:22759595;i:15;i:22759596;i:16;i:22759597;i:17;i:22759598;i:18;i:22767697;i:19;i:22767698;i:20;i:22767699;i:21;i:22767700;i:22;i:22767701;i:23;i:22767702;i:24;i:22767703;i:25;i:22767704;i:26;i:22767705;i:27;i:22767706;i:28;i:22767707;i:29;i:22771644;i:30;i:22771645;i:31;i:22771646;i:32;i:22771647;i:33;i:22771648;i:34;i:22771649;i:35;i:22771650;i:36;i:22771651;i:37;i:22771652;i:38;i:22771653;i:39;i:22771654;i:40;i:22771655;i:41;i:22771698;i:42;i:22771699;i:43;i:22771700;i:44;i:22771701;i:45;i:22771702;i:46;i:22771703;i:47;i:22771704;i:48;i:22771705;i:49;i:22771706;i:50;i:22771707;i:51;i:22771708;i:52;i:22771709;i:53;i:22784314;i:54;i:22784315;i:55;i:22784316;i:56;i:22784317;i:57;i:22784318;i:58;i:22784319;i:59;i:22784320;i:60;i:22784321;i:61;i:22784322;i:62;i:22784323;i:63;i:22784324;i:64;i:22784325;i:65;i:22880827;i:66;i:22880828;i:67;i:22880829;i:68;i:22880830;i:69;i:22880831;i:70;i:22880832;i:71;i:22880833;i:72;i:22880834;i:73;i:22880835;i:74;i:22880836;i:75;i:22880837;i:76;i:22880838;i:77;i:22880839;i:78;i:22880840;i:79;i:22880841;i:80;i:22880842;i:81;i:22880843;i:82;i:22880844;i:83;i:22880845;i:84;i:22880846;i:85;i:22880847;i:86;i:22880848;i:87;i:22880849;i:88;i:22880850;i:89;i:22880851;i:90;i:22880852;i:91;i:22880853;i:92;i:22880854;i:93;i:22880855;i:94;i:22880856;i:95;i:22880857;i:96;i:22880858;i:97;i:22880859;i:98;i:22880860;i:99;i:22880861;i:100;i:22880862;i:101;i:22880863;i:102;i:22880864;i:103;i:22880865;i:104;i:22880866;i:105;i:22880867;i:106;i:22880868;i:107;i:23073068;i:108;i:23073069;i:109;i:23073070;i:110;i:23073071;i:111;i:23073072;i:112;i:23073073;i:113;i:23073074;i:114;i:23073075;i:115;i:23073076;i:116;i:23073077;i:117;i:23073078;i:118;i:23073079;i:119;i:23073080;i:120;i:23073081;i:121;i:23073082;i:122;i:23073083;i:123;i:23073084;i:124;i:23073085;i:125;i:23073086;i:126;i:23073087;i:127;i:23073088;i:128;i:23073089;i:129;i:23073090;i:130;i:23073091;i:131;i:23073092;i:132;i:23073093;i:133;i:23073094;i:134;i:23073095;i:135;i:23073096;i:136;i:23073097;i:137;i:23073098;i:138;i:23073099;i:139;i:23073100;i:140;i:23073101;i:141;i:23073102;i:142;i:23073103;i:143;i:23073104;i:144;i:23073105;i:145;i:23073106;i:146;i:23073107;i:147;i:23073108;i:148;i:23073109;i:149;i:23073398;i:150;i:23073399;i:151;i:23073400;i:152;i:23073401;i:153;i:23073402;i:154;i:23073403;i:155;i:23073404;i:156;i:23073405;i:157;i:23073406;i:158;i:23073407;i:159;i:23073408;i:160;i:23073409;i:161;i:23073410;i:162;i:23073411;i:163;i:23073412;i:164;i:23073413;i:165;i:23073414;i:166;i:23073415;i:167;i:23073416;i:168;i:23073417;i:169;i:23073418;i:170;i:23073440;i:171;i:23073441;i:172;i:23073442;i:173;i:23073443;i:174;i:23073444;i:175;i:23073445;i:176;i:23073446;i:177;i:23073447;i:178;i:23073448;i:179;i:23073449;i:180;i:23073450;i:181;i:23073451;i:182;i:23073452;i:183;i:23073453;i:184;i:23073454;i:185;i:23073455;i:186;i:23073456;i:187;i:23073457;i:188;i:23073458;i:189;i:23073459;i:190;i:23073460;i:191;i:23074796;i:192;i:23074797;i:193;i:23074798;i:194;i:23074799;i:195;i:23074800;i:196;i:23074801;i:197;i:23074802;i:198;i:23074803;i:199;i:23074804;i:200;i:23074805;i:201;i:23074806;i:202;i:23074807;i:203;i:23074808;i:204;i:23074809;i:205;i:23074810;i:206;i:23074811;i:207;i:23074812;i:208;i:23074813;i:209;i:23074814;i:210;i:23074815;i:211;i:23074816;i:212;i:23400162;i:213;i:23400163;i:214;i:23400164;i:215;i:23400165;i:216;i:23400166;i:217;i:23400167;i:218;i:23400168;i:219;i:23400169;i:220;i:23400170;i:221;i:23400171;i:222;i:23400172;i:223;i:23400173;i:224;i:23400174;i:225;i:23400175;i:226;i:23400176;i:227;i:23400177;i:228;i:23400178;i:229;i:23400179;i:230;i:23400180;i:231;i:23400181;i:232;i:23400182;i:233;i:23400337;i:234;i:23400338;i:235;i:23400339;i:236;i:23400340;i:237;i:23400341;i:238;i:23400342;i:239;i:23400343;i:240;i:23400344;i:241;i:23400345;i:242;i:23400346;i:243;i:23400347;i:244;i:23400348;i:245;i:23400349;i:246;i:23400350;i:247;i:23400351;i:248;i:23400352;i:249;i:23400353;i:250;i:23400354;i:251;i:23400355;i:252;i:23400356;i:253;i:23400357;i:254;i:23421648;i:255;i:23421649;i:256;i:23421650;i:257;i:23421651;i:258;i:23421652;i:259;i:23421653;i:260;i:23421654;i:261;i:23421655;i:262;i:23421656;i:263;i:23421657;i:264;i:23421658;i:265;i:23421659;i:266;i:23421660;i:267;i:23421661;i:268;i:23421662;i:269;i:23421663;i:270;i:23421664;i:271;i:23421665;i:272;i:23421666;i:273;i:23421667;i:274;i:23421668;i:275;i:23713014;i:276;i:23713015;i:277;i:23713016;i:278;i:23713017;i:279;i:23713018;i:280;i:23713019;i:281;i:23713020;i:282;i:23713021;i:283;i:23713022;i:284;i:23713023;i:285;i:23713024;i:286;i:23713025;i:287;i:23713026;i:288;i:23713027;i:289;i:23713028;i:290;i:23713029;i:291;i:23713030;i:292;i:23713031;i:293;i:23713032;i:294;i:23713033;i:295;i:23713034;i:296;i:24295747;i:297;i:24295748;i:298;i:24295749;i:299;i:24295750;i:300;i:24295751;i:301;i:24295752;i:302;i:24295753;i:303;i:24295754;i:304;i:24295755;i:305;i:24295756;i:306;i:24295757;i:307;i:24295758;i:308;i:24295759;i:309;i:24295760;i:310;i:24295761;i:311;i:24295762;i:312;i:24295763;i:313;i:24295764;i:314;i:24295765;i:315;i:24295766;i:316;i:24295767;i:317;i:24295834;i:318;i:24295835;i:319;i:24295836;i:320;i:24295837;i:321;i:24295838;i:322;i:24295839;i:323;i:24295840;i:324;i:24295841;i:325;i:24295842;i:326;i:24295843;i:327;i:24295844;i:328;i:24295845;i:329;i:24295846;i:330;i:24295847;i:331;i:24295848;i:332;i:24295849;i:333;i:24295850;i:334;i:24295851;i:335;i:24295852;i:336;i:24295853;i:337;i:24295854;i:338;i:24559291;i:339;i:24559292;i:340;i:24559293;i:341;i:24559294;i:342;i:24559295;i:343;i:24559296;i:344;i:24559297;i:345;i:24559298;i:346;i:24559299;i:347;i:24559300;i:348;i:24559301;i:349;i:24559302;i:350;i:24559303;i:351;i:24559304;i:352;i:24559305;i:353;i:24559306;i:354;i:24559307;i:355;i:24559308;i:356;i:24559309;i:357;i:24559310;i:358;i:24559311;i:359;i:24678087;i:360;i:24678088;i:361;i:24678089;i:362;i:24678090;i:363;i:24678091;i:364;i:24678092;i:365;i:24678093;i:366;i:24678094;i:367;i:24678095;i:368;i:24678096;i:369;i:24678097;i:370;i:24678098;i:371;i:24678099;i:372;i:24678100;i:373;i:24678101;i:374;i:24678102;i:375;i:24678103;i:376;i:24678104;i:377;i:24678105;i:378;i:24678106;i:379;i:24678107;}
)
[rets_virtual_tour_url_unbranded] => Array
(
[0] => https://drive.google.com/file/d/1f15nVA3wHbz5sEucftVeO0fGJMPuPGXP/view?usp=sharing
)
[virtual_tour] => Array
(
[0] => https://drive.google.com/file/d/1f15nVA3wHbz5sEucftVeO0fGJMPuPGXP/view?usp=sharing
)
[rets_attribution_contact] => Array
(
[0] => (808) 386-2126
)
[rets_exempt_listing_yn] => Array
(
[0] => 0
)
[_thumbnail_id] => Array
(
[0] => 24678087
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446