Welcome to your freshly renovated new home! Leave your slippers outside as you enter the inviting open concept living room and kitchen, complete with new appliances, where you and your ohana will share quality time together over great food and drinks. Take a steaming shower beneath one of two luxurious rainfall showers or enjoy a nice soak in the bath after a stressful day. Conveniently located in Village Park, this home is moments away from groceries, shopping, restaurants, and parks. It is also a short drive to the freeway or to Waikele Shopping Center.
*Look for virtual tour link.* Offers due no later than Mon. 3/28 @12pm.
Listing by: eXp Realty
array(156) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "175600.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "551700.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "727300.00"
}
["assn_fee_inclusions"]=>
array(1) {
[0]=>
string(2) "12"
}
["association_fees"]=>
array(1) {
[0]=>
string(2) "12"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "3"
}
["building_style"]=>
array(1) {
[0]=>
string(20) "Detach Single Family"
}
["city"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(45) "Property Disclosure Stmt,Relative of Licensee"
}
["easements"]=>
array(1) {
[0]=>
string(4) "None"
}
["floor_covering"]=>
array(1) {
[0]=>
string(5) "Vinyl"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "2"
}
["furnished"]=>
array(1) {
[0]=>
string(4) "None"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["home_exampt"]=>
array(1) {
[0]=>
string(1) "0"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(7) "3389.00"
}
["land_recorded"]=>
array(1) {
[0]=>
string(14) "Regular System"
}
["land_tenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["list_agent_email"]=>
array(1) {
[0]=>
string(25) "justin.kong@exprealty.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(13) "Justin K Kong"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 725-2794"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-03-16"
}
["list_office_name"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["list_price"]=>
array(1) {
[0]=>
string(9) "775000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "1024"
}
["location"]=>
array(1) {
[0]=>
string(39) "94-597 Kaiewa Street, Waipahu, HI 96797"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202204786"
}
["neighborhood"]=>
array(1) {
[0]=>
string(12) "VILLAGE PARK"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "2"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(3) "One"
}
["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(4) "None"
}
["possession"]=>
array(1) {
[0]=>
string(10) "At Closing"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96797"
}
["property_condition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["property_type"]=>
array(1) {
[0]=>
string(13) "single_family"
}
["property_type_label"]=>
array(1) {
[0]=>
string(13) "single_family"
}
["region"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["rets_association_community_name"]=>
array(1) {
[0]=>
string(34) "Village Park Community Association"
}
["rets_association_fee"]=>
array(1) {
[0]=>
string(2) "12"
}
["rets_association_fee_total"]=>
array(1) {
[0]=>
string(2) "12"
}
["rets_association_phone"]=>
array(1) {
[0]=>
string(13) "(808)531-6847"
}
["rets_baths_full"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_baths_half"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_baths_total"]=>
array(1) {
[0]=>
string(4) "2.00"
}
["rets_beds_total"]=>
array(1) {
[0]=>
string(1) "3"
}
["rets_city"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["rets_compensation_method"]=>
array(1) {
[0]=>
string(3) "N/A"
}
["rets_condo_property_regime_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(9) "875000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(2) "15"
}
["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) "16507015"
}
["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) "1"
}
["rets_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 725-2794"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(25) "justin.kong@exprealty.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(13) "Justin K Kong"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "51641"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(8) "16096258"
}
["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(9) "775000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-03-16"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(7) "3389.00"
}
["rets_management_company_name"]=>
array(1) {
[0]=>
string(21) "Cadmus Properties Co."
}
["rets_management_company_phone"]=>
array(1) {
[0]=>
string(13) "(808)531-6847"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-04-29T08:11:13.593"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16507015"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202204786"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(12) "VILLAGE PARK"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-03-15T15:48:58.593"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(9) "775000.00"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-9-4-120-137-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-13T23:34:51.740"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96797"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-03-16T01:09:22.423"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16507015"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(320) "Vacant and easy to show. Schedule through showtime. Virtual tour also available in MLS. Call, text, or email Justin with questions. Seller asks to consider Pam Sato w/ Title Guaranty. Offers due Mon. 3/28 @12pm. Please allow seller at least 1 day to respond. Please also note seller's agent is relative of seller."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(641) "Welcome to your freshly renovated new home! Leave your slippers outside as you enter the inviting open concept living room and kitchen, complete with new appliances, where you and your ohana will share quality time together over great food and drinks. Take a steaming shower beneath one of two luxurious rainfall showers or enjoy a nice soak in the bath after a stressful day. Conveniently located in Village Park, this home is moments away from groceries, shopping, restaurants, and parks. It is also a short drive to the freeway or to Waikele Shopping Center.
*Look for virtual tour link.* Offers due no later than Mon. 3/28 @12pm."
}
["rets_room_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "1024"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "1024"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-29T08:11:13.593"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-04-28"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(6) "Kaiewa"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(6) "94-597"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(64) "1$21.392593$-158.029398$151.43$13.33$1.00$z_EsoJRE3bhIfdPw-FDUEQ"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(4) "2.5%"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "212.13"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "2545.56"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "727300.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "175600.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "551700.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/16507015/3faa1a743c93acbc0894d2409b599cfa"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "194"
}
["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(3) "137"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "9"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(3) "120"
}
["rets_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(40) "https://player.vimeo.com/video/688080172"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1985"
}
["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) "Kaiewa"
}
["street_number"]=>
array(1) {
[0]=>
string(6) "94-597"
}
["street_suffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["terms_accept"]=>
array(1) {
[0]=>
string(39) "Cash,Conventional,FHA,USDA Financing,VA"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-9-4-120-137-0000"
}
["topography"]=>
array(1) {
[0]=>
string(5) "Clear"
}
["view"]=>
array(1) {
[0]=>
string(4) "None"
}
["virtual_tour"]=>
array(1) {
[0]=>
string(40) "https://player.vimeo.com/video/688080172"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16507015"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202204786"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1651255896"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1985"
}
["zoning"]=>
array(1) {
[0]=>
string(29) "05 - R-5 Residential District"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(1683) "a:105:{i:0;i:21829829;i:1;i:21829830;i:2;i:21829831;i:3;i:21829832;i:4;i:21829833;i:5;i:21829834;i:6;i:21829835;i:7;i:21829836;i:8;i:21829837;i:9;i:21829838;i:10;i:21829839;i:11;i:21829840;i:12;i:21829841;i:13;i:21829842;i:14;i:21829843;i:15;i:21829844;i:16;i:21829845;i:17;i:21829846;i:18;i:21829847;i:19;i:21829848;i:20;i:21829849;i:21;i:21829850;i:22;i:21829851;i:23;i:21829852;i:24;i:21829853;i:25;i:21829854;i:26;i:21829855;i:27;i:21829856;i:28;i:21829857;i:29;i:21829858;i:30;i:21829859;i:31;i:21829860;i:32;i:21829861;i:33;i:21829862;i:34;i:21829863;i:35;i:21829864;i:36;i:21829865;i:37;i:21829866;i:38;i:21829867;i:39;i:21829868;i:40;i:21829869;i:41;i:21829870;i:42;i:21864030;i:43;i:21864031;i:44;i:21864032;i:45;i:21864033;i:46;i:21864034;i:47;i:21864035;i:48;i:21864036;i:49;i:21864037;i:50;i:21864038;i:51;i:21864039;i:52;i:21864040;i:53;i:21864041;i:54;i:21864042;i:55;i:21864043;i:56;i:21864044;i:57;i:21864045;i:58;i:21864046;i:59;i:21864047;i:60;i:21864048;i:61;i:21864049;i:62;i:21864050;i:63;i:21931031;i:64;i:21931032;i:65;i:21931033;i:66;i:21931034;i:67;i:21931035;i:68;i:21931036;i:69;i:21931037;i:70;i:21931038;i:71;i:21931039;i:72;i:21931040;i:73;i:21931041;i:74;i:21931042;i:75;i:21931043;i:76;i:21931044;i:77;i:21931045;i:78;i:21931046;i:79;i:21931047;i:80;i:21931048;i:81;i:21931049;i:82;i:21931050;i:83;i:21931051;i:84;i:22118237;i:85;i:22118238;i:86;i:22118239;i:87;i:22118240;i:88;i:22118241;i:89;i:22118242;i:90;i:22118243;i:91;i:22118244;i:92;i:22118245;i:93;i:22118246;i:94;i:22118247;i:95;i:22118248;i:96;i:22118249;i:97;i:22118250;i:98;i:22118251;i:99;i:22118252;i:100;i:22118253;i:101;i:22118254;i:102;i:22118255;i:103;i:22118256;i:104;i:22118257;}"
}
["rets_open_house_count"]=>
array(1) {
[0]=>
string(1) "7"
}
["rets_active_open_house_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_open_house_upcoming"]=>
array(1) {
[0]=>
string(0) ""
}
["rets_pending_date"]=>
array(1) {
[0]=>
string(10) "2022-03-30"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-04-28"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(9) "875000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2023-03-16"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-04-28"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 393-9966"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(22) "Alma.Eustace@Remax.net"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(12) "Alma Eustace"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "48167"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(8) "12443891"
}
["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) "22118237"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 175600.00
)
[assd_val_land] => Array
(
[0] => 551700.00
)
[assd_val_total] => Array
(
[0] => 727300.00
)
[assn_fee_inclusions] => Array
(
[0] => 12
)
[association_fees] => Array
(
[0] => 12
)
[bedrooms] => Array
(
[0] => 3
)
[building_style] => Array
(
[0] => Detach Single Family
)
[city] => Array
(
[0] => Waipahu
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Property Disclosure Stmt,Relative of Licensee
)
[easements] => Array
(
[0] => None
)
[floor_covering] => Array
(
[0] => Vinyl
)
[full_baths] => Array
(
[0] => 2
)
[furnished] => Array
(
[0] => None
)
[half_baths] => Array
(
[0] => 0
)
[home_exampt] => Array
(
[0] => 0
)
[land_area_sf] => Array
(
[0] => 3389.00
)
[land_recorded] => Array
(
[0] => Regular System
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => justin.kong@exprealty.com
)
[list_agent_name] => Array
(
[0] => Justin K Kong
)
[list_agent_phone_number] => Array
(
[0] => (808) 725-2794
)
[list_date] => Array
(
[0] => 2022-03-16
)
[list_office_name] => Array
(
[0] => eXp Realty
)
[list_price] => Array
(
[0] => 775000.00
)
[living_sf] => Array
(
[0] => 1024
)
[location] => Array
(
[0] => 94-597 Kaiewa Street, Waipahu, HI 96797
)
[mls_] => Array
(
[0] => 202204786
)
[neighborhood] => Array
(
[0] => VILLAGE PARK
)
[number_of_parking_spaces] => Array
(
[0] => 2
)
[number_of_stories] => Array
(
[0] => One
)
[office_mls_id] => Array
(
[0] => EXPI
)
[parking_features] => Array
(
[0] => 2 Car,Garage,Street
)
[pool_] => Array
(
[0] => None
)
[possession] => Array
(
[0] => At Closing
)
[postal_code] => Array
(
[0] => 96797
)
[property_condition] => Array
(
[0] => Excellent
)
[property_type] => Array
(
[0] => single_family
)
[property_type_label] => Array
(
[0] => single_family
)
[region] => Array
(
[0] => Waipahu
)
[rets_association_community_name] => Array
(
[0] => Village Park Community Association
)
[rets_association_fee] => Array
(
[0] => 12
)
[rets_association_fee_total] => Array
(
[0] => 12
)
[rets_association_phone] => Array
(
[0] => (808)531-6847
)
[rets_baths_full] => Array
(
[0] => 2
)
[rets_baths_half] => Array
(
[0] => 0
)
[rets_baths_total] => Array
(
[0] => 2.00
)
[rets_beds_total] => Array
(
[0] => 3
)
[rets_city] => Array
(
[0] => Waipahu
)
[rets_compensation_method] => Array
(
[0] => N/A
)
[rets_condo_property_regime_yn] => Array
(
[0] => 0
)
[rets_current_price] => Array
(
[0] => 875000.00
)
[rets_dom] => Array
(
[0] => 15
)
[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] => 16507015
)
[rets_immoviewer_yn] => Array
(
[0] => 0
)
[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] => justin.kong@exprealty.com
)
[rets_list_agent_full_name] => Array
(
[0] => Justin K Kong
)
[rets_list_agent_mlsid] => Array
(
[0] => 51641
)
[rets_list_agent_mui] => Array
(
[0] => 16096258
)
[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] => 775000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-03-16
)
[rets_lot_size_area] => Array
(
[0] => 3389.00
)
[rets_management_company_name] => Array
(
[0] => Cadmus Properties Co.
)
[rets_management_company_phone] => Array
(
[0] => (808)531-6847
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-04-29T08:11:13.593
)
[rets_matrix_unique_id] => Array
(
[0] => 16507015
)
[rets_mls_number] => Array
(
[0] => 202204786
)
[rets_neighbourhood] => Array
(
[0] => VILLAGE PARK
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-03-15T15:48:58.593
)
[rets_original_list_price] => Array
(
[0] => 775000.00
)
[rets_parcel_number] => Array
(
[0] => 1-9-4-120-137-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-13T23:34:51.740
)
[rets_postal_code] => Array
(
[0] => 96797
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-03-16T01:09:22.423
)
[rets_primary_key] => Array
(
[0] => 16507015
)
[rets_private_remarks] => Array
(
[0] => Vacant and easy to show. Schedule through showtime. Virtual tour also available in MLS. Call, text, or email Justin with questions. Seller asks to consider Pam Sato w/ Title Guaranty. Offers due Mon. 3/28 @12pm. Please allow seller at least 1 day to respond. Please also note seller's agent is relative of seller.
)
[rets_public_remarks] => Array
(
[0] => Welcome to your freshly renovated new home! Leave your slippers outside as you enter the inviting open concept living room and kitchen, complete with new appliances, where you and your ohana will share quality time together over great food and drinks. Take a steaming shower beneath one of two luxurious rainfall showers or enjoy a nice soak in the bath after a stressful day. Conveniently located in Village Park, this home is moments away from groceries, shopping, restaurants, and parks. It is also a short drive to the freeway or to Waikele Shopping Center.
*Look for virtual tour link.* Offers due no later than Mon. 3/28 @12pm.
)
[rets_room_count] => Array
(
[0] => 0
)
[rets_sqft_roofed_living] => Array
(
[0] => 1024
)
[rets_sqft_total] => Array
(
[0] => 1024
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-04-29T08:11:13.593
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-04-28
)
[rets_street_name] => Array
(
[0] => Kaiewa
)
[rets_street_number] => Array
(
[0] => 94-597
)
[rets_street_view_param] => Array
(
[0] => 1$21.392593$-158.029398$151.43$13.33$1.00$z_EsoJRE3bhIfdPw-FDUEQ
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5%
)
[rets_tax_amount] => Array
(
[0] => 212.13
)
[rets_tax_annual_amount] => Array
(
[0] => 2545.56
)
[rets_tax_assessed_value] => Array
(
[0] => 727300.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 175600.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 551700.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/16507015/3faa1a743c93acbc0894d2409b599cfa
)
[rets_tmk_area] => Array
(
[0] => 194
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 0
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 137
)
[rets_tmk_section] => Array
(
[0] => 4
)
[rets_tmk_zone] => Array
(
[0] => 9
)
[rets_tmkplat] => Array
(
[0] => 120
)
[rets_virtual_tour_url_unbranded] => Array
(
[0] => https://player.vimeo.com/video/688080172
)
[rets_year_built] => Array
(
[0] => 1985
)
[setbacks] => Array
(
[0] => C&C
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Kaiewa
)
[street_number] => Array
(
[0] => 94-597
)
[street_suffix] => Array
(
[0] => Street
)
[terms_accept] => Array
(
[0] => Cash,Conventional,FHA,USDA Financing,VA
)
[tmk] => Array
(
[0] => 1-9-4-120-137-0000
)
[topography] => Array
(
[0] => Clear
)
[view] => Array
(
[0] => None
)
[virtual_tour] => Array
(
[0] => https://player.vimeo.com/video/688080172
)
[wpp::rets_pk] => Array
(
[0] => 16507015
)
[wpp_gpid] => Array
(
[0] => 202204786
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1651255896
)
[year_built] => Array
(
[0] => 1985
)
[zoning] => Array
(
[0] => 05 - R-5 Residential District
)
[new_attached_media] => Array
(
[0] => a:105:{i:0;i:21829829;i:1;i:21829830;i:2;i:21829831;i:3;i:21829832;i:4;i:21829833;i:5;i:21829834;i:6;i:21829835;i:7;i:21829836;i:8;i:21829837;i:9;i:21829838;i:10;i:21829839;i:11;i:21829840;i:12;i:21829841;i:13;i:21829842;i:14;i:21829843;i:15;i:21829844;i:16;i:21829845;i:17;i:21829846;i:18;i:21829847;i:19;i:21829848;i:20;i:21829849;i:21;i:21829850;i:22;i:21829851;i:23;i:21829852;i:24;i:21829853;i:25;i:21829854;i:26;i:21829855;i:27;i:21829856;i:28;i:21829857;i:29;i:21829858;i:30;i:21829859;i:31;i:21829860;i:32;i:21829861;i:33;i:21829862;i:34;i:21829863;i:35;i:21829864;i:36;i:21829865;i:37;i:21829866;i:38;i:21829867;i:39;i:21829868;i:40;i:21829869;i:41;i:21829870;i:42;i:21864030;i:43;i:21864031;i:44;i:21864032;i:45;i:21864033;i:46;i:21864034;i:47;i:21864035;i:48;i:21864036;i:49;i:21864037;i:50;i:21864038;i:51;i:21864039;i:52;i:21864040;i:53;i:21864041;i:54;i:21864042;i:55;i:21864043;i:56;i:21864044;i:57;i:21864045;i:58;i:21864046;i:59;i:21864047;i:60;i:21864048;i:61;i:21864049;i:62;i:21864050;i:63;i:21931031;i:64;i:21931032;i:65;i:21931033;i:66;i:21931034;i:67;i:21931035;i:68;i:21931036;i:69;i:21931037;i:70;i:21931038;i:71;i:21931039;i:72;i:21931040;i:73;i:21931041;i:74;i:21931042;i:75;i:21931043;i:76;i:21931044;i:77;i:21931045;i:78;i:21931046;i:79;i:21931047;i:80;i:21931048;i:81;i:21931049;i:82;i:21931050;i:83;i:21931051;i:84;i:22118237;i:85;i:22118238;i:86;i:22118239;i:87;i:22118240;i:88;i:22118241;i:89;i:22118242;i:90;i:22118243;i:91;i:22118244;i:92;i:22118245;i:93;i:22118246;i:94;i:22118247;i:95;i:22118248;i:96;i:22118249;i:97;i:22118250;i:98;i:22118251;i:99;i:22118252;i:100;i:22118253;i:101;i:22118254;i:102;i:22118255;i:103;i:22118256;i:104;i:22118257;}
)
[rets_open_house_count] => Array
(
[0] => 7
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_open_house_upcoming] => Array
(
[0] =>
)
[rets_pending_date] => Array
(
[0] => 2022-03-30
)
[rets_close_date] => Array
(
[0] => 2022-04-28
)
[rets_close_price] => Array
(
[0] => 875000.00
)
[rets_expiration_date] => Array
(
[0] => 2023-03-16
)
[rets_off_market_date] => Array
(
[0] => 2022-04-28
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 393-9966
)
[rets_selling_agent_email] => Array
(
[0] => Alma.Eustace@Remax.net
)
[rets_selling_agent_full_name] => Array
(
[0] => Alma Eustace
)
[rets_selling_agent_mlsid] => Array
(
[0] => 48167
)
[rets_selling_agent_mui] => Array
(
[0] => 12443891
)
[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] => 22118237
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446