53-890 Kamehameha Highway
Hauula, HI 96717

Listing
Overview

Price: $840,000
Area: HAUULA
Status: Sold

Ocean and canal living in this beautiful Hauula home. Situated across the street from the ocean with a large deck overlooking a stream. Beautifully upgraded in 2014, this completely remodeled 4 bedroom, 2 bath home offers a flexible floor plan. Ocean, mountain, and river views from the property. The home has been approved for BYU student housing, making it an ideal rental property. Rent out part of property and keep part for you weekend getaways from Honolulu. Layout consists of two living rooms, a full kitchen and large scale wet bar, two separate entrances, and over 750 sq.ft. of decking for relaxation or outdoor entertaining. Recent upgrades include granite counter tops, double pane vinyl windows, new roof in 2011, remodeled bathrooms, and upgraded plumbing, electrical and roof.

  • Bedrooms: 4
  • Full Baths: 2
  • Land Area (sf): 8,379
  • Living (sf): 1,416
  • Year Built: 1962

  • Property Condition: Excellent
  • Number of Parking Spaces: 4
  • Pool: None
  • Number of Stories: One
  • View: Mountain,Ocean,Sunrise
  • Listing Office: eXp Realty

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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

array(148) {
  ["address_is_formatted"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "165100.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "464300.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "629400.00"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(20) "Detach Single Family"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(24) "Property Disclosure Stmt"
  }
  ["easements"]=>
  array(1) {
    [0]=>
    string(8) "Electric"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(21) "Ceramic Tile,Laminate"
  }
  ["formatted_address"]=>
  array(1) {
    [0]=>
    string(44) "53-890 Kamehameha Hwy, Hauula, HI 96717, USA"
  }
  ["formatted_address_simple"]=>
  array(1) {
    [0]=>
    string(33) "53-890 Kamehameha Hwy, Hauula, HI"
  }
  ["frontage"]=>
  array(1) {
    [0]=>
    string(12) "Stream/Canal"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["google_place_id"]=>
  array(1) {
    [0]=>
    string(27) "ChIJozNDk1REAHwRei3WPQkCoNI"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(7) "8379.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(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) "2020-10-27"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(10) "eXp Realty"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "840000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(4) "1416"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(43) "53-890 Kamehameha Highway, Hauula, HI 96717"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202028234"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(6) "HAUULA"
  }
  ["number_of_parking_spaces"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["number_of_stories"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["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"
  }
  ["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(7) "Kaneohe"
  }
  ["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) "4"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(6) "Hauula"
  }
  ["rets_condo_property_regime_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(9) "840000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["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) "15520660"
  }
  ["rets_immoviewer_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(9) "840000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2020-10-27"
  }
  ["rets_lock_box_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(7) "8379.00"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2020-12-30T22:50:56.970"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "15520660"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202028234"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(6) "HAUULA"
  }
  ["rets_new_development_construction_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2020-10-29T15:38:21.510"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(8) "84000.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-5-3-014-051-0000"
  }
  ["rets_parking_total"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["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) "2020-10-29T15:38:21.510"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96717"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "15520660"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(70) "Please contact listing agent Jason Subt 808-497-2083 for all showings."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(792) "Ocean and canal living in this beautiful Hauula home. Situated across the street from the ocean with a large deck overlooking a stream. Beautifully upgraded in 2014, this completely remodeled 4 bedroom, 2 bath home offers a flexible floor plan. Ocean, mountain, and river views from the property. The home has been approved for BYU student housing, making it an ideal rental property. Rent out part of property and keep part for you weekend getaways from Honolulu. Layout consists of two living rooms, a full kitchen and large scale wet bar, two separate entrances, and over 750 sq.ft. of decking for relaxation or outdoor entertaining. Recent upgrades include granite counter tops, double pane vinyl windows, new roof in 2011, remodeled bathrooms, and upgraded plumbing, electrical and roof."
  }
  ["rets_sqft_garage_carport"]=>
  array(1) {
    [0]=>
    string(3) "520"
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(4) "1416"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(4) "1416"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2020-12-30T22:50:56.970"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2020-12-28"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(10) "Kamehameha"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(6) "53-890"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(64) "1$21.603816$-157.900195$250.07$13.33$1.00$kV8b4qU3W7Xv9EGmhJ8_3w"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(4) "2.5%"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "183.00"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "629400.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "165100.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "464300.00"
  }
  ["rets_tax_excemption_owner_occupancy"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_tax_paid_by_seller_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tax_year"]=>
  array(1) {
    [0]=>
    string(4) "2019"
  }
  ["rets_thumbnail_url"]=>
  array(1) {
    [0]=>
    string(81) "https://cdn.rets.ci/marcusrealty-images/15520660/080cce5501242f07a9d5e0fd9571405c"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "153"
  }
  ["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) "51"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(2) "14"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1962"
  }
  ["rets_year_remodeled"]=>
  array(1) {
    [0]=>
    string(4) "2014"
  }
  ["security"]=>
  array(1) {
    [0]=>
    string(3) "Key"
  }
  ["setbacks"]=>
  array(1) {
    [0]=>
    string(13) "C&C,Of Record"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(21) "Cash,Conventional,FHA"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-5-3-014-051-0000"
  }
  ["topography"]=>
  array(1) {
    [0]=>
    string(5) "Clear"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(22) "Mountain,Ocean,Sunrise"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "15520660"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202028234"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1628986279"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1962"
  }
  ["year_remodeled_"]=>
  array(1) {
    [0]=>
    string(4) "2014"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(29) "05 - R-5 Residential District"
  }
  ["latitude"]=>
  array(1) {
    [0]=>
    string(10) "21.6038877"
  }
  ["longitude"]=>
  array(1) {
    [0]=>
    string(12) "-157.9001293"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(2754) "a:168:{i:0;i:16919434;i:1;i:16919435;i:2;i:16919436;i:3;i:16919437;i:4;i:16919438;i:5;i:16919439;i:6;i:16919440;i:7;i:16919441;i:8;i:16919442;i:9;i:16919443;i:10;i:16919444;i:11;i:16919445;i:12;i:16919446;i:13;i:16919447;i:14;i:16919448;i:15;i:16919449;i:16;i:16919450;i:17;i:16919451;i:18;i:16919452;i:19;i:16919453;i:20;i:16919454;i:21;i:16919581;i:22;i:16919582;i:23;i:16919583;i:24;i:16919584;i:25;i:16919585;i:26;i:16919586;i:27;i:16919587;i:28;i:16919588;i:29;i:16919589;i:30;i:16919590;i:31;i:16919591;i:32;i:16919592;i:33;i:16919593;i:34;i:16919594;i:35;i:16919595;i:36;i:16919596;i:37;i:16919597;i:38;i:16919598;i:39;i:16919599;i:40;i:16919600;i:41;i:16919601;i:42;i:16928869;i:43;i:16928870;i:44;i:16928871;i:45;i:16928872;i:46;i:16928873;i:47;i:16928874;i:48;i:16928875;i:49;i:16928876;i:50;i:16928877;i:51;i:16928878;i:52;i:16928879;i:53;i:16928880;i:54;i:16928881;i:55;i:16928882;i:56;i:16928883;i:57;i:16928884;i:58;i:16928885;i:59;i:16928886;i:60;i:16928887;i:61;i:16928888;i:62;i:16928889;i:63;i:17283286;i:64;i:17283287;i:65;i:17283288;i:66;i:17283289;i:67;i:17283290;i:68;i:17283291;i:69;i:17283292;i:70;i:17283293;i:71;i:17283294;i:72;i:17283295;i:73;i:17283296;i:74;i:17283297;i:75;i:17283298;i:76;i:17283299;i:77;i:17283300;i:78;i:17283301;i:79;i:17283302;i:80;i:17283303;i:81;i:17283304;i:82;i:17283305;i:83;i:17283306;i:84;i:17553511;i:85;i:17553512;i:86;i:17553513;i:87;i:17553514;i:88;i:17553515;i:89;i:17553516;i:90;i:17553517;i:91;i:17553518;i:92;i:17553519;i:93;i:17553520;i:94;i:17553521;i:95;i:17553522;i:96;i:17553523;i:97;i:17553524;i:98;i:17553525;i:99;i:17553526;i:100;i:17553527;i:101;i:17553528;i:102;i:17553529;i:103;i:17553530;i:104;i:17553531;i:105;i:20139427;i:106;i:20139428;i:107;i:20139429;i:108;i:20139430;i:109;i:20139431;i:110;i:20139432;i:111;i:20139433;i:112;i:20139434;i:113;i:20139435;i:114;i:20139436;i:115;i:20139437;i:116;i:20139438;i:117;i:20139439;i:118;i:20139440;i:119;i:20139441;i:120;i:20139442;i:121;i:20139443;i:122;i:20139444;i:123;i:20139445;i:124;i:20139446;i:125;i:20139447;i:126;i:20381928;i:127;i:20381929;i:128;i:20381930;i:129;i:20381931;i:130;i:20381932;i:131;i:20381933;i:132;i:20381934;i:133;i:20381935;i:134;i:20381936;i:135;i:20381937;i:136;i:20381938;i:137;i:20381939;i:138;i:20381940;i:139;i:20381941;i:140;i:20381942;i:141;i:20381943;i:142;i:20381944;i:143;i:20381945;i:144;i:20381946;i:145;i:20381947;i:146;i:20381948;i:147;i:20382573;i:148;i:20382574;i:149;i:20382575;i:150;i:20382576;i:151;i:20382577;i:152;i:20382578;i:153;i:20382579;i:154;i:20382580;i:155;i:20382581;i:156;i:20382582;i:157;i:20382583;i:158;i:20382584;i:159;i:20382585;i:160;i:20382586;i:161;i:20382587;i:162;i:20382588;i:163;i:20382589;i:164;i:20382590;i:165;i:20382591;i:166;i:20382592;i:167;i:20382593;}"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2020-10-29T15:50:45.507"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2020-10-28"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2020-12-28"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(9) "840000.00"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2020-12-28"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 524-3522"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(18) "HollyFHR@gmail.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(12) "Holly Pagano"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "45894"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "9874487"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "FIHR"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3487669"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(21) "First Hawaiian Realty"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 524-3522"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(6) "Hauula"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96717"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(10) "Kamehameha"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(6) "53-890"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(7) "Highway"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20382573"
  }
}