Welcome to the highly sought after and rarely available Village on the Green at Waikele. This 2-bedroom home with 2 car garage and room to park 2 additional cars is looking for a new owner! The home boasts a spacious interior, newer stainless steal appliances, split AC units in living room and main bedroom. Enjoy cooking in the large kitchen with pantry, plenty of cabinets, counter space and breakfast nook. Or you could choose to unwind in your private backyard while surrounded by stunning golf course views. The home is centrally located on island making it the perfect starting point for weekend fun or daily commute. Conveniently located near community walking paths, community recreation center, parks, Waikele Shopping Center, grocery and department stores with easy access to freeways.
Listing by: eXp Realty
array(168) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "227200.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "400000.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "627200.00"
}
["assn_fee_inclusions"]=>
array(1) {
[0]=>
string(2) "49"
}
["association_fees"]=>
array(1) {
[0]=>
string(2) "49"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "2"
}
["building_name"]=>
array(1) {
[0]=>
string(23) "Village On The Green 1A"
}
["building_style"]=>
array(1) {
[0]=>
string(9) "Townhouse"
}
["city"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(46) "Pets Allowed (Verify),Property Disclosure Stmt"
}
["floor_covering"]=>
array(1) {
[0]=>
string(32) "Ceramic Tile,Laminate,W/W Carpet"
}
["frontage"]=>
array(1) {
[0]=>
string(11) "Golf Course"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "2"
}
["furnished"]=>
array(1) {
[0]=>
string(4) "None"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "1"
}
["home_exampt"]=>
array(1) {
[0]=>
string(1) "0"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(2) "75"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(9) "463043.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(19) "Raele@808Heroes.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(13) "Raele A Scott"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 725-2794"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-06-29"
}
["list_office_name"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["list_price"]=>
array(1) {
[0]=>
string(9) "675000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "1413"
}
["location"]=>
array(1) {
[0]=>
string(49) "94-752 Lumiauau Street Unit Z2, Waipahu, HI 96797"
}
["maintenance_fees"]=>
array(1) {
[0]=>
string(6) "661.61"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202212432"
}
["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(4) "EXPI"
}
["parking_features"]=>
array(1) {
[0]=>
string(15) "Garage,Open - 2"
}
["possession"]=>
array(1) {
[0]=>
string(10) "At Closing"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96797"
}
["property_condition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["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_community_name"]=>
array(1) {
[0]=>
string(29) "Waikele Community Association"
}
["rets_association_fee"]=>
array(1) {
[0]=>
string(2) "49"
}
["rets_association_fee_total"]=>
array(1) {
[0]=>
string(3) "711"
}
["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) "2"
}
["rets_building_name"]=>
array(1) {
[0]=>
string(23) "Village On The Green 1A"
}
["rets_city"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["rets_compensation_method"]=>
array(1) {
[0]=>
string(1) "%"
}
["rets_condo_parking_unit"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(9) "700000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(1) "5"
}
["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) "16731663"
}
["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(19) "Raele@808Heroes.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(13) "Raele A Scott"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "48791"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(8) "12930725"
}
["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) "675000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-06-29"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(9) "463043.00"
}
["rets_maintenance_expense"]=>
array(1) {
[0]=>
string(6) "661.61"
}
["rets_management_company_name"]=>
array(1) {
[0]=>
string(19) "Hawaiian Properties"
}
["rets_management_company_phone"]=>
array(1) {
[0]=>
string(12) "808.539.9777"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-08-03T08:45:27.927"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16731663"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202212432"
}
["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-06-28T17:24:54.523"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(9) "675000.00"
}
["rets_owner_occupancy_percentage"]=>
array(1) {
[0]=>
string(2) "91"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-9-4-007-047-0066"
}
["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) "24"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-28T18:03:25.437"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96797"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-29T01:39:25.507"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16731663"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(379) "Please use ShowingTime to schedule all showings. Please include As-Is, Short-Term Rental (STR) Disclosure, eXp Wire Fraud Advisory, eXp Affiliated Business Disclosure, Pre-Approval and VOF with offer. SRPDS, STR, Flood Map, eXp Addenda and Dual Agency (for eXp agents) in Supplements. Please consider Maggie Marcelli with Title Guaranty [TeamKapolei@tghawaii.com / 808.533.5817]."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(796) "Welcome to the highly sought after and rarely available Village on the Green at Waikele. This 2-bedroom home with 2 car garage and room to park 2 additional cars is looking for a new owner! The home boasts a spacious interior, newer stainless steal appliances, split AC units in living room and main bedroom. Enjoy cooking in the large kitchen with pantry, plenty of cabinets, counter space and breakfast nook. Or you could choose to unwind in your private backyard while surrounded by stunning golf course views. The home is centrally located on island making it the perfect starting point for weekend fun or daily commute. Conveniently located near community walking paths, community recreation center, parks, Waikele Shopping Center, grocery and department stores with easy access to freeways."
}
["rets_sqft_garage_carport"]=>
array(1) {
[0]=>
string(3) "385"
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(2) "75"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "1338"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "1413"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-08-03T08:45:27.927"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-08-03"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(8) "Lumiauau"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(6) "94-752"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(64) "1$21.405867$-158.001952$110.62$13.33$1.00$uMXGVDnwPa8c-0gr5l0CaQ"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(3) "2.5"
}
["rets_supplement_count"]=>
array(1) {
[0]=>
string(1) "5"
}
["rets_supplement_modification_timestam"]=>
array(1) {
[0]=>
string(23) "2022-07-01T17:19:54.207"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "182.93"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "2195.16"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "627200.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "227200.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "400000.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) "2022"
}
["rets_thumbnail_url"]=>
array(1) {
[0]=>
string(81) "https://cdn.rets.ci/marcusrealty-images/16731663/e536ecdd355cb24158209188595c5cbb"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "194"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(2) "66"
}
["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) "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(2) "Z2"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1995"
}
["security"]=>
array(1) {
[0]=>
string(3) "Key"
}
["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-752"
}
["street_suffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["terms_accept"]=>
array(1) {
[0]=>
string(24) "Cash,Conventional,FHA,VA"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-9-4-007-047-0066"
}
["unit"]=>
array(1) {
[0]=>
string(27) "Even# Unit,Multi Level,Yard"
}
["unit_number"]=>
array(1) {
[0]=>
string(2) "Z2"
}
["view"]=>
array(1) {
[0]=>
string(11) "Golf Course"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16731663"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202212432"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1659552430"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1995"
}
["zoning"]=>
array(1) {
[0]=>
string(29) "05 - R-5 Residential District"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(3825) "a:231:{i:0;i:22571769;i:1;i:22571770;i:2;i:22571771;i:3;i:22571772;i:4;i:22571773;i:5;i:22571774;i:6;i:22571775;i:7;i:22571776;i:8;i:22571777;i:9;i:22571778;i:10;i:22571779;i:11;i:22571780;i:12;i:22571781;i:13;i:22571782;i:14;i:22571783;i:15;i:22571784;i:16;i:22571785;i:17;i:22571786;i:18;i:22571787;i:19;i:22571788;i:20;i:22571789;i:21;i:22583790;i:22;i:22583791;i:23;i:22583792;i:24;i:22583793;i:25;i:22583794;i:26;i:22583795;i:27;i:22583796;i:28;i:22583797;i:29;i:22583798;i:30;i:22583799;i:31;i:22583800;i:32;i:22583801;i:33;i:22583802;i:34;i:22583803;i:35;i:22583804;i:36;i:22583805;i:37;i:22583806;i:38;i:22583807;i:39;i:22583808;i:40;i:22583809;i:41;i:22583810;i:42;i:22584013;i:43;i:22584014;i:44;i:22584015;i:45;i:22584016;i:46;i:22584017;i:47;i:22584018;i:48;i:22584019;i:49;i:22584020;i:50;i:22584021;i:51;i:22584022;i:52;i:22584023;i:53;i:22584024;i:54;i:22584025;i:55;i:22584026;i:56;i:22584027;i:57;i:22584028;i:58;i:22584029;i:59;i:22584030;i:60;i:22584031;i:61;i:22584032;i:62;i:22584033;i:63;i:22585717;i:64;i:22585718;i:65;i:22585719;i:66;i:22585720;i:67;i:22585721;i:68;i:22585722;i:69;i:22585723;i:70;i:22585724;i:71;i:22585725;i:72;i:22585726;i:73;i:22585727;i:74;i:22585728;i:75;i:22585729;i:76;i:22585730;i:77;i:22585731;i:78;i:22585732;i:79;i:22585733;i:80;i:22585734;i:81;i:22585735;i:82;i:22585736;i:83;i:22585737;i:84;i:22587110;i:85;i:22587111;i:86;i:22587112;i:87;i:22587113;i:88;i:22587114;i:89;i:22587115;i:90;i:22587116;i:91;i:22587117;i:92;i:22587118;i:93;i:22587119;i:94;i:22587120;i:95;i:22587121;i:96;i:22587122;i:97;i:22587123;i:98;i:22587124;i:99;i:22587125;i:100;i:22587126;i:101;i:22587127;i:102;i:22587128;i:103;i:22587129;i:104;i:22587130;i:105;i:22603056;i:106;i:22603057;i:107;i:22603058;i:108;i:22603059;i:109;i:22603060;i:110;i:22603061;i:111;i:22603062;i:112;i:22603063;i:113;i:22603064;i:114;i:22603065;i:115;i:22603066;i:116;i:22603067;i:117;i:22603068;i:118;i:22603069;i:119;i:22603070;i:120;i:22603071;i:121;i:22603072;i:122;i:22603073;i:123;i:22603074;i:124;i:22603075;i:125;i:22603076;i:126;i:22609148;i:127;i:22609149;i:128;i:22609150;i:129;i:22609151;i:130;i:22609152;i:131;i:22609153;i:132;i:22609154;i:133;i:22609155;i:134;i:22609156;i:135;i:22609157;i:136;i:22609158;i:137;i:22609159;i:138;i:22609160;i:139;i:22609161;i:140;i:22609162;i:141;i:22609163;i:142;i:22609164;i:143;i:22609165;i:144;i:22609166;i:145;i:22609167;i:146;i:22609168;i:147;i:22619028;i:148;i:22619029;i:149;i:22619030;i:150;i:22619031;i:151;i:22619032;i:152;i:22619033;i:153;i:22619034;i:154;i:22619035;i:155;i:22619036;i:156;i:22619037;i:157;i:22619038;i:158;i:22619039;i:159;i:22619040;i:160;i:22619041;i:161;i:22619042;i:162;i:22619043;i:163;i:22619044;i:164;i:22619045;i:165;i:22619046;i:166;i:22619047;i:167;i:22619048;i:168;i:22620932;i:169;i:22620933;i:170;i:22620934;i:171;i:22620935;i:172;i:22620936;i:173;i:22620937;i:174;i:22620938;i:175;i:22620939;i:176;i:22620940;i:177;i:22620941;i:178;i:22620942;i:179;i:22620943;i:180;i:22620944;i:181;i:22620945;i:182;i:22620946;i:183;i:22620947;i:184;i:22620948;i:185;i:22620949;i:186;i:22620950;i:187;i:22620951;i:188;i:22620952;i:189;i:22846281;i:190;i:22846282;i:191;i:22846283;i:192;i:22846284;i:193;i:22846285;i:194;i:22846286;i:195;i:22846287;i:196;i:22846288;i:197;i:22846289;i:198;i:22846290;i:199;i:22846291;i:200;i:22846292;i:201;i:22846293;i:202;i:22846294;i:203;i:22846295;i:204;i:22846296;i:205;i:22846297;i:206;i:22846298;i:207;i:22846299;i:208;i:22846300;i:209;i:22846301;i:210;i:22931303;i:211;i:22931304;i:212;i:22931305;i:213;i:22931306;i:214;i:22931307;i:215;i:22931308;i:216;i:22931309;i:217;i:22931310;i:218;i:22931311;i:219;i:22931312;i:220;i:22931313;i:221;i:22931314;i:222;i:22931315;i:223;i:22931316;i:224;i:22931317;i:225;i:22931318;i:226;i:22931319;i:227;i:22931320;i:228;i:22931321;i:229;i:22931322;i:230;i:22931323;}"
}
["rets_open_house_count"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_active_open_house_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_open_house_upcoming"]=>
array(1) {
[0]=>
string(0) ""
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-07-03"
}
["rets_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(69) "https://app.immoviewer.com/landing/unbranded/62c01315ca3e1e6db6c55447"
}
["virtual_tour"]=>
array(1) {
[0]=>
string(69) "https://app.immoviewer.com/landing/unbranded/62c01315ca3e1e6db6c55447"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-08-03"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(9) "700000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-12-30"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-08-03"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 596-0456"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(22) "jon@homesearchoahu.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(16) "Jonathan TL Pang"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "44001"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "8847257"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "CBPP"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(7) "3485212"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 596-0456"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "22931303"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 227200.00
)
[assd_val_land] => Array
(
[0] => 400000.00
)
[assd_val_total] => Array
(
[0] => 627200.00
)
[assn_fee_inclusions] => Array
(
[0] => 49
)
[association_fees] => Array
(
[0] => 49
)
[bedrooms] => Array
(
[0] => 2
)
[building_name] => Array
(
[0] => Village On The Green 1A
)
[building_style] => Array
(
[0] => Townhouse
)
[city] => Array
(
[0] => Waipahu
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Pets Allowed (Verify),Property Disclosure Stmt
)
[floor_covering] => Array
(
[0] => Ceramic Tile,Laminate,W/W Carpet
)
[frontage] => Array
(
[0] => Golf Course
)
[full_baths] => Array
(
[0] => 2
)
[furnished] => Array
(
[0] => None
)
[half_baths] => Array
(
[0] => 1
)
[home_exampt] => Array
(
[0] => 0
)
[lanai_sf] => Array
(
[0] => 75
)
[land_area_sf] => Array
(
[0] => 463043.00
)
[land_recorded] => Array
(
[0] => Regular System
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => Raele@808Heroes.com
)
[list_agent_name] => Array
(
[0] => Raele A Scott
)
[list_agent_phone_number] => Array
(
[0] => (808) 725-2794
)
[list_date] => Array
(
[0] => 2022-06-29
)
[list_office_name] => Array
(
[0] => eXp Realty
)
[list_price] => Array
(
[0] => 675000.00
)
[living_sf] => Array
(
[0] => 1413
)
[location] => Array
(
[0] => 94-752 Lumiauau Street Unit Z2, Waipahu, HI 96797
)
[maintenance_fees] => Array
(
[0] => 661.61
)
[mls_] => Array
(
[0] => 202212432
)
[neighborhood] => Array
(
[0] => WAIKELE
)
[number_of_parking_spaces] => Array
(
[0] => 4
)
[number_of_stories] => Array
(
[0] => Two
)
[office_mls_id] => Array
(
[0] => EXPI
)
[parking_features] => Array
(
[0] => Garage,Open - 2
)
[possession] => Array
(
[0] => At Closing
)
[postal_code] => Array
(
[0] => 96797
)
[property_condition] => Array
(
[0] => Average
)
[property_type] => Array
(
[0] => condo_townhouse
)
[property_type_label] => Array
(
[0] => Condo Townhouse
)
[region] => Array
(
[0] => Waipahu
)
[rets_association_community_name] => Array
(
[0] => Waikele Community Association
)
[rets_association_fee] => Array
(
[0] => 49
)
[rets_association_fee_total] => Array
(
[0] => 711
)
[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] => 2
)
[rets_building_name] => Array
(
[0] => Village On The Green 1A
)
[rets_city] => Array
(
[0] => Waipahu
)
[rets_compensation_method] => Array
(
[0] => %
)
[rets_condo_parking_unit] => Array
(
[0] => 0
)
[rets_current_price] => Array
(
[0] => 700000.00
)
[rets_dom] => Array
(
[0] => 5
)
[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] => 16731663
)
[rets_immoviewer_yn] => Array
(
[0] => 1
)
[rets_internet_automated_valuation_dis] => Array
(
[0] => 0
)
[rets_internet_consumer_comment_yn] => Array
(
[0] => 0
)
[rets_list_agent_direct_work_phone] => Array
(
[0] => (808) 725-2794
)
[rets_list_agent_email] => Array
(
[0] => Raele@808Heroes.com
)
[rets_list_agent_full_name] => Array
(
[0] => Raele A Scott
)
[rets_list_agent_mlsid] => Array
(
[0] => 48791
)
[rets_list_agent_mui] => Array
(
[0] => 12930725
)
[rets_list_office_mlsid] => Array
(
[0] => EXPI
)
[rets_list_office_mui] => Array
(
[0] => 10013908
)
[rets_list_office_name] => Array
(
[0] => eXp Realty
)
[rets_list_office_phone] => Array
(
[0] => (808) 725-2794
)
[rets_list_price] => Array
(
[0] => 675000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-06-29
)
[rets_lot_size_area] => Array
(
[0] => 463043.00
)
[rets_maintenance_expense] => Array
(
[0] => 661.61
)
[rets_management_company_name] => Array
(
[0] => Hawaiian Properties
)
[rets_management_company_phone] => Array
(
[0] => 808.539.9777
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-08-03T08:45:27.927
)
[rets_matrix_unique_id] => Array
(
[0] => 16731663
)
[rets_mls_number] => Array
(
[0] => 202212432
)
[rets_neighbourhood] => Array
(
[0] => WAIKELE
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-06-28T17:24:54.523
)
[rets_original_list_price] => Array
(
[0] => 675000.00
)
[rets_owner_occupancy_percentage] => Array
(
[0] => 91
)
[rets_parcel_number] => Array
(
[0] => 1-9-4-007-047-0066
)
[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] => 24
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2022-06-28T18:03:25.437
)
[rets_postal_code] => Array
(
[0] => 96797
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-06-29T01:39:25.507
)
[rets_primary_key] => Array
(
[0] => 16731663
)
[rets_private_remarks] => Array
(
[0] => Please use ShowingTime to schedule all showings. Please include As-Is, Short-Term Rental (STR) Disclosure, eXp Wire Fraud Advisory, eXp Affiliated Business Disclosure, Pre-Approval and VOF with offer. SRPDS, STR, Flood Map, eXp Addenda and Dual Agency (for eXp agents) in Supplements. Please consider Maggie Marcelli with Title Guaranty [TeamKapolei@tghawaii.com / 808.533.5817].
)
[rets_public_remarks] => Array
(
[0] => Welcome to the highly sought after and rarely available Village on the Green at Waikele. This 2-bedroom home with 2 car garage and room to park 2 additional cars is looking for a new owner! The home boasts a spacious interior, newer stainless steal appliances, split AC units in living room and main bedroom. Enjoy cooking in the large kitchen with pantry, plenty of cabinets, counter space and breakfast nook. Or you could choose to unwind in your private backyard while surrounded by stunning golf course views. The home is centrally located on island making it the perfect starting point for weekend fun or daily commute. Conveniently located near community walking paths, community recreation center, parks, Waikele Shopping Center, grocery and department stores with easy access to freeways.
)
[rets_sqft_garage_carport] => Array
(
[0] => 385
)
[rets_sqft_lanai_open] => Array
(
[0] => 75
)
[rets_sqft_roofed_living] => Array
(
[0] => 1338
)
[rets_sqft_total] => Array
(
[0] => 1413
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-08-03T08:45:27.927
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-08-03
)
[rets_street_name] => Array
(
[0] => Lumiauau
)
[rets_street_number] => Array
(
[0] => 94-752
)
[rets_street_view_param] => Array
(
[0] => 1$21.405867$-158.001952$110.62$13.33$1.00$uMXGVDnwPa8c-0gr5l0CaQ
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5
)
[rets_supplement_count] => Array
(
[0] => 5
)
[rets_supplement_modification_timestam] => Array
(
[0] => 2022-07-01T17:19:54.207
)
[rets_tax_amount] => Array
(
[0] => 182.93
)
[rets_tax_annual_amount] => Array
(
[0] => 2195.16
)
[rets_tax_assessed_value] => Array
(
[0] => 627200.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 227200.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 400000.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 0
)
[rets_tax_paid_by_seller_yn] => Array
(
[0] => 0
)
[rets_tax_year] => Array
(
[0] => 2022
)
[rets_thumbnail_url] => Array
(
[0] => https://cdn.rets.ci/marcusrealty-images/16731663/e536ecdd355cb24158209188595c5cbb
)
[rets_tmk_area] => Array
(
[0] => 194
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 66
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 47
)
[rets_tmk_section] => Array
(
[0] => 4
)
[rets_tmk_zone] => Array
(
[0] => 9
)
[rets_tmkplat] => Array
(
[0] => 7
)
[rets_unit_number] => Array
(
[0] => Z2
)
[rets_year_built] => Array
(
[0] => 1995
)
[security] => Array
(
[0] => Key
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Lumiauau
)
[street_number] => Array
(
[0] => 94-752
)
[street_suffix] => Array
(
[0] => Street
)
[terms_accept] => Array
(
[0] => Cash,Conventional,FHA,VA
)
[tmk] => Array
(
[0] => 1-9-4-007-047-0066
)
[unit] => Array
(
[0] => Even# Unit,Multi Level,Yard
)
[unit_number] => Array
(
[0] => Z2
)
[view] => Array
(
[0] => Golf Course
)
[wpp::rets_pk] => Array
(
[0] => 16731663
)
[wpp_gpid] => Array
(
[0] => 202212432
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1659552430
)
[year_built] => Array
(
[0] => 1995
)
[zoning] => Array
(
[0] => 05 - R-5 Residential District
)
[new_attached_media] => Array
(
[0] => a:231:{i:0;i:22571769;i:1;i:22571770;i:2;i:22571771;i:3;i:22571772;i:4;i:22571773;i:5;i:22571774;i:6;i:22571775;i:7;i:22571776;i:8;i:22571777;i:9;i:22571778;i:10;i:22571779;i:11;i:22571780;i:12;i:22571781;i:13;i:22571782;i:14;i:22571783;i:15;i:22571784;i:16;i:22571785;i:17;i:22571786;i:18;i:22571787;i:19;i:22571788;i:20;i:22571789;i:21;i:22583790;i:22;i:22583791;i:23;i:22583792;i:24;i:22583793;i:25;i:22583794;i:26;i:22583795;i:27;i:22583796;i:28;i:22583797;i:29;i:22583798;i:30;i:22583799;i:31;i:22583800;i:32;i:22583801;i:33;i:22583802;i:34;i:22583803;i:35;i:22583804;i:36;i:22583805;i:37;i:22583806;i:38;i:22583807;i:39;i:22583808;i:40;i:22583809;i:41;i:22583810;i:42;i:22584013;i:43;i:22584014;i:44;i:22584015;i:45;i:22584016;i:46;i:22584017;i:47;i:22584018;i:48;i:22584019;i:49;i:22584020;i:50;i:22584021;i:51;i:22584022;i:52;i:22584023;i:53;i:22584024;i:54;i:22584025;i:55;i:22584026;i:56;i:22584027;i:57;i:22584028;i:58;i:22584029;i:59;i:22584030;i:60;i:22584031;i:61;i:22584032;i:62;i:22584033;i:63;i:22585717;i:64;i:22585718;i:65;i:22585719;i:66;i:22585720;i:67;i:22585721;i:68;i:22585722;i:69;i:22585723;i:70;i:22585724;i:71;i:22585725;i:72;i:22585726;i:73;i:22585727;i:74;i:22585728;i:75;i:22585729;i:76;i:22585730;i:77;i:22585731;i:78;i:22585732;i:79;i:22585733;i:80;i:22585734;i:81;i:22585735;i:82;i:22585736;i:83;i:22585737;i:84;i:22587110;i:85;i:22587111;i:86;i:22587112;i:87;i:22587113;i:88;i:22587114;i:89;i:22587115;i:90;i:22587116;i:91;i:22587117;i:92;i:22587118;i:93;i:22587119;i:94;i:22587120;i:95;i:22587121;i:96;i:22587122;i:97;i:22587123;i:98;i:22587124;i:99;i:22587125;i:100;i:22587126;i:101;i:22587127;i:102;i:22587128;i:103;i:22587129;i:104;i:22587130;i:105;i:22603056;i:106;i:22603057;i:107;i:22603058;i:108;i:22603059;i:109;i:22603060;i:110;i:22603061;i:111;i:22603062;i:112;i:22603063;i:113;i:22603064;i:114;i:22603065;i:115;i:22603066;i:116;i:22603067;i:117;i:22603068;i:118;i:22603069;i:119;i:22603070;i:120;i:22603071;i:121;i:22603072;i:122;i:22603073;i:123;i:22603074;i:124;i:22603075;i:125;i:22603076;i:126;i:22609148;i:127;i:22609149;i:128;i:22609150;i:129;i:22609151;i:130;i:22609152;i:131;i:22609153;i:132;i:22609154;i:133;i:22609155;i:134;i:22609156;i:135;i:22609157;i:136;i:22609158;i:137;i:22609159;i:138;i:22609160;i:139;i:22609161;i:140;i:22609162;i:141;i:22609163;i:142;i:22609164;i:143;i:22609165;i:144;i:22609166;i:145;i:22609167;i:146;i:22609168;i:147;i:22619028;i:148;i:22619029;i:149;i:22619030;i:150;i:22619031;i:151;i:22619032;i:152;i:22619033;i:153;i:22619034;i:154;i:22619035;i:155;i:22619036;i:156;i:22619037;i:157;i:22619038;i:158;i:22619039;i:159;i:22619040;i:160;i:22619041;i:161;i:22619042;i:162;i:22619043;i:163;i:22619044;i:164;i:22619045;i:165;i:22619046;i:166;i:22619047;i:167;i:22619048;i:168;i:22620932;i:169;i:22620933;i:170;i:22620934;i:171;i:22620935;i:172;i:22620936;i:173;i:22620937;i:174;i:22620938;i:175;i:22620939;i:176;i:22620940;i:177;i:22620941;i:178;i:22620942;i:179;i:22620943;i:180;i:22620944;i:181;i:22620945;i:182;i:22620946;i:183;i:22620947;i:184;i:22620948;i:185;i:22620949;i:186;i:22620950;i:187;i:22620951;i:188;i:22620952;i:189;i:22846281;i:190;i:22846282;i:191;i:22846283;i:192;i:22846284;i:193;i:22846285;i:194;i:22846286;i:195;i:22846287;i:196;i:22846288;i:197;i:22846289;i:198;i:22846290;i:199;i:22846291;i:200;i:22846292;i:201;i:22846293;i:202;i:22846294;i:203;i:22846295;i:204;i:22846296;i:205;i:22846297;i:206;i:22846298;i:207;i:22846299;i:208;i:22846300;i:209;i:22846301;i:210;i:22931303;i:211;i:22931304;i:212;i:22931305;i:213;i:22931306;i:214;i:22931307;i:215;i:22931308;i:216;i:22931309;i:217;i:22931310;i:218;i:22931311;i:219;i:22931312;i:220;i:22931313;i:221;i:22931314;i:222;i:22931315;i:223;i:22931316;i:224;i:22931317;i:225;i:22931318;i:226;i:22931319;i:227;i:22931320;i:228;i:22931321;i:229;i:22931322;i:230;i:22931323;}
)
[rets_open_house_count] => Array
(
[0] => 2
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_open_house_upcoming] => Array
(
[0] =>
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-07-03
)
[rets_virtual_tour_url_unbranded] => Array
(
[0] => https://app.immoviewer.com/landing/unbranded/62c01315ca3e1e6db6c55447
)
[virtual_tour] => Array
(
[0] => https://app.immoviewer.com/landing/unbranded/62c01315ca3e1e6db6c55447
)
[rets_close_date] => Array
(
[0] => 2022-08-03
)
[rets_close_price] => Array
(
[0] => 700000.00
)
[rets_expiration_date] => Array
(
[0] => 2022-12-30
)
[rets_off_market_date] => Array
(
[0] => 2022-08-03
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 596-0456
)
[rets_selling_agent_email] => Array
(
[0] => jon@homesearchoahu.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Jonathan TL Pang
)
[rets_selling_agent_mlsid] => Array
(
[0] => 44001
)
[rets_selling_agent_mui] => Array
(
[0] => 8847257
)
[rets_selling_office_mlsid] => Array
(
[0] => CBPP
)
[rets_selling_office_mui] => Array
(
[0] => 3485212
)
[rets_selling_office_name] => Array
(
[0] => Coldwell Banker Realty
)
[rets_selling_office_phone] => Array
(
[0] => (808) 596-0456
)
[_thumbnail_id] => Array
(
[0] => 22931303
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446