Excellent location near Waikele shopping center. Amazing views of the ocean and mountains. This well constructed single family home has great amenities which includes terraced yard, BBQ area, Basketball court, zen garden and vegetable garden.
You will love moon-viewing and evening sunsets from the upper terraced yards and gaze the distant lights of Pearl Harbor and town!
The Chef inspired kitchen has an amazing commercial grade 8 burner double range gas oven (fit for a Chef), quartz countertop island, solid wood cabinets, and a full sized pantry with upright freezer. Other features include 27 owned photovoltaic solar panels, 4 Split A/C units, Solar Water Heater, oversized 100 gallon master bathtub, private office, freshly painted exterior, 2 car garage, no HOA fees, and so much more! This home is located east of Waikele, closer to Waipio Gentry. This one is a “can’t miss” schedule a showing today. Single family home for the price of a Town home right in the middle of Oahu location…. location…. location!
array(162) { ["assd_val_imprv"]=> array(1) { [0]=> string(9) "301700.00" } ["assd_val_land"]=> array(1) { [0]=> string(9) "426900.00" } ["assd_val_total"]=> array(1) { [0]=> string(9) "728600.00" } ["bedrooms"]=> array(1) { [0]=> string(1) "3" } ["building_style"]=> array(1) { [0]=> string(12) "Attached,CPR" } ["city"]=> array(1) { [0]=> string(7) "Waipahu" } ["county"]=> array(1) { [0]=> string(4) "Oahu" } ["disclosures"]=> array(1) { [0]=> string(24) "Property Disclosure Stmt" } ["easements"]=> array(1) { [0]=> string(4) "None" } ["elementary_school"]=> array(1) { [0]=> string(9) "Kanoelani" } ["floor_covering"]=> array(1) { [0]=> string(27) "Ceramic Tile,Laminate,Other" } ["frontage"]=> array(1) { [0]=> string(5) "Other" } ["full_baths"]=> array(1) { [0]=> string(1) "2" } ["furnished"]=> array(1) { [0]=> string(4) "None" } ["half_baths"]=> array(1) { [0]=> string(1) "1" } ["high_school"]=> array(1) { [0]=> string(10) "Pearl City" } ["home_exampt"]=> array(1) { [0]=> string(1) "0" } ["land_area_sf"]=> array(1) { [0]=> string(7) "7270.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(26) "kailuaproperties@yahoo.com" } ["list_agent_name"]=> array(1) { [0]=> string(12) "Tarlok Singh" } ["list_agent_phone_number"]=> array(1) { [0]=> string(14) "(808) 732-1414" } ["list_date"]=> array(1) { [0]=> string(10) "2022-03-11" } ["list_office_name"]=> array(1) { [0]=> string(22) "Coldwell Banker Realty" } ["list_price"]=> array(1) { [0]=> string(9) "999888.00" } ["living_sf"]=> array(1) { [0]=> string(4) "1918" } ["location"]=> array(1) { [0]=> string(49) "94-1102 Lumipolu Street Unit B, Waipahu, HI 96797" } ["middle_school"]=> array(1) { [0]=> string(9) "Highlands" } ["mls_"]=> array(1) { [0]=> string(9) "202203910" } ["neighborhood"]=> array(1) { [0]=> string(7) "SEAVIEW" } ["number_of_parking_spaces"]=> array(1) { [0]=> string(1) "2" } ["number_of_stories"]=> array(1) { [0]=> string(3) "Two" } ["office_mls_id"]=> array(1) { [0]=> string(6) "CBPP02" } ["parking_features"]=> array(1) { [0]=> string(28) "2 Car,Driveway,Garage,Street" } ["pool_"]=> array(1) { [0]=> string(4) "None" } ["possession"]=> array(1) { [0]=> string(10) "At Closing" } ["postal_code"]=> array(1) { [0]=> string(5) "96797" } ["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) "Waipahu" } ["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_city"]=> array(1) { [0]=> string(7) "Waipahu" } ["rets_condo_property_regime_yn"]=> array(1) { [0]=> string(1) "1" } ["rets_current_price"]=> array(1) { [0]=> string(10) "1010000.00" } ["rets_dom"]=> array(1) { [0]=> string(2) "68" } ["rets_dual_variable_compensation_yn"]=> array(1) { [0]=> string(1) "0" } ["rets_elementary_school"]=> array(1) { [0]=> string(9) "Kanoelani" } ["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(10) "Pearl City" } ["rets_id"]=> array(1) { [0]=> string(8) "16475315" } ["rets_immoviewer_yn"]=> array(1) { [0]=> string(1) "1" } ["rets_list_agent_direct_work_phone"]=> array(1) { [0]=> string(14) "(808) 732-1414" } ["rets_list_agent_email"]=> array(1) { [0]=> string(26) "kailuaproperties@yahoo.com" } ["rets_list_agent_full_name"]=> array(1) { [0]=> string(12) "Tarlok Singh" } ["rets_list_agent_mlsid"]=> array(1) { [0]=> string(5) "28097" } ["rets_list_agent_mui"]=> array(1) { [0]=> string(7) "3477540" } ["rets_list_office_mlsid"]=> array(1) { [0]=> string(6) "CBPP02" } ["rets_list_office_mui"]=> array(1) { [0]=> string(7) "3485238" } ["rets_list_office_name"]=> array(1) { [0]=> string(22) "Coldwell Banker Realty" } ["rets_list_office_phone"]=> array(1) { [0]=> string(14) "(808) 732-1414" } ["rets_list_price"]=> array(1) { [0]=> string(9) "999888.00" } ["rets_listing_contract_date"]=> array(1) { [0]=> string(10) "2022-03-11" } ["rets_lot_size_area"]=> array(1) { [0]=> string(7) "7270.00" } ["rets_matrix_modified_dt"]=> array(1) { [0]=> string(23) "2022-06-17T16:46:11.453" } ["rets_matrix_unique_id"]=> array(1) { [0]=> string(8) "16475315" } ["rets_middle_or_junior_school"]=> array(1) { [0]=> string(9) "Highlands" } ["rets_mls_number"]=> array(1) { [0]=> string(9) "202203910" } ["rets_neighbourhood"]=> array(1) { [0]=> string(7) "SEAVIEW" } ["rets_new_development_construction_yn"]=> array(1) { [0]=> string(1) "0" } ["rets_original_entry_timestamp"]=> array(1) { [0]=> string(23) "2022-03-14T15:51:09.733" } ["rets_original_list_price"]=> array(1) { [0]=> string(10) "1125000.00" } ["rets_parcel_number"]=> array(1) { [0]=> string(18) "1-9-4-057-045-0002" } ["rets_parking_total"]=> array(1) { [0]=> string(1) "2" } ["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-05-04T17:25:07.603" } ["rets_postal_code"]=> array(1) { [0]=> string(5) "96797" } ["rets_price_change_timestamp"]=> array(1) { [0]=> string(23) "2022-05-04T15:04:30.987" } ["rets_primary_key"]=> array(1) { [0]=> string(8) "16475315" } ["rets_private_remarks"]=> array(1) { [0]=> string(65) "Vacant easy to see email listing agent with all showing requests." } ["rets_public_remarks"]=> array(1) { [0]=> string(1032) "Excellent location near Waikele shopping center. Amazing views of the ocean and mountains. This well constructed single family home has great amenities which includes terraced yard, BBQ area, Basketball court, zen garden and vegetable garden. You will love moon-viewing and evening sunsets from the upper terraced yards and gaze the distant lights of Pearl Harbor and town! The Chef inspired kitchen has an amazing commercial grade 8 burner double range gas oven (fit for a Chef), quartz countertop island, solid wood cabinets, and a full sized pantry with upright freezer. Other features include 27 owned photovoltaic solar panels, 4 Split A/C units, Solar Water Heater, oversized 100 gallon master bathtub, private office, freshly painted exterior, 2 car garage, no HOA fees, and so much more! This home is located east of Waikele, closer to Waipio Gentry. This one is a “can’t miss” schedule a showing today. Single family home for the price of a Town home right in the middle of Oahu location.... location.... location!" } ["rets_room_count"]=> array(1) { [0]=> string(1) "0" } ["rets_sqft_roofed_living"]=> array(1) { [0]=> string(4) "1918" } ["rets_sqft_total"]=> array(1) { [0]=> string(4) "1918" } ["rets_state_or_province"]=> array(1) { [0]=> string(2) "HI" } ["rets_status_change_timestamp"]=> array(1) { [0]=> string(23) "2022-06-17T16:46:11.453" } ["rets_status_contractual_search_date"]=> array(1) { [0]=> string(10) "2022-06-17" } ["rets_street_name"]=> array(1) { [0]=> string(8) "Lumipolu" } ["rets_street_number"]=> array(1) { [0]=> string(7) "94-1102" } ["rets_street_view_param"]=> array(1) { [0]=> string(64) "1$21.405597$-157.991363$239.45$13.33$1.00$tVPKT4BSbXwQOIJ9EaXglQ" } ["rets_sub_agency_compensation"]=> array(1) { [0]=> string(3) "2.5" } ["rets_tax_amount"]=> array(1) { [0]=> string(6) "214.00" } ["rets_tax_annual_amount"]=> array(1) { [0]=> string(7) "2568.00" } ["rets_tax_assessed_value"]=> array(1) { [0]=> string(9) "728600.00" } ["rets_tax_assessed_value_improvements"]=> array(1) { [0]=> string(9) "301700.00" } ["rets_tax_assessed_value_land"]=> array(1) { [0]=> string(9) "426900.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/16475315/1d7ac2047d4ba1ec33b14835fd70cc2a" } ["rets_tmk_area"]=> array(1) { [0]=> string(3) "194" } ["rets_tmk_condo_property_regime_number"]=> array(1) { [0]=> string(1) "2" } ["rets_tmk_division"]=> array(1) { [0]=> string(1) "1" } ["rets_tmk_parcel"]=> array(1) { [0]=> string(2) "45" } ["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) "57" } ["rets_unit_number"]=> array(1) { [0]=> string(1) "B" } ["rets_year_built"]=> array(1) { [0]=> string(4) "1992" } ["security"]=> array(1) { [0]=> string(3) "Key" } ["setbacks"]=> array(1) { [0]=> string(3) "C&C" } ["state_or_province"]=> array(1) { [0]=> string(2) "HI" } ["status"]=> array(1) { [0]=> string(4) "Sold" } ["street_name"]=> array(1) { [0]=> string(8) "Lumipolu" } ["street_number"]=> array(1) { [0]=> string(7) "94-1102" } ["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-057-045-0002" } ["topography"]=> array(1) { [0]=> string(5) "Other" } ["unit_number"]=> array(1) { [0]=> string(1) "B" } ["view"]=> array(1) { [0]=> string(10) "City,Other" } ["wpp::rets_pk"]=> array(1) { [0]=> string(8) "16475315" } ["wpp_gpid"]=> array(1) { [0]=> string(9) "202203910" } ["wpp_import_schedule_id"]=> array(1) { [0]=> string(10) "1463343682" } ["wpp_import_time"]=> array(1) { [0]=> string(10) "1655520404" } ["year_built"]=> array(1) { [0]=> string(4) "1992" } ["zoning"]=> array(1) { [0]=> string(29) "05 - R-5 Residential District" } ["new_attached_media"]=> array(1) { [0]=> string(7038) "a:420:{i:0;i:21819159;i:1;i:21819160;i:2;i:21819161;i:3;i:21819162;i:4;i:21819163;i:5;i:21819164;i:6;i:21819165;i:7;i:21819166;i:8;i:21819167;i:9;i:21819168;i:10;i:21819169;i:11;i:21819170;i:12;i:21819171;i:13;i:21819172;i:14;i:21819173;i:15;i:21819174;i:16;i:21819175;i:17;i:21819176;i:18;i:21819177;i:19;i:21819178;i:20;i:21819179;i:21;i:21851298;i:22;i:21851299;i:23;i:21851300;i:24;i:21851301;i:25;i:21851302;i:26;i:21851303;i:27;i:21851304;i:28;i:21851305;i:29;i:21851306;i:30;i:21851307;i:31;i:21851308;i:32;i:21851309;i:33;i:21851310;i:34;i:21851311;i:35;i:21851312;i:36;i:21851313;i:37;i:21851314;i:38;i:21851315;i:39;i:21851316;i:40;i:21851317;i:41;i:21851318;i:42;i:21863050;i:43;i:21863051;i:44;i:21863052;i:45;i:21863053;i:46;i:21863054;i:47;i:21863055;i:48;i:21863056;i:49;i:21863057;i:50;i:21863058;i:51;i:21863059;i:52;i:21863060;i:53;i:21863061;i:54;i:21863062;i:55;i:21863063;i:56;i:21863064;i:57;i:21863065;i:58;i:21863066;i:59;i:21863067;i:60;i:21863068;i:61;i:21863069;i:62;i:21863070;i:63;i:21872087;i:64;i:21872088;i:65;i:21872089;i:66;i:21872090;i:67;i:21872091;i:68;i:21872092;i:69;i:21872093;i:70;i:21872094;i:71;i:21872095;i:72;i:21872096;i:73;i:21872097;i:74;i:21872098;i:75;i:21872099;i:76;i:21872100;i:77;i:21872101;i:78;i:21872102;i:79;i:21872103;i:80;i:21872104;i:81;i:21872105;i:82;i:21872106;i:83;i:21872107;i:84;i:21897616;i:85;i:21897617;i:86;i:21897618;i:87;i:21897619;i:88;i:21897620;i:89;i:21897621;i:90;i:21897622;i:91;i:21897623;i:92;i:21897624;i:93;i:21897625;i:94;i:21897626;i:95;i:21897627;i:96;i:21897628;i:97;i:21897629;i:98;i:21897630;i:99;i:21897631;i:100;i:21897632;i:101;i:21897633;i:102;i:21897634;i:103;i:21897635;i:104;i:21897636;i:105;i:21897637;i:106;i:21897638;i:107;i:21897639;i:108;i:21897640;i:109;i:21897641;i:110;i:21897642;i:111;i:21897643;i:112;i:21897644;i:113;i:21897645;i:114;i:21897646;i:115;i:21897647;i:116;i:21897648;i:117;i:21897649;i:118;i:21897650;i:119;i:21897651;i:120;i:21897652;i:121;i:21897653;i:122;i:21897654;i:123;i:21897655;i:124;i:21897656;i:125;i:21897657;i:126;i:21921088;i:127;i:21921089;i:128;i:21921090;i:129;i:21921091;i:130;i:21921092;i:131;i:21921093;i:132;i:21921094;i:133;i:21921095;i:134;i:21921096;i:135;i:21921097;i:136;i:21921098;i:137;i:21921099;i:138;i:21921100;i:139;i:21921101;i:140;i:21921102;i:141;i:21921103;i:142;i:21921104;i:143;i:21921105;i:144;i:21921106;i:145;i:21921107;i:146;i:21921108;i:147;i:22026060;i:148;i:22026061;i:149;i:22026062;i:150;i:22026063;i:151;i:22026064;i:152;i:22026065;i:153;i:22026066;i:154;i:22026067;i:155;i:22026068;i:156;i:22026069;i:157;i:22026070;i:158;i:22026071;i:159;i:22026072;i:160;i:22026073;i:161;i:22026074;i:162;i:22026075;i:163;i:22026076;i:164;i:22026077;i:165;i:22026078;i:166;i:22026079;i:167;i:22026080;i:168;i:22032041;i:169;i:22032042;i:170;i:22032043;i:171;i:22032044;i:172;i:22032045;i:173;i:22032046;i:174;i:22032047;i:175;i:22032048;i:176;i:22032049;i:177;i:22032050;i:178;i:22032051;i:179;i:22032052;i:180;i:22032053;i:181;i:22032054;i:182;i:22032055;i:183;i:22032056;i:184;i:22032057;i:185;i:22032058;i:186;i:22032059;i:187;i:22032060;i:188;i:22032061;i:189;i:22077568;i:190;i:22077569;i:191;i:22077570;i:192;i:22077571;i:193;i:22077572;i:194;i:22077573;i:195;i:22077574;i:196;i:22077575;i:197;i:22077576;i:198;i:22077577;i:199;i:22077578;i:200;i:22077579;i:201;i:22077580;i:202;i:22077581;i:203;i:22077582;i:204;i:22077583;i:205;i:22077584;i:206;i:22077585;i:207;i:22077586;i:208;i:22077587;i:209;i:22077588;i:210;i:22155770;i:211;i:22155771;i:212;i:22155772;i:213;i:22155773;i:214;i:22155774;i:215;i:22155775;i:216;i:22155776;i:217;i:22155777;i:218;i:22155778;i:219;i:22155779;i:220;i:22155780;i:221;i:22155781;i:222;i:22155782;i:223;i:22155783;i:224;i:22155784;i:225;i:22155785;i:226;i:22155786;i:227;i:22155787;i:228;i:22155788;i:229;i:22155789;i:230;i:22155790;i:231;i:22157044;i:232;i:22157045;i:233;i:22157046;i:234;i:22157047;i:235;i:22157048;i:236;i:22157049;i:237;i:22157050;i:238;i:22157051;i:239;i:22157052;i:240;i:22157053;i:241;i:22157054;i:242;i:22157055;i:243;i:22157056;i:244;i:22157057;i:245;i:22157058;i:246;i:22157059;i:247;i:22157060;i:248;i:22157061;i:249;i:22157062;i:250;i:22157063;i:251;i:22157064;i:252;i:22157080;i:253;i:22157081;i:254;i:22157082;i:255;i:22157083;i:256;i:22157084;i:257;i:22157085;i:258;i:22157086;i:259;i:22157087;i:260;i:22157088;i:261;i:22157089;i:262;i:22157090;i:263;i:22157091;i:264;i:22157092;i:265;i:22157093;i:266;i:22157094;i:267;i:22157095;i:268;i:22157096;i:269;i:22157097;i:270;i:22157098;i:271;i:22157099;i:272;i:22157100;i:273;i:22157156;i:274;i:22157157;i:275;i:22157158;i:276;i:22157159;i:277;i:22157160;i:278;i:22157161;i:279;i:22157162;i:280;i:22157163;i:281;i:22157164;i:282;i:22157165;i:283;i:22157166;i:284;i:22157167;i:285;i:22157168;i:286;i:22157169;i:287;i:22157170;i:288;i:22157171;i:289;i:22157172;i:290;i:22157173;i:291;i:22157174;i:292;i:22157175;i:293;i:22157176;i:294;i:22157229;i:295;i:22157230;i:296;i:22157231;i:297;i:22157232;i:298;i:22157233;i:299;i:22157234;i:300;i:22157235;i:301;i:22157236;i:302;i:22157237;i:303;i:22157238;i:304;i:22157239;i:305;i:22157240;i:306;i:22157241;i:307;i:22157242;i:308;i:22157243;i:309;i:22157244;i:310;i:22157245;i:311;i:22157246;i:312;i:22157247;i:313;i:22157248;i:314;i:22157249;i:315;i:22157276;i:316;i:22157277;i:317;i:22157278;i:318;i:22157279;i:319;i:22157280;i:320;i:22157281;i:321;i:22157282;i:322;i:22157283;i:323;i:22157284;i:324;i:22157285;i:325;i:22157286;i:326;i:22157287;i:327;i:22157288;i:328;i:22157289;i:329;i:22157290;i:330;i:22157291;i:331;i:22157292;i:332;i:22157293;i:333;i:22157294;i:334;i:22157295;i:335;i:22157296;i:336;i:22208748;i:337;i:22208749;i:338;i:22208750;i:339;i:22208751;i:340;i:22208752;i:341;i:22208753;i:342;i:22208754;i:343;i:22208755;i:344;i:22208756;i:345;i:22208757;i:346;i:22208758;i:347;i:22208759;i:348;i:22208760;i:349;i:22208761;i:350;i:22208762;i:351;i:22208763;i:352;i:22208764;i:353;i:22208765;i:354;i:22208766;i:355;i:22208767;i:356;i:22208768;i:357;i:22250412;i:358;i:22250413;i:359;i:22250414;i:360;i:22250415;i:361;i:22250416;i:362;i:22250417;i:363;i:22250418;i:364;i:22250419;i:365;i:22250420;i:366;i:22250421;i:367;i:22250422;i:368;i:22250423;i:369;i:22250424;i:370;i:22250425;i:371;i:22250426;i:372;i:22250427;i:373;i:22250428;i:374;i:22250429;i:375;i:22250430;i:376;i:22250431;i:377;i:22250432;i:378;i:22469119;i:379;i:22469120;i:380;i:22469121;i:381;i:22469122;i:382;i:22469123;i:383;i:22469124;i:384;i:22469125;i:385;i:22469126;i:386;i:22469127;i:387;i:22469128;i:388;i:22469129;i:389;i:22469130;i:390;i:22469131;i:391;i:22469132;i:392;i:22469133;i:393;i:22469134;i:394;i:22469135;i:395;i:22469136;i:396;i:22469137;i:397;i:22469138;i:398;i:22469139;i:399;i:22469163;i:400;i:22469164;i:401;i:22469165;i:402;i:22469166;i:403;i:22469167;i:404;i:22469168;i:405;i:22469169;i:406;i:22469170;i:407;i:22469171;i:408;i:22469172;i:409;i:22469173;i:410;i:22469174;i:411;i:22469175;i:412;i:22469176;i:413;i:22469177;i:414;i:22469178;i:415;i:22469179;i:416;i:22469180;i:417;i:22469181;i:418;i:22469182;i:419;i:22469183;}" } ["rets_open_house_count"]=> array(1) { [0]=> string(1) "6" } ["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-05-17" } ["rets_close_date"]=> array(1) { [0]=> string(10) "2022-06-17" } ["rets_close_price"]=> array(1) { [0]=> string(10) "1010000.00" } ["rets_co_selling_agent_direct_work_pho"]=> array(1) { [0]=> string(14) "(808) 487-1561" } ["rets_co_selling_agent_email"]=> array(1) { [0]=> string(21) "jennyguasch@yahoo.com" } ["rets_co_selling_agent_full_name"]=> array(1) { [0]=> string(17) "Jennifer G Guasch" } ["rets_co_selling_agent_mlsid"]=> array(1) { [0]=> string(5) "25292" } ["rets_co_selling_agent_mui"]=> array(1) { [0]=> string(7) "3475296" } ["rets_co_selling_office_mlsid"]=> array(1) { [0]=> string(4) "HRTA" } ["rets_co_selling_office_mui"]=> array(1) { [0]=> string(7) "3487777" } ["rets_co_selling_office_name"]=> array(1) { [0]=> string(17) "Horita Realty LLC" } ["rets_co_selling_office_phone"]=> array(1) { [0]=> string(14) "(808) 487-1561" } ["rets_expiration_date"]=> array(1) { [0]=> string(10) "2023-03-03" } ["rets_off_market_date"]=> array(1) { [0]=> string(10) "2022-06-17" } ["rets_selling_agent_direct_work_phone"]=> array(1) { [0]=> string(14) "(808) 487-1561" } ["rets_selling_agent_email"]=> array(1) { [0]=> string(24) "lisanakamura99@gmail.com" } ["rets_selling_agent_full_name"]=> array(1) { [0]=> string(13) "Lisa Nakamura" } ["rets_selling_agent_mlsid"]=> array(1) { [0]=> string(5) "36321" } ["rets_selling_agent_mui"]=> array(1) { [0]=> string(7) "3480883" } ["rets_selling_office_mlsid"]=> array(1) { [0]=> string(4) "HRTA" } ["rets_selling_office_mui"]=> array(1) { [0]=> string(7) "3487777" } ["rets_selling_office_name"]=> array(1) { [0]=> string(17) "Horita Realty LLC" } ["rets_selling_office_phone"]=> array(1) { [0]=> string(14) "(808) 487-1561" } ["_thumbnail_id"]=> array(1) { [0]=> string(8) "22469163" } } Array ( [assd_val_imprv] => Array ( [0] => 301700.00 ) [assd_val_land] => Array ( [0] => 426900.00 ) [assd_val_total] => Array ( [0] => 728600.00 ) [bedrooms] => Array ( [0] => 3 ) [building_style] => Array ( [0] => Attached,CPR ) [city] => Array ( [0] => Waipahu ) [county] => Array ( [0] => Oahu ) [disclosures] => Array ( [0] => Property Disclosure Stmt ) [easements] => Array ( [0] => None ) [elementary_school] => Array ( [0] => Kanoelani ) [floor_covering] => Array ( [0] => Ceramic Tile,Laminate,Other ) [frontage] => Array ( [0] => Other ) [full_baths] => Array ( [0] => 2 ) [furnished] => Array ( [0] => None ) [half_baths] => Array ( [0] => 1 ) [high_school] => Array ( [0] => Pearl City ) [home_exampt] => Array ( [0] => 0 ) [land_area_sf] => Array ( [0] => 7270.00 ) [land_recorded] => Array ( [0] => Land Court ) [land_tenure] => Array ( [0] => FS - Fee Simple ) [list_agent_email] => Array ( [0] => kailuaproperties@yahoo.com ) [list_agent_name] => Array ( [0] => Tarlok Singh ) [list_agent_phone_number] => Array ( [0] => (808) 732-1414 ) [list_date] => Array ( [0] => 2022-03-11 ) [list_office_name] => Array ( [0] => Coldwell Banker Realty ) [list_price] => Array ( [0] => 999888.00 ) [living_sf] => Array ( [0] => 1918 ) [location] => Array ( [0] => 94-1102 Lumipolu Street Unit B, Waipahu, HI 96797 ) [middle_school] => Array ( [0] => Highlands ) [mls_] => Array ( [0] => 202203910 ) [neighborhood] => Array ( [0] => SEAVIEW ) [number_of_parking_spaces] => Array ( [0] => 2 ) [number_of_stories] => Array ( [0] => Two ) [office_mls_id] => Array ( [0] => CBPP02 ) [parking_features] => Array ( [0] => 2 Car,Driveway,Garage,Street ) [pool_] => Array ( [0] => None ) [possession] => Array ( [0] => At Closing ) [postal_code] => Array ( [0] => 96797 ) [property_condition] => Array ( [0] => Excellent ) [property_type] => Array ( [0] => single_family ) [property_type_label] => Array ( [0] => single_family ) [region] => Array ( [0] => Waipahu ) [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_city] => Array ( [0] => Waipahu ) [rets_condo_property_regime_yn] => Array ( [0] => 1 ) [rets_current_price] => Array ( [0] => 1010000.00 ) [rets_dom] => Array ( [0] => 68 ) [rets_dual_variable_compensation_yn] => Array ( [0] => 0 ) [rets_elementary_school] => Array ( [0] => Kanoelani ) [rets_foreclosure_yn] => Array ( [0] => 0 ) [rets_fractional_ownership_yn] => Array ( [0] => 0 ) [rets_high_school] => Array ( [0] => Pearl City ) [rets_id] => Array ( [0] => 16475315 ) [rets_immoviewer_yn] => Array ( [0] => 1 ) [rets_list_agent_direct_work_phone] => Array ( [0] => (808) 732-1414 ) [rets_list_agent_email] => Array ( [0] => kailuaproperties@yahoo.com ) [rets_list_agent_full_name] => Array ( [0] => Tarlok Singh ) [rets_list_agent_mlsid] => Array ( [0] => 28097 ) [rets_list_agent_mui] => Array ( [0] => 3477540 ) [rets_list_office_mlsid] => Array ( [0] => CBPP02 ) [rets_list_office_mui] => Array ( [0] => 3485238 ) [rets_list_office_name] => Array ( [0] => Coldwell Banker Realty ) [rets_list_office_phone] => Array ( [0] => (808) 732-1414 ) [rets_list_price] => Array ( [0] => 999888.00 ) [rets_listing_contract_date] => Array ( [0] => 2022-03-11 ) [rets_lot_size_area] => Array ( [0] => 7270.00 ) [rets_matrix_modified_dt] => Array ( [0] => 2022-06-17T16:46:11.453 ) [rets_matrix_unique_id] => Array ( [0] => 16475315 ) [rets_middle_or_junior_school] => Array ( [0] => Highlands ) [rets_mls_number] => Array ( [0] => 202203910 ) [rets_neighbourhood] => Array ( [0] => SEAVIEW ) [rets_new_development_construction_yn] => Array ( [0] => 0 ) [rets_original_entry_timestamp] => Array ( [0] => 2022-03-14T15:51:09.733 ) [rets_original_list_price] => Array ( [0] => 1125000.00 ) [rets_parcel_number] => Array ( [0] => 1-9-4-057-045-0002 ) [rets_parking_total] => Array ( [0] => 2 ) [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-05-04T17:25:07.603 ) [rets_postal_code] => Array ( [0] => 96797 ) [rets_price_change_timestamp] => Array ( [0] => 2022-05-04T15:04:30.987 ) [rets_primary_key] => Array ( [0] => 16475315 ) [rets_private_remarks] => Array ( [0] => Vacant easy to see email listing agent with all showing requests. ) [rets_public_remarks] => Array ( [0] => Excellent location near Waikele shopping center. Amazing views of the ocean and mountains. This well constructed single family home has great amenities which includes terraced yard, BBQ area, Basketball court, zen garden and vegetable garden. You will love moon-viewing and evening sunsets from the upper terraced yards and gaze the distant lights of Pearl Harbor and town! The Chef inspired kitchen has an amazing commercial grade 8 burner double range gas oven (fit for a Chef), quartz countertop island, solid wood cabinets, and a full sized pantry with upright freezer. Other features include 27 owned photovoltaic solar panels, 4 Split A/C units, Solar Water Heater, oversized 100 gallon master bathtub, private office, freshly painted exterior, 2 car garage, no HOA fees, and so much more! This home is located east of Waikele, closer to Waipio Gentry. This one is a “can’t miss” schedule a showing today. Single family home for the price of a Town home right in the middle of Oahu location.... location.... location! ) [rets_room_count] => Array ( [0] => 0 ) [rets_sqft_roofed_living] => Array ( [0] => 1918 ) [rets_sqft_total] => Array ( [0] => 1918 ) [rets_state_or_province] => Array ( [0] => HI ) [rets_status_change_timestamp] => Array ( [0] => 2022-06-17T16:46:11.453 ) [rets_status_contractual_search_date] => Array ( [0] => 2022-06-17 ) [rets_street_name] => Array ( [0] => Lumipolu ) [rets_street_number] => Array ( [0] => 94-1102 ) [rets_street_view_param] => Array ( [0] => 1$21.405597$-157.991363$239.45$13.33$1.00$tVPKT4BSbXwQOIJ9EaXglQ ) [rets_sub_agency_compensation] => Array ( [0] => 2.5 ) [rets_tax_amount] => Array ( [0] => 214.00 ) [rets_tax_annual_amount] => Array ( [0] => 2568.00 ) [rets_tax_assessed_value] => Array ( [0] => 728600.00 ) [rets_tax_assessed_value_improvements] => Array ( [0] => 301700.00 ) [rets_tax_assessed_value_land] => Array ( [0] => 426900.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/16475315/1d7ac2047d4ba1ec33b14835fd70cc2a ) [rets_tmk_area] => Array ( [0] => 194 ) [rets_tmk_condo_property_regime_number] => Array ( [0] => 2 ) [rets_tmk_division] => Array ( [0] => 1 ) [rets_tmk_parcel] => Array ( [0] => 45 ) [rets_tmk_section] => Array ( [0] => 4 ) [rets_tmk_zone] => Array ( [0] => 9 ) [rets_tmkplat] => Array ( [0] => 57 ) [rets_unit_number] => Array ( [0] => B ) [rets_year_built] => Array ( [0] => 1992 ) [security] => Array ( [0] => Key ) [setbacks] => Array ( [0] => C&C ) [state_or_province] => Array ( [0] => HI ) [status] => Array ( [0] => Sold ) [street_name] => Array ( [0] => Lumipolu ) [street_number] => Array ( [0] => 94-1102 ) [street_suffix] => Array ( [0] => Street ) [terms_accept] => Array ( [0] => Cash,Conventional,VA ) [tmk] => Array ( [0] => 1-9-4-057-045-0002 ) [topography] => Array ( [0] => Other ) [unit_number] => Array ( [0] => B ) [view] => Array ( [0] => City,Other ) [wpp::rets_pk] => Array ( [0] => 16475315 ) [wpp_gpid] => Array ( [0] => 202203910 ) [wpp_import_schedule_id] => Array ( [0] => 1463343682 ) [wpp_import_time] => Array ( [0] => 1655520404 ) [year_built] => Array ( [0] => 1992 ) [zoning] => Array ( [0] => 05 - R-5 Residential District ) [new_attached_media] => Array ( [0] => a:420:{i:0;i:21819159;i:1;i:21819160;i:2;i:21819161;i:3;i:21819162;i:4;i:21819163;i:5;i:21819164;i:6;i:21819165;i:7;i:21819166;i:8;i:21819167;i:9;i:21819168;i:10;i:21819169;i:11;i:21819170;i:12;i:21819171;i:13;i:21819172;i:14;i:21819173;i:15;i:21819174;i:16;i:21819175;i:17;i:21819176;i:18;i:21819177;i:19;i:21819178;i:20;i:21819179;i:21;i:21851298;i:22;i:21851299;i:23;i:21851300;i:24;i:21851301;i:25;i:21851302;i:26;i:21851303;i:27;i:21851304;i:28;i:21851305;i:29;i:21851306;i:30;i:21851307;i:31;i:21851308;i:32;i:21851309;i:33;i:21851310;i:34;i:21851311;i:35;i:21851312;i:36;i:21851313;i:37;i:21851314;i:38;i:21851315;i:39;i:21851316;i:40;i:21851317;i:41;i:21851318;i:42;i:21863050;i:43;i:21863051;i:44;i:21863052;i:45;i:21863053;i:46;i:21863054;i:47;i:21863055;i:48;i:21863056;i:49;i:21863057;i:50;i:21863058;i:51;i:21863059;i:52;i:21863060;i:53;i:21863061;i:54;i:21863062;i:55;i:21863063;i:56;i:21863064;i:57;i:21863065;i:58;i:21863066;i:59;i:21863067;i:60;i:21863068;i:61;i:21863069;i:62;i:21863070;i:63;i:21872087;i:64;i:21872088;i:65;i:21872089;i:66;i:21872090;i:67;i:21872091;i:68;i:21872092;i:69;i:21872093;i:70;i:21872094;i:71;i:21872095;i:72;i:21872096;i:73;i:21872097;i:74;i:21872098;i:75;i:21872099;i:76;i:21872100;i:77;i:21872101;i:78;i:21872102;i:79;i:21872103;i:80;i:21872104;i:81;i:21872105;i:82;i:21872106;i:83;i:21872107;i:84;i:21897616;i:85;i:21897617;i:86;i:21897618;i:87;i:21897619;i:88;i:21897620;i:89;i:21897621;i:90;i:21897622;i:91;i:21897623;i:92;i:21897624;i:93;i:21897625;i:94;i:21897626;i:95;i:21897627;i:96;i:21897628;i:97;i:21897629;i:98;i:21897630;i:99;i:21897631;i:100;i:21897632;i:101;i:21897633;i:102;i:21897634;i:103;i:21897635;i:104;i:21897636;i:105;i:21897637;i:106;i:21897638;i:107;i:21897639;i:108;i:21897640;i:109;i:21897641;i:110;i:21897642;i:111;i:21897643;i:112;i:21897644;i:113;i:21897645;i:114;i:21897646;i:115;i:21897647;i:116;i:21897648;i:117;i:21897649;i:118;i:21897650;i:119;i:21897651;i:120;i:21897652;i:121;i:21897653;i:122;i:21897654;i:123;i:21897655;i:124;i:21897656;i:125;i:21897657;i:126;i:21921088;i:127;i:21921089;i:128;i:21921090;i:129;i:21921091;i:130;i:21921092;i:131;i:21921093;i:132;i:21921094;i:133;i:21921095;i:134;i:21921096;i:135;i:21921097;i:136;i:21921098;i:137;i:21921099;i:138;i:21921100;i:139;i:21921101;i:140;i:21921102;i:141;i:21921103;i:142;i:21921104;i:143;i:21921105;i:144;i:21921106;i:145;i:21921107;i:146;i:21921108;i:147;i:22026060;i:148;i:22026061;i:149;i:22026062;i:150;i:22026063;i:151;i:22026064;i:152;i:22026065;i:153;i:22026066;i:154;i:22026067;i:155;i:22026068;i:156;i:22026069;i:157;i:22026070;i:158;i:22026071;i:159;i:22026072;i:160;i:22026073;i:161;i:22026074;i:162;i:22026075;i:163;i:22026076;i:164;i:22026077;i:165;i:22026078;i:166;i:22026079;i:167;i:22026080;i:168;i:22032041;i:169;i:22032042;i:170;i:22032043;i:171;i:22032044;i:172;i:22032045;i:173;i:22032046;i:174;i:22032047;i:175;i:22032048;i:176;i:22032049;i:177;i:22032050;i:178;i:22032051;i:179;i:22032052;i:180;i:22032053;i:181;i:22032054;i:182;i:22032055;i:183;i:22032056;i:184;i:22032057;i:185;i:22032058;i:186;i:22032059;i:187;i:22032060;i:188;i:22032061;i:189;i:22077568;i:190;i:22077569;i:191;i:22077570;i:192;i:22077571;i:193;i:22077572;i:194;i:22077573;i:195;i:22077574;i:196;i:22077575;i:197;i:22077576;i:198;i:22077577;i:199;i:22077578;i:200;i:22077579;i:201;i:22077580;i:202;i:22077581;i:203;i:22077582;i:204;i:22077583;i:205;i:22077584;i:206;i:22077585;i:207;i:22077586;i:208;i:22077587;i:209;i:22077588;i:210;i:22155770;i:211;i:22155771;i:212;i:22155772;i:213;i:22155773;i:214;i:22155774;i:215;i:22155775;i:216;i:22155776;i:217;i:22155777;i:218;i:22155778;i:219;i:22155779;i:220;i:22155780;i:221;i:22155781;i:222;i:22155782;i:223;i:22155783;i:224;i:22155784;i:225;i:22155785;i:226;i:22155786;i:227;i:22155787;i:228;i:22155788;i:229;i:22155789;i:230;i:22155790;i:231;i:22157044;i:232;i:22157045;i:233;i:22157046;i:234;i:22157047;i:235;i:22157048;i:236;i:22157049;i:237;i:22157050;i:238;i:22157051;i:239;i:22157052;i:240;i:22157053;i:241;i:22157054;i:242;i:22157055;i:243;i:22157056;i:244;i:22157057;i:245;i:22157058;i:246;i:22157059;i:247;i:22157060;i:248;i:22157061;i:249;i:22157062;i:250;i:22157063;i:251;i:22157064;i:252;i:22157080;i:253;i:22157081;i:254;i:22157082;i:255;i:22157083;i:256;i:22157084;i:257;i:22157085;i:258;i:22157086;i:259;i:22157087;i:260;i:22157088;i:261;i:22157089;i:262;i:22157090;i:263;i:22157091;i:264;i:22157092;i:265;i:22157093;i:266;i:22157094;i:267;i:22157095;i:268;i:22157096;i:269;i:22157097;i:270;i:22157098;i:271;i:22157099;i:272;i:22157100;i:273;i:22157156;i:274;i:22157157;i:275;i:22157158;i:276;i:22157159;i:277;i:22157160;i:278;i:22157161;i:279;i:22157162;i:280;i:22157163;i:281;i:22157164;i:282;i:22157165;i:283;i:22157166;i:284;i:22157167;i:285;i:22157168;i:286;i:22157169;i:287;i:22157170;i:288;i:22157171;i:289;i:22157172;i:290;i:22157173;i:291;i:22157174;i:292;i:22157175;i:293;i:22157176;i:294;i:22157229;i:295;i:22157230;i:296;i:22157231;i:297;i:22157232;i:298;i:22157233;i:299;i:22157234;i:300;i:22157235;i:301;i:22157236;i:302;i:22157237;i:303;i:22157238;i:304;i:22157239;i:305;i:22157240;i:306;i:22157241;i:307;i:22157242;i:308;i:22157243;i:309;i:22157244;i:310;i:22157245;i:311;i:22157246;i:312;i:22157247;i:313;i:22157248;i:314;i:22157249;i:315;i:22157276;i:316;i:22157277;i:317;i:22157278;i:318;i:22157279;i:319;i:22157280;i:320;i:22157281;i:321;i:22157282;i:322;i:22157283;i:323;i:22157284;i:324;i:22157285;i:325;i:22157286;i:326;i:22157287;i:327;i:22157288;i:328;i:22157289;i:329;i:22157290;i:330;i:22157291;i:331;i:22157292;i:332;i:22157293;i:333;i:22157294;i:334;i:22157295;i:335;i:22157296;i:336;i:22208748;i:337;i:22208749;i:338;i:22208750;i:339;i:22208751;i:340;i:22208752;i:341;i:22208753;i:342;i:22208754;i:343;i:22208755;i:344;i:22208756;i:345;i:22208757;i:346;i:22208758;i:347;i:22208759;i:348;i:22208760;i:349;i:22208761;i:350;i:22208762;i:351;i:22208763;i:352;i:22208764;i:353;i:22208765;i:354;i:22208766;i:355;i:22208767;i:356;i:22208768;i:357;i:22250412;i:358;i:22250413;i:359;i:22250414;i:360;i:22250415;i:361;i:22250416;i:362;i:22250417;i:363;i:22250418;i:364;i:22250419;i:365;i:22250420;i:366;i:22250421;i:367;i:22250422;i:368;i:22250423;i:369;i:22250424;i:370;i:22250425;i:371;i:22250426;i:372;i:22250427;i:373;i:22250428;i:374;i:22250429;i:375;i:22250430;i:376;i:22250431;i:377;i:22250432;i:378;i:22469119;i:379;i:22469120;i:380;i:22469121;i:381;i:22469122;i:382;i:22469123;i:383;i:22469124;i:384;i:22469125;i:385;i:22469126;i:386;i:22469127;i:387;i:22469128;i:388;i:22469129;i:389;i:22469130;i:390;i:22469131;i:391;i:22469132;i:392;i:22469133;i:393;i:22469134;i:394;i:22469135;i:395;i:22469136;i:396;i:22469137;i:397;i:22469138;i:398;i:22469139;i:399;i:22469163;i:400;i:22469164;i:401;i:22469165;i:402;i:22469166;i:403;i:22469167;i:404;i:22469168;i:405;i:22469169;i:406;i:22469170;i:407;i:22469171;i:408;i:22469172;i:409;i:22469173;i:410;i:22469174;i:411;i:22469175;i:412;i:22469176;i:413;i:22469177;i:414;i:22469178;i:415;i:22469179;i:416;i:22469180;i:417;i:22469181;i:418;i:22469182;i:419;i:22469183;} ) [rets_open_house_count] => Array ( [0] => 6 ) [rets_active_open_house_count] => Array ( [0] => 0 ) [rets_open_house_upcoming] => Array ( [0] => ) [rets_active_continue_to_show_date] => Array ( [0] => 2022-05-17 ) [rets_close_date] => Array ( [0] => 2022-06-17 ) [rets_close_price] => Array ( [0] => 1010000.00 ) [rets_co_selling_agent_direct_work_pho] => Array ( [0] => (808) 487-1561 ) [rets_co_selling_agent_email] => Array ( [0] => jennyguasch@yahoo.com ) [rets_co_selling_agent_full_name] => Array ( [0] => Jennifer G Guasch ) [rets_co_selling_agent_mlsid] => Array ( [0] => 25292 ) [rets_co_selling_agent_mui] => Array ( [0] => 3475296 ) [rets_co_selling_office_mlsid] => Array ( [0] => HRTA ) [rets_co_selling_office_mui] => Array ( [0] => 3487777 ) [rets_co_selling_office_name] => Array ( [0] => Horita Realty LLC ) [rets_co_selling_office_phone] => Array ( [0] => (808) 487-1561 ) [rets_expiration_date] => Array ( [0] => 2023-03-03 ) [rets_off_market_date] => Array ( [0] => 2022-06-17 ) [rets_selling_agent_direct_work_phone] => Array ( [0] => (808) 487-1561 ) [rets_selling_agent_email] => Array ( [0] => lisanakamura99@gmail.com ) [rets_selling_agent_full_name] => Array ( [0] => Lisa Nakamura ) [rets_selling_agent_mlsid] => Array ( [0] => 36321 ) [rets_selling_agent_mui] => Array ( [0] => 3480883 ) [rets_selling_office_mlsid] => Array ( [0] => HRTA ) [rets_selling_office_mui] => Array ( [0] => 3487777 ) [rets_selling_office_name] => Array ( [0] => Horita Realty LLC ) [rets_selling_office_phone] => Array ( [0] => (808) 487-1561 ) [_thumbnail_id] => Array ( [0] => 22469163 ) )
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446