94-559 Koaleo Street
Waipahu, HI 96797

Take a Virtual Tour

Listing
Overview

Price: $1,098,888
Area: ROBINSON HEIGHTS
Status: Sold

Huge price drop on this wonderful duplex! Discover this rare gem in the exclusive development of Sugar Mill Estates! Located in the Robinson Heights neighborhood, this single family home is a separately metered duplex, a rare find! Live in one, and rent out the other or rent out both for a great investment opportunity. Located on a large lot at the end of a cul-de-sac with loads of parking (at least 8 cars), fruit trees (mango, avocado, papaya), large carport with storage, and no home behind, you will love the sense of privacy. This duplex features a 1200 square foot 3 bedroom/2 bath home downstairs AND a 3 bedroom/2 bath home upstairs, with two private access stairways. This property is a true duplex with separately metered electric, dual Solar water heaters & each home has it’s own washer/dryer. Easy access to H-1 and located in the heart of Waipahu with nearby shops and restaurants.

  • Bedrooms: 6
  • Full Baths: 4
  • Land Area (sf): 7,702
  • Living (sf): 2,511
  • Year Built: 2015

  • Property Condition: Above Average
  • Number of Parking Spaces: 10
  • Pool: None
  • Number of Stories: Two
  • View: None
  • Listing Office: Ruby Realty LLC

  • Association Fees: $100
  • Land Tenure: FS - Fee Simple

  • Elementary School: Waipahu
  • Middle School: Waipahu
  • High School: Waipahu

CONTACT US

Marcus Realty

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

