This stunning and large home will check off all the boxes! Attention to details, completely renovated from top to bottom. Features 4 BR/2 BA upstairs + double family rooms,a huge lanai that opens up to ocean/mountain views everyday. An entire 1 BR/ 1BA +family room is situated downstairs ideal for the in-laws ,older children, home office,or maybe even rental. Upstair highlights w/ open beam ceiling which brings in natural lighting into the house and a gorgeous HUGE kitchen is situated below boasting quality Thermador built-in stainless steel appliances, granite countertop, and many storage solutions– keeping great cooks delightful. Split AC’s in every room keeps everyone cool. A garden oasis greets you outside to a soothing waterfall feature to make you feel you are in your own world -at home! Grassy backyard is lined with citrus fruits for your pickings & your own golf putting green adds to family fun time for sure. 26 Photovoltaic owned panels on coveted NEM agreement keeps energy cost low. Newtown Estate Rec Ctr down the street offers lap swimming pool, tennis/pickleball/basketball courts, gym, playground, and indoor classes year round for $35/mo assoc fee…what a deal!
Listing by: eXp Realty
array(157) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "215000.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "911200.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(10) "1126200.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "5"
}
["building_style"]=>
array(1) {
[0]=>
string(20) "Detach Single Family"
}
["city"]=>
array(1) {
[0]=>
string(4) "Aiea"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(24) "Property Disclosure Stmt"
}
["easements"]=>
array(1) {
[0]=>
string(4) "None"
}
["floor_covering"]=>
array(1) {
[0]=>
string(38) "Ceramic Tile,Laminate,Vinyl,W/W Carpet"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "3"
}
["furnished"]=>
array(1) {
[0]=>
string(7) "Partial"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["home_exampt"]=>
array(1) {
[0]=>
string(6) "100000"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(3) "192"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(7) "7090.00"
}
["land_recorded"]=>
array(1) {
[0]=>
string(12) "Dual Systems"
}
["land_tenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["list_agent_email"]=>
array(1) {
[0]=>
string(19) "suzie.mai@gmail.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(18) "Suzie T Mai-French"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 725-2794"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-03-29"
}
["list_office_name"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["list_price"]=>
array(1) {
[0]=>
string(10) "1525000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "2541"
}
["location"]=>
array(1) {
[0]=>
string(36) "98-1043 Oliwa Street, Aiea, HI 96701"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202205892"
}
["neighborhood"]=>
array(1) {
[0]=>
string(7) "NEWTOWN"
}
["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(4) "EXPI"
}
["parking_features"]=>
array(1) {
[0]=>
string(19) "2 Car,Garage,Street"
}
["pool_"]=>
array(1) {
[0]=>
string(26) "Community Association Pool"
}
["possession"]=>
array(1) {
[0]=>
string(26) "45 Days or Less,At Closing"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96701"
}
["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(9) "PearlCity"
}
["rets_association_community_name"]=>
array(1) {
[0]=>
string(15) "Newtown Estates"
}
["rets_association_phone"]=>
array(1) {
[0]=>
string(12) "808-487-3806"
}
["rets_baths_full"]=>
array(1) {
[0]=>
string(1) "3"
}
["rets_baths_half"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_baths_total"]=>
array(1) {
[0]=>
string(4) "3.00"
}
["rets_beds_total"]=>
array(1) {
[0]=>
string(1) "5"
}
["rets_city"]=>
array(1) {
[0]=>
string(4) "Aiea"
}
["rets_condo_property_regime_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(10) "1700000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(1) "7"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_foreclosure_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_fractional_ownership_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_id"]=>
array(1) {
[0]=>
string(8) "16535643"
}
["rets_immoviewer_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["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) 725-2794"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(19) "suzie.mai@gmail.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(18) "Suzie T Mai-French"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "29307"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "3478050"
}
["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(10) "1525000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-03-29"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(7) "7090.00"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-06-01T14:48:03.133"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16535643"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202205892"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(7) "NEWTOWN"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-03-29T14:18:26.810"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(10) "1525000.00"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-9-8-053-007-0000"
}
["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-03-29T21:15:24.690"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96701"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16535643"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(171) "First Open house: 4/3 @ 2-5pm
Please schedule in ShowingTime and home is vacant easy to show. Offers will be reviewed Monday 4/4, 7pm. Mahalo for your client's interest."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(1197) "This stunning and large home will check off all the boxes! Attention to details, completely renovated from top to bottom. Features 4 BR/2 BA upstairs + double family rooms,a huge lanai that opens up to ocean/mountain views everyday. An entire 1 BR/ 1BA +family room is situated downstairs ideal for the in-laws ,older children, home office,or maybe even rental. Upstair highlights w/ open beam ceiling which brings in natural lighting into the house and a gorgeous HUGE kitchen is situated below boasting quality Thermador built-in stainless steel appliances, granite countertop, and many storage solutions-- keeping great cooks delightful. Split AC's in every room keeps everyone cool. A garden oasis greets you outside to a soothing waterfall feature to make you feel you are in your own world -at home! Grassy backyard is lined with citrus fruits for your pickings & your own golf putting green adds to family fun time for sure. 26 Photovoltaic owned panels on coveted NEM agreement keeps energy cost low. Newtown Estate Rec Ctr down the street offers lap swimming pool, tennis/pickleball/basketball courts, gym, playground, and indoor classes year round for $35/mo assoc fee...what a deal!"
}
["rets_sqft_garage_carport"]=>
array(1) {
[0]=>
string(3) "578"
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(3) "192"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "2349"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "2541"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-01T14:48:03.133"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-06-01"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(5) "Oliwa"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(7) "98-1043"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(5) "2.25%"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "239.00"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "2868.00"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(10) "1126200.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "215000.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "911200.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(6) "100000"
}
["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/16535643/eb26d85a265a2c5d523d734cd41510e8"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "198"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_tmk_division"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tmk_parcel"]=>
array(1) {
[0]=>
string(1) "7"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "8"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "9"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(2) "53"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1973"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(4) "2017"
}
["setbacks"]=>
array(1) {
[0]=>
string(13) "C&C,Of Record"
}
["state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["street_name"]=>
array(1) {
[0]=>
string(5) "Oliwa"
}
["street_number"]=>
array(1) {
[0]=>
string(7) "98-1043"
}
["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-8-053-007-0000"
}
["topography"]=>
array(1) {
[0]=>
string(5) "Clear"
}
["view"]=>
array(1) {
[0]=>
string(21) "Garden,Mountain,Ocean"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16535643"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202205892"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1654130898"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1973"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "2017"
}
["zoning"]=>
array(1) {
[0]=>
string(29) "05 - R-5 Residential District"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(4675) "a:281:{i:0;i:21914122;i:1;i:21914123;i:2;i:21914124;i:3;i:21914125;i:4;i:21914126;i:5;i:21914127;i:6;i:21914128;i:7;i:21914129;i:8;i:21914130;i:9;i:21914131;i:10;i:21914132;i:11;i:21914133;i:12;i:21914134;i:13;i:21914135;i:14;i:21914136;i:15;i:21914137;i:16;i:21915897;i:17;i:21915898;i:18;i:21915899;i:19;i:21915900;i:20;i:21915901;i:21;i:21915902;i:22;i:21915903;i:23;i:21915904;i:24;i:21915905;i:25;i:21915906;i:26;i:21915907;i:27;i:21915908;i:28;i:21915909;i:29;i:21916019;i:30;i:21916020;i:31;i:21916021;i:32;i:21916022;i:33;i:21916023;i:34;i:21916024;i:35;i:21916025;i:36;i:21916026;i:37;i:21916027;i:38;i:21916028;i:39;i:21916029;i:40;i:21916030;i:41;i:21916031;i:42;i:21916032;i:43;i:21916033;i:44;i:21916034;i:45;i:21916035;i:46;i:21916036;i:47;i:21916037;i:48;i:21916038;i:49;i:21916039;i:50;i:21916110;i:51;i:21916111;i:52;i:21916112;i:53;i:21916113;i:54;i:21916114;i:55;i:21916115;i:56;i:21916116;i:57;i:21916117;i:58;i:21916118;i:59;i:21916119;i:60;i:21916120;i:61;i:21916121;i:62;i:21916122;i:63;i:21916123;i:64;i:21916124;i:65;i:21916125;i:66;i:21916126;i:67;i:21916127;i:68;i:21916128;i:69;i:21916129;i:70;i:21916130;i:71;i:21916167;i:72;i:21916168;i:73;i:21916169;i:74;i:21916170;i:75;i:21916171;i:76;i:21916172;i:77;i:21916173;i:78;i:21916174;i:79;i:21916175;i:80;i:21916176;i:81;i:21916177;i:82;i:21916178;i:83;i:21916179;i:84;i:21916180;i:85;i:21916181;i:86;i:21916182;i:87;i:21916183;i:88;i:21916184;i:89;i:21916185;i:90;i:21916186;i:91;i:21916187;i:92;i:21916200;i:93;i:21916201;i:94;i:21916202;i:95;i:21916203;i:96;i:21916204;i:97;i:21916205;i:98;i:21916206;i:99;i:21916207;i:100;i:21916208;i:101;i:21916209;i:102;i:21916210;i:103;i:21916211;i:104;i:21916212;i:105;i:21916213;i:106;i:21916214;i:107;i:21916215;i:108;i:21916216;i:109;i:21916217;i:110;i:21916218;i:111;i:21916219;i:112;i:21916220;i:113;i:21919496;i:114;i:21919497;i:115;i:21919498;i:116;i:21919499;i:117;i:21919500;i:118;i:21919501;i:119;i:21919502;i:120;i:21919503;i:121;i:21919504;i:122;i:21919505;i:123;i:21919506;i:124;i:21919507;i:125;i:21919508;i:126;i:21919509;i:127;i:21919510;i:128;i:21919511;i:129;i:21919512;i:130;i:21919513;i:131;i:21919514;i:132;i:21919515;i:133;i:21919516;i:134;i:21919811;i:135;i:21919812;i:136;i:21919813;i:137;i:21919814;i:138;i:21919815;i:139;i:21919816;i:140;i:21919817;i:141;i:21919818;i:142;i:21919819;i:143;i:21919820;i:144;i:21919821;i:145;i:21919822;i:146;i:21919823;i:147;i:21919824;i:148;i:21919825;i:149;i:21919826;i:150;i:21919827;i:151;i:21919828;i:152;i:21919829;i:153;i:21919830;i:154;i:21919831;i:155;i:21919896;i:156;i:21919897;i:157;i:21919898;i:158;i:21919899;i:159;i:21919900;i:160;i:21919901;i:161;i:21919902;i:162;i:21919903;i:163;i:21919904;i:164;i:21919905;i:165;i:21919906;i:166;i:21919907;i:167;i:21919908;i:168;i:21919909;i:169;i:21919910;i:170;i:21919911;i:171;i:21919912;i:172;i:21919913;i:173;i:21919914;i:174;i:21919915;i:175;i:21919916;i:176;i:21920254;i:177;i:21920255;i:178;i:21920256;i:179;i:21920257;i:180;i:21920258;i:181;i:21920259;i:182;i:21920260;i:183;i:21920261;i:184;i:21920262;i:185;i:21920263;i:186;i:21920264;i:187;i:21920265;i:188;i:21920266;i:189;i:21920267;i:190;i:21920268;i:191;i:21920269;i:192;i:21920270;i:193;i:21920271;i:194;i:21920272;i:195;i:21920273;i:196;i:21920274;i:197;i:21940629;i:198;i:21940630;i:199;i:21940631;i:200;i:21940632;i:201;i:21940633;i:202;i:21940634;i:203;i:21940635;i:204;i:21940636;i:205;i:21940637;i:206;i:21940638;i:207;i:21940639;i:208;i:21940640;i:209;i:21940641;i:210;i:21940642;i:211;i:21940643;i:212;i:21940644;i:213;i:21940645;i:214;i:21940646;i:215;i:21940647;i:216;i:21940648;i:217;i:21940649;i:218;i:21956905;i:219;i:21956906;i:220;i:21956907;i:221;i:21956908;i:222;i:21956909;i:223;i:21956910;i:224;i:21956911;i:225;i:21956912;i:226;i:21956913;i:227;i:21956914;i:228;i:21956915;i:229;i:21956916;i:230;i:21956917;i:231;i:21956918;i:232;i:21956919;i:233;i:21956920;i:234;i:21956921;i:235;i:21956922;i:236;i:21956923;i:237;i:21956924;i:238;i:21956925;i:239;i:21960690;i:240;i:21960691;i:241;i:21960692;i:242;i:21960693;i:243;i:21960694;i:244;i:21960695;i:245;i:21960696;i:246;i:21960697;i:247;i:21960698;i:248;i:21960699;i:249;i:21960700;i:250;i:21960701;i:251;i:21960702;i:252;i:21960703;i:253;i:21960704;i:254;i:21960705;i:255;i:21960706;i:256;i:21960707;i:257;i:21960708;i:258;i:21960709;i:259;i:21960710;i:260;i:22343314;i:261;i:22343315;i:262;i:22343316;i:263;i:22343317;i:264;i:22343318;i:265;i:22343319;i:266;i:22343320;i:267;i:22343321;i:268;i:22343322;i:269;i:22343323;i:270;i:22343324;i:271;i:22343325;i:272;i:22343326;i:273;i:22343327;i:274;i:22343328;i:275;i:22343329;i:276;i:22343330;i:277;i:22343331;i:278;i:22343332;i:279;i:22343333;i:280;i:22343334;}"
}
["rets_open_house_count"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_active_open_house_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_open_house_upcoming"]=>
array(1) {
[0]=>
string(0) ""
}
["assn_fee_inclusions"]=>
array(1) {
[0]=>
string(2) "35"
}
["association_fees"]=>
array(1) {
[0]=>
string(2) "35"
}
["rets_association_fee"]=>
array(1) {
[0]=>
string(2) "35"
}
["rets_association_fee_total"]=>
array(1) {
[0]=>
string(2) "35"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-04-05"
}
["rets_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(69) "https://app.immoviewer.com/landing/unbranded/624d7df03877c24748c167ce"
}
["virtual_tour"]=>
array(1) {
[0]=>
string(69) "https://app.immoviewer.com/landing/unbranded/624d7df03877c24748c167ce"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-06-01"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(10) "1700000.00"
}
["rets_concessions"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-09-29"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-06-01"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 738-3600"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(23) "BrettA@BetterHawaii.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(11) "Brett K Aka"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "44367"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "9057047"
}
["rets_selling_agent_remarks"]=>
array(1) {
[0]=>
string(28) "Nice working with you Brett!"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "ADVG"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(7) "9695164"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 738-3600"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "22343314"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 215000.00
)
[assd_val_land] => Array
(
[0] => 911200.00
)
[assd_val_total] => Array
(
[0] => 1126200.00
)
[bedrooms] => Array
(
[0] => 5
)
[building_style] => Array
(
[0] => Detach Single Family
)
[city] => Array
(
[0] => Aiea
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Property Disclosure Stmt
)
[easements] => Array
(
[0] => None
)
[floor_covering] => Array
(
[0] => Ceramic Tile,Laminate,Vinyl,W/W Carpet
)
[full_baths] => Array
(
[0] => 3
)
[furnished] => Array
(
[0] => Partial
)
[half_baths] => Array
(
[0] => 0
)
[home_exampt] => Array
(
[0] => 100000
)
[lanai_sf] => Array
(
[0] => 192
)
[land_area_sf] => Array
(
[0] => 7090.00
)
[land_recorded] => Array
(
[0] => Dual Systems
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => suzie.mai@gmail.com
)
[list_agent_name] => Array
(
[0] => Suzie T Mai-French
)
[list_agent_phone_number] => Array
(
[0] => (808) 725-2794
)
[list_date] => Array
(
[0] => 2022-03-29
)
[list_office_name] => Array
(
[0] => eXp Realty
)
[list_price] => Array
(
[0] => 1525000.00
)
[living_sf] => Array
(
[0] => 2541
)
[location] => Array
(
[0] => 98-1043 Oliwa Street, Aiea, HI 96701
)
[mls_] => Array
(
[0] => 202205892
)
[neighborhood] => Array
(
[0] => NEWTOWN
)
[number_of_parking_spaces] => Array
(
[0] => 2
)
[number_of_stories] => Array
(
[0] => Two
)
[office_mls_id] => Array
(
[0] => EXPI
)
[parking_features] => Array
(
[0] => 2 Car,Garage,Street
)
[pool_] => Array
(
[0] => Community Association Pool
)
[possession] => Array
(
[0] => 45 Days or Less,At Closing
)
[postal_code] => Array
(
[0] => 96701
)
[property_condition] => Array
(
[0] => Excellent
)
[property_type] => Array
(
[0] => single_family
)
[property_type_label] => Array
(
[0] => single_family
)
[region] => Array
(
[0] => PearlCity
)
[rets_association_community_name] => Array
(
[0] => Newtown Estates
)
[rets_association_phone] => Array
(
[0] => 808-487-3806
)
[rets_baths_full] => Array
(
[0] => 3
)
[rets_baths_half] => Array
(
[0] => 0
)
[rets_baths_total] => Array
(
[0] => 3.00
)
[rets_beds_total] => Array
(
[0] => 5
)
[rets_city] => Array
(
[0] => Aiea
)
[rets_condo_property_regime_yn] => Array
(
[0] => 0
)
[rets_current_price] => Array
(
[0] => 1700000.00
)
[rets_dom] => Array
(
[0] => 7
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_id] => Array
(
[0] => 16535643
)
[rets_immoviewer_yn] => Array
(
[0] => 1
)
[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) 725-2794
)
[rets_list_agent_email] => Array
(
[0] => suzie.mai@gmail.com
)
[rets_list_agent_full_name] => Array
(
[0] => Suzie T Mai-French
)
[rets_list_agent_mlsid] => Array
(
[0] => 29307
)
[rets_list_agent_mui] => Array
(
[0] => 3478050
)
[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] => 1525000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-03-29
)
[rets_lot_size_area] => Array
(
[0] => 7090.00
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-06-01T14:48:03.133
)
[rets_matrix_unique_id] => Array
(
[0] => 16535643
)
[rets_mls_number] => Array
(
[0] => 202205892
)
[rets_neighbourhood] => Array
(
[0] => NEWTOWN
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-03-29T14:18:26.810
)
[rets_original_list_price] => Array
(
[0] => 1525000.00
)
[rets_parcel_number] => Array
(
[0] => 1-9-8-053-007-0000
)
[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-03-29T21:15:24.690
)
[rets_postal_code] => Array
(
[0] => 96701
)
[rets_primary_key] => Array
(
[0] => 16535643
)
[rets_private_remarks] => Array
(
[0] => First Open house: 4/3 @ 2-5pm
Please schedule in ShowingTime and home is vacant easy to show. Offers will be reviewed Monday 4/4, 7pm. Mahalo for your client's interest.
)
[rets_public_remarks] => Array
(
[0] => This stunning and large home will check off all the boxes! Attention to details, completely renovated from top to bottom. Features 4 BR/2 BA upstairs + double family rooms,a huge lanai that opens up to ocean/mountain views everyday. An entire 1 BR/ 1BA +family room is situated downstairs ideal for the in-laws ,older children, home office,or maybe even rental. Upstair highlights w/ open beam ceiling which brings in natural lighting into the house and a gorgeous HUGE kitchen is situated below boasting quality Thermador built-in stainless steel appliances, granite countertop, and many storage solutions-- keeping great cooks delightful. Split AC's in every room keeps everyone cool. A garden oasis greets you outside to a soothing waterfall feature to make you feel you are in your own world -at home! Grassy backyard is lined with citrus fruits for your pickings & your own golf putting green adds to family fun time for sure. 26 Photovoltaic owned panels on coveted NEM agreement keeps energy cost low. Newtown Estate Rec Ctr down the street offers lap swimming pool, tennis/pickleball/basketball courts, gym, playground, and indoor classes year round for $35/mo assoc fee...what a deal!
)
[rets_sqft_garage_carport] => Array
(
[0] => 578
)
[rets_sqft_lanai_open] => Array
(
[0] => 192
)
[rets_sqft_roofed_living] => Array
(
[0] => 2349
)
[rets_sqft_total] => Array
(
[0] => 2541
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-06-01T14:48:03.133
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-06-01
)
[rets_street_name] => Array
(
[0] => Oliwa
)
[rets_street_number] => Array
(
[0] => 98-1043
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.25%
)
[rets_tax_amount] => Array
(
[0] => 239.00
)
[rets_tax_annual_amount] => Array
(
[0] => 2868.00
)
[rets_tax_assessed_value] => Array
(
[0] => 1126200.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 215000.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 911200.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 100000
)
[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/16535643/eb26d85a265a2c5d523d734cd41510e8
)
[rets_tmk_area] => Array
(
[0] => 198
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 0
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 7
)
[rets_tmk_section] => Array
(
[0] => 8
)
[rets_tmk_zone] => Array
(
[0] => 9
)
[rets_tmkplat] => Array
(
[0] => 53
)
[rets_year_built] => Array
(
[0] => 1973
)
[rets_year_remodeled] => Array
(
[0] => 2017
)
[setbacks] => Array
(
[0] => C&C,Of Record
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Oliwa
)
[street_number] => Array
(
[0] => 98-1043
)
[street_suffix] => Array
(
[0] => Street
)
[terms_accept] => Array
(
[0] => Cash,Conventional,VA
)
[tmk] => Array
(
[0] => 1-9-8-053-007-0000
)
[topography] => Array
(
[0] => Clear
)
[view] => Array
(
[0] => Garden,Mountain,Ocean
)
[wpp::rets_pk] => Array
(
[0] => 16535643
)
[wpp_gpid] => Array
(
[0] => 202205892
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1654130898
)
[year_built] => Array
(
[0] => 1973
)
[year_remodeled_] => Array
(
[0] => 2017
)
[zoning] => Array
(
[0] => 05 - R-5 Residential District
)
[new_attached_media] => Array
(
[0] => a:281:{i:0;i:21914122;i:1;i:21914123;i:2;i:21914124;i:3;i:21914125;i:4;i:21914126;i:5;i:21914127;i:6;i:21914128;i:7;i:21914129;i:8;i:21914130;i:9;i:21914131;i:10;i:21914132;i:11;i:21914133;i:12;i:21914134;i:13;i:21914135;i:14;i:21914136;i:15;i:21914137;i:16;i:21915897;i:17;i:21915898;i:18;i:21915899;i:19;i:21915900;i:20;i:21915901;i:21;i:21915902;i:22;i:21915903;i:23;i:21915904;i:24;i:21915905;i:25;i:21915906;i:26;i:21915907;i:27;i:21915908;i:28;i:21915909;i:29;i:21916019;i:30;i:21916020;i:31;i:21916021;i:32;i:21916022;i:33;i:21916023;i:34;i:21916024;i:35;i:21916025;i:36;i:21916026;i:37;i:21916027;i:38;i:21916028;i:39;i:21916029;i:40;i:21916030;i:41;i:21916031;i:42;i:21916032;i:43;i:21916033;i:44;i:21916034;i:45;i:21916035;i:46;i:21916036;i:47;i:21916037;i:48;i:21916038;i:49;i:21916039;i:50;i:21916110;i:51;i:21916111;i:52;i:21916112;i:53;i:21916113;i:54;i:21916114;i:55;i:21916115;i:56;i:21916116;i:57;i:21916117;i:58;i:21916118;i:59;i:21916119;i:60;i:21916120;i:61;i:21916121;i:62;i:21916122;i:63;i:21916123;i:64;i:21916124;i:65;i:21916125;i:66;i:21916126;i:67;i:21916127;i:68;i:21916128;i:69;i:21916129;i:70;i:21916130;i:71;i:21916167;i:72;i:21916168;i:73;i:21916169;i:74;i:21916170;i:75;i:21916171;i:76;i:21916172;i:77;i:21916173;i:78;i:21916174;i:79;i:21916175;i:80;i:21916176;i:81;i:21916177;i:82;i:21916178;i:83;i:21916179;i:84;i:21916180;i:85;i:21916181;i:86;i:21916182;i:87;i:21916183;i:88;i:21916184;i:89;i:21916185;i:90;i:21916186;i:91;i:21916187;i:92;i:21916200;i:93;i:21916201;i:94;i:21916202;i:95;i:21916203;i:96;i:21916204;i:97;i:21916205;i:98;i:21916206;i:99;i:21916207;i:100;i:21916208;i:101;i:21916209;i:102;i:21916210;i:103;i:21916211;i:104;i:21916212;i:105;i:21916213;i:106;i:21916214;i:107;i:21916215;i:108;i:21916216;i:109;i:21916217;i:110;i:21916218;i:111;i:21916219;i:112;i:21916220;i:113;i:21919496;i:114;i:21919497;i:115;i:21919498;i:116;i:21919499;i:117;i:21919500;i:118;i:21919501;i:119;i:21919502;i:120;i:21919503;i:121;i:21919504;i:122;i:21919505;i:123;i:21919506;i:124;i:21919507;i:125;i:21919508;i:126;i:21919509;i:127;i:21919510;i:128;i:21919511;i:129;i:21919512;i:130;i:21919513;i:131;i:21919514;i:132;i:21919515;i:133;i:21919516;i:134;i:21919811;i:135;i:21919812;i:136;i:21919813;i:137;i:21919814;i:138;i:21919815;i:139;i:21919816;i:140;i:21919817;i:141;i:21919818;i:142;i:21919819;i:143;i:21919820;i:144;i:21919821;i:145;i:21919822;i:146;i:21919823;i:147;i:21919824;i:148;i:21919825;i:149;i:21919826;i:150;i:21919827;i:151;i:21919828;i:152;i:21919829;i:153;i:21919830;i:154;i:21919831;i:155;i:21919896;i:156;i:21919897;i:157;i:21919898;i:158;i:21919899;i:159;i:21919900;i:160;i:21919901;i:161;i:21919902;i:162;i:21919903;i:163;i:21919904;i:164;i:21919905;i:165;i:21919906;i:166;i:21919907;i:167;i:21919908;i:168;i:21919909;i:169;i:21919910;i:170;i:21919911;i:171;i:21919912;i:172;i:21919913;i:173;i:21919914;i:174;i:21919915;i:175;i:21919916;i:176;i:21920254;i:177;i:21920255;i:178;i:21920256;i:179;i:21920257;i:180;i:21920258;i:181;i:21920259;i:182;i:21920260;i:183;i:21920261;i:184;i:21920262;i:185;i:21920263;i:186;i:21920264;i:187;i:21920265;i:188;i:21920266;i:189;i:21920267;i:190;i:21920268;i:191;i:21920269;i:192;i:21920270;i:193;i:21920271;i:194;i:21920272;i:195;i:21920273;i:196;i:21920274;i:197;i:21940629;i:198;i:21940630;i:199;i:21940631;i:200;i:21940632;i:201;i:21940633;i:202;i:21940634;i:203;i:21940635;i:204;i:21940636;i:205;i:21940637;i:206;i:21940638;i:207;i:21940639;i:208;i:21940640;i:209;i:21940641;i:210;i:21940642;i:211;i:21940643;i:212;i:21940644;i:213;i:21940645;i:214;i:21940646;i:215;i:21940647;i:216;i:21940648;i:217;i:21940649;i:218;i:21956905;i:219;i:21956906;i:220;i:21956907;i:221;i:21956908;i:222;i:21956909;i:223;i:21956910;i:224;i:21956911;i:225;i:21956912;i:226;i:21956913;i:227;i:21956914;i:228;i:21956915;i:229;i:21956916;i:230;i:21956917;i:231;i:21956918;i:232;i:21956919;i:233;i:21956920;i:234;i:21956921;i:235;i:21956922;i:236;i:21956923;i:237;i:21956924;i:238;i:21956925;i:239;i:21960690;i:240;i:21960691;i:241;i:21960692;i:242;i:21960693;i:243;i:21960694;i:244;i:21960695;i:245;i:21960696;i:246;i:21960697;i:247;i:21960698;i:248;i:21960699;i:249;i:21960700;i:250;i:21960701;i:251;i:21960702;i:252;i:21960703;i:253;i:21960704;i:254;i:21960705;i:255;i:21960706;i:256;i:21960707;i:257;i:21960708;i:258;i:21960709;i:259;i:21960710;i:260;i:22343314;i:261;i:22343315;i:262;i:22343316;i:263;i:22343317;i:264;i:22343318;i:265;i:22343319;i:266;i:22343320;i:267;i:22343321;i:268;i:22343322;i:269;i:22343323;i:270;i:22343324;i:271;i:22343325;i:272;i:22343326;i:273;i:22343327;i:274;i:22343328;i:275;i:22343329;i:276;i:22343330;i:277;i:22343331;i:278;i:22343332;i:279;i:22343333;i:280;i:22343334;}
)
[rets_open_house_count] => Array
(
[0] => 1
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_open_house_upcoming] => Array
(
[0] =>
)
[assn_fee_inclusions] => Array
(
[0] => 35
)
[association_fees] => Array
(
[0] => 35
)
[rets_association_fee] => Array
(
[0] => 35
)
[rets_association_fee_total] => Array
(
[0] => 35
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-04-05
)
[rets_virtual_tour_url_unbranded] => Array
(
[0] => https://app.immoviewer.com/landing/unbranded/624d7df03877c24748c167ce
)
[virtual_tour] => Array
(
[0] => https://app.immoviewer.com/landing/unbranded/624d7df03877c24748c167ce
)
[rets_close_date] => Array
(
[0] => 2022-06-01
)
[rets_close_price] => Array
(
[0] => 1700000.00
)
[rets_concessions] => Array
(
[0] => 0
)
[rets_expiration_date] => Array
(
[0] => 2022-09-29
)
[rets_off_market_date] => Array
(
[0] => 2022-06-01
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 738-3600
)
[rets_selling_agent_email] => Array
(
[0] => BrettA@BetterHawaii.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Brett K Aka
)
[rets_selling_agent_mlsid] => Array
(
[0] => 44367
)
[rets_selling_agent_mui] => Array
(
[0] => 9057047
)
[rets_selling_agent_remarks] => Array
(
[0] => Nice working with you Brett!
)
[rets_selling_office_mlsid] => Array
(
[0] => ADVG
)
[rets_selling_office_mui] => Array
(
[0] => 9695164
)
[rets_selling_office_name] => Array
(
[0] => BHGRE Advantage Realty
)
[rets_selling_office_phone] => Array
(
[0] => (808) 738-3600
)
[_thumbnail_id] => Array
(
[0] => 22343314
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446