Welcome to the well manicured and pet-friendly Greens at Waikele. The property features a functional floor plan, a
spacious interior and flow-through living/dining area. Split and window AC units are powered by 15 owned PV
panels keeps the energy bill in check, while water is included in the maintenance fee. Home has generous living
spaces and well-proportioned rooms making it feel more like a single family inside. An oasis of peace and relaxation,
the owner’s suite provides a walk-in closet, walk-in shower and jetted bathtub. Unwind or entertain in the charming
backyard that comes complete with a covered patio, room for pets and mature fruit trees. Conveniently situated near
parks, Waikele Premium shopping outlets grocery and department stores. Property centrally located on the island,
making it the perfect starting point for your daily commute or weekend fun. Benefits of the spacious 2-car enclosed
garage are innumerable, especially with with room for 2 more cars in parked in front. Several guest parking spots
located just feet from the front door, perfect for having guests over!
array(174) {
["agency"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "113800.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "451700.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "565500.00"
}
["assn_fee_inclusions"]=>
array(1) {
[0]=>
string(2) "48"
}
["association_fees"]=>
array(1) {
[0]=>
string(2) "48"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "3"
}
["building_name"]=>
array(1) {
[0]=>
string(17) "Greens At Waikele"
}
["building_style"]=>
array(1) {
[0]=>
string(59) "Low-Rise 6 or Less Stories,No Unit Above or Below,Townhouse"
}
["city"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(50) "Pet on Property,Pets Allowed (Verify),Photovoltaic"
}
["floor_covering"]=>
array(1) {
[0]=>
string(27) "Ceramic Tile,Laminate,Other"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "2"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "1"
}
["home_exampt"]=>
array(1) {
[0]=>
string(1) "0"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(9) "241322.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(25) "marlene@marlenesedeno.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(16) "Marlene K Sedeno"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 597-5550"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-03-22"
}
["list_office_name"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["list_price"]=>
array(1) {
[0]=>
string(9) "715000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "1387"
}
["location"]=>
array(1) {
[0]=>
string(51) "94-835 Lumiauau Street Unit K105, Waipahu, HI 96797"
}
["maintenance_fees"]=>
array(1) {
[0]=>
string(6) "832.72"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202205436"
}
["neighborhood"]=>
array(1) {
[0]=>
string(7) "WAIKELE"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "4"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(3) "Two"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(6) "CBPP09"
}
["parking_features"]=>
array(1) {
[0]=>
string(30) "Assigned,Garage,Guest,Open - 2"
}
["possession"]=>
array(1) {
[0]=>
string(26) "45 Days or More,Negotiable"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96797"
}
["property_condition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["property_type"]=>
array(1) {
[0]=>
string(15) "condo_townhouse"
}
["property_type_label"]=>
array(1) {
[0]=>
string(15) "Condo Townhouse"
}
["region"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["rets_association_fee"]=>
array(1) {
[0]=>
string(2) "48"
}
["rets_association_fee_total"]=>
array(1) {
[0]=>
string(3) "881"
}
["rets_association_phone"]=>
array(1) {
[0]=>
string(12) "808-676-1991"
}
["rets_baths_full"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_baths_half"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_baths_total"]=>
array(1) {
[0]=>
string(4) "2.01"
}
["rets_beds_total"]=>
array(1) {
[0]=>
string(1) "3"
}
["rets_building_name"]=>
array(1) {
[0]=>
string(17) "Greens At Waikele"
}
["rets_city"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["rets_co_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 597-5550"
}
["rets_co_list_agent_email"]=>
array(1) {
[0]=>
string(23) "justin@justinsedeno.com"
}
["rets_co_list_agent_full_name"]=>
array(1) {
[0]=>
string(15) "Justin A Sedeno"
}
["rets_co_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "47294"
}
["rets_co_list_agent_mui"]=>
array(1) {
[0]=>
string(8) "10914521"
}
["rets_co_list_office_mlsid"]=>
array(1) {
[0]=>
string(6) "CBPP09"
}
["rets_co_list_office_mui"]=>
array(1) {
[0]=>
string(7) "3487755"
}
["rets_co_list_office_name"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["rets_co_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 597-5550"
}
["rets_condo_parking_unit"]=>
array(1) {
[0]=>
string(11) "41,42,43,44"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(9) "750000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(2) "10"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_floor_number"]=>
array(1) {
[0]=>
string(1) "1"
}
["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) "16523419"
}
["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) "(808) 597-5550"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(25) "marlene@marlenesedeno.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(16) "Marlene K Sedeno"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "50839"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(8) "15526794"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(6) "CBPP09"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(7) "3487755"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 597-5550"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(9) "715000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-03-22"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(9) "241322.00"
}
["rets_maintenance_expense"]=>
array(1) {
[0]=>
string(6) "832.72"
}
["rets_management_company_name"]=>
array(1) {
[0]=>
string(9) "Hawaiiana"
}
["rets_management_company_phone"]=>
array(1) {
[0]=>
string(12) "808-593-9100"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-05-31T11:22:48.607"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16523419"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202205436"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIKELE"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-03-22T12:11:33.253"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(9) "715000.00"
}
["rets_owner_occupancy_percentage"]=>
array(1) {
[0]=>
string(2) "70"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-9-4-007-046-0043"
}
["rets_parking_additional"]=>
array(1) {
[0]=>
string(1) "0"
}
["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) "2022-03-22T12:16:31.527"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96797"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-03-22T12:11:33.253"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16523419"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(409) "Home is owner occupied, Schedule through Showing Time, 24 hour noticed preferred. Sale is AS-IS, please include
As-is addendum and CB Realty Standard Addendum. Seller requests Nicole Yasuda of First American Title for escrow.
Please text/ email Justin @ 808-392-9359 for any questions. Seller will need a post-closing agreement. Stand alone freeze exclude from sale. No showings until after 1st open house."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(1107) "Welcome to the well manicured and pet-friendly Greens at Waikele. The property features a functional floor plan, a
spacious interior and flow-through living/dining area. Split and window AC units are powered by 15 owned PV
panels keeps the energy bill in check, while water is included in the maintenance fee. Home has generous living
spaces and well-proportioned rooms making it feel more like a single family inside. An oasis of peace and relaxation,
the owner's suite provides a walk-in closet, walk-in shower and jetted bathtub. Unwind or entertain in the charming
backyard that comes complete with a covered patio, room for pets and mature fruit trees. Conveniently situated near
parks, Waikele Premium shopping outlets grocery and department stores. Property centrally located on the island,
making it the perfect starting point for your daily commute or weekend fun. Benefits of the spacious 2-car enclosed
garage are innumerable, especially with with room for 2 more cars in parked in front. Several guest parking spots
located just feet from the front door, perfect for having guests over!"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "1387"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "1387"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-05-31T11:22:48.607"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-05-31"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(8) "Lumiauau"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(6) "94-835"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(64) "1$21.405213$-157.999484$247.89$13.33$1.00$C8gglX1HVYe_yFxA14FDhA"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(3) "2.5"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "164.94"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "1979.28"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "565500.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "113800.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "451700.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) "2021"
}
["rets_thumbnail_url"]=>
array(1) {
[0]=>
string(81) "https://cdn.rets.ci/marcusrealty-images/16523419/11d276f82b43a8705790dcc2dcf224fd"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "194"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(2) "43"
}
["rets_tmk_division"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tmk_parcel"]=>
array(1) {
[0]=>
string(2) "46"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "9"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(1) "7"
}
["rets_unit_number"]=>
array(1) {
[0]=>
string(4) "K105"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1993"
}
["state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["street_name"]=>
array(1) {
[0]=>
string(8) "Lumiauau"
}
["street_number"]=>
array(1) {
[0]=>
string(6) "94-835"
}
["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-007-046-0043"
}
["unit"]=>
array(1) {
[0]=>
string(54) "Ground Floor Unit,Multi Level,Split Level,Storage,Yard"
}
["unit_number"]=>
array(1) {
[0]=>
string(4) "K105"
}
["view"]=>
array(1) {
[0]=>
string(4) "None"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16523419"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202205436"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1654032184"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1993"
}
["zoning"]=>
array(1) {
[0]=>
string(29) "05 - R-5 Residential District"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(3111) "a:189:{i:0;i:21869001;i:1;i:21869002;i:2;i:21869003;i:3;i:21869004;i:4;i:21869005;i:5;i:21869006;i:6;i:21869007;i:7;i:21869008;i:8;i:21869009;i:9;i:21869010;i:10;i:21869011;i:11;i:21869012;i:12;i:21869013;i:13;i:21869014;i:14;i:21869015;i:15;i:21869016;i:16;i:21869017;i:17;i:21869018;i:18;i:21869019;i:19;i:21869020;i:20;i:21869021;i:21;i:21869050;i:22;i:21869051;i:23;i:21869052;i:24;i:21869053;i:25;i:21869054;i:26;i:21869055;i:27;i:21869056;i:28;i:21869057;i:29;i:21869058;i:30;i:21869059;i:31;i:21869060;i:32;i:21869061;i:33;i:21869062;i:34;i:21869063;i:35;i:21869064;i:36;i:21869065;i:37;i:21869066;i:38;i:21869067;i:39;i:21869068;i:40;i:21869069;i:41;i:21869070;i:42;i:21869912;i:43;i:21869913;i:44;i:21869914;i:45;i:21869915;i:46;i:21869916;i:47;i:21869917;i:48;i:21869918;i:49;i:21869919;i:50;i:21869920;i:51;i:21869921;i:52;i:21869922;i:53;i:21869923;i:54;i:21869924;i:55;i:21869925;i:56;i:21869926;i:57;i:21869927;i:58;i:21869928;i:59;i:21869929;i:60;i:21869930;i:61;i:21869931;i:62;i:21869932;i:63;i:21870007;i:64;i:21870008;i:65;i:21870009;i:66;i:21870010;i:67;i:21870011;i:68;i:21870012;i:69;i:21870013;i:70;i:21870014;i:71;i:21870015;i:72;i:21870016;i:73;i:21870017;i:74;i:21870018;i:75;i:21870019;i:76;i:21870020;i:77;i:21870021;i:78;i:21870022;i:79;i:21870023;i:80;i:21870024;i:81;i:21870025;i:82;i:21870026;i:83;i:21870027;i:84;i:21870028;i:85;i:21870029;i:86;i:21870030;i:87;i:21870031;i:88;i:21870032;i:89;i:21870033;i:90;i:21870034;i:91;i:21870035;i:92;i:21870036;i:93;i:21870037;i:94;i:21870038;i:95;i:21870039;i:96;i:21870040;i:97;i:21870041;i:98;i:21870042;i:99;i:21870043;i:100;i:21870044;i:101;i:21870045;i:102;i:21870046;i:103;i:21870047;i:104;i:21870048;i:105;i:21937345;i:106;i:21937346;i:107;i:21937347;i:108;i:21937348;i:109;i:21937349;i:110;i:21937350;i:111;i:21937351;i:112;i:21937352;i:113;i:21937353;i:114;i:21937354;i:115;i:21937355;i:116;i:21937356;i:117;i:21937357;i:118;i:21937358;i:119;i:21937359;i:120;i:21937360;i:121;i:21937361;i:122;i:21937362;i:123;i:21937363;i:124;i:21937364;i:125;i:21937365;i:126;i:22070529;i:127;i:22070530;i:128;i:22070531;i:129;i:22070532;i:130;i:22070533;i:131;i:22070534;i:132;i:22070535;i:133;i:22070536;i:134;i:22070537;i:135;i:22070538;i:136;i:22070539;i:137;i:22070540;i:138;i:22070541;i:139;i:22070542;i:140;i:22070543;i:141;i:22070544;i:142;i:22070545;i:143;i:22070546;i:144;i:22070547;i:145;i:22070548;i:146;i:22070549;i:147;i:22075135;i:148;i:22075136;i:149;i:22075137;i:150;i:22075138;i:151;i:22075139;i:152;i:22075140;i:153;i:22075141;i:154;i:22075142;i:155;i:22075143;i:156;i:22075144;i:157;i:22075145;i:158;i:22075146;i:159;i:22075147;i:160;i:22075148;i:161;i:22075149;i:162;i:22075150;i:163;i:22075151;i:164;i:22075152;i:165;i:22075153;i:166;i:22075154;i:167;i:22075155;i:168;i:22331230;i:169;i:22331231;i:170;i:22331232;i:171;i:22331233;i:172;i:22331234;i:173;i:22331235;i:174;i:22331236;i:175;i:22331237;i:176;i:22331238;i:177;i:22331239;i:178;i:22331240;i:179;i:22331241;i:180;i:22331242;i:181;i:22331243;i:182;i:22331244;i:183;i:22331245;i:184;i:22331246;i:185;i:22331247;i:186;i:22331248;i:187;i:22331249;i:188;i:22331250;}"
}
["rets_open_house_count"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-04-21"
}
["rets_active_open_house_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-05-31"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(9) "750000.00"
}
["rets_co_selling_agent_direct_work_pho"]=>
array(1) {
[0]=>
string(14) "(808) 675-6642"
}
["rets_co_selling_agent_email"]=>
array(1) {
[0]=>
string(18) "Katy@mhshawaii.com"
}
["rets_co_selling_agent_full_name"]=>
array(1) {
[0]=>
string(9) "Katy Bird"
}
["rets_co_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "46908"
}
["rets_co_selling_agent_mui"]=>
array(1) {
[0]=>
string(8) "10674597"
}
["rets_co_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "VTRN"
}
["rets_co_selling_office_mui"]=>
array(1) {
[0]=>
string(8) "15279310"
}
["rets_co_selling_office_name"]=>
array(1) {
[0]=>
string(23) "Sentry Residential, LLC"
}
["rets_co_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 675-6642"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-09-22"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-05-31"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 675-6642"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(21) "Deborah@mhshawaii.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(18) "Deborah L Arguello"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "45031"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "9450531"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "VTRN"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(8) "15279310"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(23) "Sentry Residential, LLC"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 675-6642"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "22331230"
}
}
Array
(
[agency] => Array
(
[0] => Coldwell Banker Realty
)
[assd_val_imprv] => Array
(
[0] => 113800.00
)
[assd_val_land] => Array
(
[0] => 451700.00
)
[assd_val_total] => Array
(
[0] => 565500.00
)
[assn_fee_inclusions] => Array
(
[0] => 48
)
[association_fees] => Array
(
[0] => 48
)
[bedrooms] => Array
(
[0] => 3
)
[building_name] => Array
(
[0] => Greens At Waikele
)
[building_style] => Array
(
[0] => Low-Rise 6 or Less Stories,No Unit Above or Below,Townhouse
)
[city] => Array
(
[0] => Waipahu
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Pet on Property,Pets Allowed (Verify),Photovoltaic
)
[floor_covering] => Array
(
[0] => Ceramic Tile,Laminate,Other
)
[full_baths] => Array
(
[0] => 2
)
[half_baths] => Array
(
[0] => 1
)
[home_exampt] => Array
(
[0] => 0
)
[land_area_sf] => Array
(
[0] => 241322.00
)
[land_recorded] => Array
(
[0] => Land Court
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => marlene@marlenesedeno.com
)
[list_agent_name] => Array
(
[0] => Marlene K Sedeno
)
[list_agent_phone_number] => Array
(
[0] => (808) 597-5550
)
[list_date] => Array
(
[0] => 2022-03-22
)
[list_office_name] => Array
(
[0] => Coldwell Banker Realty
)
[list_price] => Array
(
[0] => 715000.00
)
[living_sf] => Array
(
[0] => 1387
)
[location] => Array
(
[0] => 94-835 Lumiauau Street Unit K105, Waipahu, HI 96797
)
[maintenance_fees] => Array
(
[0] => 832.72
)
[mls_] => Array
(
[0] => 202205436
)
[neighborhood] => Array
(
[0] => WAIKELE
)
[number_of_parking_spaces] => Array
(
[0] => 4
)
[number_of_stories] => Array
(
[0] => Two
)
[office_mls_id] => Array
(
[0] => CBPP09
)
[parking_features] => Array
(
[0] => Assigned,Garage,Guest,Open - 2
)
[possession] => Array
(
[0] => 45 Days or More,Negotiable
)
[postal_code] => Array
(
[0] => 96797
)
[property_condition] => Array
(
[0] => Excellent
)
[property_type] => Array
(
[0] => condo_townhouse
)
[property_type_label] => Array
(
[0] => Condo Townhouse
)
[region] => Array
(
[0] => Waipahu
)
[rets_association_fee] => Array
(
[0] => 48
)
[rets_association_fee_total] => Array
(
[0] => 881
)
[rets_association_phone] => Array
(
[0] => 808-676-1991
)
[rets_baths_full] => Array
(
[0] => 2
)
[rets_baths_half] => Array
(
[0] => 1
)
[rets_baths_total] => Array
(
[0] => 2.01
)
[rets_beds_total] => Array
(
[0] => 3
)
[rets_building_name] => Array
(
[0] => Greens At Waikele
)
[rets_city] => Array
(
[0] => Waipahu
)
[rets_co_list_agent_direct_work_phone] => Array
(
[0] => (808) 597-5550
)
[rets_co_list_agent_email] => Array
(
[0] => justin@justinsedeno.com
)
[rets_co_list_agent_full_name] => Array
(
[0] => Justin A Sedeno
)
[rets_co_list_agent_mlsid] => Array
(
[0] => 47294
)
[rets_co_list_agent_mui] => Array
(
[0] => 10914521
)
[rets_co_list_office_mlsid] => Array
(
[0] => CBPP09
)
[rets_co_list_office_mui] => Array
(
[0] => 3487755
)
[rets_co_list_office_name] => Array
(
[0] => Coldwell Banker Realty
)
[rets_co_list_office_phone] => Array
(
[0] => (808) 597-5550
)
[rets_condo_parking_unit] => Array
(
[0] => 41,42,43,44
)
[rets_current_price] => Array
(
[0] => 750000.00
)
[rets_dom] => Array
(
[0] => 10
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_floor_number] => Array
(
[0] => 1
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_id] => Array
(
[0] => 16523419
)
[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] => (808) 597-5550
)
[rets_list_agent_email] => Array
(
[0] => marlene@marlenesedeno.com
)
[rets_list_agent_full_name] => Array
(
[0] => Marlene K Sedeno
)
[rets_list_agent_mlsid] => Array
(
[0] => 50839
)
[rets_list_agent_mui] => Array
(
[0] => 15526794
)
[rets_list_office_mlsid] => Array
(
[0] => CBPP09
)
[rets_list_office_mui] => Array
(
[0] => 3487755
)
[rets_list_office_name] => Array
(
[0] => Coldwell Banker Realty
)
[rets_list_office_phone] => Array
(
[0] => (808) 597-5550
)
[rets_list_price] => Array
(
[0] => 715000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-03-22
)
[rets_lot_size_area] => Array
(
[0] => 241322.00
)
[rets_maintenance_expense] => Array
(
[0] => 832.72
)
[rets_management_company_name] => Array
(
[0] => Hawaiiana
)
[rets_management_company_phone] => Array
(
[0] => 808-593-9100
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-05-31T11:22:48.607
)
[rets_matrix_unique_id] => Array
(
[0] => 16523419
)
[rets_mls_number] => Array
(
[0] => 202205436
)
[rets_neighbourhood] => Array
(
[0] => WAIKELE
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-03-22T12:11:33.253
)
[rets_original_list_price] => Array
(
[0] => 715000.00
)
[rets_owner_occupancy_percentage] => Array
(
[0] => 70
)
[rets_parcel_number] => Array
(
[0] => 1-9-4-007-046-0043
)
[rets_parking_additional] => Array
(
[0] => 0
)
[rets_parking_total] => Array
(
[0] => 4
)
[rets_permit_address_internet_yn] => Array
(
[0] => 1
)
[rets_permit_internet_yn] => Array
(
[0] => 1
)
[rets_photo_count] => Array
(
[0] => 25
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2022-03-22T12:16:31.527
)
[rets_postal_code] => Array
(
[0] => 96797
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-03-22T12:11:33.253
)
[rets_primary_key] => Array
(
[0] => 16523419
)
[rets_private_remarks] => Array
(
[0] => Home is owner occupied, Schedule through Showing Time, 24 hour noticed preferred. Sale is AS-IS, please include
As-is addendum and CB Realty Standard Addendum. Seller requests Nicole Yasuda of First American Title for escrow.
Please text/ email Justin @ 808-392-9359 for any questions. Seller will need a post-closing agreement. Stand alone freeze exclude from sale. No showings until after 1st open house.
)
[rets_public_remarks] => Array
(
[0] => Welcome to the well manicured and pet-friendly Greens at Waikele. The property features a functional floor plan, a
spacious interior and flow-through living/dining area. Split and window AC units are powered by 15 owned PV
panels keeps the energy bill in check, while water is included in the maintenance fee. Home has generous living
spaces and well-proportioned rooms making it feel more like a single family inside. An oasis of peace and relaxation,
the owner's suite provides a walk-in closet, walk-in shower and jetted bathtub. Unwind or entertain in the charming
backyard that comes complete with a covered patio, room for pets and mature fruit trees. Conveniently situated near
parks, Waikele Premium shopping outlets grocery and department stores. Property centrally located on the island,
making it the perfect starting point for your daily commute or weekend fun. Benefits of the spacious 2-car enclosed
garage are innumerable, especially with with room for 2 more cars in parked in front. Several guest parking spots
located just feet from the front door, perfect for having guests over!
)
[rets_sqft_roofed_living] => Array
(
[0] => 1387
)
[rets_sqft_total] => Array
(
[0] => 1387
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-05-31T11:22:48.607
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-05-31
)
[rets_street_name] => Array
(
[0] => Lumiauau
)
[rets_street_number] => Array
(
[0] => 94-835
)
[rets_street_view_param] => Array
(
[0] => 1$21.405213$-157.999484$247.89$13.33$1.00$C8gglX1HVYe_yFxA14FDhA
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5
)
[rets_tax_amount] => Array
(
[0] => 164.94
)
[rets_tax_annual_amount] => Array
(
[0] => 1979.28
)
[rets_tax_assessed_value] => Array
(
[0] => 565500.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 113800.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 451700.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 0
)
[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/16523419/11d276f82b43a8705790dcc2dcf224fd
)
[rets_tmk_area] => Array
(
[0] => 194
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 43
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 46
)
[rets_tmk_section] => Array
(
[0] => 4
)
[rets_tmk_zone] => Array
(
[0] => 9
)
[rets_tmkplat] => Array
(
[0] => 7
)
[rets_unit_number] => Array
(
[0] => K105
)
[rets_year_built] => Array
(
[0] => 1993
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Lumiauau
)
[street_number] => Array
(
[0] => 94-835
)
[street_suffix] => Array
(
[0] => Street
)
[terms_accept] => Array
(
[0] => Cash,Conventional,VA
)
[tmk] => Array
(
[0] => 1-9-4-007-046-0043
)
[unit] => Array
(
[0] => Ground Floor Unit,Multi Level,Split Level,Storage,Yard
)
[unit_number] => Array
(
[0] => K105
)
[view] => Array
(
[0] => None
)
[wpp::rets_pk] => Array
(
[0] => 16523419
)
[wpp_gpid] => Array
(
[0] => 202205436
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1654032184
)
[year_built] => Array
(
[0] => 1993
)
[zoning] => Array
(
[0] => 05 - R-5 Residential District
)
[new_attached_media] => Array
(
[0] => a:189:{i:0;i:21869001;i:1;i:21869002;i:2;i:21869003;i:3;i:21869004;i:4;i:21869005;i:5;i:21869006;i:6;i:21869007;i:7;i:21869008;i:8;i:21869009;i:9;i:21869010;i:10;i:21869011;i:11;i:21869012;i:12;i:21869013;i:13;i:21869014;i:14;i:21869015;i:15;i:21869016;i:16;i:21869017;i:17;i:21869018;i:18;i:21869019;i:19;i:21869020;i:20;i:21869021;i:21;i:21869050;i:22;i:21869051;i:23;i:21869052;i:24;i:21869053;i:25;i:21869054;i:26;i:21869055;i:27;i:21869056;i:28;i:21869057;i:29;i:21869058;i:30;i:21869059;i:31;i:21869060;i:32;i:21869061;i:33;i:21869062;i:34;i:21869063;i:35;i:21869064;i:36;i:21869065;i:37;i:21869066;i:38;i:21869067;i:39;i:21869068;i:40;i:21869069;i:41;i:21869070;i:42;i:21869912;i:43;i:21869913;i:44;i:21869914;i:45;i:21869915;i:46;i:21869916;i:47;i:21869917;i:48;i:21869918;i:49;i:21869919;i:50;i:21869920;i:51;i:21869921;i:52;i:21869922;i:53;i:21869923;i:54;i:21869924;i:55;i:21869925;i:56;i:21869926;i:57;i:21869927;i:58;i:21869928;i:59;i:21869929;i:60;i:21869930;i:61;i:21869931;i:62;i:21869932;i:63;i:21870007;i:64;i:21870008;i:65;i:21870009;i:66;i:21870010;i:67;i:21870011;i:68;i:21870012;i:69;i:21870013;i:70;i:21870014;i:71;i:21870015;i:72;i:21870016;i:73;i:21870017;i:74;i:21870018;i:75;i:21870019;i:76;i:21870020;i:77;i:21870021;i:78;i:21870022;i:79;i:21870023;i:80;i:21870024;i:81;i:21870025;i:82;i:21870026;i:83;i:21870027;i:84;i:21870028;i:85;i:21870029;i:86;i:21870030;i:87;i:21870031;i:88;i:21870032;i:89;i:21870033;i:90;i:21870034;i:91;i:21870035;i:92;i:21870036;i:93;i:21870037;i:94;i:21870038;i:95;i:21870039;i:96;i:21870040;i:97;i:21870041;i:98;i:21870042;i:99;i:21870043;i:100;i:21870044;i:101;i:21870045;i:102;i:21870046;i:103;i:21870047;i:104;i:21870048;i:105;i:21937345;i:106;i:21937346;i:107;i:21937347;i:108;i:21937348;i:109;i:21937349;i:110;i:21937350;i:111;i:21937351;i:112;i:21937352;i:113;i:21937353;i:114;i:21937354;i:115;i:21937355;i:116;i:21937356;i:117;i:21937357;i:118;i:21937358;i:119;i:21937359;i:120;i:21937360;i:121;i:21937361;i:122;i:21937362;i:123;i:21937363;i:124;i:21937364;i:125;i:21937365;i:126;i:22070529;i:127;i:22070530;i:128;i:22070531;i:129;i:22070532;i:130;i:22070533;i:131;i:22070534;i:132;i:22070535;i:133;i:22070536;i:134;i:22070537;i:135;i:22070538;i:136;i:22070539;i:137;i:22070540;i:138;i:22070541;i:139;i:22070542;i:140;i:22070543;i:141;i:22070544;i:142;i:22070545;i:143;i:22070546;i:144;i:22070547;i:145;i:22070548;i:146;i:22070549;i:147;i:22075135;i:148;i:22075136;i:149;i:22075137;i:150;i:22075138;i:151;i:22075139;i:152;i:22075140;i:153;i:22075141;i:154;i:22075142;i:155;i:22075143;i:156;i:22075144;i:157;i:22075145;i:158;i:22075146;i:159;i:22075147;i:160;i:22075148;i:161;i:22075149;i:162;i:22075150;i:163;i:22075151;i:164;i:22075152;i:165;i:22075153;i:166;i:22075154;i:167;i:22075155;i:168;i:22331230;i:169;i:22331231;i:170;i:22331232;i:171;i:22331233;i:172;i:22331234;i:173;i:22331235;i:174;i:22331236;i:175;i:22331237;i:176;i:22331238;i:177;i:22331239;i:178;i:22331240;i:179;i:22331241;i:180;i:22331242;i:181;i:22331243;i:182;i:22331244;i:183;i:22331245;i:184;i:22331246;i:185;i:22331247;i:186;i:22331248;i:187;i:22331249;i:188;i:22331250;}
)
[rets_open_house_count] => Array
(
[0] => 2
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-04-21
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_close_date] => Array
(
[0] => 2022-05-31
)
[rets_close_price] => Array
(
[0] => 750000.00
)
[rets_co_selling_agent_direct_work_pho] => Array
(
[0] => (808) 675-6642
)
[rets_co_selling_agent_email] => Array
(
[0] => Katy@mhshawaii.com
)
[rets_co_selling_agent_full_name] => Array
(
[0] => Katy Bird
)
[rets_co_selling_agent_mlsid] => Array
(
[0] => 46908
)
[rets_co_selling_agent_mui] => Array
(
[0] => 10674597
)
[rets_co_selling_office_mlsid] => Array
(
[0] => VTRN
)
[rets_co_selling_office_mui] => Array
(
[0] => 15279310
)
[rets_co_selling_office_name] => Array
(
[0] => Sentry Residential, LLC
)
[rets_co_selling_office_phone] => Array
(
[0] => (808) 675-6642
)
[rets_expiration_date] => Array
(
[0] => 2022-09-22
)
[rets_off_market_date] => Array
(
[0] => 2022-05-31
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 675-6642
)
[rets_selling_agent_email] => Array
(
[0] => Deborah@mhshawaii.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Deborah L Arguello
)
[rets_selling_agent_mlsid] => Array
(
[0] => 45031
)
[rets_selling_agent_mui] => Array
(
[0] => 9450531
)
[rets_selling_office_mlsid] => Array
(
[0] => VTRN
)
[rets_selling_office_mui] => Array
(
[0] => 15279310
)
[rets_selling_office_name] => Array
(
[0] => Sentry Residential, LLC
)
[rets_selling_office_phone] => Array
(
[0] => (808) 675-6642
)
[_thumbnail_id] => Array
(
[0] => 22331230
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446