array(164) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "330000.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "624300.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "954300.00"
  }
  ["assn_fee_inclusions"]=>
  array(1) {
    [0]=>
    string(3) "100"
  }
  ["association_fees"]=>
  array(1) {
    [0]=>
    string(3) "100"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(6) "Duplex"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(15) "Pet on Property"
  }
  ["easements"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["elementary_school"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["exclusions"]=>
  array(1) {
    [0]=>
    string(11) "Ceiling Fan"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(29) "Ceramic Tile,Vinyl,W/W Carpet"
  }
  ["frontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["furnished"]=>
  array(1) {
    [0]=>
    string(7) "Partial"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["high_school"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(6) "100000"
  }
  ["lanai_sf"]=>
  array(1) {
    [0]=>
    string(2) "15"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(7) "7702.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(18) "Cathy@RubyRlty.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(18) "Catherine E Pierce"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 352-0231"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-05-10"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(15) "Ruby Realty LLC"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(10) "1098888.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(4) "2511"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(39) "94-559 Koaleo Street, Waipahu, HI 96797"
  }
  ["middle_school"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202111902"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(16) "ROBINSON HEIGHTS"
  }
  ["number_of_parking_spaces"]=>
  array(1) {
    [0]=>
    string(2) "10"
  }
  ["number_of_stories"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "RUBY"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(23) "3 Car+,Carport,Driveway"
  }
  ["pool_"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(26) "45 Days or Less,At Closing"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96797"
  }
  ["property_condition"]=>
  array(1) {
    [0]=>
    string(13) "Above 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(7) "Waipahu"
  }
  ["rets_active_open_house_count"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_association_community_name"]=>
  array(1) {
    [0]=>
    string(18) "Sugar Mill Estates"
  }
  ["rets_association_fee"]=>
  array(1) {
    [0]=>
    string(3) "100"
  }
  ["rets_association_fee_total"]=>
  array(1) {
    [0]=>
    string(3) "100"
  }
  ["rets_baths_full"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["rets_baths_half"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_baths_total"]=>
  array(1) {
    [0]=>
    string(4) "4.00"
  }
  ["rets_beds_total"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["rets_compensation_method"]=>
  array(1) {
    [0]=>
    string(8) "Variable"
  }
  ["rets_condo_property_regime_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(10) "1060000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(2) "71"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_elementary_school"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["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(7) "Waipahu"
  }
  ["rets_id"]=>
  array(1) {
    [0]=>
    string(8) "15903144"
  }
  ["rets_immoviewer_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 352-0231"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(18) "Cathy@RubyRlty.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(18) "Catherine E Pierce"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "44027"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "8858974"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "RUBY"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "12570664"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(15) "Ruby Realty LLC"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 352-0231"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(10) "1098888.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-05-10"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(7) "7702.00"
  }
  ["rets_management_company_name"]=>
  array(1) {
    [0]=>
    string(14) "Associa Hawaii"
  }
  ["rets_management_company_phone"]=>
  array(1) {
    [0]=>
    string(12) "808-836-0911"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-24T13:52:20.743"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "15903144"
  }
  ["rets_middle_or_junior_school"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202111902"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(16) "ROBINSON HEIGHTS"
  }
  ["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-05-09T01:43:43.943"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(10) "1200000.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-9-4-035-089-0000"
  }
  ["rets_parking_total"]=>
  array(1) {
    [0]=>
    string(2) "10"
  }
  ["rets_pending_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-07-19"
  }
  ["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) "2021-05-11T19:39:09.693"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96797"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-07-16T19:09:40.023"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "15903144"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(162) "Private showings are possible, but please give 48 hours notice. Offers will be submitted immediately. Please include As-IS and POF. Please consider Tanya McBride."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(898) "Huge price drop on this wonderful duplex! Discover this rare gem in the exclusive development of Sugar Mill Estates! Located in the Robinson Heights neighborhood, this single family home is a separately metered duplex, a rare find! Live in one, and rent out the other or rent out both for a great investment opportunity. Located on a large lot at the end of a cul-de-sac with loads of parking (at least 8 cars), fruit trees (mango, avocado, papaya), large carport with storage, and no home behind, you will love the sense of privacy. This duplex features a 1200 square foot 3 bedroom/2 bath home downstairs AND a 3 bedroom/2 bath home upstairs, with two private access stairways. This property is a true duplex with separately metered electric, dual Solar water heaters & each home has it's own washer/dryer. Easy access to H-1 and located in the heart of Waipahu with nearby shops and restaurants."
  }
  ["rets_sqft_garage_carport"]=>
  array(1) {
    [0]=>
    string(3) "480"
  }
  ["rets_sqft_lanai_open"]=>
  array(1) {
    [0]=>
    string(2) "15"
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(4) "2400"
  }
  ["rets_sqft_roofed_other"]=>
  array(1) {
    [0]=>
    string(2) "96"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(4) "2511"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-24T13:52:20.743"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-23"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(6) "Koaleo"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(6) "94-559"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(64) "1$21.390225$-158.018432$198.74$13.33$1.00$2onVNfZtC_IdtXBde3cT2A"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "221.50"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "954300.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "330000.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "624300.00"
  }
  ["rets_tax_excemption_owner_occupancy"]=>
  array(1) {
    [0]=>
    string(6) "100000"
  }
  ["rets_tax_paid_by_seller_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tax_year"]=>
  array(1) {
    [0]=>
    string(4) "2020"
  }
  ["rets_thumbnail_url"]=>
  array(1) {
    [0]=>
    string(81) "https://cdn.rets.ci/marcusrealty-images/15903144/6d695f6fe7ff508fb2d25ccde56554f4"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "194"
  }
  ["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) "89"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "9"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(2) "35"
  }
  ["rets_virtual_tour_url_unbranded"]=>
  array(1) {
    [0]=>
    string(51) "https://my.matterport.com/show/?m=HmGfXCnfD1P&mls=1"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "2015"
  }
  ["security"]=>
  array(1) {
    [0]=>
    string(3) "Key"
  }
  ["setbacks"]=>
  array(1) {
    [0]=>
    string(13) "C&C,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) "Koaleo"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(6) "94-559"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(20) "Cash,Conventional,VA"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-9-4-035-089-0000"
  }
  ["topography"]=>
  array(1) {
    [0]=>
    string(5) "Clear"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["virtual_tour"]=>
  array(1) {
    [0]=>
    string(51) "https://my.matterport.com/show/?m=HmGfXCnfD1P&mls=1"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "15903144"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202111902"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1632527562"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "2015"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(29) "05 - R-5 Residential District"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(1683) "a:105:{i:0;i:19979502;i:1;i:19979503;i:2;i:19979504;i:3;i:19979505;i:4;i:19979506;i:5;i:19979507;i:6;i:19979508;i:7;i:19979509;i:8;i:19979510;i:9;i:19979511;i:10;i:19979512;i:11;i:19979513;i:12;i:19979514;i:13;i:19979515;i:14;i:19979516;i:15;i:19979517;i:16;i:19979518;i:17;i:19979519;i:18;i:19979520;i:19;i:19979521;i:20;i:19979522;i:21;i:20031928;i:22;i:20031929;i:23;i:20031930;i:24;i:20031931;i:25;i:20031932;i:26;i:20031933;i:27;i:20031934;i:28;i:20031935;i:29;i:20031936;i:30;i:20031937;i:31;i:20031938;i:32;i:20031939;i:33;i:20031940;i:34;i:20031941;i:35;i:20031942;i:36;i:20031943;i:37;i:20031944;i:38;i:20031945;i:39;i:20031946;i:40;i:20031947;i:41;i:20031948;i:42;i:20279640;i:43;i:20279641;i:44;i:20279642;i:45;i:20279643;i:46;i:20279644;i:47;i:20279645;i:48;i:20279646;i:49;i:20279647;i:50;i:20279648;i:51;i:20279649;i:52;i:20279650;i:53;i:20279651;i:54;i:20279652;i:55;i:20279653;i:56;i:20279654;i:57;i:20279655;i:58;i:20279656;i:59;i:20279657;i:60;i:20279658;i:61;i:20279659;i:62;i:20279660;i:63;i:20814223;i:64;i:20814224;i:65;i:20814225;i:66;i:20814226;i:67;i:20814227;i:68;i:20814228;i:69;i:20814229;i:70;i:20814230;i:71;i:20814231;i:72;i:20814232;i:73;i:20814233;i:74;i:20814234;i:75;i:20814235;i:76;i:20814236;i:77;i:20814237;i:78;i:20814238;i:79;i:20814239;i:80;i:20814240;i:81;i:20814241;i:82;i:20814242;i:83;i:20814243;i:84;i:20833326;i:85;i:20833327;i:86;i:20833328;i:87;i:20833329;i:88;i:20833330;i:89;i:20833331;i:90;i:20833332;i:91;i:20833333;i:92;i:20833334;i:93;i:20833335;i:94;i:20833336;i:95;i:20833337;i:96;i:20833338;i:97;i:20833339;i:98;i:20833340;i:99;i:20833341;i:100;i:20833342;i:101;i:20833343;i:102;i:20833344;i:103;i:20833345;i:104;i:20833346;}"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-23"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(10) "1060000.00"
  }
  ["rets_expiration_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-10"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-23"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 941-8436"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(18) "mike2344@gmail.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(19) "Mike Tavepholjalern"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "26894"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3476540"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "DOLL"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3486815"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(16) "Darlene Y S Chun"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 941-8436"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20833326"
  }
}