PRICE REDUCED! RARELY AVAILABLE PROPERTY WITH 3 SEPARATE LIVING AREAS at Whitmore Village. A total of 7 bedroom, 3 bath. Perfect for extended family with a potential rentals to supplement a mortgage. (Front Right) 3bed/2bath, (Front Left) 2 bed/1 bath, (Back) 2 bed/1bath with laundry area and nice spacious back yard. Close to Wheeler Army, Schofield and North Shore. Include As-Is, LBP Disclosure and Pre approval letter with all offers. Tenants are in a month-to-month tenancy but would like to stay. The number of bedroom/square footage of the home differs from the building department and/or tax assessors records. Buyer to do their own due diligence before close of escrow.
Listing by: Team Real Estate, Inc.
array(156) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "205500.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "427700.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "633200.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "7"
}
["building_style"]=>
array(1) {
[0]=>
string(51) "Attached,Detach Single Family,Duplex,Ohana Dwelling"
}
["city"]=>
array(1) {
[0]=>
string(7) "Wahiawa"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(52) "Pet on Property,Property Disclosure Stmt,See Remarks"
}
["easements"]=>
array(1) {
[0]=>
string(4) "None"
}
["elementary_school"]=>
array(1) {
[0]=>
string(8) "Helemano"
}
["floor_covering"]=>
array(1) {
[0]=>
string(27) "Ceramic Tile,Laminate,Vinyl"
}
["frontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "4"
}
["furnished"]=>
array(1) {
[0]=>
string(4) "None"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["high_school"]=>
array(1) {
[0]=>
string(8) "Leilehua"
}
["home_exampt"]=>
array(1) {
[0]=>
string(4) "0.00"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(3) "362"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(7) "6383.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(23) "teresaabella8@gmail.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(21) "Maria Teresa M Abella"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 637-3507"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-04-11"
}
["list_office_name"]=>
array(1) {
[0]=>
string(22) "Team Real Estate, Inc."
}
["list_price"]=>
array(1) {
[0]=>
string(9) "799999.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "1806"
}
["location"]=>
array(1) {
[0]=>
string(37) "1050 Aheahe Avenue, Wahiawa, HI 96786"
}
["middle_school"]=>
array(1) {
[0]=>
string(7) "Wahiawa"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202206923"
}
["neighborhood"]=>
array(1) {
[0]=>
string(16) "WHITMORE VILLAGE"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "4"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(3) "One"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "TEAM"
}
["parking_features"]=>
array(1) {
[0]=>
string(30) "3 Car+,Carport,Driveway,Street"
}
["pool_"]=>
array(1) {
[0]=>
string(4) "None"
}
["possession"]=>
array(1) {
[0]=>
string(39) "45 Days or Less,Subject to Rental Lease"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96786"
}
["property_condition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["property_type"]=>
array(1) {
[0]=>
string(13) "single_family"
}
["property_type_label"]=>
array(1) {
[0]=>
string(13) "single_family"
}
["region"]=>
array(1) {
[0]=>
string(7) "Central"
}
["rets_baths_full"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_baths_half"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_baths_total"]=>
array(1) {
[0]=>
string(4) "4.00"
}
["rets_beds_total"]=>
array(1) {
[0]=>
string(1) "7"
}
["rets_city"]=>
array(1) {
[0]=>
string(7) "Wahiawa"
}
["rets_condo_property_regime_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(9) "770000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(2) "25"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_elementary_school"]=>
array(1) {
[0]=>
string(8) "Helemano"
}
["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(8) "Leilehua"
}
["rets_id"]=>
array(1) {
[0]=>
string(8) "16561473"
}
["rets_immoviewer_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_internet_automated_valuation_dis"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_internet_consumer_comment_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 637-3507"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(23) "teresaabella8@gmail.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(21) "Maria Teresa M Abella"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "37572"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "3481340"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "TEAM"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(7) "3485712"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(22) "Team Real Estate, Inc."
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 637-3507"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(9) "799999.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-04-11"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(7) "6383.00"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-10-11T16:33:00.470"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16561473"
}
["rets_middle_or_junior_school"]=>
array(1) {
[0]=>
string(7) "Wahiawa"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202206923"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(16) "WHITMORE VILLAGE"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-11T22:37:34.673"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(9) "850000.00"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-7-1-007-075-0000"
}
["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) "20"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-18T13:09:47.753"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96786"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16561473"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(247) "Please email the listing agent or use showing time for appointments with 2 Day notice required. Listing agent maybe present. Buyer's agent must accompany their buyer and MUST wear mask. Consider using Jill Kihara at Title Guaranty Mililani Branch."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(682) "PRICE REDUCED! RARELY AVAILABLE PROPERTY WITH 3 SEPARATE LIVING AREAS at Whitmore Village. A total of 7 bedroom, 3 bath. Perfect for extended family with a potential rentals to supplement a mortgage. (Front Right) 3bed/2bath, (Front Left) 2 bed/1 bath, (Back) 2 bed/1bath with laundry area and nice spacious back yard. Close to Wheeler Army, Schofield and North Shore. Include As-Is, LBP Disclosure and Pre approval letter with all offers. Tenants are in a month-to-month tenancy but would like to stay. The number of bedroom/square footage of the home differs from the building department and/or tax assessors records. Buyer to do their own due diligence before close of escrow."
}
["rets_room_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_sqft_garage_carport"]=>
array(1) {
[0]=>
string(3) "472"
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(3) "362"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "1444"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "1806"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-10-10T15:50:38.843"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-07-01"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(6) "Aheahe"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(4) "1050"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(64) "1$21.511078$-158.022304$231.11$13.33$1.00$62ERIH7R_oLxjEFv-BJYVQ"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(2) "2%"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "185.00"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "2220.00"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "633200.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "205500.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "427700.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(4) "0.00"
}
["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/16561473/c11e6fb1a03ef195bc7216a102f642f7"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "171"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_tmk_division"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tmk_parcel"]=>
array(1) {
[0]=>
string(2) "75"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "7"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(1) "7"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1971"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(4) "1985"
}
["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(6) "Aheahe"
}
["street_number"]=>
array(1) {
[0]=>
string(4) "1050"
}
["street_suffix"]=>
array(1) {
[0]=>
string(6) "Avenue"
}
["terms_accept"]=>
array(1) {
[0]=>
string(38) "Cash,Conventional,Due On Sale,Exchange"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-7-1-007-075-0000"
}
["topography"]=>
array(1) {
[0]=>
string(5) "Clear"
}
["view"]=>
array(1) {
[0]=>
string(5) "Other"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16561473"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202206923"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1665541988"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1971"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "1985"
}
["zoning"]=>
array(1) {
[0]=>
string(29) "05 - R-5 Residential District"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(3978) "a:240:{i:0;i:21999204;i:1;i:21999205;i:2;i:21999206;i:3;i:21999207;i:4;i:21999208;i:5;i:21999209;i:6;i:21999210;i:7;i:21999211;i:8;i:21999212;i:9;i:21999249;i:10;i:21999250;i:11;i:21999251;i:12;i:21999252;i:13;i:21999253;i:14;i:21999254;i:15;i:21999255;i:16;i:21999256;i:17;i:21999257;i:18;i:22005291;i:19;i:22005292;i:20;i:22005293;i:21;i:22005294;i:22;i:22005295;i:23;i:22005296;i:24;i:22005297;i:25;i:22005298;i:26;i:22005299;i:27;i:22006916;i:28;i:22006917;i:29;i:22006918;i:30;i:22006919;i:31;i:22006920;i:32;i:22006921;i:33;i:22006922;i:34;i:22006923;i:35;i:22006924;i:36;i:22006925;i:37;i:22006926;i:38;i:22006927;i:39;i:22006928;i:40;i:22006929;i:41;i:22006930;i:42;i:22006931;i:43;i:22006932;i:44;i:22006933;i:45;i:22010286;i:46;i:22010287;i:47;i:22010288;i:48;i:22010289;i:49;i:22010290;i:50;i:22010291;i:51;i:22010292;i:52;i:22010293;i:53;i:22010294;i:54;i:22010295;i:55;i:22010296;i:56;i:22010297;i:57;i:22010298;i:58;i:22010299;i:59;i:22010300;i:60;i:22010301;i:61;i:22010302;i:62;i:22010303;i:63;i:22040444;i:64;i:22040445;i:65;i:22040446;i:66;i:22040447;i:67;i:22040448;i:68;i:22040449;i:69;i:22040450;i:70;i:22040451;i:71;i:22040452;i:72;i:22040453;i:73;i:22040454;i:74;i:22040455;i:75;i:22040456;i:76;i:22040457;i:77;i:22040458;i:78;i:22040459;i:79;i:22040460;i:80;i:22040461;i:81;i:22040462;i:82;i:22040505;i:83;i:22040506;i:84;i:22040507;i:85;i:22040508;i:86;i:22040509;i:87;i:22040510;i:88;i:22040511;i:89;i:22040512;i:90;i:22040513;i:91;i:22040514;i:92;i:22040515;i:93;i:22040516;i:94;i:22040517;i:95;i:22040518;i:96;i:22040519;i:97;i:22040520;i:98;i:22040521;i:99;i:22040522;i:100;i:22040523;i:101;i:22040602;i:102;i:22040603;i:103;i:22040604;i:104;i:22040605;i:105;i:22040606;i:106;i:22040607;i:107;i:22040608;i:108;i:22040609;i:109;i:22040610;i:110;i:22040611;i:111;i:22040612;i:112;i:22040613;i:113;i:22040614;i:114;i:22040615;i:115;i:22040616;i:116;i:22040617;i:117;i:22040618;i:118;i:22040619;i:119;i:22040620;i:120;i:22040793;i:121;i:22040794;i:122;i:22040795;i:123;i:22040796;i:124;i:22040797;i:125;i:22040798;i:126;i:22040799;i:127;i:22040800;i:128;i:22040801;i:129;i:22040802;i:130;i:22040803;i:131;i:22040804;i:132;i:22040805;i:133;i:22040806;i:134;i:22040807;i:135;i:22040808;i:136;i:22040809;i:137;i:22040810;i:138;i:22040811;i:139;i:22040812;i:140;i:22144552;i:141;i:22144553;i:142;i:22144554;i:143;i:22144555;i:144;i:22144556;i:145;i:22144557;i:146;i:22144558;i:147;i:22144559;i:148;i:22144560;i:149;i:22144561;i:150;i:22144562;i:151;i:22144563;i:152;i:22144564;i:153;i:22144565;i:154;i:22144566;i:155;i:22144567;i:156;i:22144568;i:157;i:22144569;i:158;i:22144570;i:159;i:22144571;i:160;i:22170973;i:161;i:22170974;i:162;i:22170975;i:163;i:22170976;i:164;i:22170977;i:165;i:22170978;i:166;i:22170979;i:167;i:22170980;i:168;i:22170981;i:169;i:22170982;i:170;i:22170983;i:171;i:22170984;i:172;i:22170985;i:173;i:22170986;i:174;i:22170987;i:175;i:22170988;i:176;i:22170989;i:177;i:22170990;i:178;i:22170991;i:179;i:22170992;i:180;i:22535566;i:181;i:22535567;i:182;i:22535568;i:183;i:22535569;i:184;i:22535570;i:185;i:22535571;i:186;i:22535572;i:187;i:22535573;i:188;i:22535574;i:189;i:22535575;i:190;i:22535576;i:191;i:22535577;i:192;i:22535578;i:193;i:22535579;i:194;i:22535580;i:195;i:22535581;i:196;i:22535582;i:197;i:22535583;i:198;i:22535584;i:199;i:22535585;i:200;i:23582043;i:201;i:23582044;i:202;i:23582045;i:203;i:23582046;i:204;i:23582047;i:205;i:23582048;i:206;i:23582049;i:207;i:23582050;i:208;i:23582051;i:209;i:23582052;i:210;i:23582053;i:211;i:23582054;i:212;i:23582055;i:213;i:23582056;i:214;i:23582057;i:215;i:23582058;i:216;i:23582059;i:217;i:23582060;i:218;i:23582061;i:219;i:23582062;i:220;i:23592162;i:221;i:23592163;i:222;i:23592164;i:223;i:23592165;i:224;i:23592166;i:225;i:23592167;i:226;i:23592168;i:227;i:23592169;i:228;i:23592170;i:229;i:23592171;i:230;i:23592172;i:231;i:23592173;i:232;i:23592174;i:233;i:23592175;i:234;i:23592176;i:235;i:23592177;i:236;i:23592178;i:237;i:23592179;i:238;i:23592180;i:239;i:23592181;}"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-05-03T10:40:36.720"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-05-05"
}
["rets_pending_date"]=>
array(1) {
[0]=>
string(10) "2022-05-05"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-07-01"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(9) "770000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2024-10-11"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-07-01"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 382-6871"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(26) "Vincent@FiveStarRealty.org"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(11) "Vincent Lao"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "22205"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "3474247"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "FIVE"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(7) "3486552"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(22) "Five Star Realty, Inc."
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 382-6871"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "23592162"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 205500.00
)
[assd_val_land] => Array
(
[0] => 427700.00
)
[assd_val_total] => Array
(
[0] => 633200.00
)
[bedrooms] => Array
(
[0] => 7
)
[building_style] => Array
(
[0] => Attached,Detach Single Family,Duplex,Ohana Dwelling
)
[city] => Array
(
[0] => Wahiawa
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Pet on Property,Property Disclosure Stmt,See Remarks
)
[easements] => Array
(
[0] => None
)
[elementary_school] => Array
(
[0] => Helemano
)
[floor_covering] => Array
(
[0] => Ceramic Tile,Laminate,Vinyl
)
[frontage] => Array
(
[0] => Other
)
[full_baths] => Array
(
[0] => 4
)
[furnished] => Array
(
[0] => None
)
[half_baths] => Array
(
[0] => 0
)
[high_school] => Array
(
[0] => Leilehua
)
[home_exampt] => Array
(
[0] => 0.00
)
[lanai_sf] => Array
(
[0] => 362
)
[land_area_sf] => Array
(
[0] => 6383.00
)
[land_recorded] => Array
(
[0] => Land Court
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => teresaabella8@gmail.com
)
[list_agent_name] => Array
(
[0] => Maria Teresa M Abella
)
[list_agent_phone_number] => Array
(
[0] => (808) 637-3507
)
[list_date] => Array
(
[0] => 2022-04-11
)
[list_office_name] => Array
(
[0] => Team Real Estate, Inc.
)
[list_price] => Array
(
[0] => 799999.00
)
[living_sf] => Array
(
[0] => 1806
)
[location] => Array
(
[0] => 1050 Aheahe Avenue, Wahiawa, HI 96786
)
[middle_school] => Array
(
[0] => Wahiawa
)
[mls_] => Array
(
[0] => 202206923
)
[neighborhood] => Array
(
[0] => WHITMORE VILLAGE
)
[number_of_parking_spaces] => Array
(
[0] => 4
)
[number_of_stories] => Array
(
[0] => One
)
[office_mls_id] => Array
(
[0] => TEAM
)
[parking_features] => Array
(
[0] => 3 Car+,Carport,Driveway,Street
)
[pool_] => Array
(
[0] => None
)
[possession] => Array
(
[0] => 45 Days or Less,Subject to Rental Lease
)
[postal_code] => Array
(
[0] => 96786
)
[property_condition] => Array
(
[0] => Above Average
)
[property_type] => Array
(
[0] => single_family
)
[property_type_label] => Array
(
[0] => single_family
)
[region] => Array
(
[0] => Central
)
[rets_baths_full] => Array
(
[0] => 4
)
[rets_baths_half] => Array
(
[0] => 0
)
[rets_baths_total] => Array
(
[0] => 4.00
)
[rets_beds_total] => Array
(
[0] => 7
)
[rets_city] => Array
(
[0] => Wahiawa
)
[rets_condo_property_regime_yn] => Array
(
[0] => 0
)
[rets_current_price] => Array
(
[0] => 770000.00
)
[rets_dom] => Array
(
[0] => 25
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_elementary_school] => Array
(
[0] => Helemano
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_high_school] => Array
(
[0] => Leilehua
)
[rets_id] => Array
(
[0] => 16561473
)
[rets_immoviewer_yn] => Array
(
[0] => 0
)
[rets_internet_automated_valuation_dis] => Array
(
[0] => 1
)
[rets_internet_consumer_comment_yn] => Array
(
[0] => 0
)
[rets_list_agent_direct_work_phone] => Array
(
[0] => (808) 637-3507
)
[rets_list_agent_email] => Array
(
[0] => teresaabella8@gmail.com
)
[rets_list_agent_full_name] => Array
(
[0] => Maria Teresa M Abella
)
[rets_list_agent_mlsid] => Array
(
[0] => 37572
)
[rets_list_agent_mui] => Array
(
[0] => 3481340
)
[rets_list_office_mlsid] => Array
(
[0] => TEAM
)
[rets_list_office_mui] => Array
(
[0] => 3485712
)
[rets_list_office_name] => Array
(
[0] => Team Real Estate, Inc.
)
[rets_list_office_phone] => Array
(
[0] => (808) 637-3507
)
[rets_list_price] => Array
(
[0] => 799999.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-04-11
)
[rets_lot_size_area] => Array
(
[0] => 6383.00
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-10-11T16:33:00.470
)
[rets_matrix_unique_id] => Array
(
[0] => 16561473
)
[rets_middle_or_junior_school] => Array
(
[0] => Wahiawa
)
[rets_mls_number] => Array
(
[0] => 202206923
)
[rets_neighbourhood] => Array
(
[0] => WHITMORE VILLAGE
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-04-11T22:37:34.673
)
[rets_original_list_price] => Array
(
[0] => 850000.00
)
[rets_parcel_number] => Array
(
[0] => 1-7-1-007-075-0000
)
[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] => 20
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2022-04-18T13:09:47.753
)
[rets_postal_code] => Array
(
[0] => 96786
)
[rets_primary_key] => Array
(
[0] => 16561473
)
[rets_private_remarks] => Array
(
[0] => Please email the listing agent or use showing time for appointments with 2 Day notice required. Listing agent maybe present. Buyer's agent must accompany their buyer and MUST wear mask. Consider using Jill Kihara at Title Guaranty Mililani Branch.
)
[rets_public_remarks] => Array
(
[0] => PRICE REDUCED! RARELY AVAILABLE PROPERTY WITH 3 SEPARATE LIVING AREAS at Whitmore Village. A total of 7 bedroom, 3 bath. Perfect for extended family with a potential rentals to supplement a mortgage. (Front Right) 3bed/2bath, (Front Left) 2 bed/1 bath, (Back) 2 bed/1bath with laundry area and nice spacious back yard. Close to Wheeler Army, Schofield and North Shore. Include As-Is, LBP Disclosure and Pre approval letter with all offers. Tenants are in a month-to-month tenancy but would like to stay. The number of bedroom/square footage of the home differs from the building department and/or tax assessors records. Buyer to do their own due diligence before close of escrow.
)
[rets_room_count] => Array
(
[0] => 0
)
[rets_sqft_garage_carport] => Array
(
[0] => 472
)
[rets_sqft_lanai_open] => Array
(
[0] => 362
)
[rets_sqft_roofed_living] => Array
(
[0] => 1444
)
[rets_sqft_total] => Array
(
[0] => 1806
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-10-10T15:50:38.843
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-07-01
)
[rets_street_name] => Array
(
[0] => Aheahe
)
[rets_street_number] => Array
(
[0] => 1050
)
[rets_street_view_param] => Array
(
[0] => 1$21.511078$-158.022304$231.11$13.33$1.00$62ERIH7R_oLxjEFv-BJYVQ
)
[rets_sub_agency_compensation] => Array
(
[0] => 2%
)
[rets_tax_amount] => Array
(
[0] => 185.00
)
[rets_tax_annual_amount] => Array
(
[0] => 2220.00
)
[rets_tax_assessed_value] => Array
(
[0] => 633200.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 205500.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 427700.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 0.00
)
[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/16561473/c11e6fb1a03ef195bc7216a102f642f7
)
[rets_tmk_area] => Array
(
[0] => 171
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 0
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 75
)
[rets_tmk_section] => Array
(
[0] => 1
)
[rets_tmk_zone] => Array
(
[0] => 7
)
[rets_tmkplat] => Array
(
[0] => 7
)
[rets_year_built] => Array
(
[0] => 1971
)
[rets_year_remodeled] => Array
(
[0] => 1985
)
[security] => Array
(
[0] => Key
)
[setbacks] => Array
(
[0] => C&C
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Aheahe
)
[street_number] => Array
(
[0] => 1050
)
[street_suffix] => Array
(
[0] => Avenue
)
[terms_accept] => Array
(
[0] => Cash,Conventional,Due On Sale,Exchange
)
[tmk] => Array
(
[0] => 1-7-1-007-075-0000
)
[topography] => Array
(
[0] => Clear
)
[view] => Array
(
[0] => Other
)
[wpp::rets_pk] => Array
(
[0] => 16561473
)
[wpp_gpid] => Array
(
[0] => 202206923
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1665541988
)
[year_built] => Array
(
[0] => 1971
)
[year_remodeled_] => Array
(
[0] => 1985
)
[zoning] => Array
(
[0] => 05 - R-5 Residential District
)
[new_attached_media] => Array
(
[0] => a:240:{i:0;i:21999204;i:1;i:21999205;i:2;i:21999206;i:3;i:21999207;i:4;i:21999208;i:5;i:21999209;i:6;i:21999210;i:7;i:21999211;i:8;i:21999212;i:9;i:21999249;i:10;i:21999250;i:11;i:21999251;i:12;i:21999252;i:13;i:21999253;i:14;i:21999254;i:15;i:21999255;i:16;i:21999256;i:17;i:21999257;i:18;i:22005291;i:19;i:22005292;i:20;i:22005293;i:21;i:22005294;i:22;i:22005295;i:23;i:22005296;i:24;i:22005297;i:25;i:22005298;i:26;i:22005299;i:27;i:22006916;i:28;i:22006917;i:29;i:22006918;i:30;i:22006919;i:31;i:22006920;i:32;i:22006921;i:33;i:22006922;i:34;i:22006923;i:35;i:22006924;i:36;i:22006925;i:37;i:22006926;i:38;i:22006927;i:39;i:22006928;i:40;i:22006929;i:41;i:22006930;i:42;i:22006931;i:43;i:22006932;i:44;i:22006933;i:45;i:22010286;i:46;i:22010287;i:47;i:22010288;i:48;i:22010289;i:49;i:22010290;i:50;i:22010291;i:51;i:22010292;i:52;i:22010293;i:53;i:22010294;i:54;i:22010295;i:55;i:22010296;i:56;i:22010297;i:57;i:22010298;i:58;i:22010299;i:59;i:22010300;i:60;i:22010301;i:61;i:22010302;i:62;i:22010303;i:63;i:22040444;i:64;i:22040445;i:65;i:22040446;i:66;i:22040447;i:67;i:22040448;i:68;i:22040449;i:69;i:22040450;i:70;i:22040451;i:71;i:22040452;i:72;i:22040453;i:73;i:22040454;i:74;i:22040455;i:75;i:22040456;i:76;i:22040457;i:77;i:22040458;i:78;i:22040459;i:79;i:22040460;i:80;i:22040461;i:81;i:22040462;i:82;i:22040505;i:83;i:22040506;i:84;i:22040507;i:85;i:22040508;i:86;i:22040509;i:87;i:22040510;i:88;i:22040511;i:89;i:22040512;i:90;i:22040513;i:91;i:22040514;i:92;i:22040515;i:93;i:22040516;i:94;i:22040517;i:95;i:22040518;i:96;i:22040519;i:97;i:22040520;i:98;i:22040521;i:99;i:22040522;i:100;i:22040523;i:101;i:22040602;i:102;i:22040603;i:103;i:22040604;i:104;i:22040605;i:105;i:22040606;i:106;i:22040607;i:107;i:22040608;i:108;i:22040609;i:109;i:22040610;i:110;i:22040611;i:111;i:22040612;i:112;i:22040613;i:113;i:22040614;i:114;i:22040615;i:115;i:22040616;i:116;i:22040617;i:117;i:22040618;i:118;i:22040619;i:119;i:22040620;i:120;i:22040793;i:121;i:22040794;i:122;i:22040795;i:123;i:22040796;i:124;i:22040797;i:125;i:22040798;i:126;i:22040799;i:127;i:22040800;i:128;i:22040801;i:129;i:22040802;i:130;i:22040803;i:131;i:22040804;i:132;i:22040805;i:133;i:22040806;i:134;i:22040807;i:135;i:22040808;i:136;i:22040809;i:137;i:22040810;i:138;i:22040811;i:139;i:22040812;i:140;i:22144552;i:141;i:22144553;i:142;i:22144554;i:143;i:22144555;i:144;i:22144556;i:145;i:22144557;i:146;i:22144558;i:147;i:22144559;i:148;i:22144560;i:149;i:22144561;i:150;i:22144562;i:151;i:22144563;i:152;i:22144564;i:153;i:22144565;i:154;i:22144566;i:155;i:22144567;i:156;i:22144568;i:157;i:22144569;i:158;i:22144570;i:159;i:22144571;i:160;i:22170973;i:161;i:22170974;i:162;i:22170975;i:163;i:22170976;i:164;i:22170977;i:165;i:22170978;i:166;i:22170979;i:167;i:22170980;i:168;i:22170981;i:169;i:22170982;i:170;i:22170983;i:171;i:22170984;i:172;i:22170985;i:173;i:22170986;i:174;i:22170987;i:175;i:22170988;i:176;i:22170989;i:177;i:22170990;i:178;i:22170991;i:179;i:22170992;i:180;i:22535566;i:181;i:22535567;i:182;i:22535568;i:183;i:22535569;i:184;i:22535570;i:185;i:22535571;i:186;i:22535572;i:187;i:22535573;i:188;i:22535574;i:189;i:22535575;i:190;i:22535576;i:191;i:22535577;i:192;i:22535578;i:193;i:22535579;i:194;i:22535580;i:195;i:22535581;i:196;i:22535582;i:197;i:22535583;i:198;i:22535584;i:199;i:22535585;i:200;i:23582043;i:201;i:23582044;i:202;i:23582045;i:203;i:23582046;i:204;i:23582047;i:205;i:23582048;i:206;i:23582049;i:207;i:23582050;i:208;i:23582051;i:209;i:23582052;i:210;i:23582053;i:211;i:23582054;i:212;i:23582055;i:213;i:23582056;i:214;i:23582057;i:215;i:23582058;i:216;i:23582059;i:217;i:23582060;i:218;i:23582061;i:219;i:23582062;i:220;i:23592162;i:221;i:23592163;i:222;i:23592164;i:223;i:23592165;i:224;i:23592166;i:225;i:23592167;i:226;i:23592168;i:227;i:23592169;i:228;i:23592170;i:229;i:23592171;i:230;i:23592172;i:231;i:23592173;i:232;i:23592174;i:233;i:23592175;i:234;i:23592176;i:235;i:23592177;i:236;i:23592178;i:237;i:23592179;i:238;i:23592180;i:239;i:23592181;}
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-05-03T10:40:36.720
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-05-05
)
[rets_pending_date] => Array
(
[0] => 2022-05-05
)
[rets_close_date] => Array
(
[0] => 2022-07-01
)
[rets_close_price] => Array
(
[0] => 770000.00
)
[rets_expiration_date] => Array
(
[0] => 2024-10-11
)
[rets_off_market_date] => Array
(
[0] => 2022-07-01
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 382-6871
)
[rets_selling_agent_email] => Array
(
[0] => Vincent@FiveStarRealty.org
)
[rets_selling_agent_full_name] => Array
(
[0] => Vincent Lao
)
[rets_selling_agent_mlsid] => Array
(
[0] => 22205
)
[rets_selling_agent_mui] => Array
(
[0] => 3474247
)
[rets_selling_office_mlsid] => Array
(
[0] => FIVE
)
[rets_selling_office_mui] => Array
(
[0] => 3486552
)
[rets_selling_office_name] => Array
(
[0] => Five Star Realty, Inc.
)
[rets_selling_office_phone] => Array
(
[0] => (808) 382-6871
)
[_thumbnail_id] => Array
(
[0] => 23592162
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446