Live, Work & Shop in Central Waipio, Walking Distance to Costco, Central Oahu Regional Park, Public Schools & H2, with short drives to Schofield, Waikele Premium Outlets, Mililani & Pearl City. Inside this 700 Sq Ft, Recently Renovated 2 Bedroom, 1 Bath Condo you’ll enjoy the comforts you seek, from Quartz Countertops, New Cabinets, Stainless Appliances & a Large Flat Screen TV to Vessel Sinks & a Premium Tiled Bathroom, along with a 65 Sq Ft Partially Covered Tiki Patio & Backyard for Outdoor Living. The large Master Bedroom features an En Suite Bathroom while each living space has its dedicated A/C unit. 1 Dedicated Parking Space with plenty of Guest parking in & outside the community.
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446
array(173) {
["agency"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "220100.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "172500.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "392600.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "2"
}
["building_name"]=>
array(1) {
[0]=>
string(22) "Royal Palm at Waipio I"
}
["building_style"]=>
array(1) {
[0]=>
string(36) "Low-Rise 6 or Less Stories,Townhouse"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(21) "Pets Allowed (Verify)"
}
["elementary_school"]=>
array(1) {
[0]=>
string(9) "Kanoelani"
}
["exclusions"]=>
array(1) {
[0]=>
string(12) "Dryer,Washer"
}
["floor_covering"]=>
array(1) {
[0]=>
string(21) "Ceramic Tile,Laminate"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "1"
}
["furnished"]=>
array(1) {
[0]=>
string(4) "None"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["high_school"]=>
array(1) {
[0]=>
string(10) "Pearl City"
}
["home_exampt"]=>
array(1) {
[0]=>
string(3) "Yes"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(2) "65"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(9) "115042.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(20) "staci@staciwolff.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(11) "Staci Wolff"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 725-2794"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2021-04-22"
}
["list_office_name"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["list_price"]=>
array(1) {
[0]=>
string(9) "430000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(3) "773"
}
["location"]=>
array(1) {
[0]=>
string(47) "94-1345 Kulewa Loop Unit 18B, Waipahu, HI 96797"
}
["maintenance_fees"]=>
array(1) {
[0]=>
string(6) "497.00"
}
["middle_school"]=>
array(1) {
[0]=>
string(9) "Highlands"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202108974"
}
["neighborhood"]=>
array(1) {
[0]=>
string(13) "WAIPIO GENTRY"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "1"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(3) "One"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "EXPI"
}
["parking_features"]=>
array(1) {
[0]=>
string(33) "Assigned,Covered - 1,Guest,Street"
}
["possession"]=>
array(1) {
[0]=>
string(26) "45 Days or Less,At Closing"
}
["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) "Waipahu"
}
["rets_association_fee_total"]=>
array(1) {
[0]=>
string(3) "497"
}
["rets_association_phone"]=>
array(1) {
[0]=>
string(12) "808-671-2272"
}
["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(22) "Royal Palm at Waipio I"
}
["rets_city"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["rets_co_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 725-2794"
}
["rets_co_list_agent_email"]=>
array(1) {
[0]=>
string(27) "TravisFarrisHomes@gmail.com"
}
["rets_co_list_agent_full_name"]=>
array(1) {
[0]=>
string(15) "Travis D Farris"
}
["rets_co_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "43382"
}
["rets_co_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "3483551"
}
["rets_co_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "EXPI"
}
["rets_co_list_office_mui"]=>
array(1) {
[0]=>
string(8) "10013908"
}
["rets_co_list_office_name"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["rets_co_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 725-2794"
}
["rets_condo_parking_unit"]=>
array(1) {
[0]=>
string(3) "127"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(9) "450000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(1) "8"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_elementary_school"]=>
array(1) {
[0]=>
string(9) "Kanoelani"
}
["rets_elevators_number_of"]=>
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_high_school"]=>
array(1) {
[0]=>
string(10) "Pearl City"
}
["rets_id"]=>
array(1) {
[0]=>
string(8) "15843538"
}
["rets_immoviewer_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 725-2794"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(20) "staci@staciwolff.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(11) "Staci Wolff"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "49980"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(8) "14852083"
}
["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) "430000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2021-04-22"
}
["rets_lock_box_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(9) "115042.00"
}
["rets_maintenance_expense"]=>
array(1) {
[0]=>
string(6) "497.00"
}
["rets_management_company_name"]=>
array(1) {
[0]=>
string(10) "Touchstone"
}
["rets_management_company_phone"]=>
array(1) {
[0]=>
string(12) "808-566-4100"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2021-06-15T18:22:26.070"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "15843538"
}
["rets_middle_or_junior_school"]=>
array(1) {
[0]=>
string(9) "Highlands"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202108974"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(13) "WAIPIO GENTRY"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2021-04-23T12:26:55.583"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(9) "430000.00"
}
["rets_owner_occupancy_percentage"]=>
array(1) {
[0]=>
string(2) "43"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-9-4-115-036-0034"
}
["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) "16"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2021-04-23T12:26:55.583"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96797"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "15843538"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(297) "Please use Showing Time to request all showings. Contact Staci Wolff with questions: 808.208.3785. Please submit all offers to staci@staciwolff.com and travisfarrishomes@gmail.com PLEASE USE KEVIN BATUNGBACAL AT FIRST AMERICAN TITLE. INCLUDE AS-IS ADDENDUM AND PRE APPROVAL LETTER WITH ALL OFFERS."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(696) "Live, Work & Shop in Central Waipio, Walking Distance to Costco, Central Oahu Regional Park, Public Schools & H2, with short drives to Schofield, Waikele Premium Outlets, Mililani & Pearl City. Inside this 700 Sq Ft, Recently Renovated 2 Bedroom, 1 Bath Condo you'll enjoy the comforts you seek, from Quartz Countertops, New Cabinets, Stainless Appliances & a Large Flat Screen TV to Vessel Sinks & a Premium Tiled Bathroom, along with a 65 Sq Ft Partially Covered Tiki Patio & Backyard for Outdoor Living. The large Master Bedroom features an En Suite Bathroom while each living space has its dedicated A/C unit. 1 Dedicated Parking Space with plenty of Guest parking in & outside the community."
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(2) "65"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(3) "708"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(3) "773"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2021-06-15T18:22:26.070"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2021-06-15"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(6) "Kulewa"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(7) "94-1345"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(3) "2.5"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(5) "88.80"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "392600.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "220100.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "172500.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(3) "Yes"
}
["rets_tax_paid_by_seller_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_tax_year"]=>
array(1) {
[0]=>
string(4) "2020"
}
["rets_thumbnail_url"]=>
array(1) {
[0]=>
string(81) "https://cdn.rets.ci/marcusrealty-images/15843538/a20b2145eb0426206a9f42393dc700aa"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "194"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(2) "34"
}
["rets_tmk_division"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tmk_parcel"]=>
array(1) {
[0]=>
string(2) "36"
}
["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) "115"
}
["rets_unit_number"]=>
array(1) {
[0]=>
string(3) "18B"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1987"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(4) "2018"
}
["security"]=>
array(1) {
[0]=>
string(15) "Security Patrol"
}
["status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["terms_accept"]=>
array(1) {
[0]=>
string(24) "Cash,Conventional,FHA,VA"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-9-4-115-036-0034"
}
["unit"]=>
array(1) {
[0]=>
string(73) "Bedroom on 1st Level,Corner/End,Even# Unit,Ground Floor Unit,Single Level"
}
["view"]=>
array(1) {
[0]=>
string(6) "Garden"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "15843538"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202108974"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1628914895"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1987"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "2018"
}
["zoning"]=>
array(1) {
[0]=>
string(30) "11 - A-1 Low Density Apartment"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(1683) "a:105:{i:0;i:19860698;i:1;i:19860699;i:2;i:19860700;i:3;i:19860701;i:4;i:19860702;i:5;i:19860703;i:6;i:19860704;i:7;i:19860705;i:8;i:19860706;i:9;i:19860707;i:10;i:19860708;i:11;i:19860709;i:12;i:19862648;i:13;i:19862649;i:14;i:19862650;i:15;i:19862651;i:16;i:19862652;i:17;i:19862653;i:18;i:19862654;i:19;i:19862655;i:20;i:19862656;i:21;i:19862657;i:22;i:19862658;i:23;i:19862659;i:24;i:19862660;i:25;i:19862661;i:26;i:19862662;i:27;i:19862663;i:28;i:19863149;i:29;i:19863150;i:30;i:19863151;i:31;i:19863152;i:32;i:19863153;i:33;i:19863154;i:34;i:19863155;i:35;i:19863156;i:36;i:19863157;i:37;i:19863158;i:38;i:19863159;i:39;i:19863160;i:40;i:19863161;i:41;i:19866804;i:42;i:19866805;i:43;i:19866806;i:44;i:19866807;i:45;i:19866808;i:46;i:19866809;i:47;i:19866810;i:48;i:19866811;i:49;i:19866812;i:50;i:19866813;i:51;i:19866814;i:52;i:19866815;i:53;i:19866816;i:54;i:19866817;i:55;i:19866818;i:56;i:19866819;i:57;i:19902839;i:58;i:19902840;i:59;i:19902841;i:60;i:19902842;i:61;i:19902843;i:62;i:19902844;i:63;i:19902845;i:64;i:19902846;i:65;i:19902847;i:66;i:19902848;i:67;i:19902849;i:68;i:19902850;i:69;i:19902851;i:70;i:19902852;i:71;i:19902853;i:72;i:19902854;i:73;i:20041862;i:74;i:20041863;i:75;i:20041864;i:76;i:20041865;i:77;i:20041866;i:78;i:20041867;i:79;i:20041868;i:80;i:20041869;i:81;i:20041870;i:82;i:20041871;i:83;i:20041872;i:84;i:20041873;i:85;i:20041874;i:86;i:20041875;i:87;i:20041876;i:88;i:20041877;i:89;i:20289969;i:90;i:20289970;i:91;i:20289971;i:92;i:20289972;i:93;i:20289973;i:94;i:20289974;i:95;i:20289975;i:96;i:20289976;i:97;i:20289977;i:98;i:20289978;i:99;i:20289979;i:100;i:20289980;i:101;i:20289981;i:102;i:20289982;i:103;i:20289983;i:104;i:20289984;}"
}
["rets_open_house_count"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_active_open_house_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_open_house_upcoming"]=>
array(1) {
[0]=>
string(0) ""
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(79) "1$21.42158366066207$-158.0002297575691$194.98$13.33$1.00$Yg0k7lsOFYWX4-9fOhGFzw"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2021-04-29"
}
["city"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96797"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2021-06-15"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(9) "450000.00"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2021-06-15"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 388-5555"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(22) "Cynthia@20Degreesn.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(14) "Cynthia Milles"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "47827"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(8) "12229770"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "DGRS"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(8) "12747418"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(28) "20 Degrees North Real Estate"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 388-5555"
}
["state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["street_name"]=>
array(1) {
[0]=>
string(6) "Kulewa"
}
["street_number"]=>
array(1) {
[0]=>
string(7) "94-1345"
}
["street_suffix"]=>
array(1) {
[0]=>
string(4) "Loop"
}
["unit_number"]=>
array(1) {
[0]=>
string(3) "18B"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "20289969"
}
}