Private Oceanfront home with a Pier and Boat Dock w/winch!! Located right on Kaneohe Bay, you’ll enjoy views of sailboats framed perfectly with the luscious Ko’olau mountains and Coconut Island in the background all year long. Enter through the powered gate to unwind in the peace and comfort of this spacious 3 bed, 2 bath, and 2 half bath oasis. The first level has a welcoming open floor-plan with newly installed high grade carpet in the living room, luxury vinyl plank flooring in the kitchen, and freshly painted walls throughout. For added seclusion, retreat to the primary bedroom upstairs – the only room on the second level – and take in the panoramic views from the lanai. Stepping outdoors, you’ll find the backyard with your very own boat dock w/winch stand and pier, fit for any ocean related activities. Conveniently located near shops, restaurants, highway access, and all the entertainment Kaneohe has to offer. Schedule a visit today and see this charming bay home for yourself! To view the 3D tour, click on movie reel under photos.
Listing by: Locations LLC
array(160) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(8) "72800.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(10) "1350000.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(10) "1422800.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(24) "Property Disclosure Stmt"
}
["easements"]=>
array(1) {
[0]=>
string(4) "None"
}
["elementary_school"]=>
array(1) {
[0]=>
string(7) "Puohala"
}
["floor_covering"]=>
array(1) {
[0]=>
string(10) "W/W Carpet"
}
["frontage"]=>
array(1) {
[0]=>
string(5) "Ocean"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "2"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "2"
}
["high_school"]=>
array(1) {
[0]=>
string(6) "Castle"
}
["home_exampt"]=>
array(1) {
[0]=>
string(6) "140000"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(3) "188"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(7) "6924.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(32) "corinda.wong@locationshawaii.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(14) "Corinda S Wong"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 735-4200"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-04-19"
}
["list_office_name"]=>
array(1) {
[0]=>
string(13) "Locations LLC"
}
["list_price"]=>
array(1) {
[0]=>
string(10) "2300000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "2509"
}
["location"]=>
array(1) {
[0]=>
string(39) "44-247 Mikiola Drive, Kaneohe, HI 96744"
}
["middle_school"]=>
array(1) {
[0]=>
string(4) "King"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202207417"
}
["neighborhood"]=>
array(1) {
[0]=>
string(7) "MIKIOLA"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "4"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(3) "Two"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "LOCA"
}
["parking_features"]=>
array(1) {
[0]=>
string(23) "3 Car+,Carport,Driveway"
}
["pool_"]=>
array(1) {
[0]=>
string(4) "None"
}
["possession"]=>
array(1) {
[0]=>
string(10) "At Closing"
}
["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) "2"
}
["rets_baths_total"]=>
array(1) {
[0]=>
string(4) "2.02"
}
["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) "2557000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(2) "10"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_elementary_school"]=>
array(1) {
[0]=>
string(7) "Puohala"
}
["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(6) "Castle"
}
["rets_id"]=>
array(1) {
[0]=>
string(8) "16574738"
}
["rets_immoviewer_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_internet_automated_valuation_dis"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_internet_consumer_comment_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 735-4200"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(32) "corinda.wong@locationshawaii.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(14) "Corinda S Wong"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "16809"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "8842911"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "LOCA"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(7) "3485305"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(13) "Locations LLC"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 735-4200"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(10) "2300000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-04-19"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(7) "6924.00"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-06-16T15:35:14.947"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16574738"
}
["rets_middle_or_junior_school"]=>
array(1) {
[0]=>
string(4) "King"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202207417"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(7) "MIKIOLA"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-19T17:11:49.070"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(10) "2300000.00"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-4-4-018-076-0000"
}
["rets_parking_total"]=>
array(1) {
[0]=>
string(1) "4"
}
["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-20T03:53:07.843"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96744"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-19T17:11:49.070"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16574738"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(406) "BO (4/21) 10:30-12:30 & OH (4/24) 2-5 PM. For showing requests, please email Michelle Love at Michelle.Love@locationshawaii.com or text, 808-372-1112. Seller prefers Fidelity National Title (Kailua office) – Jasmine Bishaw. See Supplements for Addenda to include. *SUBMIT ALL OFFERS TO -TeamWong@locationshawaii.com.*
NOTE: Flood zones are in D & X. *Monthly tax amount reflects 2021 assessed values."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(1061) "Private Oceanfront home with a Pier and Boat Dock w/winch!! Located right on Kaneohe Bay, you’ll enjoy views of sailboats framed perfectly with the luscious Ko’olau mountains and Coconut Island in the background all year long. Enter through the powered gate to unwind in the peace and comfort of this spacious 3 bed, 2 bath, and 2 half bath oasis. The first level has a welcoming open floor-plan with newly installed high grade carpet in the living room, luxury vinyl plank flooring in the kitchen, and freshly painted walls throughout. For added seclusion, retreat to the primary bedroom upstairs – the only room on the second level – and take in the panoramic views from the lanai. Stepping outdoors, you’ll find the backyard with your very own boat dock w/winch stand and pier, fit for any ocean related activities. Conveniently located near shops, restaurants, highway access, and all the entertainment Kaneohe has to offer. Schedule a visit today and see this charming bay home for yourself! To view the 3D tour, click on movie reel under photos."
}
["rets_sqft_garage_carport"]=>
array(1) {
[0]=>
string(3) "340"
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(3) "188"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "2278"
}
["rets_sqft_roofed_other"]=>
array(1) {
[0]=>
string(2) "43"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "2509"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-16T15:35:14.947"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-06-16"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(7) "Mikiola"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(6) "44-247"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(60) "1$21.412658$-157.775$50.55$13.33$1.00$kaaKiDHt1UzdvIF0ernCgA"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(2) "3%"
}
["rets_supplement_count"]=>
array(1) {
[0]=>
string(1) "6"
}
["rets_supplement_modification_timestam"]=>
array(1) {
[0]=>
string(23) "2022-04-19T17:04:15.127"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "291.00"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "3492.00"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(10) "1422800.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(8) "72800.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(10) "1350000.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(6) "140000"
}
["rets_tax_paid_by_seller_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tax_year"]=>
array(1) {
[0]=>
string(4) "2022"
}
["rets_thumbnail_url"]=>
array(1) {
[0]=>
string(81) "https://cdn.rets.ci/marcusrealty-images/16574738/6e1a63175025326c43e79c9bf3d92b7c"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "144"
}
["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) "76"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(2) "18"
}
["rets_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(51) "https://my.matterport.com/show/?m=PwMqv4metcg&mls=1"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1954"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(4) "2019"
}
["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(7) "Mikiola"
}
["street_number"]=>
array(1) {
[0]=>
string(6) "44-247"
}
["street_suffix"]=>
array(1) {
[0]=>
string(5) "Drive"
}
["terms_accept"]=>
array(1) {
[0]=>
string(20) "Cash,Conventional,VA"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-4-4-018-076-0000"
}
["topography"]=>
array(1) {
[0]=>
string(13) "Clear,Rim Lot"
}
["view"]=>
array(1) {
[0]=>
string(28) "Mountain,Ocean,Other,Sunrise"
}
["virtual_tour"]=>
array(1) {
[0]=>
string(51) "https://my.matterport.com/show/?m=PwMqv4metcg&mls=1"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16574738"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202207417"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1655429785"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1954"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "2019"
}
["zoning"]=>
array(1) {
[0]=>
string(29) "05 - R-5 Residential District"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(2397) "a:147:{i:0;i:22051204;i:1;i:22051205;i:2;i:22051206;i:3;i:22051207;i:4;i:22051208;i:5;i:22051209;i:6;i:22051210;i:7;i:22051211;i:8;i:22051212;i:9;i:22051213;i:10;i:22051214;i:11;i:22051215;i:12;i:22051216;i:13;i:22051217;i:14;i:22051218;i:15;i:22051219;i:16;i:22051220;i:17;i:22051221;i:18;i:22051222;i:19;i:22051223;i:20;i:22051224;i:21;i:22051233;i:22;i:22051234;i:23;i:22051235;i:24;i:22051236;i:25;i:22051237;i:26;i:22051238;i:27;i:22051239;i:28;i:22051240;i:29;i:22051241;i:30;i:22051242;i:31;i:22051243;i:32;i:22051244;i:33;i:22051245;i:34;i:22051246;i:35;i:22051247;i:36;i:22051248;i:37;i:22051249;i:38;i:22051250;i:39;i:22051251;i:40;i:22051252;i:41;i:22051253;i:42;i:22053369;i:43;i:22053370;i:44;i:22053371;i:45;i:22053372;i:46;i:22053373;i:47;i:22053374;i:48;i:22053375;i:49;i:22053376;i:50;i:22053377;i:51;i:22053378;i:52;i:22053379;i:53;i:22053380;i:54;i:22053381;i:55;i:22053382;i:56;i:22053383;i:57;i:22053384;i:58;i:22053385;i:59;i:22053386;i:60;i:22053387;i:61;i:22053388;i:62;i:22053389;i:63;i:22053390;i:64;i:22053391;i:65;i:22053392;i:66;i:22053393;i:67;i:22053394;i:68;i:22053395;i:69;i:22053396;i:70;i:22053397;i:71;i:22053398;i:72;i:22053399;i:73;i:22053400;i:74;i:22053401;i:75;i:22053402;i:76;i:22053403;i:77;i:22053404;i:78;i:22053405;i:79;i:22053406;i:80;i:22053407;i:81;i:22053408;i:82;i:22053409;i:83;i:22053410;i:84;i:22058150;i:85;i:22058151;i:86;i:22058152;i:87;i:22058153;i:88;i:22058154;i:89;i:22058155;i:90;i:22058156;i:91;i:22058157;i:92;i:22058158;i:93;i:22058159;i:94;i:22058160;i:95;i:22058161;i:96;i:22058162;i:97;i:22058163;i:98;i:22058164;i:99;i:22058165;i:100;i:22058166;i:101;i:22058167;i:102;i:22058168;i:103;i:22058169;i:104;i:22058170;i:105;i:22124191;i:106;i:22124192;i:107;i:22124193;i:108;i:22124194;i:109;i:22124195;i:110;i:22124196;i:111;i:22124197;i:112;i:22124198;i:113;i:22124199;i:114;i:22124200;i:115;i:22124201;i:116;i:22124202;i:117;i:22124203;i:118;i:22124204;i:119;i:22124205;i:120;i:22124206;i:121;i:22124207;i:122;i:22124208;i:123;i:22124209;i:124;i:22124210;i:125;i:22124211;i:126;i:22459183;i:127;i:22459184;i:128;i:22459185;i:129;i:22459186;i:130;i:22459187;i:131;i:22459188;i:132;i:22459189;i:133;i:22459190;i:134;i:22459191;i:135;i:22459192;i:136;i:22459193;i:137;i:22459194;i:138;i:22459195;i:139;i:22459196;i:140;i:22459197;i:141;i:22459198;i:142;i:22459199;i:143;i:22459200;i:144;i:22459201;i:145;i:22459202;i:146;i:22459203;}"
}
["rets_open_house_count"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_active_open_house_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_open_house_upcoming"]=>
array(1) {
[0]=>
string(0) ""
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-04-29"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-06-16"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(10) "2557000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-12-31"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-06-16"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 487-1561"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(21) "dlyfujikami@gmail.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(17) "Diane LY Fujikami"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "12118"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "3472875"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "HRTA"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(7) "3487777"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(17) "Horita Realty LLC"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 487-1561"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "22459183"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 72800.00
)
[assd_val_land] => Array
(
[0] => 1350000.00
)
[assd_val_total] => Array
(
[0] => 1422800.00
)
[bedrooms] => Array
(
[0] => 3
)
[building_style] => Array
(
[0] => Detach Single Family
)
[city] => Array
(
[0] => Kaneohe
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Property Disclosure Stmt
)
[easements] => Array
(
[0] => None
)
[elementary_school] => Array
(
[0] => Puohala
)
[floor_covering] => Array
(
[0] => W/W Carpet
)
[frontage] => Array
(
[0] => Ocean
)
[full_baths] => Array
(
[0] => 2
)
[half_baths] => Array
(
[0] => 2
)
[high_school] => Array
(
[0] => Castle
)
[home_exampt] => Array
(
[0] => 140000
)
[lanai_sf] => Array
(
[0] => 188
)
[land_area_sf] => Array
(
[0] => 6924.00
)
[land_recorded] => Array
(
[0] => Land Court
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => corinda.wong@locationshawaii.com
)
[list_agent_name] => Array
(
[0] => Corinda S Wong
)
[list_agent_phone_number] => Array
(
[0] => (808) 735-4200
)
[list_date] => Array
(
[0] => 2022-04-19
)
[list_office_name] => Array
(
[0] => Locations LLC
)
[list_price] => Array
(
[0] => 2300000.00
)
[living_sf] => Array
(
[0] => 2509
)
[location] => Array
(
[0] => 44-247 Mikiola Drive, Kaneohe, HI 96744
)
[middle_school] => Array
(
[0] => King
)
[mls_] => Array
(
[0] => 202207417
)
[neighborhood] => Array
(
[0] => MIKIOLA
)
[number_of_parking_spaces] => Array
(
[0] => 4
)
[number_of_stories] => Array
(
[0] => Two
)
[office_mls_id] => Array
(
[0] => LOCA
)
[parking_features] => Array
(
[0] => 3 Car+,Carport,Driveway
)
[pool_] => Array
(
[0] => None
)
[possession] => Array
(
[0] => At Closing
)
[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] => 2
)
[rets_baths_total] => Array
(
[0] => 2.02
)
[rets_beds_total] => Array
(
[0] => 3
)
[rets_city] => Array
(
[0] => Kaneohe
)
[rets_condo_property_regime_yn] => Array
(
[0] => 0
)
[rets_current_price] => Array
(
[0] => 2557000.00
)
[rets_dom] => Array
(
[0] => 10
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_elementary_school] => Array
(
[0] => Puohala
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_high_school] => Array
(
[0] => Castle
)
[rets_id] => Array
(
[0] => 16574738
)
[rets_immoviewer_yn] => Array
(
[0] => 0
)
[rets_internet_automated_valuation_dis] => Array
(
[0] => 0
)
[rets_internet_consumer_comment_yn] => Array
(
[0] => 0
)
[rets_list_agent_direct_work_phone] => Array
(
[0] => (808) 735-4200
)
[rets_list_agent_email] => Array
(
[0] => corinda.wong@locationshawaii.com
)
[rets_list_agent_full_name] => Array
(
[0] => Corinda S Wong
)
[rets_list_agent_mlsid] => Array
(
[0] => 16809
)
[rets_list_agent_mui] => Array
(
[0] => 8842911
)
[rets_list_office_mlsid] => Array
(
[0] => LOCA
)
[rets_list_office_mui] => Array
(
[0] => 3485305
)
[rets_list_office_name] => Array
(
[0] => Locations LLC
)
[rets_list_office_phone] => Array
(
[0] => (808) 735-4200
)
[rets_list_price] => Array
(
[0] => 2300000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-04-19
)
[rets_lot_size_area] => Array
(
[0] => 6924.00
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-06-16T15:35:14.947
)
[rets_matrix_unique_id] => Array
(
[0] => 16574738
)
[rets_middle_or_junior_school] => Array
(
[0] => King
)
[rets_mls_number] => Array
(
[0] => 202207417
)
[rets_neighbourhood] => Array
(
[0] => MIKIOLA
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-04-19T17:11:49.070
)
[rets_original_list_price] => Array
(
[0] => 2300000.00
)
[rets_parcel_number] => Array
(
[0] => 1-4-4-018-076-0000
)
[rets_parking_total] => Array
(
[0] => 4
)
[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-20T03:53:07.843
)
[rets_postal_code] => Array
(
[0] => 96744
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-04-19T17:11:49.070
)
[rets_primary_key] => Array
(
[0] => 16574738
)
[rets_private_remarks] => Array
(
[0] => BO (4/21) 10:30-12:30 & OH (4/24) 2-5 PM. For showing requests, please email Michelle Love at Michelle.Love@locationshawaii.com or text, 808-372-1112. Seller prefers Fidelity National Title (Kailua office) – Jasmine Bishaw. See Supplements for Addenda to include. *SUBMIT ALL OFFERS TO -TeamWong@locationshawaii.com.*
NOTE: Flood zones are in D & X. *Monthly tax amount reflects 2021 assessed values.
)
[rets_public_remarks] => Array
(
[0] => Private Oceanfront home with a Pier and Boat Dock w/winch!! Located right on Kaneohe Bay, you’ll enjoy views of sailboats framed perfectly with the luscious Ko’olau mountains and Coconut Island in the background all year long. Enter through the powered gate to unwind in the peace and comfort of this spacious 3 bed, 2 bath, and 2 half bath oasis. The first level has a welcoming open floor-plan with newly installed high grade carpet in the living room, luxury vinyl plank flooring in the kitchen, and freshly painted walls throughout. For added seclusion, retreat to the primary bedroom upstairs – the only room on the second level – and take in the panoramic views from the lanai. Stepping outdoors, you’ll find the backyard with your very own boat dock w/winch stand and pier, fit for any ocean related activities. Conveniently located near shops, restaurants, highway access, and all the entertainment Kaneohe has to offer. Schedule a visit today and see this charming bay home for yourself! To view the 3D tour, click on movie reel under photos.
)
[rets_sqft_garage_carport] => Array
(
[0] => 340
)
[rets_sqft_lanai_open] => Array
(
[0] => 188
)
[rets_sqft_roofed_living] => Array
(
[0] => 2278
)
[rets_sqft_roofed_other] => Array
(
[0] => 43
)
[rets_sqft_total] => Array
(
[0] => 2509
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-06-16T15:35:14.947
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-06-16
)
[rets_street_name] => Array
(
[0] => Mikiola
)
[rets_street_number] => Array
(
[0] => 44-247
)
[rets_street_view_param] => Array
(
[0] => 1$21.412658$-157.775$50.55$13.33$1.00$kaaKiDHt1UzdvIF0ernCgA
)
[rets_sub_agency_compensation] => Array
(
[0] => 3%
)
[rets_supplement_count] => Array
(
[0] => 6
)
[rets_supplement_modification_timestam] => Array
(
[0] => 2022-04-19T17:04:15.127
)
[rets_tax_amount] => Array
(
[0] => 291.00
)
[rets_tax_annual_amount] => Array
(
[0] => 3492.00
)
[rets_tax_assessed_value] => Array
(
[0] => 1422800.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 72800.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 1350000.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 140000
)
[rets_tax_paid_by_seller_yn] => Array
(
[0] => 1
)
[rets_tax_year] => Array
(
[0] => 2022
)
[rets_thumbnail_url] => Array
(
[0] => https://cdn.rets.ci/marcusrealty-images/16574738/6e1a63175025326c43e79c9bf3d92b7c
)
[rets_tmk_area] => Array
(
[0] => 144
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 0
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 76
)
[rets_tmk_section] => Array
(
[0] => 4
)
[rets_tmk_zone] => Array
(
[0] => 4
)
[rets_tmkplat] => Array
(
[0] => 18
)
[rets_virtual_tour_url_unbranded] => Array
(
[0] => https://my.matterport.com/show/?m=PwMqv4metcg&mls=1
)
[rets_year_built] => Array
(
[0] => 1954
)
[rets_year_remodeled] => Array
(
[0] => 2019
)
[setbacks] => Array
(
[0] => C&C
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Mikiola
)
[street_number] => Array
(
[0] => 44-247
)
[street_suffix] => Array
(
[0] => Drive
)
[terms_accept] => Array
(
[0] => Cash,Conventional,VA
)
[tmk] => Array
(
[0] => 1-4-4-018-076-0000
)
[topography] => Array
(
[0] => Clear,Rim Lot
)
[view] => Array
(
[0] => Mountain,Ocean,Other,Sunrise
)
[virtual_tour] => Array
(
[0] => https://my.matterport.com/show/?m=PwMqv4metcg&mls=1
)
[wpp::rets_pk] => Array
(
[0] => 16574738
)
[wpp_gpid] => Array
(
[0] => 202207417
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1655429785
)
[year_built] => Array
(
[0] => 1954
)
[year_remodeled_] => Array
(
[0] => 2019
)
[zoning] => Array
(
[0] => 05 - R-5 Residential District
)
[new_attached_media] => Array
(
[0] => a:147:{i:0;i:22051204;i:1;i:22051205;i:2;i:22051206;i:3;i:22051207;i:4;i:22051208;i:5;i:22051209;i:6;i:22051210;i:7;i:22051211;i:8;i:22051212;i:9;i:22051213;i:10;i:22051214;i:11;i:22051215;i:12;i:22051216;i:13;i:22051217;i:14;i:22051218;i:15;i:22051219;i:16;i:22051220;i:17;i:22051221;i:18;i:22051222;i:19;i:22051223;i:20;i:22051224;i:21;i:22051233;i:22;i:22051234;i:23;i:22051235;i:24;i:22051236;i:25;i:22051237;i:26;i:22051238;i:27;i:22051239;i:28;i:22051240;i:29;i:22051241;i:30;i:22051242;i:31;i:22051243;i:32;i:22051244;i:33;i:22051245;i:34;i:22051246;i:35;i:22051247;i:36;i:22051248;i:37;i:22051249;i:38;i:22051250;i:39;i:22051251;i:40;i:22051252;i:41;i:22051253;i:42;i:22053369;i:43;i:22053370;i:44;i:22053371;i:45;i:22053372;i:46;i:22053373;i:47;i:22053374;i:48;i:22053375;i:49;i:22053376;i:50;i:22053377;i:51;i:22053378;i:52;i:22053379;i:53;i:22053380;i:54;i:22053381;i:55;i:22053382;i:56;i:22053383;i:57;i:22053384;i:58;i:22053385;i:59;i:22053386;i:60;i:22053387;i:61;i:22053388;i:62;i:22053389;i:63;i:22053390;i:64;i:22053391;i:65;i:22053392;i:66;i:22053393;i:67;i:22053394;i:68;i:22053395;i:69;i:22053396;i:70;i:22053397;i:71;i:22053398;i:72;i:22053399;i:73;i:22053400;i:74;i:22053401;i:75;i:22053402;i:76;i:22053403;i:77;i:22053404;i:78;i:22053405;i:79;i:22053406;i:80;i:22053407;i:81;i:22053408;i:82;i:22053409;i:83;i:22053410;i:84;i:22058150;i:85;i:22058151;i:86;i:22058152;i:87;i:22058153;i:88;i:22058154;i:89;i:22058155;i:90;i:22058156;i:91;i:22058157;i:92;i:22058158;i:93;i:22058159;i:94;i:22058160;i:95;i:22058161;i:96;i:22058162;i:97;i:22058163;i:98;i:22058164;i:99;i:22058165;i:100;i:22058166;i:101;i:22058167;i:102;i:22058168;i:103;i:22058169;i:104;i:22058170;i:105;i:22124191;i:106;i:22124192;i:107;i:22124193;i:108;i:22124194;i:109;i:22124195;i:110;i:22124196;i:111;i:22124197;i:112;i:22124198;i:113;i:22124199;i:114;i:22124200;i:115;i:22124201;i:116;i:22124202;i:117;i:22124203;i:118;i:22124204;i:119;i:22124205;i:120;i:22124206;i:121;i:22124207;i:122;i:22124208;i:123;i:22124209;i:124;i:22124210;i:125;i:22124211;i:126;i:22459183;i:127;i:22459184;i:128;i:22459185;i:129;i:22459186;i:130;i:22459187;i:131;i:22459188;i:132;i:22459189;i:133;i:22459190;i:134;i:22459191;i:135;i:22459192;i:136;i:22459193;i:137;i:22459194;i:138;i:22459195;i:139;i:22459196;i:140;i:22459197;i:141;i:22459198;i:142;i:22459199;i:143;i:22459200;i:144;i:22459201;i:145;i:22459202;i:146;i:22459203;}
)
[rets_open_house_count] => Array
(
[0] => 2
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_open_house_upcoming] => Array
(
[0] =>
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-04-29
)
[rets_close_date] => Array
(
[0] => 2022-06-16
)
[rets_close_price] => Array
(
[0] => 2557000.00
)
[rets_expiration_date] => Array
(
[0] => 2022-12-31
)
[rets_off_market_date] => Array
(
[0] => 2022-06-16
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 487-1561
)
[rets_selling_agent_email] => Array
(
[0] => dlyfujikami@gmail.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Diane LY Fujikami
)
[rets_selling_agent_mlsid] => Array
(
[0] => 12118
)
[rets_selling_agent_mui] => Array
(
[0] => 3472875
)
[rets_selling_office_mlsid] => Array
(
[0] => HRTA
)
[rets_selling_office_mui] => Array
(
[0] => 3487777
)
[rets_selling_office_name] => Array
(
[0] => Horita Realty LLC
)
[rets_selling_office_phone] => Array
(
[0] => (808) 487-1561
)
[_thumbnail_id] => Array
(
[0] => 22459183
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446