Move in ready town-home located on ground floor that is close distance to Mililani shopping center, schools and Schofield Military base. Enjoy the natural breeze coming from the living room back and masters bedroom patio with a beautiful site to see to feel the tranquility of the natural resources with no neighbors in the back patio. The Northbrook Melemanu Woodland community features community pool, tennis court, recreation center for events, resident manager, security guard, club house and bbq area. The neighborhood building also contains it’s own backyard paradise view that offers a beautiful landscaping, spacious green areas surrounding the unit. Must see to believe!
Listing by: RE/MAX ALOHA HOMES (808) 393-9966
array(177) {
["agency"]=>
array(1) {
[0]=>
string(18) "RE/MAX ALOHA HOMES"
}
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "175100.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "106400.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "281500.00"
}
["assn_fee_inclusions"]=>
array(1) {
[0]=>
string(2) "17"
}
["association_fees"]=>
array(1) {
[0]=>
string(2) "17"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "2"
}
["building_name"]=>
array(1) {
[0]=>
string(19) "Northbrook-melemanu"
}
["building_style"]=>
array(1) {
[0]=>
string(17) "Townhouse,Walk-Up"
}
["city"]=>
array(1) {
[0]=>
string(8) "Mililani"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(4) "None"
}
["elementary_school"]=>
array(1) {
[0]=>
string(5) "Kapaa"
}
["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"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["high_school"]=>
array(1) {
[0]=>
string(8) "Mililani"
}
["home_exampt"]=>
array(1) {
[0]=>
string(6) "100000"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(2) "97"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(9) "170145.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(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) "2021-09-07"
}
["list_office_name"]=>
array(1) {
[0]=>
string(18) "RE/MAX ALOHA HOMES"
}
["list_price"]=>
array(1) {
[0]=>
string(9) "350000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(3) "896"
}
["location"]=>
array(1) {
[0]=>
string(53) "95-2039 Waikalani Place Unit C104, Mililani, HI 96789"
}
["maintenance_fees"]=>
array(1) {
[0]=>
string(6) "373.08"
}
["middle_school"]=>
array(1) {
[0]=>
string(7) "Wheeler"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202123429"
}
["neighborhood"]=>
array(1) {
[0]=>
string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "2"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(6) "Three+"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "RMXA"
}
["parking_features"]=>
array(1) {
[0]=>
string(27) "Assigned,Covered - 2,Tandem"
}
["possession"]=>
array(1) {
[0]=>
string(33) "45 Days or Less,Seller Lease Back"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96789"
}
["property_condition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["property_type"]=>
array(1) {
[0]=>
string(15) "condo_townhouse"
}
["property_type_label"]=>
array(1) {
[0]=>
string(15) "Condo Townhouse"
}
["region"]=>
array(1) {
[0]=>
string(7) "Central"
}
["rets_association_fee"]=>
array(1) {
[0]=>
string(2) "17"
}
["rets_association_fee_total"]=>
array(1) {
[0]=>
string(3) "390"
}
["rets_baths_full"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_baths_half"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_baths_total"]=>
array(1) {
[0]=>
string(4) "1.00"
}
["rets_beds_total"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_building_name"]=>
array(1) {
[0]=>
string(19) "Northbrook-melemanu"
}
["rets_city"]=>
array(1) {
[0]=>
string(8) "Mililani"
}
["rets_co_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 393-9966"
}
["rets_co_list_agent_email"]=>
array(1) {
[0]=>
string(26) "raeni@alohahomesagents.com"
}
["rets_co_list_agent_full_name"]=>
array(1) {
[0]=>
string(11) "Raeni Escue"
}
["rets_co_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "50470"
}
["rets_co_list_agent_mui"]=>
array(1) {
[0]=>
string(8) "15250364"
}
["rets_co_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "RMXA"
}
["rets_co_list_office_mui"]=>
array(1) {
[0]=>
string(8) "12873659"
}
["rets_co_list_office_name"]=>
array(1) {
[0]=>
string(18) "RE/MAX ALOHA HOMES"
}
["rets_co_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 393-9966"
}
["rets_condo_parking_unit"]=>
array(1) {
[0]=>
string(6) "45, 47"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(9) "370000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(2) "15"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_elementary_school"]=>
array(1) {
[0]=>
string(5) "Kapaa"
}
["rets_floor_number"]=>
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_high_school"]=>
array(1) {
[0]=>
string(8) "Mililani"
}
["rets_id"]=>
array(1) {
[0]=>
string(8) "16152234"
}
["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) "350000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2021-09-07"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(9) "170145.00"
}
["rets_maintenance_expense"]=>
array(1) {
[0]=>
string(6) "373.08"
}
["rets_management_company_name"]=>
array(1) {
[0]=>
string(7) "Associa"
}
["rets_management_company_phone"]=>
array(1) {
[0]=>
string(12) "808-836-0911"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2021-11-08T14:54:40.450"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16152234"
}
["rets_middle_or_junior_school"]=>
array(1) {
[0]=>
string(7) "Wheeler"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202123429"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2021-09-10T09:52:45.573"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(9) "350000.00"
}
["rets_owner_occupancy_percentage"]=>
array(1) {
[0]=>
string(2) "42"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-9-5-012-030-0048"
}
["rets_parking_additional"]=>
array(1) {
[0]=>
string(1) "0"
}
["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) "21"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2021-09-10T09:56:58.127"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96789"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16152234"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(214) "Fist Open House Sunday September 12th at 2-5pm. To request private showings, schedule through via Showing Time only, and listing agent will be present. Property is subject to replacement property and selling as is."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(679) "Move in ready town-home located on ground floor that is close distance to Mililani shopping center, schools and Schofield Military base. Enjoy the natural breeze coming from the living room back and masters bedroom patio with a beautiful site to see to feel the tranquility of the natural resources with no neighbors in the back patio. The Northbrook Melemanu Woodland community features community pool, tennis court, recreation center for events, resident manager, security guard, club house and bbq area. The neighborhood building also contains it's own backyard paradise view that offers a beautiful landscaping, spacious green areas surrounding the unit. Must see to believe!"
}
["rets_room_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(2) "97"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(3) "799"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(3) "896"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2021-11-08T14:54:40.450"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2021-11-08"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(9) "Waikalani"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(7) "95-2039"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(3) "2.5"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(5) "52.94"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "281500.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "175100.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "106400.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(6) "100000"
}
["rets_tax_paid_by_seller_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tax_year"]=>
array(1) {
[0]=>
string(4) "2021"
}
["rets_thumbnail_url"]=>
array(1) {
[0]=>
string(81) "https://cdn.rets.ci/marcusrealty-images/16152234/0b2d6ac08a363a7f0ce6083560504b12"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "195"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(2) "48"
}
["rets_tmk_division"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tmk_parcel"]=>
array(1) {
[0]=>
string(2) "30"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "5"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "9"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(2) "12"
}
["rets_unit_number"]=>
array(1) {
[0]=>
string(4) "C104"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1973"
}
["security"]=>
array(1) {
[0]=>
string(15) "Security Patrol"
}
["state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["street_name"]=>
array(1) {
[0]=>
string(9) "Waikalani"
}
["street_number"]=>
array(1) {
[0]=>
string(7) "95-2039"
}
["street_suffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["terms_accept"]=>
array(1) {
[0]=>
string(24) "Cash,Conventional,FHA,VA"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-9-5-012-030-0048"
}
["unit"]=>
array(1) {
[0]=>
string(17) "Ground Floor Unit"
}
["unit_number"]=>
array(1) {
[0]=>
string(4) "C104"
}
["view"]=>
array(1) {
[0]=>
string(6) "Garden"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16152234"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202123429"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1636419349"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1973"
}
["zoning"]=>
array(1) {
[0]=>
string(30) "11 - A-1 Low Density Apartment"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(2397) "a:147:{i:0;i:20715690;i:1;i:20715691;i:2;i:20715692;i:3;i:20715693;i:4;i:20715694;i:5;i:20715695;i:6;i:20715696;i:7;i:20715697;i:8;i:20715698;i:9;i:20715699;i:10;i:20715700;i:11;i:20715701;i:12;i:20715702;i:13;i:20715703;i:14;i:20715704;i:15;i:20715705;i:16;i:20715706;i:17;i:20715707;i:18;i:20715708;i:19;i:20715709;i:20;i:20715710;i:21;i:20715728;i:22;i:20715729;i:23;i:20715730;i:24;i:20715731;i:25;i:20715732;i:26;i:20715733;i:27;i:20715734;i:28;i:20715735;i:29;i:20715736;i:30;i:20715737;i:31;i:20715738;i:32;i:20715739;i:33;i:20715740;i:34;i:20715741;i:35;i:20715742;i:36;i:20715743;i:37;i:20715744;i:38;i:20715745;i:39;i:20715746;i:40;i:20715747;i:41;i:20715748;i:42;i:20715749;i:43;i:20715750;i:44;i:20715751;i:45;i:20715752;i:46;i:20715753;i:47;i:20715754;i:48;i:20715755;i:49;i:20715756;i:50;i:20715757;i:51;i:20715758;i:52;i:20715759;i:53;i:20715760;i:54;i:20715761;i:55;i:20715762;i:56;i:20715763;i:57;i:20715764;i:58;i:20715765;i:59;i:20715766;i:60;i:20715767;i:61;i:20715768;i:62;i:20715769;i:63;i:20723136;i:64;i:20723137;i:65;i:20723138;i:66;i:20723139;i:67;i:20723140;i:68;i:20723141;i:69;i:20723142;i:70;i:20723143;i:71;i:20723144;i:72;i:20723145;i:73;i:20723146;i:74;i:20723147;i:75;i:20723148;i:76;i:20723149;i:77;i:20723150;i:78;i:20723151;i:79;i:20723152;i:80;i:20723153;i:81;i:20723154;i:82;i:20723155;i:83;i:20723156;i:84;i:20736001;i:85;i:20736002;i:86;i:20736003;i:87;i:20736004;i:88;i:20736005;i:89;i:20736006;i:90;i:20736007;i:91;i:20736008;i:92;i:20736009;i:93;i:20736010;i:94;i:20736011;i:95;i:20736012;i:96;i:20736013;i:97;i:20736014;i:98;i:20736015;i:99;i:20736016;i:100;i:20736017;i:101;i:20736018;i:102;i:20736019;i:103;i:20736020;i:104;i:20736021;i:105;i:20795320;i:106;i:20795321;i:107;i:20795322;i:108;i:20795323;i:109;i:20795324;i:110;i:20795325;i:111;i:20795326;i:112;i:20795327;i:113;i:20795328;i:114;i:20795329;i:115;i:20795330;i:116;i:20795331;i:117;i:20795332;i:118;i:20795333;i:119;i:20795334;i:120;i:20795335;i:121;i:20795336;i:122;i:20795337;i:123;i:20795338;i:124;i:20795339;i:125;i:20795340;i:126;i:21121040;i:127;i:21121041;i:128;i:21121042;i:129;i:21121043;i:130;i:21121044;i:131;i:21121045;i:132;i:21121046;i:133;i:21121047;i:134;i:21121048;i:135;i:21121049;i:136;i:21121050;i:137;i:21121051;i:138;i:21121052;i:139;i:21121053;i:140;i:21121054;i:141;i:21121055;i:142;i:21121056;i:143;i:21121057;i:144;i:21121058;i:145;i:21121059;i:146;i:21121060;}"
}
["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_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(69) "https://app.immoviewer.com/landing/unbranded/61404a4cd600cb6001c39cd7"
}
["virtual_tour"]=>
array(1) {
[0]=>
string(69) "https://app.immoviewer.com/landing/unbranded/61404a4cd600cb6001c39cd7"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2021-09-18"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2021-11-08"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(9) "370000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-09-07"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2021-11-08"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 261-4747"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(25) "kaleo@hawaiirealtygrp.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(18) "Joseph Kaleo Ahina"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "38082"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "3481518"
}
["rets_selling_agent_remarks"]=>
array(1) {
[0]=>
string(92) "Amazing realtor to have work with. Pleasure to have a smooth transaction with Kaleo (Joseph)"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "HGRP"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(7) "9647176"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(23) "Hawaii Realty Group LLC"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 261-4747"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(6) "635.28"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "21121040"
}
}
Array
(
[agency] => Array
(
[0] => RE/MAX ALOHA HOMES
)
[assd_val_imprv] => Array
(
[0] => 175100.00
)
[assd_val_land] => Array
(
[0] => 106400.00
)
[assd_val_total] => Array
(
[0] => 281500.00
)
[assn_fee_inclusions] => Array
(
[0] => 17
)
[association_fees] => Array
(
[0] => 17
)
[bedrooms] => Array
(
[0] => 2
)
[building_name] => Array
(
[0] => Northbrook-melemanu
)
[building_style] => Array
(
[0] => Townhouse,Walk-Up
)
[city] => Array
(
[0] => Mililani
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => None
)
[elementary_school] => Array
(
[0] => Kapaa
)
[floor_covering] => Array
(
[0] => Vinyl,W/W Carpet
)
[frontage] => Array
(
[0] => Other
)
[full_baths] => Array
(
[0] => 1
)
[half_baths] => Array
(
[0] => 0
)
[high_school] => Array
(
[0] => Mililani
)
[home_exampt] => Array
(
[0] => 100000
)
[lanai_sf] => Array
(
[0] => 97
)
[land_area_sf] => Array
(
[0] => 170145.00
)
[land_recorded] => Array
(
[0] => Land Court
)
[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] => 2021-09-07
)
[list_office_name] => Array
(
[0] => RE/MAX ALOHA HOMES
)
[list_price] => Array
(
[0] => 350000.00
)
[living_sf] => Array
(
[0] => 896
)
[location] => Array
(
[0] => 95-2039 Waikalani Place Unit C104, Mililani, HI 96789
)
[maintenance_fees] => Array
(
[0] => 373.08
)
[middle_school] => Array
(
[0] => Wheeler
)
[mls_] => Array
(
[0] => 202123429
)
[neighborhood] => Array
(
[0] => WAIPIO ACRES/WAIKALANI WOODLANDS
)
[number_of_parking_spaces] => Array
(
[0] => 2
)
[number_of_stories] => Array
(
[0] => Three+
)
[office_mls_id] => Array
(
[0] => RMXA
)
[parking_features] => Array
(
[0] => Assigned,Covered - 2,Tandem
)
[possession] => Array
(
[0] => 45 Days or Less,Seller Lease Back
)
[postal_code] => Array
(
[0] => 96789
)
[property_condition] => Array
(
[0] => Average
)
[property_type] => Array
(
[0] => condo_townhouse
)
[property_type_label] => Array
(
[0] => Condo Townhouse
)
[region] => Array
(
[0] => Central
)
[rets_association_fee] => Array
(
[0] => 17
)
[rets_association_fee_total] => Array
(
[0] => 390
)
[rets_baths_full] => Array
(
[0] => 1
)
[rets_baths_half] => Array
(
[0] => 0
)
[rets_baths_total] => Array
(
[0] => 1.00
)
[rets_beds_total] => Array
(
[0] => 2
)
[rets_building_name] => Array
(
[0] => Northbrook-melemanu
)
[rets_city] => Array
(
[0] => Mililani
)
[rets_co_list_agent_direct_work_phone] => Array
(
[0] => (808) 393-9966
)
[rets_co_list_agent_email] => Array
(
[0] => raeni@alohahomesagents.com
)
[rets_co_list_agent_full_name] => Array
(
[0] => Raeni Escue
)
[rets_co_list_agent_mlsid] => Array
(
[0] => 50470
)
[rets_co_list_agent_mui] => Array
(
[0] => 15250364
)
[rets_co_list_office_mlsid] => Array
(
[0] => RMXA
)
[rets_co_list_office_mui] => Array
(
[0] => 12873659
)
[rets_co_list_office_name] => Array
(
[0] => RE/MAX ALOHA HOMES
)
[rets_co_list_office_phone] => Array
(
[0] => (808) 393-9966
)
[rets_condo_parking_unit] => Array
(
[0] => 45, 47
)
[rets_current_price] => Array
(
[0] => 370000.00
)
[rets_dom] => Array
(
[0] => 15
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_elementary_school] => Array
(
[0] => Kapaa
)
[rets_floor_number] => Array
(
[0] => 0
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_high_school] => Array
(
[0] => Mililani
)
[rets_id] => Array
(
[0] => 16152234
)
[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] => 350000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2021-09-07
)
[rets_lot_size_area] => Array
(
[0] => 170145.00
)
[rets_maintenance_expense] => Array
(
[0] => 373.08
)
[rets_management_company_name] => Array
(
[0] => Associa
)
[rets_management_company_phone] => Array
(
[0] => 808-836-0911
)
[rets_matrix_modified_dt] => Array
(
[0] => 2021-11-08T14:54:40.450
)
[rets_matrix_unique_id] => Array
(
[0] => 16152234
)
[rets_middle_or_junior_school] => Array
(
[0] => Wheeler
)
[rets_mls_number] => Array
(
[0] => 202123429
)
[rets_neighbourhood] => Array
(
[0] => WAIPIO ACRES/WAIKALANI WOODLANDS
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2021-09-10T09:52:45.573
)
[rets_original_list_price] => Array
(
[0] => 350000.00
)
[rets_owner_occupancy_percentage] => Array
(
[0] => 42
)
[rets_parcel_number] => Array
(
[0] => 1-9-5-012-030-0048
)
[rets_parking_additional] => Array
(
[0] => 0
)
[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] => 21
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2021-09-10T09:56:58.127
)
[rets_postal_code] => Array
(
[0] => 96789
)
[rets_primary_key] => Array
(
[0] => 16152234
)
[rets_private_remarks] => Array
(
[0] => Fist Open House Sunday September 12th at 2-5pm. To request private showings, schedule through via Showing Time only, and listing agent will be present. Property is subject to replacement property and selling as is.
)
[rets_public_remarks] => Array
(
[0] => Move in ready town-home located on ground floor that is close distance to Mililani shopping center, schools and Schofield Military base. Enjoy the natural breeze coming from the living room back and masters bedroom patio with a beautiful site to see to feel the tranquility of the natural resources with no neighbors in the back patio. The Northbrook Melemanu Woodland community features community pool, tennis court, recreation center for events, resident manager, security guard, club house and bbq area. The neighborhood building also contains it's own backyard paradise view that offers a beautiful landscaping, spacious green areas surrounding the unit. Must see to believe!
)
[rets_room_count] => Array
(
[0] => 0
)
[rets_sqft_lanai_open] => Array
(
[0] => 97
)
[rets_sqft_roofed_living] => Array
(
[0] => 799
)
[rets_sqft_total] => Array
(
[0] => 896
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2021-11-08T14:54:40.450
)
[rets_status_contractual_search_date] => Array
(
[0] => 2021-11-08
)
[rets_street_name] => Array
(
[0] => Waikalani
)
[rets_street_number] => Array
(
[0] => 95-2039
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5
)
[rets_tax_amount] => Array
(
[0] => 52.94
)
[rets_tax_assessed_value] => Array
(
[0] => 281500.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 175100.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 106400.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 100000
)
[rets_tax_paid_by_seller_yn] => Array
(
[0] => 1
)
[rets_tax_year] => Array
(
[0] => 2021
)
[rets_thumbnail_url] => Array
(
[0] => https://cdn.rets.ci/marcusrealty-images/16152234/0b2d6ac08a363a7f0ce6083560504b12
)
[rets_tmk_area] => Array
(
[0] => 195
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 48
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 30
)
[rets_tmk_section] => Array
(
[0] => 5
)
[rets_tmk_zone] => Array
(
[0] => 9
)
[rets_tmkplat] => Array
(
[0] => 12
)
[rets_unit_number] => Array
(
[0] => C104
)
[rets_year_built] => Array
(
[0] => 1973
)
[security] => Array
(
[0] => Security Patrol
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Waikalani
)
[street_number] => Array
(
[0] => 95-2039
)
[street_suffix] => Array
(
[0] => Place
)
[terms_accept] => Array
(
[0] => Cash,Conventional,FHA,VA
)
[tmk] => Array
(
[0] => 1-9-5-012-030-0048
)
[unit] => Array
(
[0] => Ground Floor Unit
)
[unit_number] => Array
(
[0] => C104
)
[view] => Array
(
[0] => Garden
)
[wpp::rets_pk] => Array
(
[0] => 16152234
)
[wpp_gpid] => Array
(
[0] => 202123429
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1636419349
)
[year_built] => Array
(
[0] => 1973
)
[zoning] => Array
(
[0] => 11 - A-1 Low Density Apartment
)
[new_attached_media] => Array
(
[0] => a:147:{i:0;i:20715690;i:1;i:20715691;i:2;i:20715692;i:3;i:20715693;i:4;i:20715694;i:5;i:20715695;i:6;i:20715696;i:7;i:20715697;i:8;i:20715698;i:9;i:20715699;i:10;i:20715700;i:11;i:20715701;i:12;i:20715702;i:13;i:20715703;i:14;i:20715704;i:15;i:20715705;i:16;i:20715706;i:17;i:20715707;i:18;i:20715708;i:19;i:20715709;i:20;i:20715710;i:21;i:20715728;i:22;i:20715729;i:23;i:20715730;i:24;i:20715731;i:25;i:20715732;i:26;i:20715733;i:27;i:20715734;i:28;i:20715735;i:29;i:20715736;i:30;i:20715737;i:31;i:20715738;i:32;i:20715739;i:33;i:20715740;i:34;i:20715741;i:35;i:20715742;i:36;i:20715743;i:37;i:20715744;i:38;i:20715745;i:39;i:20715746;i:40;i:20715747;i:41;i:20715748;i:42;i:20715749;i:43;i:20715750;i:44;i:20715751;i:45;i:20715752;i:46;i:20715753;i:47;i:20715754;i:48;i:20715755;i:49;i:20715756;i:50;i:20715757;i:51;i:20715758;i:52;i:20715759;i:53;i:20715760;i:54;i:20715761;i:55;i:20715762;i:56;i:20715763;i:57;i:20715764;i:58;i:20715765;i:59;i:20715766;i:60;i:20715767;i:61;i:20715768;i:62;i:20715769;i:63;i:20723136;i:64;i:20723137;i:65;i:20723138;i:66;i:20723139;i:67;i:20723140;i:68;i:20723141;i:69;i:20723142;i:70;i:20723143;i:71;i:20723144;i:72;i:20723145;i:73;i:20723146;i:74;i:20723147;i:75;i:20723148;i:76;i:20723149;i:77;i:20723150;i:78;i:20723151;i:79;i:20723152;i:80;i:20723153;i:81;i:20723154;i:82;i:20723155;i:83;i:20723156;i:84;i:20736001;i:85;i:20736002;i:86;i:20736003;i:87;i:20736004;i:88;i:20736005;i:89;i:20736006;i:90;i:20736007;i:91;i:20736008;i:92;i:20736009;i:93;i:20736010;i:94;i:20736011;i:95;i:20736012;i:96;i:20736013;i:97;i:20736014;i:98;i:20736015;i:99;i:20736016;i:100;i:20736017;i:101;i:20736018;i:102;i:20736019;i:103;i:20736020;i:104;i:20736021;i:105;i:20795320;i:106;i:20795321;i:107;i:20795322;i:108;i:20795323;i:109;i:20795324;i:110;i:20795325;i:111;i:20795326;i:112;i:20795327;i:113;i:20795328;i:114;i:20795329;i:115;i:20795330;i:116;i:20795331;i:117;i:20795332;i:118;i:20795333;i:119;i:20795334;i:120;i:20795335;i:121;i:20795336;i:122;i:20795337;i:123;i:20795338;i:124;i:20795339;i:125;i:20795340;i:126;i:21121040;i:127;i:21121041;i:128;i:21121042;i:129;i:21121043;i:130;i:21121044;i:131;i:21121045;i:132;i:21121046;i:133;i:21121047;i:134;i:21121048;i:135;i:21121049;i:136;i:21121050;i:137;i:21121051;i:138;i:21121052;i:139;i:21121053;i:140;i:21121054;i:141;i:21121055;i:142;i:21121056;i:143;i:21121057;i:144;i:21121058;i:145;i:21121059;i:146;i:21121060;}
)
[rets_open_house_count] => Array
(
[0] => 2
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_open_house_upcoming] => Array
(
[0] =>
)
[rets_virtual_tour_url_unbranded] => Array
(
[0] => https://app.immoviewer.com/landing/unbranded/61404a4cd600cb6001c39cd7
)
[virtual_tour] => Array
(
[0] => https://app.immoviewer.com/landing/unbranded/61404a4cd600cb6001c39cd7
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2021-09-18
)
[rets_close_date] => Array
(
[0] => 2021-11-08
)
[rets_close_price] => Array
(
[0] => 370000.00
)
[rets_expiration_date] => Array
(
[0] => 2022-09-07
)
[rets_off_market_date] => Array
(
[0] => 2021-11-08
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 261-4747
)
[rets_selling_agent_email] => Array
(
[0] => kaleo@hawaiirealtygrp.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Joseph Kaleo Ahina
)
[rets_selling_agent_mlsid] => Array
(
[0] => 38082
)
[rets_selling_agent_mui] => Array
(
[0] => 3481518
)
[rets_selling_agent_remarks] => Array
(
[0] => Amazing realtor to have work with. Pleasure to have a smooth transaction with Kaleo (Joseph)
)
[rets_selling_office_mlsid] => Array
(
[0] => HGRP
)
[rets_selling_office_mui] => Array
(
[0] => 9647176
)
[rets_selling_office_name] => Array
(
[0] => Hawaii Realty Group LLC
)
[rets_selling_office_phone] => Array
(
[0] => (808) 261-4747
)
[rets_tax_annual_amount] => Array
(
[0] => 635.28
)
[_thumbnail_id] => Array
(
[0] => 21121040
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446