59-548 Aukauka Place
Haleiwa, HI 96712

Take a Virtual Tour

Listing
Overview

Price: $2,650,000
Area: PUPUKEA
Status: Sold

Secluded 2 acre Dream Property in Excellent, Turn Key Condition. Rarely available Pupukea estate with ability to CPR into two separate lots. Private and gated 2 acres of beautiful landscaping with architect designed custom home. Horse lovers dream with lots of flat ground. Shares property line with thousands of acres of the Pupukea Paumalu Forest Reserve. Access miles of Sunset Hills trails right from your backyard. Recently remodeled 3 bedroom and 3 bathroom main home. 2 car garage with a studio apartment above. Separate studio and additional stand alone 4 car garage. The two separate studios with private entrances are great for guests or extra income. 24 owned PV panels on net metering. Parking for many vehicles, boats or room for all the North Shore toys in one of the 3 garage bays. Truly a once in a lifetime opportunity to purchase such a special property.

  • Bedrooms: 3
  • Full Baths: 5
  • Land Area (sf): 87,120
  • Living (sf): 2,783
  • Year Built: 1998

  • Property Condition: Excellent
  • Number of Parking Spaces: 8
  • Pool: None
  • Number of Stories: Three+
  • View: Garden,Mountain
  • Listing Office: eXp Realty

  • Land Tenure: FS - Fee Simple

  • Elementary School: Sunset Beach
  • Middle School: Kahuku
  • High School: Kahuku

CONTACT US

Marcus Realty

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

