Excellent investment opportunity! Whether you are an investor looking for a quick flip, or a home buyer looking to make it your own, now is the perfect time to get your hands on this fixer-upper located at the beautiful Waiau Gardens in Pearl City. The current owner has removed all of the old appliances and cabinetry so that you can get to work right away on building out your vision. Other units in the Waiau Gardens complex have taken down the wall between the kitchen and dining room to make an even more inviting living space. Upstairs you will find 3 large bedrooms, and a bathroom large enough for a dual vanity. The spacious back lanai looks out on to the pristine grounds, and the mountains beyond. You can even catch a peekaboo view of Pearl Harbor. Less than 200 feet from your back door you will find the swimming pool and lounge area.
LOCATION! With the H-1 on-ramp just 2 minutes away, you can be anywhere on island in NO TIME, without having to suffer the noise of traffic from your home. Less than 10 minutes to Pearl Harbor/Hickham, and less than 20 minutes to Wheeler, Schofield, Downtown Honolulu, and so much more. Two assigned parking stalls are right outside your front door.
array(163) {
["agency"]=>
array(1) {
[0]=>
string(19) "Hawaii Sands Realty"
}
["assd_val_imprv"]=>
array(1) {
[0]=>
string(8) "80600.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "342200.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "422800.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "3"
}
["building_name"]=>
array(1) {
[0]=>
string(3) "N/A"
}
["building_style"]=>
array(1) {
[0]=>
string(9) "Townhouse"
}
["city"]=>
array(1) {
[0]=>
string(10) "Pearl City"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(58) "Pets Allowed (Verify),Property Disclosure Stmt,See Remarks"
}
["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) "1"
}
["home_exampt"]=>
array(1) {
[0]=>
string(2) "No"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(9) "379582.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(23) "awatson@hawaiisands.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(11) "Alex Watson"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 664-3084"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-04-16"
}
["list_office_name"]=>
array(1) {
[0]=>
string(19) "Hawaii Sands Realty"
}
["list_price"]=>
array(1) {
[0]=>
string(9) "549000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "1142"
}
["location"]=>
array(1) {
[0]=>
string(52) "98-1410 Koaheahe Street Unit A, Pearl City, HI 96782"
}
["maintenance_fees"]=>
array(1) {
[0]=>
string(6) "520.00"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202207050"
}
["neighborhood"]=>
array(1) {
[0]=>
string(5) "WAIAU"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "2"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(3) "Two"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "HSAN"
}
["parking_features"]=>
array(1) {
[0]=>
string(17) "Assigned,Open - 2"
}
["possession"]=>
array(1) {
[0]=>
string(10) "At Closing"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96782"
}
["property_condition"]=>
array(1) {
[0]=>
string(12) "Average,Fair"
}
["property_type"]=>
array(1) {
[0]=>
string(15) "condo_townhouse"
}
["property_type_label"]=>
array(1) {
[0]=>
string(15) "Condo Townhouse"
}
["region"]=>
array(1) {
[0]=>
string(9) "PearlCity"
}
["rets_association_fee_total"]=>
array(1) {
[0]=>
string(3) "520"
}
["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) "3"
}
["rets_building_name"]=>
array(1) {
[0]=>
string(3) "N/A"
}
["rets_city"]=>
array(1) {
[0]=>
string(10) "Pearl City"
}
["rets_co_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 664-3084"
}
["rets_co_list_agent_email"]=>
array(1) {
[0]=>
string(22) "dmoyer@hawaiisands.com"
}
["rets_co_list_agent_full_name"]=>
array(1) {
[0]=>
string(13) "David L Moyer"
}
["rets_co_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "25258"
}
["rets_co_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "3475272"
}
["rets_co_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "HSAN"
}
["rets_co_list_office_mui"]=>
array(1) {
[0]=>
string(8) "10165565"
}
["rets_co_list_office_name"]=>
array(1) {
[0]=>
string(19) "Hawaii Sands Realty"
}
["rets_co_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 664-3084"
}
["rets_condo_parking_unit"]=>
array(1) {
[0]=>
string(6) "59, 60"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(9) "575000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(1) "9"
}
["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) "16564783"
}
["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) 664-3084"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(23) "awatson@hawaiisands.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(11) "Alex Watson"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "47508"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(8) "11043016"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "HSAN"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(8) "10165565"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(19) "Hawaii Sands Realty"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 664-3084"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(9) "549000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-04-16"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(9) "379582.00"
}
["rets_maintenance_expense"]=>
array(1) {
[0]=>
string(6) "520.00"
}
["rets_management_company_name"]=>
array(1) {
[0]=>
string(21) "Touchstone Properties"
}
["rets_management_company_phone"]=>
array(1) {
[0]=>
string(12) "808-566-4100"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-05-08T15:47:36.123"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16564783"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202207050"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(5) "WAIAU"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-15T20:06:49.517"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(9) "549000.00"
}
["rets_owner_occupancy_percentage"]=>
array(1) {
[0]=>
string(2) "67"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-9-8-059-007-0032"
}
["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) "25"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-16T07:55:21.077"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96782"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-16T07:52:18.563"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16564783"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(200) "Property is vacant and ready to Go and Show. Please use SHOWING TIME to schedule. BROKERS OPEN Wednesday, 4/20 from 11a-2p. SUNDAY OPEN HOUSE CANCELLED! Please use Athena Zamora of Old Republic Title."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(1199) "Excellent investment opportunity! Whether you are an investor looking for a quick flip, or a home buyer looking to make it your own, now is the perfect time to get your hands on this fixer-upper located at the beautiful Waiau Gardens in Pearl City. The current owner has removed all of the old appliances and cabinetry so that you can get to work right away on building out your vision. Other units in the Waiau Gardens complex have taken down the wall between the kitchen and dining room to make an even more inviting living space. Upstairs you will find 3 large bedrooms, and a bathroom large enough for a dual vanity. The spacious back lanai looks out on to the pristine grounds, and the mountains beyond. You can even catch a peekaboo view of Pearl Harbor. Less than 200 feet from your back door you will find the swimming pool and lounge area.
LOCATION! With the H-1 on-ramp just 2 minutes away, you can be anywhere on island in NO TIME, without having to suffer the noise of traffic from your home. Less than 10 minutes to Pearl Harbor/Hickham, and less than 20 minutes to Wheeler, Schofield, Downtown Honolulu, and so much more. Two assigned parking stalls are right outside your front door."
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "1142"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "1142"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-05-08T15:47:36.123"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-05-06"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(8) "Koaheahe"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(7) "98-1410"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(63) "1$21.39618$-157.956936$299.16$13.33$1.00$Q4cyvGumZ26DrZyVSP8bag"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(3) "2.5"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "123.33"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "1479.96"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "422800.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(8) "80600.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "342200.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(2) "No"
}
["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/16564783/b7559cac0c129162432f879ca5c69bcd"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "198"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(2) "32"
}
["rets_tmk_division"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tmk_parcel"]=>
array(1) {
[0]=>
string(1) "7"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "8"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "9"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(2) "59"
}
["rets_unit_number"]=>
array(1) {
[0]=>
string(1) "A"
}
["rets_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(51) "https://my.matterport.com/show/?m=By3tk7mEj1U&mls=1"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1974"
}
["security"]=>
array(1) {
[0]=>
string(3) "Key"
}
["state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["street_name"]=>
array(1) {
[0]=>
string(8) "Koaheahe"
}
["street_number"]=>
array(1) {
[0]=>
string(7) "98-1410"
}
["street_suffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["terms_accept"]=>
array(1) {
[0]=>
string(20) "Cash,Conventional,VA"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-9-8-059-007-0032"
}
["unit"]=>
array(1) {
[0]=>
string(35) "Corner/End,Multi Level,Storage,Yard"
}
["unit_number"]=>
array(1) {
[0]=>
string(1) "A"
}
["view"]=>
array(1) {
[0]=>
string(46) "Coastline,Garden,Mountain,Ocean,Sunrise,Sunset"
}
["virtual_tour"]=>
array(1) {
[0]=>
string(51) "https://my.matterport.com/show/?m=By3tk7mEj1U&mls=1"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16564783"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202207050"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1652060919"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1974"
}
["zoning"]=>
array(1) {
[0]=>
string(30) "11 - A-1 Low Density Apartment"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(2040) "a:126:{i:0;i:22030777;i:1;i:22030778;i:2;i:22030779;i:3;i:22030780;i:4;i:22030781;i:5;i:22030782;i:6;i:22030783;i:7;i:22030784;i:8;i:22030785;i:9;i:22030786;i:10;i:22030787;i:11;i:22030788;i:12;i:22030789;i:13;i:22030790;i:14;i:22030791;i:15;i:22030792;i:16;i:22030793;i:17;i:22030794;i:18;i:22030795;i:19;i:22030796;i:20;i:22030797;i:21;i:22030798;i:22;i:22030799;i:23;i:22030800;i:24;i:22030801;i:25;i:22030802;i:26;i:22030803;i:27;i:22030804;i:28;i:22030805;i:29;i:22030806;i:30;i:22030807;i:31;i:22030808;i:32;i:22030809;i:33;i:22030810;i:34;i:22030811;i:35;i:22030812;i:36;i:22030813;i:37;i:22030814;i:38;i:22030815;i:39;i:22030816;i:40;i:22030817;i:41;i:22030818;i:42;i:22041428;i:43;i:22041429;i:44;i:22041430;i:45;i:22041431;i:46;i:22041432;i:47;i:22041433;i:48;i:22041434;i:49;i:22041435;i:50;i:22041436;i:51;i:22041437;i:52;i:22041438;i:53;i:22041439;i:54;i:22041440;i:55;i:22041441;i:56;i:22041442;i:57;i:22041443;i:58;i:22041444;i:59;i:22041445;i:60;i:22041446;i:61;i:22041447;i:62;i:22041448;i:63;i:22079234;i:64;i:22079235;i:65;i:22079236;i:66;i:22079237;i:67;i:22079238;i:68;i:22079239;i:69;i:22079240;i:70;i:22079241;i:71;i:22079242;i:72;i:22079243;i:73;i:22079244;i:74;i:22079245;i:75;i:22079246;i:76;i:22079247;i:77;i:22079248;i:78;i:22079249;i:79;i:22079250;i:80;i:22079251;i:81;i:22079252;i:82;i:22079253;i:83;i:22079254;i:84;i:22086398;i:85;i:22086399;i:86;i:22086400;i:87;i:22086401;i:88;i:22086402;i:89;i:22086403;i:90;i:22086404;i:91;i:22086405;i:92;i:22086406;i:93;i:22086407;i:94;i:22086408;i:95;i:22086409;i:96;i:22086410;i:97;i:22086411;i:98;i:22086412;i:99;i:22086413;i:100;i:22086414;i:101;i:22086415;i:102;i:22086416;i:103;i:22086417;i:104;i:22086418;i:105;i:22178503;i:106;i:22178504;i:107;i:22178505;i:108;i:22178506;i:109;i:22178507;i:110;i:22178508;i:111;i:22178509;i:112;i:22178510;i:113;i:22178511;i:114;i:22178512;i:115;i:22178513;i:116;i:22178514;i:117;i:22178515;i:118;i:22178516;i:119;i:22178517;i:120;i:22178518;i:121;i:22178519;i:122;i:22178520;i:123;i:22178521;i:124;i:22178522;i:125;i:22178523;}"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-04-22"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-05-06"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(9) "575000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2023-04-01"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-05-06"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 468-2456"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(17) "dlr1540@gmail.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(12) "David Rucker"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "48931"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(8) "13029670"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "MORI"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(8) "16247122"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(15) "MORE Realty Inc"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 468-2456"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "22178503"
}
}
Array
(
[agency] => Array
(
[0] => Hawaii Sands Realty
)
[assd_val_imprv] => Array
(
[0] => 80600.00
)
[assd_val_land] => Array
(
[0] => 342200.00
)
[assd_val_total] => Array
(
[0] => 422800.00
)
[bedrooms] => Array
(
[0] => 3
)
[building_name] => Array
(
[0] => N/A
)
[building_style] => Array
(
[0] => Townhouse
)
[city] => Array
(
[0] => Pearl City
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Pets Allowed (Verify),Property Disclosure Stmt,See Remarks
)
[floor_covering] => Array
(
[0] => Ceramic Tile,Laminate
)
[full_baths] => Array
(
[0] => 1
)
[furnished] => Array
(
[0] => None
)
[half_baths] => Array
(
[0] => 1
)
[home_exampt] => Array
(
[0] => No
)
[land_area_sf] => Array
(
[0] => 379582.00
)
[land_recorded] => Array
(
[0] => Regular System
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => awatson@hawaiisands.com
)
[list_agent_name] => Array
(
[0] => Alex Watson
)
[list_agent_phone_number] => Array
(
[0] => (808) 664-3084
)
[list_date] => Array
(
[0] => 2022-04-16
)
[list_office_name] => Array
(
[0] => Hawaii Sands Realty
)
[list_price] => Array
(
[0] => 549000.00
)
[living_sf] => Array
(
[0] => 1142
)
[location] => Array
(
[0] => 98-1410 Koaheahe Street Unit A, Pearl City, HI 96782
)
[maintenance_fees] => Array
(
[0] => 520.00
)
[mls_] => Array
(
[0] => 202207050
)
[neighborhood] => Array
(
[0] => WAIAU
)
[number_of_parking_spaces] => Array
(
[0] => 2
)
[number_of_stories] => Array
(
[0] => Two
)
[office_mls_id] => Array
(
[0] => HSAN
)
[parking_features] => Array
(
[0] => Assigned,Open - 2
)
[possession] => Array
(
[0] => At Closing
)
[postal_code] => Array
(
[0] => 96782
)
[property_condition] => Array
(
[0] => Average,Fair
)
[property_type] => Array
(
[0] => condo_townhouse
)
[property_type_label] => Array
(
[0] => Condo Townhouse
)
[region] => Array
(
[0] => PearlCity
)
[rets_association_fee_total] => Array
(
[0] => 520
)
[rets_baths_full] => Array
(
[0] => 1
)
[rets_baths_half] => Array
(
[0] => 1
)
[rets_baths_total] => Array
(
[0] => 1.01
)
[rets_beds_total] => Array
(
[0] => 3
)
[rets_building_name] => Array
(
[0] => N/A
)
[rets_city] => Array
(
[0] => Pearl City
)
[rets_co_list_agent_direct_work_phone] => Array
(
[0] => (808) 664-3084
)
[rets_co_list_agent_email] => Array
(
[0] => dmoyer@hawaiisands.com
)
[rets_co_list_agent_full_name] => Array
(
[0] => David L Moyer
)
[rets_co_list_agent_mlsid] => Array
(
[0] => 25258
)
[rets_co_list_agent_mui] => Array
(
[0] => 3475272
)
[rets_co_list_office_mlsid] => Array
(
[0] => HSAN
)
[rets_co_list_office_mui] => Array
(
[0] => 10165565
)
[rets_co_list_office_name] => Array
(
[0] => Hawaii Sands Realty
)
[rets_co_list_office_phone] => Array
(
[0] => (808) 664-3084
)
[rets_condo_parking_unit] => Array
(
[0] => 59, 60
)
[rets_current_price] => Array
(
[0] => 575000.00
)
[rets_dom] => Array
(
[0] => 9
)
[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] => 16564783
)
[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) 664-3084
)
[rets_list_agent_email] => Array
(
[0] => awatson@hawaiisands.com
)
[rets_list_agent_full_name] => Array
(
[0] => Alex Watson
)
[rets_list_agent_mlsid] => Array
(
[0] => 47508
)
[rets_list_agent_mui] => Array
(
[0] => 11043016
)
[rets_list_office_mlsid] => Array
(
[0] => HSAN
)
[rets_list_office_mui] => Array
(
[0] => 10165565
)
[rets_list_office_name] => Array
(
[0] => Hawaii Sands Realty
)
[rets_list_office_phone] => Array
(
[0] => (808) 664-3084
)
[rets_list_price] => Array
(
[0] => 549000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-04-16
)
[rets_lot_size_area] => Array
(
[0] => 379582.00
)
[rets_maintenance_expense] => Array
(
[0] => 520.00
)
[rets_management_company_name] => Array
(
[0] => Touchstone Properties
)
[rets_management_company_phone] => Array
(
[0] => 808-566-4100
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-05-08T15:47:36.123
)
[rets_matrix_unique_id] => Array
(
[0] => 16564783
)
[rets_mls_number] => Array
(
[0] => 202207050
)
[rets_neighbourhood] => Array
(
[0] => WAIAU
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-04-15T20:06:49.517
)
[rets_original_list_price] => Array
(
[0] => 549000.00
)
[rets_owner_occupancy_percentage] => Array
(
[0] => 67
)
[rets_parcel_number] => Array
(
[0] => 1-9-8-059-007-0032
)
[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] => 25
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2022-04-16T07:55:21.077
)
[rets_postal_code] => Array
(
[0] => 96782
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-04-16T07:52:18.563
)
[rets_primary_key] => Array
(
[0] => 16564783
)
[rets_private_remarks] => Array
(
[0] => Property is vacant and ready to Go and Show. Please use SHOWING TIME to schedule. BROKERS OPEN Wednesday, 4/20 from 11a-2p. SUNDAY OPEN HOUSE CANCELLED! Please use Athena Zamora of Old Republic Title.
)
[rets_public_remarks] => Array
(
[0] => Excellent investment opportunity! Whether you are an investor looking for a quick flip, or a home buyer looking to make it your own, now is the perfect time to get your hands on this fixer-upper located at the beautiful Waiau Gardens in Pearl City. The current owner has removed all of the old appliances and cabinetry so that you can get to work right away on building out your vision. Other units in the Waiau Gardens complex have taken down the wall between the kitchen and dining room to make an even more inviting living space. Upstairs you will find 3 large bedrooms, and a bathroom large enough for a dual vanity. The spacious back lanai looks out on to the pristine grounds, and the mountains beyond. You can even catch a peekaboo view of Pearl Harbor. Less than 200 feet from your back door you will find the swimming pool and lounge area.
LOCATION! With the H-1 on-ramp just 2 minutes away, you can be anywhere on island in NO TIME, without having to suffer the noise of traffic from your home. Less than 10 minutes to Pearl Harbor/Hickham, and less than 20 minutes to Wheeler, Schofield, Downtown Honolulu, and so much more. Two assigned parking stalls are right outside your front door.
)
[rets_sqft_roofed_living] => Array
(
[0] => 1142
)
[rets_sqft_total] => Array
(
[0] => 1142
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-05-08T15:47:36.123
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-05-06
)
[rets_street_name] => Array
(
[0] => Koaheahe
)
[rets_street_number] => Array
(
[0] => 98-1410
)
[rets_street_view_param] => Array
(
[0] => 1$21.39618$-157.956936$299.16$13.33$1.00$Q4cyvGumZ26DrZyVSP8bag
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5
)
[rets_tax_amount] => Array
(
[0] => 123.33
)
[rets_tax_annual_amount] => Array
(
[0] => 1479.96
)
[rets_tax_assessed_value] => Array
(
[0] => 422800.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 80600.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 342200.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => No
)
[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/16564783/b7559cac0c129162432f879ca5c69bcd
)
[rets_tmk_area] => Array
(
[0] => 198
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 32
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 7
)
[rets_tmk_section] => Array
(
[0] => 8
)
[rets_tmk_zone] => Array
(
[0] => 9
)
[rets_tmkplat] => Array
(
[0] => 59
)
[rets_unit_number] => Array
(
[0] => A
)
[rets_virtual_tour_url_unbranded] => Array
(
[0] => https://my.matterport.com/show/?m=By3tk7mEj1U&mls=1
)
[rets_year_built] => Array
(
[0] => 1974
)
[security] => Array
(
[0] => Key
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Koaheahe
)
[street_number] => Array
(
[0] => 98-1410
)
[street_suffix] => Array
(
[0] => Street
)
[terms_accept] => Array
(
[0] => Cash,Conventional,VA
)
[tmk] => Array
(
[0] => 1-9-8-059-007-0032
)
[unit] => Array
(
[0] => Corner/End,Multi Level,Storage,Yard
)
[unit_number] => Array
(
[0] => A
)
[view] => Array
(
[0] => Coastline,Garden,Mountain,Ocean,Sunrise,Sunset
)
[virtual_tour] => Array
(
[0] => https://my.matterport.com/show/?m=By3tk7mEj1U&mls=1
)
[wpp::rets_pk] => Array
(
[0] => 16564783
)
[wpp_gpid] => Array
(
[0] => 202207050
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1652060919
)
[year_built] => Array
(
[0] => 1974
)
[zoning] => Array
(
[0] => 11 - A-1 Low Density Apartment
)
[new_attached_media] => Array
(
[0] => a:126:{i:0;i:22030777;i:1;i:22030778;i:2;i:22030779;i:3;i:22030780;i:4;i:22030781;i:5;i:22030782;i:6;i:22030783;i:7;i:22030784;i:8;i:22030785;i:9;i:22030786;i:10;i:22030787;i:11;i:22030788;i:12;i:22030789;i:13;i:22030790;i:14;i:22030791;i:15;i:22030792;i:16;i:22030793;i:17;i:22030794;i:18;i:22030795;i:19;i:22030796;i:20;i:22030797;i:21;i:22030798;i:22;i:22030799;i:23;i:22030800;i:24;i:22030801;i:25;i:22030802;i:26;i:22030803;i:27;i:22030804;i:28;i:22030805;i:29;i:22030806;i:30;i:22030807;i:31;i:22030808;i:32;i:22030809;i:33;i:22030810;i:34;i:22030811;i:35;i:22030812;i:36;i:22030813;i:37;i:22030814;i:38;i:22030815;i:39;i:22030816;i:40;i:22030817;i:41;i:22030818;i:42;i:22041428;i:43;i:22041429;i:44;i:22041430;i:45;i:22041431;i:46;i:22041432;i:47;i:22041433;i:48;i:22041434;i:49;i:22041435;i:50;i:22041436;i:51;i:22041437;i:52;i:22041438;i:53;i:22041439;i:54;i:22041440;i:55;i:22041441;i:56;i:22041442;i:57;i:22041443;i:58;i:22041444;i:59;i:22041445;i:60;i:22041446;i:61;i:22041447;i:62;i:22041448;i:63;i:22079234;i:64;i:22079235;i:65;i:22079236;i:66;i:22079237;i:67;i:22079238;i:68;i:22079239;i:69;i:22079240;i:70;i:22079241;i:71;i:22079242;i:72;i:22079243;i:73;i:22079244;i:74;i:22079245;i:75;i:22079246;i:76;i:22079247;i:77;i:22079248;i:78;i:22079249;i:79;i:22079250;i:80;i:22079251;i:81;i:22079252;i:82;i:22079253;i:83;i:22079254;i:84;i:22086398;i:85;i:22086399;i:86;i:22086400;i:87;i:22086401;i:88;i:22086402;i:89;i:22086403;i:90;i:22086404;i:91;i:22086405;i:92;i:22086406;i:93;i:22086407;i:94;i:22086408;i:95;i:22086409;i:96;i:22086410;i:97;i:22086411;i:98;i:22086412;i:99;i:22086413;i:100;i:22086414;i:101;i:22086415;i:102;i:22086416;i:103;i:22086417;i:104;i:22086418;i:105;i:22178503;i:106;i:22178504;i:107;i:22178505;i:108;i:22178506;i:109;i:22178507;i:110;i:22178508;i:111;i:22178509;i:112;i:22178510;i:113;i:22178511;i:114;i:22178512;i:115;i:22178513;i:116;i:22178514;i:117;i:22178515;i:118;i:22178516;i:119;i:22178517;i:120;i:22178518;i:121;i:22178519;i:122;i:22178520;i:123;i:22178521;i:124;i:22178522;i:125;i:22178523;}
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-04-22
)
[rets_close_date] => Array
(
[0] => 2022-05-06
)
[rets_close_price] => Array
(
[0] => 575000.00
)
[rets_expiration_date] => Array
(
[0] => 2023-04-01
)
[rets_off_market_date] => Array
(
[0] => 2022-05-06
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 468-2456
)
[rets_selling_agent_email] => Array
(
[0] => dlr1540@gmail.com
)
[rets_selling_agent_full_name] => Array
(
[0] => David Rucker
)
[rets_selling_agent_mlsid] => Array
(
[0] => 48931
)
[rets_selling_agent_mui] => Array
(
[0] => 13029670
)
[rets_selling_office_mlsid] => Array
(
[0] => MORI
)
[rets_selling_office_mui] => Array
(
[0] => 16247122
)
[rets_selling_office_name] => Array
(
[0] => MORE Realty Inc
)
[rets_selling_office_phone] => Array
(
[0] => (808) 468-2456
)
[_thumbnail_id] => Array
(
[0] => 22178503
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446