Absolutely breathtaking views greet everyone who steps inside this architecturally distinctive oceanfront home in Kaimalino. You’ll fall in love with the soaring wood ceilings, the spectacular entrance with dual spiral staircases and the layout of this 5 bedroom/3 bath house. The house boasts all new windows and doors, vinyl flooring on the first floor, new roof, split AC’s, an upgraded bathroom with custom designed vanity and a huge master suite with stunning ocean views. A gorgeous pool and hot tub await you on the front side of the home, while floor-to-ceiling windows on the back side capture the panoramic views of the mesmerizing pacific blue ocean waters, whales and the world famous Mokulua Islands. A few upgrades will make this a true waterfront oasis in Kaimalino, which features 10,000+ square foot lots and is one of Kailua’s most sought-after neighborhoods.
Listing by: BHGRE Advantage Realty
array(157) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(10) "1269700.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(10) "1940600.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(10) "3210300.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "5"
}
["building_style"]=>
array(1) {
[0]=>
string(20) "Detach Single Family"
}
["city"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["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(6) "Aikahi"
}
["floor_covering"]=>
array(1) {
[0]=>
string(44) "Ceramic Tile,Marble/Granite,Vinyl,W/W Carpet"
}
["frontage"]=>
array(1) {
[0]=>
string(5) "Ocean"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "3"
}
["furnished"]=>
array(1) {
[0]=>
string(4) "None"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["high_school"]=>
array(1) {
[0]=>
string(7) "Kalaheo"
}
["home_exampt"]=>
array(1) {
[0]=>
string(7) "100,000"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(3) "106"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(8) "10030.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(24) "StacyLP@BetterHawaii.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(13) "Stacy L Paris"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 261-1800"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-04-29"
}
["list_office_name"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["list_price"]=>
array(1) {
[0]=>
string(10) "3195000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "4486"
}
["location"]=>
array(1) {
[0]=>
string(36) "605 Milokai Street, Kailua, HI 96734"
}
["middle_school"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202205912"
}
["neighborhood"]=>
array(1) {
[0]=>
string(9) "KAIMALINO"
}
["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(6) "ADVG02"
}
["parking_features"]=>
array(1) {
[0]=>
string(13) "3 Car+,Garage"
}
["pool_"]=>
array(1) {
[0]=>
string(25) "In Ground,Spa/HotTub,Tile"
}
["possession"]=>
array(1) {
[0]=>
string(15) "45 Days or Less"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96734"
}
["property_condition"]=>
array(1) {
[0]=>
string(23) "Above Average,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(6) "Kailua"
}
["rets_baths_full"]=>
array(1) {
[0]=>
string(1) "3"
}
["rets_baths_half"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_baths_total"]=>
array(1) {
[0]=>
string(4) "3.00"
}
["rets_beds_total"]=>
array(1) {
[0]=>
string(1) "5"
}
["rets_city"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["rets_condo_property_regime_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(10) "3120000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(2) "13"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_elementary_school"]=>
array(1) {
[0]=>
string(6) "Aikahi"
}
["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(7) "Kalaheo"
}
["rets_id"]=>
array(1) {
[0]=>
string(8) "16536001"
}
["rets_immoviewer_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 261-1800"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(24) "StacyLP@BetterHawaii.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(13) "Stacy L Paris"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "47622"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(8) "11102251"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(6) "ADVG02"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(8) "10139093"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 261-1800"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(10) "3195000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-04-29"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(8) "10030.00"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-06-27T08:07:00.147"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16536001"
}
["rets_middle_or_junior_school"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202205912"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(9) "KAIMALINO"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-29T07:05:40.507"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(10) "3195000.00"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-4-4-039-009-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-29T15:41:47.350"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96734"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-29T07:05:40.507"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16536001"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(393) "No showings until 1st open house Sunday May 1st 2-5. Please use SHOWINGTIME to schedule. Listor must be present for all showings. First Open House Sunday May 1st 2-5pm. Broker’s Open Thursday May 5th 9:30-12noon. A second Open House will be held Saturday May 7th 2-5pm. Please consider using Camille Staley with First Hawaii Title.. Monthly tax Amount is based on 2021 assessed values."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(885) "Absolutely breathtaking views greet everyone who steps inside this architecturally distinctive oceanfront home in Kaimalino. You’ll fall in love with the soaring wood ceilings, the spectacular entrance with dual spiral staircases and the layout of this 5 bedroom/3 bath house. The house boasts all new windows and doors, vinyl flooring on the first floor, new roof, split AC’s, an upgraded bathroom with custom designed vanity and a huge master suite with stunning ocean views. A gorgeous pool and hot tub await you on the front side of the home, while floor-to-ceiling windows on the back side capture the panoramic views of the mesmerizing pacific blue ocean waters, whales and the world famous Mokulua Islands. A few upgrades will make this a true waterfront oasis in Kaimalino, which features 10,000+ square foot lots and is one of Kailua’s most sought-after neighborhoods."
}
["rets_sqft_garage_carport"]=>
array(1) {
[0]=>
string(3) "342"
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(3) "106"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "4380"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "4486"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-27T08:07:00.147"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-06-27"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(7) "Milokai"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(3) "605"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(63) "1$21.427399$-157.738417$79.24$13.33$1.00$x_dc--LvvsikYfa_KXkZgA"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(3) "2.5"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "569.83"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "6837.96"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(10) "3210300.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(10) "1269700.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(10) "1940600.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(7) "100,000"
}
["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/16536001/5f9d79121ae9856b21983bde9177f67c"
}
["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(1) "9"
}
["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) "39"
}
["rets_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(49) "https://vimeopro.com/user142926291/605-milokai-st"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1981"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(4) "2022"
}
["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) "Milokai"
}
["street_number"]=>
array(1) {
[0]=>
string(3) "605"
}
["street_suffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["terms_accept"]=>
array(1) {
[0]=>
string(29) "Cash,Conventional,Exchange,VA"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-4-4-039-009-0000"
}
["topography"]=>
array(1) {
[0]=>
string(5) "Clear"
}
["view"]=>
array(1) {
[0]=>
string(23) "Coastline,Ocean,Sunrise"
}
["virtual_tour"]=>
array(1) {
[0]=>
string(49) "https://vimeopro.com/user142926291/605-milokai-st"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16536001"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202205912"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1656353244"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1981"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "2022"
}
["zoning"]=>
array(1) {
[0]=>
string(31) "03 - R10 - Residential District"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(3111) "a:189:{i:0;i:22117619;i:1;i:22117620;i:2;i:22117621;i:3;i:22117622;i:4;i:22117623;i:5;i:22117624;i:6;i:22117625;i:7;i:22117626;i:8;i:22117627;i:9;i:22117628;i:10;i:22117629;i:11;i:22117630;i:12;i:22117631;i:13;i:22117632;i:14;i:22117633;i:15;i:22117634;i:16;i:22117635;i:17;i:22117636;i:18;i:22117637;i:19;i:22117638;i:20;i:22117639;i:21;i:22117661;i:22;i:22117662;i:23;i:22117663;i:24;i:22117664;i:25;i:22117665;i:26;i:22117666;i:27;i:22117667;i:28;i:22117668;i:29;i:22117669;i:30;i:22117670;i:31;i:22117671;i:32;i:22117672;i:33;i:22117673;i:34;i:22117674;i:35;i:22117675;i:36;i:22117676;i:37;i:22117677;i:38;i:22117678;i:39;i:22117679;i:40;i:22117680;i:41;i:22117681;i:42;i:22118300;i:43;i:22118301;i:44;i:22118302;i:45;i:22118303;i:46;i:22118304;i:47;i:22118305;i:48;i:22118306;i:49;i:22118307;i:50;i:22118308;i:51;i:22118309;i:52;i:22118310;i:53;i:22118311;i:54;i:22118312;i:55;i:22118313;i:56;i:22118314;i:57;i:22118315;i:58;i:22118316;i:59;i:22118317;i:60;i:22118318;i:61;i:22118319;i:62;i:22118320;i:63;i:22124254;i:64;i:22124255;i:65;i:22124256;i:66;i:22124257;i:67;i:22124258;i:68;i:22124259;i:69;i:22124260;i:70;i:22124261;i:71;i:22124262;i:72;i:22124263;i:73;i:22124264;i:74;i:22124265;i:75;i:22124266;i:76;i:22124267;i:77;i:22124268;i:78;i:22124269;i:79;i:22124270;i:80;i:22124271;i:81;i:22124272;i:82;i:22124273;i:83;i:22124274;i:84;i:22208790;i:85;i:22208791;i:86;i:22208792;i:87;i:22208793;i:88;i:22208794;i:89;i:22208795;i:90;i:22208796;i:91;i:22208797;i:92;i:22208798;i:93;i:22208799;i:94;i:22208800;i:95;i:22208801;i:96;i:22208802;i:97;i:22208803;i:98;i:22208804;i:99;i:22208805;i:100;i:22208806;i:101;i:22208807;i:102;i:22208808;i:103;i:22208809;i:104;i:22208810;i:105;i:22212712;i:106;i:22212713;i:107;i:22212714;i:108;i:22212715;i:109;i:22212716;i:110;i:22212717;i:111;i:22212718;i:112;i:22212719;i:113;i:22212720;i:114;i:22212721;i:115;i:22212722;i:116;i:22212723;i:117;i:22212724;i:118;i:22212725;i:119;i:22212726;i:120;i:22212727;i:121;i:22212728;i:122;i:22212729;i:123;i:22212730;i:124;i:22212731;i:125;i:22212732;i:126;i:22284217;i:127;i:22284218;i:128;i:22284219;i:129;i:22284220;i:130;i:22284221;i:131;i:22284222;i:132;i:22284223;i:133;i:22284224;i:134;i:22284225;i:135;i:22284226;i:136;i:22284227;i:137;i:22284228;i:138;i:22284229;i:139;i:22284230;i:140;i:22284231;i:141;i:22284232;i:142;i:22284233;i:143;i:22284234;i:144;i:22284235;i:145;i:22284236;i:146;i:22284237;i:147;i:22340920;i:148;i:22340921;i:149;i:22340922;i:150;i:22340923;i:151;i:22340924;i:152;i:22340925;i:153;i:22340926;i:154;i:22340927;i:155;i:22340928;i:156;i:22340929;i:157;i:22340930;i:158;i:22340931;i:159;i:22340932;i:160;i:22340933;i:161;i:22340934;i:162;i:22340935;i:163;i:22340936;i:164;i:22340937;i:165;i:22340938;i:166;i:22340939;i:167;i:22340940;i:168;i:22554900;i:169;i:22554901;i:170;i:22554902;i:171;i:22554903;i:172;i:22554904;i:173;i:22554905;i:174;i:22554906;i:175;i:22554907;i:176;i:22554908;i:177;i:22554909;i:178;i:22554910;i:179;i:22554911;i:180;i:22554912;i:181;i:22554913;i:182;i:22554914;i:183;i:22554915;i:184;i:22554916;i:185;i:22554917;i:186;i:22554918;i:187;i:22554919;i:188;i:22554920;}"
}
["rets_open_house_count"]=>
array(1) {
[0]=>
string(1) "3"
}
["rets_active_open_house_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_open_house_upcoming"]=>
array(1) {
[0]=>
string(0) ""
}
["rets_pending_date"]=>
array(1) {
[0]=>
string(10) "2022-05-12"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-05-12"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-06-27"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(10) "3120000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-08-15"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-06-27"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 596-0456"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(18) "kyles@cbrealty.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(13) "Kyle C Sakoda"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "27256"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "3476898"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "CBPP"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(7) "3485212"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 596-0456"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "22554900"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 1269700.00
)
[assd_val_land] => Array
(
[0] => 1940600.00
)
[assd_val_total] => Array
(
[0] => 3210300.00
)
[bedrooms] => Array
(
[0] => 5
)
[building_style] => Array
(
[0] => Detach Single Family
)
[city] => Array
(
[0] => Kailua
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Property Disclosure Stmt
)
[easements] => Array
(
[0] => None
)
[elementary_school] => Array
(
[0] => Aikahi
)
[floor_covering] => Array
(
[0] => Ceramic Tile,Marble/Granite,Vinyl,W/W Carpet
)
[frontage] => Array
(
[0] => Ocean
)
[full_baths] => Array
(
[0] => 3
)
[furnished] => Array
(
[0] => None
)
[half_baths] => Array
(
[0] => 0
)
[high_school] => Array
(
[0] => Kalaheo
)
[home_exampt] => Array
(
[0] => 100,000
)
[lanai_sf] => Array
(
[0] => 106
)
[land_area_sf] => Array
(
[0] => 10030.00
)
[land_recorded] => Array
(
[0] => Land Court
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => StacyLP@BetterHawaii.com
)
[list_agent_name] => Array
(
[0] => Stacy L Paris
)
[list_agent_phone_number] => Array
(
[0] => (808) 261-1800
)
[list_date] => Array
(
[0] => 2022-04-29
)
[list_office_name] => Array
(
[0] => BHGRE Advantage Realty
)
[list_price] => Array
(
[0] => 3195000.00
)
[living_sf] => Array
(
[0] => 4486
)
[location] => Array
(
[0] => 605 Milokai Street, Kailua, HI 96734
)
[middle_school] => Array
(
[0] => Kailua
)
[mls_] => Array
(
[0] => 202205912
)
[neighborhood] => Array
(
[0] => KAIMALINO
)
[number_of_parking_spaces] => Array
(
[0] => 4
)
[number_of_stories] => Array
(
[0] => Two
)
[office_mls_id] => Array
(
[0] => ADVG02
)
[parking_features] => Array
(
[0] => 3 Car+,Garage
)
[pool_] => Array
(
[0] => In Ground,Spa/HotTub,Tile
)
[possession] => Array
(
[0] => 45 Days or Less
)
[postal_code] => Array
(
[0] => 96734
)
[property_condition] => Array
(
[0] => Above Average,Excellent
)
[property_type] => Array
(
[0] => single_family
)
[property_type_label] => Array
(
[0] => single_family
)
[region] => Array
(
[0] => Kailua
)
[rets_baths_full] => Array
(
[0] => 3
)
[rets_baths_half] => Array
(
[0] => 0
)
[rets_baths_total] => Array
(
[0] => 3.00
)
[rets_beds_total] => Array
(
[0] => 5
)
[rets_city] => Array
(
[0] => Kailua
)
[rets_condo_property_regime_yn] => Array
(
[0] => 0
)
[rets_current_price] => Array
(
[0] => 3120000.00
)
[rets_dom] => Array
(
[0] => 13
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_elementary_school] => Array
(
[0] => Aikahi
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_high_school] => Array
(
[0] => Kalaheo
)
[rets_id] => Array
(
[0] => 16536001
)
[rets_immoviewer_yn] => Array
(
[0] => 0
)
[rets_list_agent_direct_work_phone] => Array
(
[0] => (808) 261-1800
)
[rets_list_agent_email] => Array
(
[0] => StacyLP@BetterHawaii.com
)
[rets_list_agent_full_name] => Array
(
[0] => Stacy L Paris
)
[rets_list_agent_mlsid] => Array
(
[0] => 47622
)
[rets_list_agent_mui] => Array
(
[0] => 11102251
)
[rets_list_office_mlsid] => Array
(
[0] => ADVG02
)
[rets_list_office_mui] => Array
(
[0] => 10139093
)
[rets_list_office_name] => Array
(
[0] => BHGRE Advantage Realty
)
[rets_list_office_phone] => Array
(
[0] => (808) 261-1800
)
[rets_list_price] => Array
(
[0] => 3195000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-04-29
)
[rets_lot_size_area] => Array
(
[0] => 10030.00
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-06-27T08:07:00.147
)
[rets_matrix_unique_id] => Array
(
[0] => 16536001
)
[rets_middle_or_junior_school] => Array
(
[0] => Kailua
)
[rets_mls_number] => Array
(
[0] => 202205912
)
[rets_neighbourhood] => Array
(
[0] => KAIMALINO
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-04-29T07:05:40.507
)
[rets_original_list_price] => Array
(
[0] => 3195000.00
)
[rets_parcel_number] => Array
(
[0] => 1-4-4-039-009-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-29T15:41:47.350
)
[rets_postal_code] => Array
(
[0] => 96734
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-04-29T07:05:40.507
)
[rets_primary_key] => Array
(
[0] => 16536001
)
[rets_private_remarks] => Array
(
[0] => No showings until 1st open house Sunday May 1st 2-5. Please use SHOWINGTIME to schedule. Listor must be present for all showings. First Open House Sunday May 1st 2-5pm. Broker’s Open Thursday May 5th 9:30-12noon. A second Open House will be held Saturday May 7th 2-5pm. Please consider using Camille Staley with First Hawaii Title.. Monthly tax Amount is based on 2021 assessed values.
)
[rets_public_remarks] => Array
(
[0] => Absolutely breathtaking views greet everyone who steps inside this architecturally distinctive oceanfront home in Kaimalino. You’ll fall in love with the soaring wood ceilings, the spectacular entrance with dual spiral staircases and the layout of this 5 bedroom/3 bath house. The house boasts all new windows and doors, vinyl flooring on the first floor, new roof, split AC’s, an upgraded bathroom with custom designed vanity and a huge master suite with stunning ocean views. A gorgeous pool and hot tub await you on the front side of the home, while floor-to-ceiling windows on the back side capture the panoramic views of the mesmerizing pacific blue ocean waters, whales and the world famous Mokulua Islands. A few upgrades will make this a true waterfront oasis in Kaimalino, which features 10,000+ square foot lots and is one of Kailua’s most sought-after neighborhoods.
)
[rets_sqft_garage_carport] => Array
(
[0] => 342
)
[rets_sqft_lanai_open] => Array
(
[0] => 106
)
[rets_sqft_roofed_living] => Array
(
[0] => 4380
)
[rets_sqft_total] => Array
(
[0] => 4486
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-06-27T08:07:00.147
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-06-27
)
[rets_street_name] => Array
(
[0] => Milokai
)
[rets_street_number] => Array
(
[0] => 605
)
[rets_street_view_param] => Array
(
[0] => 1$21.427399$-157.738417$79.24$13.33$1.00$x_dc--LvvsikYfa_KXkZgA
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5
)
[rets_tax_amount] => Array
(
[0] => 569.83
)
[rets_tax_annual_amount] => Array
(
[0] => 6837.96
)
[rets_tax_assessed_value] => Array
(
[0] => 3210300.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 1269700.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 1940600.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 100,000
)
[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/16536001/5f9d79121ae9856b21983bde9177f67c
)
[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] => 9
)
[rets_tmk_section] => Array
(
[0] => 4
)
[rets_tmk_zone] => Array
(
[0] => 4
)
[rets_tmkplat] => Array
(
[0] => 39
)
[rets_virtual_tour_url_unbranded] => Array
(
[0] => https://vimeopro.com/user142926291/605-milokai-st
)
[rets_year_built] => Array
(
[0] => 1981
)
[rets_year_remodeled] => Array
(
[0] => 2022
)
[setbacks] => Array
(
[0] => C&C
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Milokai
)
[street_number] => Array
(
[0] => 605
)
[street_suffix] => Array
(
[0] => Street
)
[terms_accept] => Array
(
[0] => Cash,Conventional,Exchange,VA
)
[tmk] => Array
(
[0] => 1-4-4-039-009-0000
)
[topography] => Array
(
[0] => Clear
)
[view] => Array
(
[0] => Coastline,Ocean,Sunrise
)
[virtual_tour] => Array
(
[0] => https://vimeopro.com/user142926291/605-milokai-st
)
[wpp::rets_pk] => Array
(
[0] => 16536001
)
[wpp_gpid] => Array
(
[0] => 202205912
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1656353244
)
[year_built] => Array
(
[0] => 1981
)
[year_remodeled_] => Array
(
[0] => 2022
)
[zoning] => Array
(
[0] => 03 - R10 - Residential District
)
[new_attached_media] => Array
(
[0] => a:189:{i:0;i:22117619;i:1;i:22117620;i:2;i:22117621;i:3;i:22117622;i:4;i:22117623;i:5;i:22117624;i:6;i:22117625;i:7;i:22117626;i:8;i:22117627;i:9;i:22117628;i:10;i:22117629;i:11;i:22117630;i:12;i:22117631;i:13;i:22117632;i:14;i:22117633;i:15;i:22117634;i:16;i:22117635;i:17;i:22117636;i:18;i:22117637;i:19;i:22117638;i:20;i:22117639;i:21;i:22117661;i:22;i:22117662;i:23;i:22117663;i:24;i:22117664;i:25;i:22117665;i:26;i:22117666;i:27;i:22117667;i:28;i:22117668;i:29;i:22117669;i:30;i:22117670;i:31;i:22117671;i:32;i:22117672;i:33;i:22117673;i:34;i:22117674;i:35;i:22117675;i:36;i:22117676;i:37;i:22117677;i:38;i:22117678;i:39;i:22117679;i:40;i:22117680;i:41;i:22117681;i:42;i:22118300;i:43;i:22118301;i:44;i:22118302;i:45;i:22118303;i:46;i:22118304;i:47;i:22118305;i:48;i:22118306;i:49;i:22118307;i:50;i:22118308;i:51;i:22118309;i:52;i:22118310;i:53;i:22118311;i:54;i:22118312;i:55;i:22118313;i:56;i:22118314;i:57;i:22118315;i:58;i:22118316;i:59;i:22118317;i:60;i:22118318;i:61;i:22118319;i:62;i:22118320;i:63;i:22124254;i:64;i:22124255;i:65;i:22124256;i:66;i:22124257;i:67;i:22124258;i:68;i:22124259;i:69;i:22124260;i:70;i:22124261;i:71;i:22124262;i:72;i:22124263;i:73;i:22124264;i:74;i:22124265;i:75;i:22124266;i:76;i:22124267;i:77;i:22124268;i:78;i:22124269;i:79;i:22124270;i:80;i:22124271;i:81;i:22124272;i:82;i:22124273;i:83;i:22124274;i:84;i:22208790;i:85;i:22208791;i:86;i:22208792;i:87;i:22208793;i:88;i:22208794;i:89;i:22208795;i:90;i:22208796;i:91;i:22208797;i:92;i:22208798;i:93;i:22208799;i:94;i:22208800;i:95;i:22208801;i:96;i:22208802;i:97;i:22208803;i:98;i:22208804;i:99;i:22208805;i:100;i:22208806;i:101;i:22208807;i:102;i:22208808;i:103;i:22208809;i:104;i:22208810;i:105;i:22212712;i:106;i:22212713;i:107;i:22212714;i:108;i:22212715;i:109;i:22212716;i:110;i:22212717;i:111;i:22212718;i:112;i:22212719;i:113;i:22212720;i:114;i:22212721;i:115;i:22212722;i:116;i:22212723;i:117;i:22212724;i:118;i:22212725;i:119;i:22212726;i:120;i:22212727;i:121;i:22212728;i:122;i:22212729;i:123;i:22212730;i:124;i:22212731;i:125;i:22212732;i:126;i:22284217;i:127;i:22284218;i:128;i:22284219;i:129;i:22284220;i:130;i:22284221;i:131;i:22284222;i:132;i:22284223;i:133;i:22284224;i:134;i:22284225;i:135;i:22284226;i:136;i:22284227;i:137;i:22284228;i:138;i:22284229;i:139;i:22284230;i:140;i:22284231;i:141;i:22284232;i:142;i:22284233;i:143;i:22284234;i:144;i:22284235;i:145;i:22284236;i:146;i:22284237;i:147;i:22340920;i:148;i:22340921;i:149;i:22340922;i:150;i:22340923;i:151;i:22340924;i:152;i:22340925;i:153;i:22340926;i:154;i:22340927;i:155;i:22340928;i:156;i:22340929;i:157;i:22340930;i:158;i:22340931;i:159;i:22340932;i:160;i:22340933;i:161;i:22340934;i:162;i:22340935;i:163;i:22340936;i:164;i:22340937;i:165;i:22340938;i:166;i:22340939;i:167;i:22340940;i:168;i:22554900;i:169;i:22554901;i:170;i:22554902;i:171;i:22554903;i:172;i:22554904;i:173;i:22554905;i:174;i:22554906;i:175;i:22554907;i:176;i:22554908;i:177;i:22554909;i:178;i:22554910;i:179;i:22554911;i:180;i:22554912;i:181;i:22554913;i:182;i:22554914;i:183;i:22554915;i:184;i:22554916;i:185;i:22554917;i:186;i:22554918;i:187;i:22554919;i:188;i:22554920;}
)
[rets_open_house_count] => Array
(
[0] => 3
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_open_house_upcoming] => Array
(
[0] =>
)
[rets_pending_date] => Array
(
[0] => 2022-05-12
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-05-12
)
[rets_close_date] => Array
(
[0] => 2022-06-27
)
[rets_close_price] => Array
(
[0] => 3120000.00
)
[rets_expiration_date] => Array
(
[0] => 2022-08-15
)
[rets_off_market_date] => Array
(
[0] => 2022-06-27
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 596-0456
)
[rets_selling_agent_email] => Array
(
[0] => kyles@cbrealty.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Kyle C Sakoda
)
[rets_selling_agent_mlsid] => Array
(
[0] => 27256
)
[rets_selling_agent_mui] => Array
(
[0] => 3476898
)
[rets_selling_office_mlsid] => Array
(
[0] => CBPP
)
[rets_selling_office_mui] => Array
(
[0] => 3485212
)
[rets_selling_office_name] => Array
(
[0] => Coldwell Banker Realty
)
[rets_selling_office_phone] => Array
(
[0] => (808) 596-0456
)
[_thumbnail_id] => Array
(
[0] => 22554900
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446