A charming island home, that has been nicely renovated, with quality materials. New kitchen, roof, water heater, bathrooms, interior and exterior paint all done in 2018. All appliances are all included with sale. Appliances were purchased in 2018. Nice wide carport and driveway can easily fit 4 cars, stacked. Yard is fully fenced with vinyl fencing, creating a safe area for pets and kids to roam. Property is conveniently located near the BEAUTIFUL and TRANQUIL Waikalualoko fish ponds and park one of the few remaining ancient Hawaiian fishponds, that feeds to Kaneohe Bay. Enjoy a Sunday afternoon bike ride, picnic or fishing excursion to Waikalualoko park with the Ohana. Near KMC Marine base, shopping, eateries and public transportation. 20 minutes away from Kailua and Lanikai beach. This home is the epitome of nostalgic island living.
Property address on home is noted as 45-027 Waikalualoko LP. However, title report indicated 45-27 Waikalualopo LP.
Listing by: Coldwell Banker Realty
array(147) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "198600.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "583200.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "781800.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "3"
}
["building_style"]=>
array(1) {
[0]=>
string(20) "Detach Single Family"
}
["city"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(46) "Pets Allowed (Verify),Property Disclosure Stmt"
}
["easements"]=>
array(1) {
[0]=>
string(14) "Drainage,Sewer"
}
["floor_covering"]=>
array(1) {
[0]=>
string(18) "Ceramic Tile,Vinyl"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "2"
}
["furnished"]=>
array(1) {
[0]=>
string(7) "Partial"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["home_exampt"]=>
array(1) {
[0]=>
string(1) "0"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(7) "4120.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(21) "bjkmelanson@gmail.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(20) "Billie Jo K Melanson"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 676-7200"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-03-22"
}
["list_office_name"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["list_price"]=>
array(1) {
[0]=>
string(10) "1000000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "1020"
}
["location"]=>
array(1) {
[0]=>
string(43) "45-027 Waikalualoko Loop, Kaneohe, HI 96744"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202205456"
}
["neighborhood"]=>
array(1) {
[0]=>
string(8) "WAIKALUA"
}
["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(6) "CBPP15"
}
["parking_features"]=>
array(1) {
[0]=>
string(23) "3 Car+,Carport,Driveway"
}
["pool_"]=>
array(1) {
[0]=>
string(4) "None"
}
["possession"]=>
array(1) {
[0]=>
string(15) "45 Days or Less"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96744"
}
["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) "Kaneohe"
}
["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) "Kaneohe"
}
["rets_condo_property_regime_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(10) "1000000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(1) "7"
}
["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) "16523813"
}
["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) 676-7200"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(21) "bjkmelanson@gmail.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(20) "Billie Jo K Melanson"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "30101"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "3478371"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(6) "CBPP15"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(8) "12345774"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 676-7200"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(10) "1000000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-03-22"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(7) "4120.00"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-04-25T16:33:28.653"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16523813"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202205456"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(8) "WAIKALUA"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-03-22T15:57:23.727"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(10) "1000000.00"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-4-5-006-010-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-22T20:00:53.740"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96744"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16523813"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(45) "Prefer Cindi Lewis with First American Title."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(966) "A charming island home, that has been nicely renovated, with quality materials. New kitchen, roof, water heater, bathrooms, interior and exterior paint all done in 2018. All appliances are all included with sale. Appliances were purchased in 2018. Nice wide carport and driveway can easily fit 4 cars, stacked. Yard is fully fenced with vinyl fencing, creating a safe area for pets and kids to roam. Property is conveniently located near the BEAUTIFUL and TRANQUIL Waikalualoko fish ponds and park one of the few remaining ancient Hawaiian fishponds, that feeds to Kaneohe Bay. Enjoy a Sunday afternoon bike ride, picnic or fishing excursion to Waikalualoko park with the Ohana. Near KMC Marine base, shopping, eateries and public transportation. 20 minutes away from Kailua and Lanikai beach. This home is the epitome of nostalgic island living.
Property address on home is noted as 45-027 Waikalualoko LP. However, title report indicated 45-27 Waikalualopo LP."
}
["rets_room_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_sqft_garage_carport"]=>
array(1) {
[0]=>
string(3) "378"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "1020"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "1020"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-25T16:33:28.653"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-04-25"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(12) "Waikalualoko"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(6) "45-027"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(64) "1$21.412989$-157.787652$132.70$13.33$1.00$otrmP70rZpULV4ycCj3FGQ"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(4) "2.50"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "196.33"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "2355.96"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "781800.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "198600.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "583200.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) "2021"
}
["rets_thumbnail_url"]=>
array(1) {
[0]=>
string(81) "https://cdn.rets.ci/marcusrealty-images/16523813/e696e01fea8554190470f8311edd9ee2"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "145"
}
["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(2) "10"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "5"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(1) "6"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1985"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(4) "2018"
}
["security"]=>
array(1) {
[0]=>
string(3) "Key"
}
["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(12) "Waikalualoko"
}
["street_number"]=>
array(1) {
[0]=>
string(6) "45-027"
}
["street_suffix"]=>
array(1) {
[0]=>
string(4) "Loop"
}
["terms_accept"]=>
array(1) {
[0]=>
string(28) "A/S,Cash,Conventional,FHA,VA"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-4-5-006-010-0000"
}
["topography"]=>
array(1) {
[0]=>
string(5) "Clear"
}
["view"]=>
array(1) {
[0]=>
string(4) "None"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16523813"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202205456"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1650940497"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1985"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "2018"
}
["zoning"]=>
array(1) {
[0]=>
string(29) "05 - R-5 Residential District"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(2754) "a:168:{i:0;i:21871641;i:1;i:21871642;i:2;i:21871643;i:3;i:21871644;i:4;i:21871645;i:5;i:21871646;i:6;i:21871647;i:7;i:21871648;i:8;i:21871649;i:9;i:21871650;i:10;i:21871651;i:11;i:21871652;i:12;i:21871653;i:13;i:21871654;i:14;i:21871655;i:15;i:21871656;i:16;i:21871657;i:17;i:21871658;i:18;i:21871659;i:19;i:21871660;i:20;i:21871661;i:21;i:21872984;i:22;i:21872985;i:23;i:21872986;i:24;i:21872987;i:25;i:21872988;i:26;i:21872989;i:27;i:21872990;i:28;i:21872991;i:29;i:21872992;i:30;i:21872993;i:31;i:21872994;i:32;i:21872995;i:33;i:21872996;i:34;i:21872997;i:35;i:21872998;i:36;i:21872999;i:37;i:21873000;i:38;i:21873001;i:39;i:21873002;i:40;i:21873003;i:41;i:21873004;i:42;i:21873005;i:43;i:21873006;i:44;i:21873007;i:45;i:21873008;i:46;i:21873009;i:47;i:21873010;i:48;i:21873011;i:49;i:21873012;i:50;i:21873013;i:51;i:21873014;i:52;i:21873015;i:53;i:21873016;i:54;i:21873017;i:55;i:21873018;i:56;i:21873019;i:57;i:21873020;i:58;i:21873021;i:59;i:21873022;i:60;i:21873023;i:61;i:21873024;i:62;i:21873025;i:63;i:21873038;i:64;i:21873039;i:65;i:21873040;i:66;i:21873041;i:67;i:21873042;i:68;i:21873043;i:69;i:21873044;i:70;i:21873045;i:71;i:21873046;i:72;i:21873047;i:73;i:21873048;i:74;i:21873049;i:75;i:21873050;i:76;i:21873051;i:77;i:21873052;i:78;i:21873053;i:79;i:21873054;i:80;i:21873055;i:81;i:21873056;i:82;i:21873057;i:83;i:21873058;i:84;i:21873334;i:85;i:21873335;i:86;i:21873336;i:87;i:21873337;i:88;i:21873338;i:89;i:21873339;i:90;i:21873340;i:91;i:21873341;i:92;i:21873342;i:93;i:21873343;i:94;i:21873344;i:95;i:21873345;i:96;i:21873346;i:97;i:21873347;i:98;i:21873348;i:99;i:21873349;i:100;i:21873350;i:101;i:21873351;i:102;i:21873352;i:103;i:21873353;i:104;i:21873354;i:105;i:21916146;i:106;i:21916147;i:107;i:21916148;i:108;i:21916149;i:109;i:21916150;i:110;i:21916151;i:111;i:21916152;i:112;i:21916153;i:113;i:21916154;i:114;i:21916155;i:115;i:21916156;i:116;i:21916157;i:117;i:21916158;i:118;i:21916159;i:119;i:21916160;i:120;i:21916161;i:121;i:21916162;i:122;i:21916163;i:123;i:21916164;i:124;i:21916165;i:125;i:21916166;i:126;i:21916221;i:127;i:21916222;i:128;i:21916223;i:129;i:21916224;i:130;i:21916225;i:131;i:21916226;i:132;i:21916227;i:133;i:21916228;i:134;i:21916229;i:135;i:21916230;i:136;i:21916231;i:137;i:21916232;i:138;i:21916233;i:139;i:21916234;i:140;i:21916235;i:141;i:21916236;i:142;i:21916237;i:143;i:21916238;i:144;i:21916239;i:145;i:21916240;i:146;i:21916241;i:147;i:22089848;i:148;i:22089849;i:149;i:22089850;i:150;i:22089851;i:151;i:22089852;i:152;i:22089853;i:153;i:22089854;i:154;i:22089855;i:155;i:22089856;i:156;i:22089857;i:157;i:22089858;i:158;i:22089859;i:159;i:22089860;i:160;i:22089861;i:161;i:22089862;i:162;i:22089863;i:163;i:22089864;i:164;i:22089865;i:165;i:22089866;i:166;i:22089867;i:167;i:22089868;}"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-03-28"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-04-25"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(10) "1000000.00"
}
["rets_concessions"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2023-03-22"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-04-25"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 836-5000"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(30) "KenGines@FlatFee5000Hawaii.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(9) "Ken Gines"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "28681"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "3477757"
}
["rets_selling_agent_remarks"]=>
array(1) {
[0]=>
string(41) "No credits, home in immaculate condition."
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(6) "STSH02"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(8) "12376636"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(28) "Soldier to Soldier HI Realty"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 836-5000"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "22089848"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 198600.00
)
[assd_val_land] => Array
(
[0] => 583200.00
)
[assd_val_total] => Array
(
[0] => 781800.00
)
[bedrooms] => Array
(
[0] => 3
)
[building_style] => Array
(
[0] => Detach Single Family
)
[city] => Array
(
[0] => Kaneohe
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Pets Allowed (Verify),Property Disclosure Stmt
)
[easements] => Array
(
[0] => Drainage,Sewer
)
[floor_covering] => Array
(
[0] => Ceramic Tile,Vinyl
)
[full_baths] => Array
(
[0] => 2
)
[furnished] => Array
(
[0] => Partial
)
[half_baths] => Array
(
[0] => 0
)
[home_exampt] => Array
(
[0] => 0
)
[land_area_sf] => Array
(
[0] => 4120.00
)
[land_recorded] => Array
(
[0] => Regular System
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => bjkmelanson@gmail.com
)
[list_agent_name] => Array
(
[0] => Billie Jo K Melanson
)
[list_agent_phone_number] => Array
(
[0] => (808) 676-7200
)
[list_date] => Array
(
[0] => 2022-03-22
)
[list_office_name] => Array
(
[0] => Coldwell Banker Realty
)
[list_price] => Array
(
[0] => 1000000.00
)
[living_sf] => Array
(
[0] => 1020
)
[location] => Array
(
[0] => 45-027 Waikalualoko Loop, Kaneohe, HI 96744
)
[mls_] => Array
(
[0] => 202205456
)
[neighborhood] => Array
(
[0] => WAIKALUA
)
[number_of_parking_spaces] => Array
(
[0] => 2
)
[number_of_stories] => Array
(
[0] => One
)
[office_mls_id] => Array
(
[0] => CBPP15
)
[parking_features] => Array
(
[0] => 3 Car+,Carport,Driveway
)
[pool_] => Array
(
[0] => None
)
[possession] => Array
(
[0] => 45 Days or Less
)
[postal_code] => Array
(
[0] => 96744
)
[property_condition] => Array
(
[0] => Excellent
)
[property_type] => Array
(
[0] => single_family
)
[property_type_label] => Array
(
[0] => single_family
)
[region] => Array
(
[0] => Kaneohe
)
[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] => Kaneohe
)
[rets_condo_property_regime_yn] => Array
(
[0] => 0
)
[rets_current_price] => Array
(
[0] => 1000000.00
)
[rets_dom] => Array
(
[0] => 7
)
[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] => 16523813
)
[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) 676-7200
)
[rets_list_agent_email] => Array
(
[0] => bjkmelanson@gmail.com
)
[rets_list_agent_full_name] => Array
(
[0] => Billie Jo K Melanson
)
[rets_list_agent_mlsid] => Array
(
[0] => 30101
)
[rets_list_agent_mui] => Array
(
[0] => 3478371
)
[rets_list_office_mlsid] => Array
(
[0] => CBPP15
)
[rets_list_office_mui] => Array
(
[0] => 12345774
)
[rets_list_office_name] => Array
(
[0] => Coldwell Banker Realty
)
[rets_list_office_phone] => Array
(
[0] => (808) 676-7200
)
[rets_list_price] => Array
(
[0] => 1000000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-03-22
)
[rets_lot_size_area] => Array
(
[0] => 4120.00
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-04-25T16:33:28.653
)
[rets_matrix_unique_id] => Array
(
[0] => 16523813
)
[rets_mls_number] => Array
(
[0] => 202205456
)
[rets_neighbourhood] => Array
(
[0] => WAIKALUA
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-03-22T15:57:23.727
)
[rets_original_list_price] => Array
(
[0] => 1000000.00
)
[rets_parcel_number] => Array
(
[0] => 1-4-5-006-010-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-22T20:00:53.740
)
[rets_postal_code] => Array
(
[0] => 96744
)
[rets_primary_key] => Array
(
[0] => 16523813
)
[rets_private_remarks] => Array
(
[0] => Prefer Cindi Lewis with First American Title.
)
[rets_public_remarks] => Array
(
[0] => A charming island home, that has been nicely renovated, with quality materials. New kitchen, roof, water heater, bathrooms, interior and exterior paint all done in 2018. All appliances are all included with sale. Appliances were purchased in 2018. Nice wide carport and driveway can easily fit 4 cars, stacked. Yard is fully fenced with vinyl fencing, creating a safe area for pets and kids to roam. Property is conveniently located near the BEAUTIFUL and TRANQUIL Waikalualoko fish ponds and park one of the few remaining ancient Hawaiian fishponds, that feeds to Kaneohe Bay. Enjoy a Sunday afternoon bike ride, picnic or fishing excursion to Waikalualoko park with the Ohana. Near KMC Marine base, shopping, eateries and public transportation. 20 minutes away from Kailua and Lanikai beach. This home is the epitome of nostalgic island living.
Property address on home is noted as 45-027 Waikalualoko LP. However, title report indicated 45-27 Waikalualopo LP.
)
[rets_room_count] => Array
(
[0] => 0
)
[rets_sqft_garage_carport] => Array
(
[0] => 378
)
[rets_sqft_roofed_living] => Array
(
[0] => 1020
)
[rets_sqft_total] => Array
(
[0] => 1020
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-04-25T16:33:28.653
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-04-25
)
[rets_street_name] => Array
(
[0] => Waikalualoko
)
[rets_street_number] => Array
(
[0] => 45-027
)
[rets_street_view_param] => Array
(
[0] => 1$21.412989$-157.787652$132.70$13.33$1.00$otrmP70rZpULV4ycCj3FGQ
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.50
)
[rets_tax_amount] => Array
(
[0] => 196.33
)
[rets_tax_annual_amount] => Array
(
[0] => 2355.96
)
[rets_tax_assessed_value] => Array
(
[0] => 781800.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 198600.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 583200.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 0
)
[rets_tax_paid_by_seller_yn] => Array
(
[0] => 0
)
[rets_tax_year] => Array
(
[0] => 2021
)
[rets_thumbnail_url] => Array
(
[0] => https://cdn.rets.ci/marcusrealty-images/16523813/e696e01fea8554190470f8311edd9ee2
)
[rets_tmk_area] => Array
(
[0] => 145
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 0
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 10
)
[rets_tmk_section] => Array
(
[0] => 5
)
[rets_tmk_zone] => Array
(
[0] => 4
)
[rets_tmkplat] => Array
(
[0] => 6
)
[rets_year_built] => Array
(
[0] => 1985
)
[rets_year_remodeled] => Array
(
[0] => 2018
)
[security] => Array
(
[0] => Key
)
[setbacks] => Array
(
[0] => C&C
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Waikalualoko
)
[street_number] => Array
(
[0] => 45-027
)
[street_suffix] => Array
(
[0] => Loop
)
[terms_accept] => Array
(
[0] => A/S,Cash,Conventional,FHA,VA
)
[tmk] => Array
(
[0] => 1-4-5-006-010-0000
)
[topography] => Array
(
[0] => Clear
)
[view] => Array
(
[0] => None
)
[wpp::rets_pk] => Array
(
[0] => 16523813
)
[wpp_gpid] => Array
(
[0] => 202205456
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1650940497
)
[year_built] => Array
(
[0] => 1985
)
[year_remodeled_] => Array
(
[0] => 2018
)
[zoning] => Array
(
[0] => 05 - R-5 Residential District
)
[new_attached_media] => Array
(
[0] => a:168:{i:0;i:21871641;i:1;i:21871642;i:2;i:21871643;i:3;i:21871644;i:4;i:21871645;i:5;i:21871646;i:6;i:21871647;i:7;i:21871648;i:8;i:21871649;i:9;i:21871650;i:10;i:21871651;i:11;i:21871652;i:12;i:21871653;i:13;i:21871654;i:14;i:21871655;i:15;i:21871656;i:16;i:21871657;i:17;i:21871658;i:18;i:21871659;i:19;i:21871660;i:20;i:21871661;i:21;i:21872984;i:22;i:21872985;i:23;i:21872986;i:24;i:21872987;i:25;i:21872988;i:26;i:21872989;i:27;i:21872990;i:28;i:21872991;i:29;i:21872992;i:30;i:21872993;i:31;i:21872994;i:32;i:21872995;i:33;i:21872996;i:34;i:21872997;i:35;i:21872998;i:36;i:21872999;i:37;i:21873000;i:38;i:21873001;i:39;i:21873002;i:40;i:21873003;i:41;i:21873004;i:42;i:21873005;i:43;i:21873006;i:44;i:21873007;i:45;i:21873008;i:46;i:21873009;i:47;i:21873010;i:48;i:21873011;i:49;i:21873012;i:50;i:21873013;i:51;i:21873014;i:52;i:21873015;i:53;i:21873016;i:54;i:21873017;i:55;i:21873018;i:56;i:21873019;i:57;i:21873020;i:58;i:21873021;i:59;i:21873022;i:60;i:21873023;i:61;i:21873024;i:62;i:21873025;i:63;i:21873038;i:64;i:21873039;i:65;i:21873040;i:66;i:21873041;i:67;i:21873042;i:68;i:21873043;i:69;i:21873044;i:70;i:21873045;i:71;i:21873046;i:72;i:21873047;i:73;i:21873048;i:74;i:21873049;i:75;i:21873050;i:76;i:21873051;i:77;i:21873052;i:78;i:21873053;i:79;i:21873054;i:80;i:21873055;i:81;i:21873056;i:82;i:21873057;i:83;i:21873058;i:84;i:21873334;i:85;i:21873335;i:86;i:21873336;i:87;i:21873337;i:88;i:21873338;i:89;i:21873339;i:90;i:21873340;i:91;i:21873341;i:92;i:21873342;i:93;i:21873343;i:94;i:21873344;i:95;i:21873345;i:96;i:21873346;i:97;i:21873347;i:98;i:21873348;i:99;i:21873349;i:100;i:21873350;i:101;i:21873351;i:102;i:21873352;i:103;i:21873353;i:104;i:21873354;i:105;i:21916146;i:106;i:21916147;i:107;i:21916148;i:108;i:21916149;i:109;i:21916150;i:110;i:21916151;i:111;i:21916152;i:112;i:21916153;i:113;i:21916154;i:114;i:21916155;i:115;i:21916156;i:116;i:21916157;i:117;i:21916158;i:118;i:21916159;i:119;i:21916160;i:120;i:21916161;i:121;i:21916162;i:122;i:21916163;i:123;i:21916164;i:124;i:21916165;i:125;i:21916166;i:126;i:21916221;i:127;i:21916222;i:128;i:21916223;i:129;i:21916224;i:130;i:21916225;i:131;i:21916226;i:132;i:21916227;i:133;i:21916228;i:134;i:21916229;i:135;i:21916230;i:136;i:21916231;i:137;i:21916232;i:138;i:21916233;i:139;i:21916234;i:140;i:21916235;i:141;i:21916236;i:142;i:21916237;i:143;i:21916238;i:144;i:21916239;i:145;i:21916240;i:146;i:21916241;i:147;i:22089848;i:148;i:22089849;i:149;i:22089850;i:150;i:22089851;i:151;i:22089852;i:152;i:22089853;i:153;i:22089854;i:154;i:22089855;i:155;i:22089856;i:156;i:22089857;i:157;i:22089858;i:158;i:22089859;i:159;i:22089860;i:160;i:22089861;i:161;i:22089862;i:162;i:22089863;i:163;i:22089864;i:164;i:22089865;i:165;i:22089866;i:166;i:22089867;i:167;i:22089868;}
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-03-28
)
[rets_close_date] => Array
(
[0] => 2022-04-25
)
[rets_close_price] => Array
(
[0] => 1000000.00
)
[rets_concessions] => Array
(
[0] => 0
)
[rets_expiration_date] => Array
(
[0] => 2023-03-22
)
[rets_off_market_date] => Array
(
[0] => 2022-04-25
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 836-5000
)
[rets_selling_agent_email] => Array
(
[0] => KenGines@FlatFee5000Hawaii.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Ken Gines
)
[rets_selling_agent_mlsid] => Array
(
[0] => 28681
)
[rets_selling_agent_mui] => Array
(
[0] => 3477757
)
[rets_selling_agent_remarks] => Array
(
[0] => No credits, home in immaculate condition.
)
[rets_selling_office_mlsid] => Array
(
[0] => STSH02
)
[rets_selling_office_mui] => Array
(
[0] => 12376636
)
[rets_selling_office_name] => Array
(
[0] => Soldier to Soldier HI Realty
)
[rets_selling_office_phone] => Array
(
[0] => (808) 836-5000
)
[_thumbnail_id] => Array
(
[0] => 22089848
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446