The one you have all been waiting for! Built in 2011 this beautifully designed 4 BD, 3 BA executive island style home is located in the coveted neighborhood of Niu Valley. The huge open floor plan with multiple living spaces provides seamless flow to the beautifully landscaped yards and covered patio for a true indoor/outdoor lifestyle! Your guests can lounge around the spacious kitchen island as you cook and entertain in your stunning gourmet kitchen. Enjoy the summer months with split A/C throughout, with tastefully installed in-wall plumbing and electrical, and 34 owned PV panels with net metering and solar water! The upstairs primary suite provides privacy and relaxation with its spacious layout, deep walk-in closet, and spa style rain shower. The highly functional floor plan also comes with two oversized bedrooms and a Jack and Jill bathroom upstairs. Conveniently situated downstairs, you will find a fourth bedroom or den and full bath w/ walk in shower. Need the perfect Father’s Day gift . . . consider gifting him this oversized 571 sq. ft. garage with storage galore and a bonus workshop nook with additional storage. A must see!
Listing by: Coldwell Banker Realty
array(162) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "625000.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "988800.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(10) "1613800.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "4"
}
["building_style"]=>
array(1) {
[0]=>
string(20) "Detach Single Family"
}
["city"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(37) "Photovoltaic,Property Disclosure Stmt"
}
["easements"]=>
array(1) {
[0]=>
string(4) "None"
}
["exclusions"]=>
array(1) {
[0]=>
string(5) "Other"
}
["floor_covering"]=>
array(1) {
[0]=>
string(32) "Ceramic Tile,Laminate,W/W Carpet"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "3"
}
["furnished"]=>
array(1) {
[0]=>
string(4) "None"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["home_exampt"]=>
array(1) {
[0]=>
string(6) "100000"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(8) "10001.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) "tommy.kim@cbpacific.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(9) "Tommy Kim"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 596-0456"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-06-09"
}
["list_office_name"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["list_price"]=>
array(1) {
[0]=>
string(10) "2250000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "2649"
}
["location"]=>
array(1) {
[0]=>
string(41) "150 Hawaii Loa Street, Honolulu, HI 96821"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202211096"
}
["neighborhood"]=>
array(1) {
[0]=>
string(10) "NIU VALLEY"
}
["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) "CBPP"
}
["parking_features"]=>
array(1) {
[0]=>
string(29) "3 Car+,Driveway,Garage,Street"
}
["pool_"]=>
array(1) {
[0]=>
string(4) "None"
}
["possession"]=>
array(1) {
[0]=>
string(10) "At Closing"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96821"
}
["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(9) "DiamondHd"
}
["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) "4"
}
["rets_city"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["rets_condo_property_regime_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(10) "2200000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(2) "12"
}
["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) "16696376"
}
["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) 596-0456"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(23) "tommy.kim@cbpacific.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(9) "Tommy Kim"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "44909"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "9350639"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "CBPP"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(7) "3485212"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 596-0456"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(10) "2250000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-06-09"
}
["rets_lock_box_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(8) "10001.00"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-08-12T10:29:23.503"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16696376"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202211096"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(10) "NIU VALLEY"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-09T18:50:35.263"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(10) "2250000.00"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-3-7-009-059-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-06-09T18:50:35.263"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96821"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16696376"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(368) "Showing appointments to prequalified and registered clients only are available starting Friday June 10th after 12 noon. For all questions and showing requests, please call or text listing agent Tommy Kim at 808-779-1416. OFFERS DUE BY 5:00 PM MONDAY JUNE 20TH. PLEASE SEE SUPPLEMENTS FOR OFFERING SUGGESTIONS & ADDENDA. PLEASE CONSIDER CRAIG ENDO of ORTC FOR ESCROW."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(1156) "The one you have all been waiting for! Built in 2011 this beautifully designed 4 BD, 3 BA executive island style home is located in the coveted neighborhood of Niu Valley. The huge open floor plan with multiple living spaces provides seamless flow to the beautifully landscaped yards and covered patio for a true indoor/outdoor lifestyle! Your guests can lounge around the spacious kitchen island as you cook and entertain in your stunning gourmet kitchen. Enjoy the summer months with split A/C throughout, with tastefully installed in-wall plumbing and electrical, and 34 owned PV panels with net metering and solar water! The upstairs primary suite provides privacy and relaxation with its spacious layout, deep walk-in closet, and spa style rain shower. The highly functional floor plan also comes with two oversized bedrooms and a Jack and Jill bathroom upstairs. Conveniently situated downstairs, you will find a fourth bedroom or den and full bath w/ walk in shower. Need the perfect Father’s Day gift . . . consider gifting him this oversized 571 sq. ft. garage with storage galore and a bonus workshop nook with additional storage. A must see!"
}
["rets_room_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_sqft_garage_carport"]=>
array(1) {
[0]=>
string(3) "561"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "2455"
}
["rets_sqft_roofed_other"]=>
array(1) {
[0]=>
string(3) "194"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "2649"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-08-12T10:29:23.503"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-08-12"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(10) "Hawaii Loa"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(3) "150"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(63) "1$21.281779$-157.74249$325.09$13.33$1.00$9m3X3at_bS8f8T_-TWp9oQ"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(3) "2.5"
}
["rets_supplement_count"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_supplement_modification_timestam"]=>
array(1) {
[0]=>
string(23) "2022-06-09T18:34:36.673"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "442.00"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "5304.00"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(10) "1613800.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "625000.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "988800.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(6) "100000"
}
["rets_tax_paid_by_seller_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_tax_year"]=>
array(1) {
[0]=>
string(4) "2022"
}
["rets_thumbnail_url"]=>
array(1) {
[0]=>
string(81) "https://cdn.rets.ci/marcusrealty-images/16696376/ea5ca256ecc5b33d4e5913f7ae68d4b6"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "137"
}
["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) "59"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "7"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "3"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(1) "9"
}
["rets_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(39) "http://player.vimeo.com/video/716978912"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "2011"
}
["security"]=>
array(1) {
[0]=>
string(3) "Key"
}
["setbacks"]=>
array(1) {
[0]=>
string(13) "C&C,Of Record"
}
["state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["street_name"]=>
array(1) {
[0]=>
string(10) "Hawaii Loa"
}
["street_number"]=>
array(1) {
[0]=>
string(3) "150"
}
["street_suffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["terms_accept"]=>
array(1) {
[0]=>
string(26) "Cash,Conventional,Exchange"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-3-7-009-059-0000"
}
["topography"]=>
array(1) {
[0]=>
string(5) "Clear"
}
["view"]=>
array(1) {
[0]=>
string(22) "Mountain,Other,Sunrise"
}
["virtual_tour"]=>
array(1) {
[0]=>
string(39) "http://player.vimeo.com/video/716978912"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16696376"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202211096"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1660336275"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "2011"
}
["zoning"]=>
array(1) {
[0]=>
string(31) "03 - R10 - Residential District"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(3111) "a:189:{i:0;i:22401725;i:1;i:22401726;i:2;i:22401727;i:3;i:22401728;i:4;i:22401729;i:5;i:22401730;i:6;i:22401731;i:7;i:22401732;i:8;i:22401733;i:9;i:22401734;i:10;i:22401735;i:11;i:22401736;i:12;i:22401737;i:13;i:22401738;i:14;i:22401739;i:15;i:22401740;i:16;i:22401741;i:17;i:22401742;i:18;i:22401743;i:19;i:22401744;i:20;i:22401745;i:21;i:22401759;i:22;i:22401760;i:23;i:22401761;i:24;i:22401762;i:25;i:22401763;i:26;i:22401764;i:27;i:22401765;i:28;i:22401766;i:29;i:22401767;i:30;i:22401768;i:31;i:22401769;i:32;i:22401770;i:33;i:22401771;i:34;i:22401772;i:35;i:22401773;i:36;i:22401774;i:37;i:22401775;i:38;i:22401776;i:39;i:22401777;i:40;i:22401778;i:41;i:22401779;i:42;i:22456342;i:43;i:22456343;i:44;i:22456344;i:45;i:22456345;i:46;i:22456346;i:47;i:22456347;i:48;i:22456348;i:49;i:22456349;i:50;i:22456350;i:51;i:22456351;i:52;i:22456352;i:53;i:22456353;i:54;i:22456354;i:55;i:22456355;i:56;i:22456356;i:57;i:22456357;i:58;i:22456358;i:59;i:22456359;i:60;i:22456360;i:61;i:22456361;i:62;i:22456362;i:63;i:22482311;i:64;i:22482312;i:65;i:22482313;i:66;i:22482314;i:67;i:22482315;i:68;i:22482316;i:69;i:22482317;i:70;i:22482318;i:71;i:22482319;i:72;i:22482320;i:73;i:22482321;i:74;i:22482322;i:75;i:22482323;i:76;i:22482324;i:77;i:22482325;i:78;i:22482326;i:79;i:22482327;i:80;i:22482328;i:81;i:22482329;i:82;i:22482330;i:83;i:22482331;i:84;i:22505392;i:85;i:22505393;i:86;i:22505394;i:87;i:22505395;i:88;i:22505396;i:89;i:22505397;i:90;i:22505398;i:91;i:22505399;i:92;i:22505400;i:93;i:22505401;i:94;i:22505402;i:95;i:22505403;i:96;i:22505404;i:97;i:22505405;i:98;i:22505406;i:99;i:22505407;i:100;i:22505408;i:101;i:22505409;i:102;i:22505410;i:103;i:22505411;i:104;i:22505412;i:105;i:22532866;i:106;i:22532867;i:107;i:22532868;i:108;i:22532869;i:109;i:22532870;i:110;i:22532871;i:111;i:22532872;i:112;i:22532873;i:113;i:22532874;i:114;i:22532875;i:115;i:22532876;i:116;i:22532877;i:117;i:22532878;i:118;i:22532879;i:119;i:22532880;i:120;i:22532881;i:121;i:22532882;i:122;i:22532883;i:123;i:22532884;i:124;i:22532885;i:125;i:22532886;i:126;i:22532968;i:127;i:22532969;i:128;i:22532970;i:129;i:22532971;i:130;i:22532972;i:131;i:22532973;i:132;i:22532974;i:133;i:22532975;i:134;i:22532976;i:135;i:22532977;i:136;i:22532978;i:137;i:22532979;i:138;i:22532980;i:139;i:22532981;i:140;i:22532982;i:141;i:22532983;i:142;i:22532984;i:143;i:22532985;i:144;i:22532986;i:145;i:22532987;i:146;i:22532988;i:147;i:22550548;i:148;i:22550549;i:149;i:22550550;i:150;i:22550551;i:151;i:22550552;i:152;i:22550553;i:153;i:22550554;i:154;i:22550555;i:155;i:22550556;i:156;i:22550557;i:157;i:22550558;i:158;i:22550559;i:159;i:22550560;i:160;i:22550561;i:161;i:22550562;i:162;i:22550563;i:163;i:22550564;i:164;i:22550565;i:165;i:22550566;i:166;i:22550567;i:167;i:22550568;i:168;i:23030705;i:169;i:23030706;i:170;i:23030707;i:171;i:23030708;i:172;i:23030709;i:173;i:23030710;i:174;i:23030711;i:175;i:23030712;i:176;i:23030713;i:177;i:23030714;i:178;i:23030715;i:179;i:23030716;i:180;i:23030717;i:181;i:23030718;i:182;i:23030719;i:183;i:23030720;i:184;i:23030721;i:185;i:23030722;i:186;i:23030723;i:187;i:23030724;i:188;i:23030725;}"
}
["rets_open_house_count"]=>
array(1) {
[0]=>
string(1) "4"
}
["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-06-21"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-08-12"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(10) "2200000.00"
}
["rets_co_selling_agent_direct_work_pho"]=>
array(1) {
[0]=>
string(14) "(808) 596-0456"
}
["rets_co_selling_agent_email"]=>
array(1) {
[0]=>
string(26) "Bryan.Watkins@cbrealty.com"
}
["rets_co_selling_agent_full_name"]=>
array(1) {
[0]=>
string(13) "Bryan Watkins"
}
["rets_co_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "51642"
}
["rets_co_selling_agent_mui"]=>
array(1) {
[0]=>
string(8) "16097918"
}
["rets_co_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "CBPP"
}
["rets_co_selling_office_mui"]=>
array(1) {
[0]=>
string(7) "3485212"
}
["rets_co_selling_office_name"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["rets_co_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 596-0456"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2023-06-09"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-08-12"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 596-0456"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(21) "adriany@cbpacific.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(11) "Adrian H Yi"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "43509"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "3483642"
}
["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) "23030705"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 625000.00
)
[assd_val_land] => Array
(
[0] => 988800.00
)
[assd_val_total] => Array
(
[0] => 1613800.00
)
[bedrooms] => Array
(
[0] => 4
)
[building_style] => Array
(
[0] => Detach Single Family
)
[city] => Array
(
[0] => Honolulu
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Photovoltaic,Property Disclosure Stmt
)
[easements] => Array
(
[0] => None
)
[exclusions] => Array
(
[0] => Other
)
[floor_covering] => Array
(
[0] => Ceramic Tile,Laminate,W/W Carpet
)
[full_baths] => Array
(
[0] => 3
)
[furnished] => Array
(
[0] => None
)
[half_baths] => Array
(
[0] => 0
)
[home_exampt] => Array
(
[0] => 100000
)
[land_area_sf] => Array
(
[0] => 10001.00
)
[land_recorded] => Array
(
[0] => Regular System
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => tommy.kim@cbpacific.com
)
[list_agent_name] => Array
(
[0] => Tommy Kim
)
[list_agent_phone_number] => Array
(
[0] => (808) 596-0456
)
[list_date] => Array
(
[0] => 2022-06-09
)
[list_office_name] => Array
(
[0] => Coldwell Banker Realty
)
[list_price] => Array
(
[0] => 2250000.00
)
[living_sf] => Array
(
[0] => 2649
)
[location] => Array
(
[0] => 150 Hawaii Loa Street, Honolulu, HI 96821
)
[mls_] => Array
(
[0] => 202211096
)
[neighborhood] => Array
(
[0] => NIU VALLEY
)
[number_of_parking_spaces] => Array
(
[0] => 2
)
[number_of_stories] => Array
(
[0] => Two
)
[office_mls_id] => Array
(
[0] => CBPP
)
[parking_features] => Array
(
[0] => 3 Car+,Driveway,Garage,Street
)
[pool_] => Array
(
[0] => None
)
[possession] => Array
(
[0] => At Closing
)
[postal_code] => Array
(
[0] => 96821
)
[property_condition] => Array
(
[0] => Excellent
)
[property_type] => Array
(
[0] => single_family
)
[property_type_label] => Array
(
[0] => single_family
)
[region] => Array
(
[0] => DiamondHd
)
[rets_baths_full] => Array
(
[0] => 3
)
[rets_baths_half] => Array
(
[0] => 0
)
[rets_baths_total] => Array
(
[0] => 3.00
)
[rets_beds_total] => Array
(
[0] => 4
)
[rets_city] => Array
(
[0] => Honolulu
)
[rets_condo_property_regime_yn] => Array
(
[0] => 0
)
[rets_current_price] => Array
(
[0] => 2200000.00
)
[rets_dom] => Array
(
[0] => 12
)
[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] => 16696376
)
[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) 596-0456
)
[rets_list_agent_email] => Array
(
[0] => tommy.kim@cbpacific.com
)
[rets_list_agent_full_name] => Array
(
[0] => Tommy Kim
)
[rets_list_agent_mlsid] => Array
(
[0] => 44909
)
[rets_list_agent_mui] => Array
(
[0] => 9350639
)
[rets_list_office_mlsid] => Array
(
[0] => CBPP
)
[rets_list_office_mui] => Array
(
[0] => 3485212
)
[rets_list_office_name] => Array
(
[0] => Coldwell Banker Realty
)
[rets_list_office_phone] => Array
(
[0] => (808) 596-0456
)
[rets_list_price] => Array
(
[0] => 2250000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-06-09
)
[rets_lock_box_yn] => Array
(
[0] => 1
)
[rets_lot_size_area] => Array
(
[0] => 10001.00
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-08-12T10:29:23.503
)
[rets_matrix_unique_id] => Array
(
[0] => 16696376
)
[rets_mls_number] => Array
(
[0] => 202211096
)
[rets_neighbourhood] => Array
(
[0] => NIU VALLEY
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-06-09T18:50:35.263
)
[rets_original_list_price] => Array
(
[0] => 2250000.00
)
[rets_parcel_number] => Array
(
[0] => 1-3-7-009-059-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-06-09T18:50:35.263
)
[rets_postal_code] => Array
(
[0] => 96821
)
[rets_primary_key] => Array
(
[0] => 16696376
)
[rets_private_remarks] => Array
(
[0] => Showing appointments to prequalified and registered clients only are available starting Friday June 10th after 12 noon. For all questions and showing requests, please call or text listing agent Tommy Kim at 808-779-1416. OFFERS DUE BY 5:00 PM MONDAY JUNE 20TH. PLEASE SEE SUPPLEMENTS FOR OFFERING SUGGESTIONS & ADDENDA. PLEASE CONSIDER CRAIG ENDO of ORTC FOR ESCROW.
)
[rets_public_remarks] => Array
(
[0] => The one you have all been waiting for! Built in 2011 this beautifully designed 4 BD, 3 BA executive island style home is located in the coveted neighborhood of Niu Valley. The huge open floor plan with multiple living spaces provides seamless flow to the beautifully landscaped yards and covered patio for a true indoor/outdoor lifestyle! Your guests can lounge around the spacious kitchen island as you cook and entertain in your stunning gourmet kitchen. Enjoy the summer months with split A/C throughout, with tastefully installed in-wall plumbing and electrical, and 34 owned PV panels with net metering and solar water! The upstairs primary suite provides privacy and relaxation with its spacious layout, deep walk-in closet, and spa style rain shower. The highly functional floor plan also comes with two oversized bedrooms and a Jack and Jill bathroom upstairs. Conveniently situated downstairs, you will find a fourth bedroom or den and full bath w/ walk in shower. Need the perfect Father’s Day gift . . . consider gifting him this oversized 571 sq. ft. garage with storage galore and a bonus workshop nook with additional storage. A must see!
)
[rets_room_count] => Array
(
[0] => 0
)
[rets_sqft_garage_carport] => Array
(
[0] => 561
)
[rets_sqft_roofed_living] => Array
(
[0] => 2455
)
[rets_sqft_roofed_other] => Array
(
[0] => 194
)
[rets_sqft_total] => Array
(
[0] => 2649
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-08-12T10:29:23.503
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-08-12
)
[rets_street_name] => Array
(
[0] => Hawaii Loa
)
[rets_street_number] => Array
(
[0] => 150
)
[rets_street_view_param] => Array
(
[0] => 1$21.281779$-157.74249$325.09$13.33$1.00$9m3X3at_bS8f8T_-TWp9oQ
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5
)
[rets_supplement_count] => Array
(
[0] => 2
)
[rets_supplement_modification_timestam] => Array
(
[0] => 2022-06-09T18:34:36.673
)
[rets_tax_amount] => Array
(
[0] => 442.00
)
[rets_tax_annual_amount] => Array
(
[0] => 5304.00
)
[rets_tax_assessed_value] => Array
(
[0] => 1613800.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 625000.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 988800.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 100000
)
[rets_tax_paid_by_seller_yn] => Array
(
[0] => 0
)
[rets_tax_year] => Array
(
[0] => 2022
)
[rets_thumbnail_url] => Array
(
[0] => https://cdn.rets.ci/marcusrealty-images/16696376/ea5ca256ecc5b33d4e5913f7ae68d4b6
)
[rets_tmk_area] => Array
(
[0] => 137
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 0
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 59
)
[rets_tmk_section] => Array
(
[0] => 7
)
[rets_tmk_zone] => Array
(
[0] => 3
)
[rets_tmkplat] => Array
(
[0] => 9
)
[rets_virtual_tour_url_unbranded] => Array
(
[0] => http://player.vimeo.com/video/716978912
)
[rets_year_built] => Array
(
[0] => 2011
)
[security] => Array
(
[0] => Key
)
[setbacks] => Array
(
[0] => C&C,Of Record
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Hawaii Loa
)
[street_number] => Array
(
[0] => 150
)
[street_suffix] => Array
(
[0] => Street
)
[terms_accept] => Array
(
[0] => Cash,Conventional,Exchange
)
[tmk] => Array
(
[0] => 1-3-7-009-059-0000
)
[topography] => Array
(
[0] => Clear
)
[view] => Array
(
[0] => Mountain,Other,Sunrise
)
[virtual_tour] => Array
(
[0] => http://player.vimeo.com/video/716978912
)
[wpp::rets_pk] => Array
(
[0] => 16696376
)
[wpp_gpid] => Array
(
[0] => 202211096
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1660336275
)
[year_built] => Array
(
[0] => 2011
)
[zoning] => Array
(
[0] => 03 - R10 - Residential District
)
[new_attached_media] => Array
(
[0] => a:189:{i:0;i:22401725;i:1;i:22401726;i:2;i:22401727;i:3;i:22401728;i:4;i:22401729;i:5;i:22401730;i:6;i:22401731;i:7;i:22401732;i:8;i:22401733;i:9;i:22401734;i:10;i:22401735;i:11;i:22401736;i:12;i:22401737;i:13;i:22401738;i:14;i:22401739;i:15;i:22401740;i:16;i:22401741;i:17;i:22401742;i:18;i:22401743;i:19;i:22401744;i:20;i:22401745;i:21;i:22401759;i:22;i:22401760;i:23;i:22401761;i:24;i:22401762;i:25;i:22401763;i:26;i:22401764;i:27;i:22401765;i:28;i:22401766;i:29;i:22401767;i:30;i:22401768;i:31;i:22401769;i:32;i:22401770;i:33;i:22401771;i:34;i:22401772;i:35;i:22401773;i:36;i:22401774;i:37;i:22401775;i:38;i:22401776;i:39;i:22401777;i:40;i:22401778;i:41;i:22401779;i:42;i:22456342;i:43;i:22456343;i:44;i:22456344;i:45;i:22456345;i:46;i:22456346;i:47;i:22456347;i:48;i:22456348;i:49;i:22456349;i:50;i:22456350;i:51;i:22456351;i:52;i:22456352;i:53;i:22456353;i:54;i:22456354;i:55;i:22456355;i:56;i:22456356;i:57;i:22456357;i:58;i:22456358;i:59;i:22456359;i:60;i:22456360;i:61;i:22456361;i:62;i:22456362;i:63;i:22482311;i:64;i:22482312;i:65;i:22482313;i:66;i:22482314;i:67;i:22482315;i:68;i:22482316;i:69;i:22482317;i:70;i:22482318;i:71;i:22482319;i:72;i:22482320;i:73;i:22482321;i:74;i:22482322;i:75;i:22482323;i:76;i:22482324;i:77;i:22482325;i:78;i:22482326;i:79;i:22482327;i:80;i:22482328;i:81;i:22482329;i:82;i:22482330;i:83;i:22482331;i:84;i:22505392;i:85;i:22505393;i:86;i:22505394;i:87;i:22505395;i:88;i:22505396;i:89;i:22505397;i:90;i:22505398;i:91;i:22505399;i:92;i:22505400;i:93;i:22505401;i:94;i:22505402;i:95;i:22505403;i:96;i:22505404;i:97;i:22505405;i:98;i:22505406;i:99;i:22505407;i:100;i:22505408;i:101;i:22505409;i:102;i:22505410;i:103;i:22505411;i:104;i:22505412;i:105;i:22532866;i:106;i:22532867;i:107;i:22532868;i:108;i:22532869;i:109;i:22532870;i:110;i:22532871;i:111;i:22532872;i:112;i:22532873;i:113;i:22532874;i:114;i:22532875;i:115;i:22532876;i:116;i:22532877;i:117;i:22532878;i:118;i:22532879;i:119;i:22532880;i:120;i:22532881;i:121;i:22532882;i:122;i:22532883;i:123;i:22532884;i:124;i:22532885;i:125;i:22532886;i:126;i:22532968;i:127;i:22532969;i:128;i:22532970;i:129;i:22532971;i:130;i:22532972;i:131;i:22532973;i:132;i:22532974;i:133;i:22532975;i:134;i:22532976;i:135;i:22532977;i:136;i:22532978;i:137;i:22532979;i:138;i:22532980;i:139;i:22532981;i:140;i:22532982;i:141;i:22532983;i:142;i:22532984;i:143;i:22532985;i:144;i:22532986;i:145;i:22532987;i:146;i:22532988;i:147;i:22550548;i:148;i:22550549;i:149;i:22550550;i:150;i:22550551;i:151;i:22550552;i:152;i:22550553;i:153;i:22550554;i:154;i:22550555;i:155;i:22550556;i:156;i:22550557;i:157;i:22550558;i:158;i:22550559;i:159;i:22550560;i:160;i:22550561;i:161;i:22550562;i:162;i:22550563;i:163;i:22550564;i:164;i:22550565;i:165;i:22550566;i:166;i:22550567;i:167;i:22550568;i:168;i:23030705;i:169;i:23030706;i:170;i:23030707;i:171;i:23030708;i:172;i:23030709;i:173;i:23030710;i:174;i:23030711;i:175;i:23030712;i:176;i:23030713;i:177;i:23030714;i:178;i:23030715;i:179;i:23030716;i:180;i:23030717;i:181;i:23030718;i:182;i:23030719;i:183;i:23030720;i:184;i:23030721;i:185;i:23030722;i:186;i:23030723;i:187;i:23030724;i:188;i:23030725;}
)
[rets_open_house_count] => Array
(
[0] => 4
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_open_house_upcoming] => Array
(
[0] =>
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-06-21
)
[rets_close_date] => Array
(
[0] => 2022-08-12
)
[rets_close_price] => Array
(
[0] => 2200000.00
)
[rets_co_selling_agent_direct_work_pho] => Array
(
[0] => (808) 596-0456
)
[rets_co_selling_agent_email] => Array
(
[0] => Bryan.Watkins@cbrealty.com
)
[rets_co_selling_agent_full_name] => Array
(
[0] => Bryan Watkins
)
[rets_co_selling_agent_mlsid] => Array
(
[0] => 51642
)
[rets_co_selling_agent_mui] => Array
(
[0] => 16097918
)
[rets_co_selling_office_mlsid] => Array
(
[0] => CBPP
)
[rets_co_selling_office_mui] => Array
(
[0] => 3485212
)
[rets_co_selling_office_name] => Array
(
[0] => Coldwell Banker Realty
)
[rets_co_selling_office_phone] => Array
(
[0] => (808) 596-0456
)
[rets_expiration_date] => Array
(
[0] => 2023-06-09
)
[rets_off_market_date] => Array
(
[0] => 2022-08-12
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 596-0456
)
[rets_selling_agent_email] => Array
(
[0] => adriany@cbpacific.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Adrian H Yi
)
[rets_selling_agent_mlsid] => Array
(
[0] => 43509
)
[rets_selling_agent_mui] => Array
(
[0] => 3483642
)
[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] => 23030705
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446