**NEWLY UPGRADED HOME in one of most desirable neighborhood just hit the market** Beautiful two story townhome located in the center of the island of Oahu, situated in Mililani Town. Renovated kitchen with stainless steel appliances, shaker white cabinets, corian countertops luxury vinyl laminate flooring on 1st floor. All bathrooms are upgraded with luxury vinyl flooring, corian countertop, shower and vanity. Entertain guests in your backyard and witness the beautiful views from your bedroom. Close distance to shopping centers, schools, restaurants, Walmart, Costco and enjoy easy access to freeways. One assigned parking with guest parking steps away from your front door. Centrally located to Schofield Barracks, Wheeler AAF, Camp Smith, Pearl Harbor/ Hickam, and U.S Coast Guard bases. Enjoy all Mililani has to offer.**THIS ONE WILL NOT LAST LONG**
Listing by: RE/MAX ALOHA HOMES
array(166) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "100300.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "332100.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "432400.00"
}
["assn_fee_inclusions"]=>
array(1) {
[0]=>
string(2) "42"
}
["association_fees"]=>
array(1) {
[0]=>
string(2) "42"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "2"
}
["building_name"]=>
array(1) {
[0]=>
string(10) "Nob Hill 4"
}
["building_style"]=>
array(1) {
[0]=>
string(40) "No Unit Above or Below,Townhouse,Walk-Up"
}
["city"]=>
array(1) {
[0]=>
string(8) "Mililani"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(21) "Pets Allowed (Verify)"
}
["floor_covering"]=>
array(1) {
[0]=>
string(16) "Vinyl,W/W Carpet"
}
["frontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "1"
}
["furnished"]=>
array(1) {
[0]=>
string(4) "None"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "1"
}
["home_exampt"]=>
array(1) {
[0]=>
string(1) "0"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(3) "200"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(9) "476677.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(27) "margie@alohahomesagents.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(11) "Margie Jose"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 393-9966"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-04-17"
}
["list_office_name"]=>
array(1) {
[0]=>
string(18) "RE/MAX ALOHA HOMES"
}
["list_price"]=>
array(1) {
[0]=>
string(9) "580000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "1013"
}
["location"]=>
array(1) {
[0]=>
string(54) "94-1474 Lanikuhana Avenue Unit 551, Mililani, HI 96789"
}
["maintenance_fees"]=>
array(1) {
[0]=>
string(6) "402.00"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202207259"
}
["neighborhood"]=>
array(1) {
[0]=>
string(13) "MILILANI AREA"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "1"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(3) "Two"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "RMXA"
}
["parking_features"]=>
array(1) {
[0]=>
string(17) "Assigned,Open - 1"
}
["possession"]=>
array(1) {
[0]=>
string(15) "45 Days or Less"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96789"
}
["property_condition"]=>
array(1) {
[0]=>
string(23) "Above Average,Excellent"
}
["property_type"]=>
array(1) {
[0]=>
string(15) "condo_townhouse"
}
["property_type_label"]=>
array(1) {
[0]=>
string(15) "Condo Townhouse"
}
["region"]=>
array(1) {
[0]=>
string(7) "Central"
}
["rets_association_community_name"]=>
array(1) {
[0]=>
string(25) "Mililani Town Association"
}
["rets_association_fee"]=>
array(1) {
[0]=>
string(2) "42"
}
["rets_association_fee_total"]=>
array(1) {
[0]=>
string(3) "444"
}
["rets_association_phone"]=>
array(1) {
[0]=>
string(10) "8086237300"
}
["rets_baths_full"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_baths_half"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_baths_total"]=>
array(1) {
[0]=>
string(4) "1.01"
}
["rets_beds_total"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_building_name"]=>
array(1) {
[0]=>
string(10) "Nob Hill 4"
}
["rets_city"]=>
array(1) {
[0]=>
string(8) "Mililani"
}
["rets_condo_parking_unit"]=>
array(1) {
[0]=>
string(3) "TBD"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(9) "580000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(2) "26"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_floor_number"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_foreclosure_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_fractional_ownership_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_id"]=>
array(1) {
[0]=>
string(8) "16570614"
}
["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) 393-9966"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(27) "margie@alohahomesagents.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(11) "Margie Jose"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "49066"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(8) "13155211"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "RMXA"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(8) "12873659"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(18) "RE/MAX ALOHA HOMES"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 393-9966"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(9) "580000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-04-17"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(9) "476677.00"
}
["rets_maintenance_expense"]=>
array(1) {
[0]=>
string(6) "402.00"
}
["rets_management_company_name"]=>
array(1) {
[0]=>
string(11) "Touch Stone"
}
["rets_management_company_phone"]=>
array(1) {
[0]=>
string(10) "8085664100"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-06-29T13:50:05.447"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16570614"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202207259"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(13) "MILILANI AREA"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-17T19:31:47.667"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(9) "580000.00"
}
["rets_owner_occupancy_percentage"]=>
array(1) {
[0]=>
string(2) "73"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-9-4-005-035-0051"
}
["rets_parking_additional"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_parking_total"]=>
array(1) {
[0]=>
string(1) "1"
}
["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) "17"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-17T19:49:22.487"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96789"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-17T19:31:47.667"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16570614"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(322) "No private showing until 1st open house May 1st from 2pm to 5pm. Seller requests Fidelity National Title. Henson Balais escrow officer 808-485-0505; Henson.balais@fnf.com Email offers to Margie@REMAX.net and text 808-729-3204. Please include include AS IS addendum, Pre-approval Letter and/or POF, keep the Coop separate."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(862) "**NEWLY UPGRADED HOME in one of most desirable neighborhood just hit the market** Beautiful two story townhome located in the center of the island of Oahu, situated in Mililani Town. Renovated kitchen with stainless steel appliances, shaker white cabinets, corian countertops luxury vinyl laminate flooring on 1st floor. All bathrooms are upgraded with luxury vinyl flooring, corian countertop, shower and vanity. Entertain guests in your backyard and witness the beautiful views from your bedroom. Close distance to shopping centers, schools, restaurants, Walmart, Costco and enjoy easy access to freeways. One assigned parking with guest parking steps away from your front door. Centrally located to Schofield Barracks, Wheeler AAF, Camp Smith, Pearl Harbor/ Hickam, and U.S Coast Guard bases. Enjoy all Mililani has to offer.**THIS ONE WILL NOT LAST LONG**"
}
["rets_room_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(3) "200"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(3) "813"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "1013"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-29T13:50:05.447"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-06-27"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(10) "Lanikuhana"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(7) "94-1474"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(63) "1$21.445919$-158.006316$12.51$13.33$1.00$q8p5Bn0C_NKfFvFCruzD3Q"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(3) "2.5"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "111.27"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "1335.24"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "432400.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "100300.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "332100.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_tax_paid_by_seller_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_tax_year"]=>
array(1) {
[0]=>
string(4) "2022"
}
["rets_thumbnail_url"]=>
array(1) {
[0]=>
string(81) "https://cdn.rets.ci/marcusrealty-images/16570614/78707b952089efde9c95394fd4675875"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "194"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(2) "51"
}
["rets_tmk_division"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tmk_parcel"]=>
array(1) {
[0]=>
string(2) "35"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "9"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(1) "5"
}
["rets_unit_number"]=>
array(1) {
[0]=>
string(3) "551"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1975"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(4) "2021"
}
["state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["street_name"]=>
array(1) {
[0]=>
string(10) "Lanikuhana"
}
["street_number"]=>
array(1) {
[0]=>
string(7) "94-1474"
}
["street_suffix"]=>
array(1) {
[0]=>
string(6) "Avenue"
}
["terms_accept"]=>
array(1) {
[0]=>
string(20) "Cash,Conventional,VA"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-9-4-005-035-0051"
}
["unit"]=>
array(1) {
[0]=>
string(14) "Odd# Unit,Yard"
}
["unit_number"]=>
array(1) {
[0]=>
string(3) "551"
}
["view"]=>
array(1) {
[0]=>
string(4) "None"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16570614"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202207259"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1656546655"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1975"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "2021"
}
["zoning"]=>
array(1) {
[0]=>
string(31) "12 - A-2 Medium Density Apartme"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(3077) "a:187:{i:0;i:22035234;i:1;i:22035235;i:2;i:22035236;i:3;i:22035237;i:4;i:22035238;i:5;i:22035239;i:6;i:22035240;i:7;i:22035241;i:8;i:22035242;i:9;i:22035243;i:10;i:22035244;i:11;i:22035245;i:12;i:22035246;i:13;i:22035247;i:14;i:22035248;i:15;i:22035249;i:16;i:22035250;i:17;i:22035251;i:18;i:22035252;i:19;i:22035253;i:20;i:22035254;i:21;i:22035255;i:22;i:22035256;i:23;i:22035257;i:24;i:22035258;i:25;i:22035259;i:26;i:22035260;i:27;i:22035261;i:28;i:22035262;i:29;i:22035263;i:30;i:22035264;i:31;i:22035265;i:32;i:22035266;i:33;i:22035267;i:34;i:22069517;i:35;i:22069518;i:36;i:22069519;i:37;i:22069520;i:38;i:22069521;i:39;i:22069522;i:40;i:22069523;i:41;i:22069524;i:42;i:22069525;i:43;i:22069526;i:44;i:22069527;i:45;i:22069528;i:46;i:22069529;i:47;i:22069530;i:48;i:22069531;i:49;i:22069532;i:50;i:22069533;i:51;i:22100353;i:52;i:22100354;i:53;i:22100355;i:54;i:22100356;i:55;i:22100357;i:56;i:22100358;i:57;i:22100359;i:58;i:22100360;i:59;i:22100361;i:60;i:22100362;i:61;i:22100363;i:62;i:22100364;i:63;i:22100365;i:64;i:22100366;i:65;i:22100367;i:66;i:22100368;i:67;i:22100369;i:68;i:22150255;i:69;i:22150256;i:70;i:22150257;i:71;i:22150258;i:72;i:22150259;i:73;i:22150260;i:74;i:22150261;i:75;i:22150262;i:76;i:22150263;i:77;i:22150264;i:78;i:22150265;i:79;i:22150266;i:80;i:22150267;i:81;i:22150268;i:82;i:22150269;i:83;i:22150270;i:84;i:22150271;i:85;i:22150272;i:86;i:22150273;i:87;i:22150274;i:88;i:22150275;i:89;i:22150276;i:90;i:22150277;i:91;i:22150278;i:92;i:22150279;i:93;i:22150280;i:94;i:22150281;i:95;i:22150282;i:96;i:22150283;i:97;i:22150284;i:98;i:22150285;i:99;i:22150286;i:100;i:22150287;i:101;i:22150288;i:102;i:22163387;i:103;i:22163388;i:104;i:22163389;i:105;i:22163390;i:106;i:22163391;i:107;i:22163392;i:108;i:22163393;i:109;i:22163394;i:110;i:22163395;i:111;i:22163396;i:112;i:22163397;i:113;i:22163398;i:114;i:22163399;i:115;i:22163400;i:116;i:22163401;i:117;i:22163402;i:118;i:22163403;i:119;i:22220282;i:120;i:22220283;i:121;i:22220284;i:122;i:22220285;i:123;i:22220286;i:124;i:22220287;i:125;i:22220288;i:126;i:22220289;i:127;i:22220290;i:128;i:22220291;i:129;i:22220292;i:130;i:22220293;i:131;i:22220294;i:132;i:22220295;i:133;i:22220296;i:134;i:22220297;i:135;i:22220298;i:136;i:22418009;i:137;i:22418010;i:138;i:22418011;i:139;i:22418012;i:140;i:22418013;i:141;i:22418014;i:142;i:22418015;i:143;i:22418016;i:144;i:22418017;i:145;i:22418018;i:146;i:22418019;i:147;i:22418020;i:148;i:22418021;i:149;i:22418022;i:150;i:22418023;i:151;i:22418024;i:152;i:22418025;i:153;i:22577176;i:154;i:22577177;i:155;i:22577178;i:156;i:22577179;i:157;i:22577180;i:158;i:22577181;i:159;i:22577182;i:160;i:22577183;i:161;i:22577184;i:162;i:22577185;i:163;i:22577186;i:164;i:22577187;i:165;i:22577188;i:166;i:22577189;i:167;i:22577190;i:168;i:22577191;i:169;i:22577192;i:170;i:22577269;i:171;i:22577270;i:172;i:22577271;i:173;i:22577272;i:174;i:22577273;i:175;i:22577274;i:176;i:22577275;i:177;i:22577276;i:178;i:22577277;i:179;i:22577278;i:180;i:22577279;i:181;i:22577280;i:182;i:22577281;i:183;i:22577282;i:184;i:22577283;i:185;i:22577284;i:186;i:22577285;}"
}
["rets_open_house_count"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_active_open_house_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_open_house_upcoming"]=>
array(1) {
[0]=>
string(0) ""
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-05-13"
}
["rets_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(69) "https://app.immoviewer.com/landing/unbranded/625eae82089a2569f74b473b"
}
["virtual_tour"]=>
array(1) {
[0]=>
string(69) "https://app.immoviewer.com/landing/unbranded/625eae82089a2569f74b473b"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-06-27"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(9) "580000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2023-04-17"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-06-27"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 393-9966"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(28) "adrian.vasquez.mil@gmail.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(14) "Adrian Vasquez"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "52037"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(8) "16405843"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "RMXA"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(8) "12873659"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(18) "RE/MAX ALOHA HOMES"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 393-9966"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "22577269"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 100300.00
)
[assd_val_land] => Array
(
[0] => 332100.00
)
[assd_val_total] => Array
(
[0] => 432400.00
)
[assn_fee_inclusions] => Array
(
[0] => 42
)
[association_fees] => Array
(
[0] => 42
)
[bedrooms] => Array
(
[0] => 2
)
[building_name] => Array
(
[0] => Nob Hill 4
)
[building_style] => Array
(
[0] => No Unit Above or Below,Townhouse,Walk-Up
)
[city] => Array
(
[0] => Mililani
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Pets Allowed (Verify)
)
[floor_covering] => Array
(
[0] => Vinyl,W/W Carpet
)
[frontage] => Array
(
[0] => Other
)
[full_baths] => Array
(
[0] => 1
)
[furnished] => Array
(
[0] => None
)
[half_baths] => Array
(
[0] => 1
)
[home_exampt] => Array
(
[0] => 0
)
[lanai_sf] => Array
(
[0] => 200
)
[land_area_sf] => Array
(
[0] => 476677.00
)
[land_recorded] => Array
(
[0] => Dual Systems
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => margie@alohahomesagents.com
)
[list_agent_name] => Array
(
[0] => Margie Jose
)
[list_agent_phone_number] => Array
(
[0] => (808) 393-9966
)
[list_date] => Array
(
[0] => 2022-04-17
)
[list_office_name] => Array
(
[0] => RE/MAX ALOHA HOMES
)
[list_price] => Array
(
[0] => 580000.00
)
[living_sf] => Array
(
[0] => 1013
)
[location] => Array
(
[0] => 94-1474 Lanikuhana Avenue Unit 551, Mililani, HI 96789
)
[maintenance_fees] => Array
(
[0] => 402.00
)
[mls_] => Array
(
[0] => 202207259
)
[neighborhood] => Array
(
[0] => MILILANI AREA
)
[number_of_parking_spaces] => Array
(
[0] => 1
)
[number_of_stories] => Array
(
[0] => Two
)
[office_mls_id] => Array
(
[0] => RMXA
)
[parking_features] => Array
(
[0] => Assigned,Open - 1
)
[possession] => Array
(
[0] => 45 Days or Less
)
[postal_code] => Array
(
[0] => 96789
)
[property_condition] => Array
(
[0] => Above Average,Excellent
)
[property_type] => Array
(
[0] => condo_townhouse
)
[property_type_label] => Array
(
[0] => Condo Townhouse
)
[region] => Array
(
[0] => Central
)
[rets_association_community_name] => Array
(
[0] => Mililani Town Association
)
[rets_association_fee] => Array
(
[0] => 42
)
[rets_association_fee_total] => Array
(
[0] => 444
)
[rets_association_phone] => Array
(
[0] => 8086237300
)
[rets_baths_full] => Array
(
[0] => 1
)
[rets_baths_half] => Array
(
[0] => 1
)
[rets_baths_total] => Array
(
[0] => 1.01
)
[rets_beds_total] => Array
(
[0] => 2
)
[rets_building_name] => Array
(
[0] => Nob Hill 4
)
[rets_city] => Array
(
[0] => Mililani
)
[rets_condo_parking_unit] => Array
(
[0] => TBD
)
[rets_current_price] => Array
(
[0] => 580000.00
)
[rets_dom] => Array
(
[0] => 26
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_floor_number] => Array
(
[0] => 1
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_id] => Array
(
[0] => 16570614
)
[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) 393-9966
)
[rets_list_agent_email] => Array
(
[0] => margie@alohahomesagents.com
)
[rets_list_agent_full_name] => Array
(
[0] => Margie Jose
)
[rets_list_agent_mlsid] => Array
(
[0] => 49066
)
[rets_list_agent_mui] => Array
(
[0] => 13155211
)
[rets_list_office_mlsid] => Array
(
[0] => RMXA
)
[rets_list_office_mui] => Array
(
[0] => 12873659
)
[rets_list_office_name] => Array
(
[0] => RE/MAX ALOHA HOMES
)
[rets_list_office_phone] => Array
(
[0] => (808) 393-9966
)
[rets_list_price] => Array
(
[0] => 580000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-04-17
)
[rets_lot_size_area] => Array
(
[0] => 476677.00
)
[rets_maintenance_expense] => Array
(
[0] => 402.00
)
[rets_management_company_name] => Array
(
[0] => Touch Stone
)
[rets_management_company_phone] => Array
(
[0] => 8085664100
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-06-29T13:50:05.447
)
[rets_matrix_unique_id] => Array
(
[0] => 16570614
)
[rets_mls_number] => Array
(
[0] => 202207259
)
[rets_neighbourhood] => Array
(
[0] => MILILANI AREA
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-04-17T19:31:47.667
)
[rets_original_list_price] => Array
(
[0] => 580000.00
)
[rets_owner_occupancy_percentage] => Array
(
[0] => 73
)
[rets_parcel_number] => Array
(
[0] => 1-9-4-005-035-0051
)
[rets_parking_additional] => Array
(
[0] => 0
)
[rets_parking_total] => Array
(
[0] => 1
)
[rets_permit_address_internet_yn] => Array
(
[0] => 1
)
[rets_permit_internet_yn] => Array
(
[0] => 1
)
[rets_photo_count] => Array
(
[0] => 17
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2022-04-17T19:49:22.487
)
[rets_postal_code] => Array
(
[0] => 96789
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-04-17T19:31:47.667
)
[rets_primary_key] => Array
(
[0] => 16570614
)
[rets_private_remarks] => Array
(
[0] => No private showing until 1st open house May 1st from 2pm to 5pm. Seller requests Fidelity National Title. Henson Balais escrow officer 808-485-0505; Henson.balais@fnf.com Email offers to Margie@REMAX.net and text 808-729-3204. Please include include AS IS addendum, Pre-approval Letter and/or POF, keep the Coop separate.
)
[rets_public_remarks] => Array
(
[0] => **NEWLY UPGRADED HOME in one of most desirable neighborhood just hit the market** Beautiful two story townhome located in the center of the island of Oahu, situated in Mililani Town. Renovated kitchen with stainless steel appliances, shaker white cabinets, corian countertops luxury vinyl laminate flooring on 1st floor. All bathrooms are upgraded with luxury vinyl flooring, corian countertop, shower and vanity. Entertain guests in your backyard and witness the beautiful views from your bedroom. Close distance to shopping centers, schools, restaurants, Walmart, Costco and enjoy easy access to freeways. One assigned parking with guest parking steps away from your front door. Centrally located to Schofield Barracks, Wheeler AAF, Camp Smith, Pearl Harbor/ Hickam, and U.S Coast Guard bases. Enjoy all Mililani has to offer.**THIS ONE WILL NOT LAST LONG**
)
[rets_room_count] => Array
(
[0] => 0
)
[rets_sqft_lanai_open] => Array
(
[0] => 200
)
[rets_sqft_roofed_living] => Array
(
[0] => 813
)
[rets_sqft_total] => Array
(
[0] => 1013
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-06-29T13:50:05.447
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-06-27
)
[rets_street_name] => Array
(
[0] => Lanikuhana
)
[rets_street_number] => Array
(
[0] => 94-1474
)
[rets_street_view_param] => Array
(
[0] => 1$21.445919$-158.006316$12.51$13.33$1.00$q8p5Bn0C_NKfFvFCruzD3Q
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5
)
[rets_tax_amount] => Array
(
[0] => 111.27
)
[rets_tax_annual_amount] => Array
(
[0] => 1335.24
)
[rets_tax_assessed_value] => Array
(
[0] => 432400.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 100300.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 332100.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 0
)
[rets_tax_paid_by_seller_yn] => Array
(
[0] => 0
)
[rets_tax_year] => Array
(
[0] => 2022
)
[rets_thumbnail_url] => Array
(
[0] => https://cdn.rets.ci/marcusrealty-images/16570614/78707b952089efde9c95394fd4675875
)
[rets_tmk_area] => Array
(
[0] => 194
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 51
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 35
)
[rets_tmk_section] => Array
(
[0] => 4
)
[rets_tmk_zone] => Array
(
[0] => 9
)
[rets_tmkplat] => Array
(
[0] => 5
)
[rets_unit_number] => Array
(
[0] => 551
)
[rets_year_built] => Array
(
[0] => 1975
)
[rets_year_remodeled] => Array
(
[0] => 2021
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Lanikuhana
)
[street_number] => Array
(
[0] => 94-1474
)
[street_suffix] => Array
(
[0] => Avenue
)
[terms_accept] => Array
(
[0] => Cash,Conventional,VA
)
[tmk] => Array
(
[0] => 1-9-4-005-035-0051
)
[unit] => Array
(
[0] => Odd# Unit,Yard
)
[unit_number] => Array
(
[0] => 551
)
[view] => Array
(
[0] => None
)
[wpp::rets_pk] => Array
(
[0] => 16570614
)
[wpp_gpid] => Array
(
[0] => 202207259
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1656546655
)
[year_built] => Array
(
[0] => 1975
)
[year_remodeled_] => Array
(
[0] => 2021
)
[zoning] => Array
(
[0] => 12 - A-2 Medium Density Apartme
)
[new_attached_media] => Array
(
[0] => a:187:{i:0;i:22035234;i:1;i:22035235;i:2;i:22035236;i:3;i:22035237;i:4;i:22035238;i:5;i:22035239;i:6;i:22035240;i:7;i:22035241;i:8;i:22035242;i:9;i:22035243;i:10;i:22035244;i:11;i:22035245;i:12;i:22035246;i:13;i:22035247;i:14;i:22035248;i:15;i:22035249;i:16;i:22035250;i:17;i:22035251;i:18;i:22035252;i:19;i:22035253;i:20;i:22035254;i:21;i:22035255;i:22;i:22035256;i:23;i:22035257;i:24;i:22035258;i:25;i:22035259;i:26;i:22035260;i:27;i:22035261;i:28;i:22035262;i:29;i:22035263;i:30;i:22035264;i:31;i:22035265;i:32;i:22035266;i:33;i:22035267;i:34;i:22069517;i:35;i:22069518;i:36;i:22069519;i:37;i:22069520;i:38;i:22069521;i:39;i:22069522;i:40;i:22069523;i:41;i:22069524;i:42;i:22069525;i:43;i:22069526;i:44;i:22069527;i:45;i:22069528;i:46;i:22069529;i:47;i:22069530;i:48;i:22069531;i:49;i:22069532;i:50;i:22069533;i:51;i:22100353;i:52;i:22100354;i:53;i:22100355;i:54;i:22100356;i:55;i:22100357;i:56;i:22100358;i:57;i:22100359;i:58;i:22100360;i:59;i:22100361;i:60;i:22100362;i:61;i:22100363;i:62;i:22100364;i:63;i:22100365;i:64;i:22100366;i:65;i:22100367;i:66;i:22100368;i:67;i:22100369;i:68;i:22150255;i:69;i:22150256;i:70;i:22150257;i:71;i:22150258;i:72;i:22150259;i:73;i:22150260;i:74;i:22150261;i:75;i:22150262;i:76;i:22150263;i:77;i:22150264;i:78;i:22150265;i:79;i:22150266;i:80;i:22150267;i:81;i:22150268;i:82;i:22150269;i:83;i:22150270;i:84;i:22150271;i:85;i:22150272;i:86;i:22150273;i:87;i:22150274;i:88;i:22150275;i:89;i:22150276;i:90;i:22150277;i:91;i:22150278;i:92;i:22150279;i:93;i:22150280;i:94;i:22150281;i:95;i:22150282;i:96;i:22150283;i:97;i:22150284;i:98;i:22150285;i:99;i:22150286;i:100;i:22150287;i:101;i:22150288;i:102;i:22163387;i:103;i:22163388;i:104;i:22163389;i:105;i:22163390;i:106;i:22163391;i:107;i:22163392;i:108;i:22163393;i:109;i:22163394;i:110;i:22163395;i:111;i:22163396;i:112;i:22163397;i:113;i:22163398;i:114;i:22163399;i:115;i:22163400;i:116;i:22163401;i:117;i:22163402;i:118;i:22163403;i:119;i:22220282;i:120;i:22220283;i:121;i:22220284;i:122;i:22220285;i:123;i:22220286;i:124;i:22220287;i:125;i:22220288;i:126;i:22220289;i:127;i:22220290;i:128;i:22220291;i:129;i:22220292;i:130;i:22220293;i:131;i:22220294;i:132;i:22220295;i:133;i:22220296;i:134;i:22220297;i:135;i:22220298;i:136;i:22418009;i:137;i:22418010;i:138;i:22418011;i:139;i:22418012;i:140;i:22418013;i:141;i:22418014;i:142;i:22418015;i:143;i:22418016;i:144;i:22418017;i:145;i:22418018;i:146;i:22418019;i:147;i:22418020;i:148;i:22418021;i:149;i:22418022;i:150;i:22418023;i:151;i:22418024;i:152;i:22418025;i:153;i:22577176;i:154;i:22577177;i:155;i:22577178;i:156;i:22577179;i:157;i:22577180;i:158;i:22577181;i:159;i:22577182;i:160;i:22577183;i:161;i:22577184;i:162;i:22577185;i:163;i:22577186;i:164;i:22577187;i:165;i:22577188;i:166;i:22577189;i:167;i:22577190;i:168;i:22577191;i:169;i:22577192;i:170;i:22577269;i:171;i:22577270;i:172;i:22577271;i:173;i:22577272;i:174;i:22577273;i:175;i:22577274;i:176;i:22577275;i:177;i:22577276;i:178;i:22577277;i:179;i:22577278;i:180;i:22577279;i:181;i:22577280;i:182;i:22577281;i:183;i:22577282;i:184;i:22577283;i:185;i:22577284;i:186;i:22577285;}
)
[rets_open_house_count] => Array
(
[0] => 2
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_open_house_upcoming] => Array
(
[0] =>
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-05-13
)
[rets_virtual_tour_url_unbranded] => Array
(
[0] => https://app.immoviewer.com/landing/unbranded/625eae82089a2569f74b473b
)
[virtual_tour] => Array
(
[0] => https://app.immoviewer.com/landing/unbranded/625eae82089a2569f74b473b
)
[rets_close_date] => Array
(
[0] => 2022-06-27
)
[rets_close_price] => Array
(
[0] => 580000.00
)
[rets_expiration_date] => Array
(
[0] => 2023-04-17
)
[rets_off_market_date] => Array
(
[0] => 2022-06-27
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 393-9966
)
[rets_selling_agent_email] => Array
(
[0] => adrian.vasquez.mil@gmail.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Adrian Vasquez
)
[rets_selling_agent_mlsid] => Array
(
[0] => 52037
)
[rets_selling_agent_mui] => Array
(
[0] => 16405843
)
[rets_selling_office_mlsid] => Array
(
[0] => RMXA
)
[rets_selling_office_mui] => Array
(
[0] => 12873659
)
[rets_selling_office_name] => Array
(
[0] => RE/MAX ALOHA HOMES
)
[rets_selling_office_phone] => Array
(
[0] => (808) 393-9966
)
[_thumbnail_id] => Array
(
[0] => 22577269
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446