array(157) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "997100.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "939900.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(10) "1937000.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(8) "Driveway"
  }
  ["elementary_school"]=>
  array(1) {
    [0]=>
    string(12) "Sunset Beach"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(32) "Ceramic Tile,Hardwood,W/W Carpet"
  }
  ["frontage"]=>
  array(1) {
    [0]=>
    string(12) "Preservation"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["high_school"]=>
  array(1) {
    [0]=>
    string(6) "Kahuku"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["lanai_sf"]=>
  array(1) {
    [0]=>
    string(3) "648"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(8) "87120.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(24) "jason@oahuhomerealty.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(10) "Jason Subt"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 725-2794"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-07-14"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(10) "eXp Realty"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(10) "2650000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(4) "2783"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(39) "59-548 Aukauka Place, Haleiwa, HI 96712"
  }
  ["middle_school"]=>
  array(1) {
    [0]=>
    string(6) "Kahuku"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202118729"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(7) "PUPUKEA"
  }
  ["number_of_parking_spaces"]=>
  array(1) {
    [0]=>
    string(1) "8"
  }
  ["number_of_stories"]=>
  array(1) {
    [0]=>
    string(6) "Three+"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "EXPI"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(18) "3 Car+,Boat,Garage"
  }
  ["pool_"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(15) "45 Days or Less"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96712"
  }
  ["property_condition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["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_active_open_house_count"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_baths_full"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["rets_baths_half"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_baths_total"]=>
  array(1) {
    [0]=>
    string(4) "5.00"
  }
  ["rets_beds_total"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(7) "Haleiwa"
  }
  ["rets_condo_property_regime_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(10) "2650000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["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) "16046601"
  }
  ["rets_immoviewer_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_internet_automated_valuation_dis"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_internet_consumer_comment_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 725-2794"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(24) "jason@oahuhomerealty.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(10) "Jason Subt"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "45288"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "9613614"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "EXPI"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "10013908"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(10) "eXp Realty"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 725-2794"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(10) "2650000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-07-14"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(8) "87120.00"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-10-01T12:37:20.383"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "16046601"
  }
  ["rets_middle_or_junior_school"]=>
  array(1) {
    [0]=>
    string(6) "Kahuku"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202118729"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "PUPUKEA"
  }
  ["rets_new_development_construction_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_open_house_count"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_open_house_upcoming"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-07-14T18:57:11.853"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(10) "2650000.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-5-9-026-047-0000"
  }
  ["rets_parking_total"]=>
  array(1) {
    [0]=>
    string(1) "8"
  }
  ["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) "21"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-07-14T18:33:51.380"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96712"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-07-14T18:57:11.853"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "16046601"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(51) "Call or text listing agent Jason Subt 808-497-2083."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(872) "Secluded 2 acre Dream Property in Excellent, Turn Key Condition. Rarely available Pupukea estate with ability to CPR into two separate lots. Private and gated 2 acres of beautiful landscaping with architect designed custom home. Horse lovers dream with lots of flat ground. Shares property line with thousands of acres of the Pupukea Paumalu Forest Reserve. Access miles of Sunset Hills trails right from your backyard. Recently remodeled 3 bedroom and 3 bathroom main home. 2 car garage with a studio apartment above. Separate studio and additional stand alone 4 car garage. The two separate studios with private entrances are great for guests or extra income. 24 owned PV panels on net metering. Parking for many vehicles, boats or room for all the North Shore toys in one of the 3 garage bays. Truly a once in a lifetime opportunity to purchase such a special property."
  }
  ["rets_room_count"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_sqft_garage_carport"]=>
  array(1) {
    [0]=>
    string(4) "1280"
  }
  ["rets_sqft_lanai_open"]=>
  array(1) {
    [0]=>
    string(3) "648"
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(4) "2135"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(4) "2783"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-30T08:31:32.613"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-29"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(7) "Aukauka"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(6) "59-548"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(64) "1$21.648835$-158.044135$336.64$13.33$1.00$Wd8_cXChTaFGeapueQcbDA"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(3) "2.5"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "564.00"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(10) "1937000.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "997100.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "939900.00"
  }
  ["rets_tax_excemption_owner_occupancy"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_tax_paid_by_seller_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_tax_year"]=>
  array(1) {
    [0]=>
    string(4) "2020"
  }
  ["rets_thumbnail_url"]=>
  array(1) {
    [0]=>
    string(81) "https://cdn.rets.ci/marcusrealty-images/16046601/e2841eae7be28a1b044a1680ff67e5a3"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "159"
  }
  ["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) "47"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "9"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(2) "26"
  }
  ["rets_virtual_tour_url_unbranded"]=>
  array(1) {
    [0]=>
    string(40) "https://player.vimeo.com/video/255300215"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1998"
  }
  ["security"]=>
  array(1) {
    [0]=>
    string(19) "Gated Community,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(7) "Aukauka"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(6) "59-548"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(5) "Place"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(20) "Cash,Conventional,VA"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-5-9-026-047-0000"
  }
  ["topography"]=>
  array(1) {
    [0]=>
    string(13) "Clear,Rim Lot"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(15) "Garden,Mountain"
  }
  ["virtual_tour"]=>
  array(1) {
    [0]=>
    string(40) "https://player.vimeo.com/video/255300215"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "16046601"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202118729"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1633127848"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1998"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(21) "56 - Country District"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(2397) "a:147:{i:0;i:19980351;i:1;i:19980352;i:2;i:19980353;i:3;i:19980354;i:4;i:19980355;i:5;i:19980356;i:6;i:19980357;i:7;i:19980358;i:8;i:19980359;i:9;i:19980360;i:10;i:19980361;i:11;i:19980362;i:12;i:19980363;i:13;i:19980364;i:14;i:19980365;i:15;i:19980366;i:16;i:19980367;i:17;i:19980368;i:18;i:19980369;i:19;i:19980370;i:20;i:19980371;i:21;i:20024372;i:22;i:20024373;i:23;i:20024374;i:24;i:20024375;i:25;i:20024376;i:26;i:20024377;i:27;i:20024378;i:28;i:20024379;i:29;i:20024380;i:30;i:20024381;i:31;i:20024382;i:32;i:20024383;i:33;i:20024384;i:34;i:20024385;i:35;i:20024386;i:36;i:20024387;i:37;i:20024388;i:38;i:20024389;i:39;i:20024390;i:40;i:20024391;i:41;i:20024392;i:42;i:20231333;i:43;i:20231334;i:44;i:20231335;i:45;i:20231336;i:46;i:20231337;i:47;i:20231338;i:48;i:20231339;i:49;i:20231340;i:50;i:20231341;i:51;i:20231342;i:52;i:20231343;i:53;i:20231344;i:54;i:20231345;i:55;i:20231346;i:56;i:20231347;i:57;i:20231348;i:58;i:20231349;i:59;i:20231350;i:60;i:20231351;i:61;i:20231352;i:62;i:20231353;i:63;i:20634055;i:64;i:20634056;i:65;i:20634057;i:66;i:20634058;i:67;i:20634059;i:68;i:20634060;i:69;i:20634061;i:70;i:20634062;i:71;i:20634063;i:72;i:20634064;i:73;i:20634065;i:74;i:20634066;i:75;i:20634067;i:76;i:20634068;i:77;i:20634069;i:78;i:20634070;i:79;i:20634071;i:80;i:20634072;i:81;i:20634073;i:82;i:20634074;i:83;i:20634075;i:84;i:20868781;i:85;i:20868782;i:86;i:20868783;i:87;i:20868784;i:88;i:20868785;i:89;i:20868786;i:90;i:20868787;i:91;i:20868788;i:92;i:20868789;i:93;i:20868790;i:94;i:20868791;i:95;i:20868792;i:96;i:20868793;i:97;i:20868794;i:98;i:20868795;i:99;i:20868796;i:100;i:20868797;i:101;i:20868798;i:102;i:20868799;i:103;i:20868800;i:104;i:20868801;i:105;i:20869470;i:106;i:20869471;i:107;i:20869472;i:108;i:20869473;i:109;i:20869474;i:110;i:20869475;i:111;i:20869476;i:112;i:20869477;i:113;i:20869478;i:114;i:20869479;i:115;i:20869480;i:116;i:20869481;i:117;i:20869482;i:118;i:20869483;i:119;i:20869484;i:120;i:20869485;i:121;i:20869486;i:122;i:20869487;i:123;i:20869488;i:124;i:20869489;i:125;i:20869490;i:126;i:20881383;i:127;i:20881384;i:128;i:20881385;i:129;i:20881386;i:130;i:20881387;i:131;i:20881388;i:132;i:20881389;i:133;i:20881390;i:134;i:20881391;i:135;i:20881392;i:136;i:20881393;i:137;i:20881394;i:138;i:20881395;i:139;i:20881396;i:140;i:20881397;i:141;i:20881398;i:142;i:20881399;i:143;i:20881400;i:144;i:20881401;i:145;i:20881402;i:146;i:20881403;}"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-07-18"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-29"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(10) "2650000.00"
  }
  ["rets_expiration_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-10-14"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-29"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 825-4277"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(23) "jason.carey@compass.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(13) "Jason M Carey"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "45105"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "9512016"
  }
  ["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"
  }
  ["rets_concessions"]=>
  array(1) {
    [0]=>
    string(5) "45000"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20881383"
  }
}