Diamond in the rough! Largest lot on the street of 8,441 sq. ft. with possible duplex potential. Beachside community with Underground utilities, Large stucco perimeter wall. Permitted In ground pool just needs finishing touches. Close to world famous Sunset Beach. Deeded beach access. Flood insurance not required (zone X).
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446
array(169) { ["agency"]=> array(1) { [0]=> string(18) "Aloha Island Homes" } ["assd_val_imprv"]=> array(1) { [0]=> string(9) "160500.00" } ["assd_val_land"]=> array(1) { [0]=> string(9) "988700.00" } ["assd_val_total"]=> array(1) { [0]=> string(10) "1149200.00" } ["bedrooms"]=> array(1) { [0]=> string(1) "3" } ["building_style"]=> array(1) { [0]=> string(20) "Detach Single Family" } ["city"]=> array(1) { [0]=> string(7) "Haleiwa" } ["county"]=> array(1) { [0]=> string(4) "Oahu" } ["disclosures"]=> array(1) { [0]=> string(24) "Property Disclosure Stmt" } ["easements"]=> array(1) { [0]=> string(5) "Other" } ["elementary_school"]=> array(1) { [0]=> string(12) "Sunset Beach" } ["floor_covering"]=> array(1) { [0]=> string(8) "Laminate" } ["frontage"]=> array(1) { [0]=> string(5) "Other" } ["full_baths"]=> array(1) { [0]=> string(1) "2" } ["furnished"]=> array(1) { [0]=> string(7) "Partial" } ["half_baths"]=> array(1) { [0]=> string(1) "0" } ["high_school"]=> array(1) { [0]=> string(6) "Kahuku" } ["home_exampt"]=> array(1) { [0]=> string(6) "100000" } ["land_area_sf"]=> array(1) { [0]=> string(7) "8441.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(22) "jonihawaii@hotmail.com" } ["list_agent_name"]=> array(1) { [0]=> string(18) "Joni Ann Shiraishi" } ["list_agent_phone_number"]=> array(1) { [0]=> string(14) "(808) 479-8035" } ["list_date"]=> array(1) { [0]=> string(10) "2021-07-17" } ["list_office_name"]=> array(1) { [0]=> string(18) "Aloha Island Homes" } ["list_price"]=> array(1) { [0]=> string(10) "1650000.00" } ["living_sf"]=> array(1) { [0]=> string(4) "1224" } ["location"]=> array(1) { [0]=> string(38) "58-045 Kapuai Place, Haleiwa, HI 96712" } ["middle_school"]=> array(1) { [0]=> string(6) "Kahuku" } ["mls_"]=> array(1) { [0]=> string(9) "202115704" } ["neighborhood"]=> array(1) { [0]=> string(12) "SUNSET/VELZY" } ["number_of_parking_spaces"]=> array(1) { [0]=> string(1) "3" } ["number_of_stories"]=> array(1) { [0]=> string(3) "One" } ["office_mls_id"]=> array(1) { [0]=> string(4) "JONI" } ["parking_features"]=> array(1) { [0]=> string(27) "3 Car+,Boat,Driveway,Street" } ["pool_"]=> array(1) { [0]=> string(26) "In Ground,Pool on Property" } ["possession"]=> array(1) { [0]=> string(5) "Other" } ["postal_code"]=> array(1) { [0]=> string(5) "96712" } ["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) "3" } ["rets_city"]=> array(1) { [0]=> string(7) "Haleiwa" } ["rets_co_list_agent_direct_work_phone"]=> array(1) { [0]=> string(14) "(808) 479-8035" } ["rets_co_list_agent_email"]=> array(1) { [0]=> string(24) "lauren.noelani@gmail.com" } ["rets_co_list_agent_full_name"]=> array(1) { [0]=> string(18) "Lauren N Shiraishi" } ["rets_co_list_agent_mlsid"]=> array(1) { [0]=> string(5) "46452" } ["rets_co_list_agent_mui"]=> array(1) { [0]=> string(8) "10265589" } ["rets_co_list_office_mlsid"]=> array(1) { [0]=> string(4) "JONI" } ["rets_co_list_office_mui"]=> array(1) { [0]=> string(8) "10900682" } ["rets_co_list_office_name"]=> array(1) { [0]=> string(18) "Aloha Island Homes" } ["rets_co_list_office_phone"]=> array(1) { [0]=> string(14) "(808) 479-8035" } ["rets_condo_property_regime_yn"]=> array(1) { [0]=> string(1) "0" } ["rets_current_price"]=> array(1) { [0]=> string(10) "1565000.00" } ["rets_dom"]=> array(1) { [0]=> string(2) "79" } ["rets_dual_variable_compensation_yn"]=> array(1) { [0]=> string(1) "0" } ["rets_elementary_school"]=> array(1) { [0]=> string(12) "Sunset Beach" } ["rets_foreclosure_yn"]=> array(1) { [0]=> string(1) "0" } ["rets_fractional_ownership_yn"]=> array(1) { [0]=> string(1) "0" } ["rets_high_school"]=> array(1) { [0]=> string(6) "Kahuku" } ["rets_id"]=> array(1) { [0]=> string(8) "15984552" } ["rets_immoviewer_yn"]=> array(1) { [0]=> string(1) "0" } ["rets_internet_automated_valuation_dis"]=> array(1) { [0]=> string(1) "0" } ["rets_internet_consumer_comment_yn"]=> array(1) { [0]=> string(1) "1" } ["rets_list_agent_direct_work_phone"]=> array(1) { [0]=> string(14) "(808) 479-8035" } ["rets_list_agent_email"]=> array(1) { [0]=> string(22) "jonihawaii@hotmail.com" } ["rets_list_agent_full_name"]=> array(1) { [0]=> string(18) "Joni Ann Shiraishi" } ["rets_list_agent_mlsid"]=> array(1) { [0]=> string(5) "10392" } ["rets_list_agent_mui"]=> array(1) { [0]=> string(7) "3472747" } ["rets_list_office_mlsid"]=> array(1) { [0]=> string(4) "JONI" } ["rets_list_office_mui"]=> array(1) { [0]=> string(8) "10900682" } ["rets_list_office_name"]=> array(1) { [0]=> string(18) "Aloha Island Homes" } ["rets_list_office_phone"]=> array(1) { [0]=> string(14) "(808) 479-8035" } ["rets_list_price"]=> array(1) { [0]=> string(10) "1650000.00" } ["rets_listing_contract_date"]=> array(1) { [0]=> string(10) "2021-07-17" } ["rets_lot_size_area"]=> array(1) { [0]=> string(7) "8441.00" } ["rets_matrix_modified_dt"]=> array(1) { [0]=> string(23) "2022-04-04T14:34:50.447" } ["rets_matrix_unique_id"]=> array(1) { [0]=> string(8) "15984552" } ["rets_middle_or_junior_school"]=> array(1) { [0]=> string(6) "Kahuku" } ["rets_mls_number"]=> array(1) { [0]=> string(9) "202115704" } ["rets_neighbourhood"]=> array(1) { [0]=> string(12) "SUNSET/VELZY" } ["rets_new_development_construction_yn"]=> array(1) { [0]=> string(1) "0" } ["rets_original_entry_timestamp"]=> array(1) { [0]=> string(23) "2021-07-17T22:19:55.340" } ["rets_original_list_price"]=> array(1) { [0]=> string(10) "1650000.00" } ["rets_parcel_number"]=> array(1) { [0]=> string(18) "1-5-8-003-003-0000" } ["rets_parking_total"]=> array(1) { [0]=> string(1) "3" } ["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) "13" } ["rets_photo_modification_timestamp"]=> array(1) { [0]=> string(23) "2021-08-05T14:20:02.933" } ["rets_postal_code"]=> array(1) { [0]=> string(5) "96712" } ["rets_primary_key"]=> array(1) { [0]=> string(8) "15984552" } ["rets_private_remarks"]=> array(1) { [0]=> string(60) "Owner is still cleaning up Call listing agent for details." } ["rets_public_remarks"]=> array(1) { [0]=> string(328) "Diamond in the rough! Largest lot on the street of 8,441 sq. ft. with possible duplex potential. Beachside community with Underground utilities, Large stucco perimeter wall. Permitted In ground pool just needs finishing touches. Close to world famous Sunset Beach. Deeded beach access. Flood insurance not required (zone X)." } ["rets_sqft_roofed_living"]=> array(1) { [0]=> string(4) "1224" } ["rets_sqft_total"]=> array(1) { [0]=> string(4) "1224" } ["rets_state_or_province"]=> array(1) { [0]=> string(2) "HI" } ["rets_status_change_timestamp"]=> array(1) { [0]=> string(23) "2022-04-04T14:34:50.447" } ["rets_status_contractual_search_date"]=> array(1) { [0]=> string(10) "2022-04-04" } ["rets_street_name"]=> array(1) { [0]=> string(6) "Kapuai" } ["rets_street_number"]=> array(1) { [0]=> string(6) "58-045" } ["rets_street_view_param"]=> array(1) { [0]=> string(63) "1$21.679002$-158.03554$310.27$13.33$1.00$DENImSwq87VEDBe_sLRRvg" } ["rets_sub_agency_compensation"]=> array(1) { [0]=> string(2) "3%" } ["rets_tax_amount"]=> array(1) { [0]=> string(6) "306.00" } ["rets_tax_assessed_value"]=> array(1) { [0]=> string(10) "1149200.00" } ["rets_tax_assessed_value_improvements"]=> array(1) { [0]=> string(9) "160500.00" } ["rets_tax_assessed_value_land"]=> array(1) { [0]=> string(9) "988700.00" } ["rets_tax_excemption_owner_occupancy"]=> array(1) { [0]=> string(6) "100000" } ["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/15984552/fd3987f7e011f0a90578844bf9e96034" } ["rets_tmk_area"]=> array(1) { [0]=> string(3) "158" } ["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(1) "3" } ["rets_tmk_section"]=> array(1) { [0]=> string(1) "8" } ["rets_tmk_zone"]=> array(1) { [0]=> string(1) "5" } ["rets_tmkplat"]=> array(1) { [0]=> string(1) "3" } ["rets_year_built"]=> array(1) { [0]=> string(4) "1979" } ["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(6) "Kapuai" } ["street_number"]=> array(1) { [0]=> string(6) "58-045" } ["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-8-003-003-0000" } ["topography"]=> array(1) { [0]=> string(5) "Clear" } ["view"]=> array(1) { [0]=> string(8) "Mountain" } ["wpp::rets_pk"]=> array(1) { [0]=> string(8) "15984552" } ["wpp_gpid"]=> array(1) { [0]=> string(9) "202115704" } ["wpp_import_schedule_id"]=> array(1) { [0]=> string(10) "1463343682" } ["wpp_import_time"]=> array(1) { [0]=> string(10) "1649118973" } ["year_built"]=> array(1) { [0]=> string(4) "1979" } ["zoning"]=> array(1) { [0]=> string(29) "05 - R-5 Residential District" } ["new_attached_media"]=> array(1) { [0]=> string(1501) "a:94:{i:0;i:19977531;i:1;i:19977532;i:2;i:19977533;i:3;i:19977534;i:4;i:19977535;i:5;i:19977536;i:6;i:19977537;i:7;i:19977538;i:8;i:20171717;i:9;i:20171718;i:10;i:20171719;i:11;i:20171720;i:12;i:20171721;i:13;i:20171722;i:14;i:20171723;i:15;i:20171724;i:16;i:20228616;i:17;i:20228617;i:18;i:20228618;i:19;i:20228619;i:20;i:20228620;i:21;i:20228621;i:22;i:20228622;i:23;i:20228623;i:24;i:20228624;i:25;i:20228625;i:26;i:20228626;i:27;i:20228627;i:28;i:20228628;i:29;i:20818707;i:30;i:20818708;i:31;i:20818709;i:32;i:20818710;i:33;i:20818711;i:34;i:20818712;i:35;i:20818713;i:36;i:20818714;i:37;i:20818715;i:38;i:20818716;i:39;i:20818717;i:40;i:20818718;i:41;i:20818719;i:42;i:20896717;i:43;i:20896718;i:44;i:20896719;i:45;i:20896720;i:46;i:20896721;i:47;i:20896722;i:48;i:20896723;i:49;i:20896724;i:50;i:20896725;i:51;i:20896726;i:52;i:20896727;i:53;i:20896728;i:54;i:20896729;i:55;i:21324604;i:56;i:21324605;i:57;i:21324606;i:58;i:21324607;i:59;i:21324608;i:60;i:21324609;i:61;i:21324610;i:62;i:21324611;i:63;i:21324612;i:64;i:21324613;i:65;i:21324614;i:66;i:21324615;i:67;i:21324616;i:68;i:21811690;i:69;i:21811691;i:70;i:21811692;i:71;i:21811693;i:72;i:21811694;i:73;i:21811695;i:74;i:21811696;i:75;i:21811697;i:76;i:21811698;i:77;i:21811699;i:78;i:21811700;i:79;i:21811701;i:80;i:21811702;i:81;i:21949332;i:82;i:21949333;i:83;i:21949334;i:84;i:21949335;i:85;i:21949336;i:86;i:21949337;i:87;i:21949338;i:88;i:21949339;i:89;i:21949340;i:90;i:21949341;i:91;i:21949342;i:92;i:21949343;i:93;i:21949344;}" } ["rets_active_continue_to_show_date"]=> array(1) { [0]=> string(10) "2021-10-04" } ["rets_tax_annual_amount"]=> array(1) { [0]=> string(7) "3672.00" } ["rets_pending_date"]=> array(1) { [0]=> string(10) "2021-10-04" } ["rets_close_date"]=> array(1) { [0]=> string(10) "2022-04-04" } ["rets_close_price"]=> array(1) { [0]=> string(10) "1565000.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(23) "olivia@barneshawaii.com" } ["rets_co_selling_agent_full_name"]=> array(1) { [0]=> string(16) "Olivia J Sadeler" } ["rets_co_selling_agent_mlsid"]=> array(1) { [0]=> string(5) "46503" } ["rets_co_selling_agent_mui"]=> array(1) { [0]=> string(8) "10304592" } ["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_concessions"]=> array(1) { [0]=> string(5) "35000" } ["rets_expiration_date"]=> array(1) { [0]=> string(10) "2022-06-20" } ["rets_off_market_date"]=> array(1) { [0]=> string(10) "2022-04-04" } ["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_agent_remarks"]=> array(1) { [0]=> string(57) "$35k seller credit towards Buyers' closing costs/repairs." } ["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" } ["_thumbnail_id"]=> array(1) { [0]=> string(8) "21949332" } }