NEW LISTING!! Enjoy the enchanting panoramic ocean and Diamond Head views offered by this breezy 4 bdrm/3.5 bath executive style residence in highly desirable Waialae Iki Ridge. With over 3,000 sq. ft. of nicely maintained interior living space, features include fresh interior paint, new carpet and vinyl plank floors, an expansive open kitchen, high vaulted ceilings, a wraparound deck and your own private backyard oasis with an in-ground swimming pool and spa. Soak in the views from the spacious upper-level deck, perfect with a morning cup of coffee. Ideally located near beaches, parks and Kahala Mall with restaurants, shopping, and entertainment.
Listing by: BHGRE Advantage Realty (808) 738-3600
array(168) {
["agency"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "688000.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(10) "1266200.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(10) "1954200.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(48) "Inactive Licensed Owner,Property Disclosure Stmt"
}
["easements"]=>
array(1) {
[0]=>
string(5) "Sewer"
}
["elementary_school"]=>
array(1) {
[0]=>
string(10) "Aina Haina"
}
["exclusions"]=>
array(1) {
[0]=>
string(5) "Other"
}
["floor_covering"]=>
array(1) {
[0]=>
string(22) "Other,Vinyl,W/W Carpet"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "3"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "1"
}
["high_school"]=>
array(1) {
[0]=>
string(6) "Kalani"
}
["home_exampt"]=>
array(1) {
[0]=>
string(7) "100,000"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(3) "317"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(7) "7562.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) "MyronK@BetterHawaii.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(13) "Myron N Kiriu"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 738-3600"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2021-09-17"
}
["list_office_name"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["list_price"]=>
array(1) {
[0]=>
string(10) "2430000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "3347"
}
["location"]=>
array(1) {
[0]=>
string(38) "1912 Alaweo Street, Honolulu, HI 96821"
}
["middle_school"]=>
array(1) {
[0]=>
string(10) "Niu Valley"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202121671"
}
["neighborhood"]=>
array(1) {
[0]=>
string(11) "WAIALAE IKI"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "2"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(11) "Split Level"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "ADVG"
}
["parking_features"]=>
array(1) {
[0]=>
string(28) "2 Car,Driveway,Garage,Street"
}
["pool_"]=>
array(1) {
[0]=>
string(14) "In Ground,Tile"
}
["possession"]=>
array(1) {
[0]=>
string(10) "At Closing"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96821"
}
["property_condition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["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) "1"
}
["rets_baths_total"]=>
array(1) {
[0]=>
string(4) "3.01"
}
["rets_beds_total"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_city"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["rets_co_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 738-3600"
}
["rets_co_list_agent_email"]=>
array(1) {
[0]=>
string(23) "taniad@betterhawaii.com"
}
["rets_co_list_agent_full_name"]=>
array(1) {
[0]=>
string(14) "Tania De Jesus"
}
["rets_co_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "50278"
}
["rets_co_list_agent_mui"]=>
array(1) {
[0]=>
string(8) "15031786"
}
["rets_co_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "ADVG"
}
["rets_co_list_office_mui"]=>
array(1) {
[0]=>
string(7) "9695164"
}
["rets_co_list_office_name"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["rets_co_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 738-3600"
}
["rets_condo_property_regime_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(10) "2485000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(1) "7"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_elementary_school"]=>
array(1) {
[0]=>
string(10) "Aina Haina"
}
["rets_fractional_ownership_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_high_school"]=>
array(1) {
[0]=>
string(6) "Kalani"
}
["rets_id"]=>
array(1) {
[0]=>
string(8) "16122337"
}
["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) 738-3600"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(23) "MyronK@BetterHawaii.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(13) "Myron N Kiriu"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "17960"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "3473447"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "ADVG"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(7) "9695164"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 738-3600"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(10) "2430000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2021-09-17"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(7) "7562.00"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2021-10-27T11:08:14.160"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16122337"
}
["rets_middle_or_junior_school"]=>
array(1) {
[0]=>
string(10) "Niu Valley"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202121671"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(11) "WAIALAE IKI"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2021-09-17T08:17:03.803"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(10) "2430000.00"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-3-5-070-005-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) "2021-09-17T08:17:03.803"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96821"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2021-09-17T08:17:03.803"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16122337"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(234) "Please call/text/email Tania De Jesus at 808-387-7547; TaniaD@BetterHawaii.com for information and showings. For a detail tour of the home, please view our 360 degree virtual tour at https://my.matterport.com/show/?m=uiijHhNm1b4&mls=1"
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(655) "NEW LISTING!! Enjoy the enchanting panoramic ocean and Diamond Head views offered by this breezy 4 bdrm/3.5 bath executive style residence in highly desirable Waialae Iki Ridge. With over 3,000 sq. ft. of nicely maintained interior living space, features include fresh interior paint, new carpet and vinyl plank floors, an expansive open kitchen, high vaulted ceilings, a wraparound deck and your own private backyard oasis with an in-ground swimming pool and spa. Soak in the views from the spacious upper-level deck, perfect with a morning cup of coffee. Ideally located near beaches, parks and Kahala Mall with restaurants, shopping, and entertainment."
}
["rets_sqft_garage_carport"]=>
array(1) {
[0]=>
string(3) "477"
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(3) "317"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "3030"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "3347"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2021-10-27T11:08:14.160"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2021-10-27"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(6) "Alaweo"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(4) "1912"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(64) "1$21.286699$-157.765761$272.61$13.33$1.00$fFaBI7vxIKb9rEmnWvOzBA"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(3) "2.5"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "548.21"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(10) "1954200.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "688000.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(10) "1266200.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/16122337/2a47f3fc2f8842d4e4b4f04fa0dbda03"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "135"
}
["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) "5"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "5"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "3"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(2) "70"
}
["rets_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(28) "https://youtu.be/OSU1OL9_txY"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1981"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(0) ""
}
["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(6) "Alaweo"
}
["street_number"]=>
array(1) {
[0]=>
string(4) "1912"
}
["street_suffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["terms_accept"]=>
array(1) {
[0]=>
string(17) "Cash,Conventional"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-3-5-070-005-0000"
}
["topography"]=>
array(1) {
[0]=>
string(5) "Clear"
}
["view"]=>
array(1) {
[0]=>
string(23) "City,Diamond Head,Ocean"
}
["virtual_tour"]=>
array(1) {
[0]=>
string(28) "https://youtu.be/OSU1OL9_txY"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16122337"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202121671"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1635368957"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1981"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "2001"
}
["zoning"]=>
array(1) {
[0]=>
string(31) "04 - R-7.5 Residential District"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(2754) "a:168:{i:0;i:20762858;i:1;i:20762859;i:2;i:20762860;i:3;i:20762861;i:4;i:20762862;i:5;i:20762863;i:6;i:20762864;i:7;i:20762865;i:8;i:20762866;i:9;i:20762867;i:10;i:20762868;i:11;i:20762869;i:12;i:20762870;i:13;i:20762871;i:14;i:20762872;i:15;i:20762873;i:16;i:20762874;i:17;i:20762875;i:18;i:20762876;i:19;i:20762877;i:20;i:20762878;i:21;i:20762900;i:22;i:20762901;i:23;i:20762902;i:24;i:20762903;i:25;i:20762904;i:26;i:20762905;i:27;i:20762906;i:28;i:20762907;i:29;i:20762908;i:30;i:20762909;i:31;i:20762910;i:32;i:20762911;i:33;i:20762912;i:34;i:20762913;i:35;i:20762914;i:36;i:20762915;i:37;i:20762916;i:38;i:20762917;i:39;i:20762918;i:40;i:20762919;i:41;i:20762920;i:42;i:20780301;i:43;i:20780302;i:44;i:20780303;i:45;i:20780304;i:46;i:20780305;i:47;i:20780306;i:48;i:20780307;i:49;i:20780308;i:50;i:20780309;i:51;i:20780310;i:52;i:20780311;i:53;i:20780312;i:54;i:20780313;i:55;i:20780314;i:56;i:20780315;i:57;i:20780316;i:58;i:20780317;i:59;i:20780318;i:60;i:20780319;i:61;i:20780320;i:62;i:20780321;i:63;i:20787425;i:64;i:20787426;i:65;i:20787427;i:66;i:20787428;i:67;i:20787429;i:68;i:20787430;i:69;i:20787431;i:70;i:20787432;i:71;i:20787433;i:72;i:20787434;i:73;i:20787435;i:74;i:20787436;i:75;i:20787437;i:76;i:20787438;i:77;i:20787439;i:78;i:20787440;i:79;i:20787441;i:80;i:20787442;i:81;i:20787443;i:82;i:20787444;i:83;i:20787445;i:84;i:20792626;i:85;i:20792627;i:86;i:20792628;i:87;i:20792629;i:88;i:20792630;i:89;i:20792631;i:90;i:20792632;i:91;i:20792633;i:92;i:20792634;i:93;i:20792635;i:94;i:20792636;i:95;i:20792637;i:96;i:20792638;i:97;i:20792639;i:98;i:20792640;i:99;i:20792641;i:100;i:20792642;i:101;i:20792643;i:102;i:20792644;i:103;i:20792645;i:104;i:20792646;i:105;i:20836655;i:106;i:20836656;i:107;i:20836657;i:108;i:20836658;i:109;i:20836659;i:110;i:20836660;i:111;i:20836661;i:112;i:20836662;i:113;i:20836663;i:114;i:20836664;i:115;i:20836665;i:116;i:20836666;i:117;i:20836667;i:118;i:20836668;i:119;i:20836669;i:120;i:20836670;i:121;i:20836671;i:122;i:20836672;i:123;i:20836673;i:124;i:20836674;i:125;i:20836675;i:126;i:20898466;i:127;i:20898467;i:128;i:20898468;i:129;i:20898469;i:130;i:20898470;i:131;i:20898471;i:132;i:20898472;i:133;i:20898473;i:134;i:20898474;i:135;i:20898475;i:136;i:20898476;i:137;i:20898477;i:138;i:20898478;i:139;i:20898479;i:140;i:20898480;i:141;i:20898481;i:142;i:20898482;i:143;i:20898483;i:144;i:20898484;i:145;i:20898485;i:146;i:20898486;i:147;i:21043370;i:148;i:21043371;i:149;i:21043372;i:150;i:21043373;i:151;i:21043374;i:152;i:21043375;i:153;i:21043376;i:154;i:21043377;i:155;i:21043378;i:156;i:21043379;i:157;i:21043380;i:158;i:21043381;i:159;i:21043382;i:160;i:21043383;i:161;i:21043384;i:162;i:21043385;i:163;i:21043386;i:164;i:21043387;i:165;i:21043388;i:166;i:21043389;i:167;i:21043390;}"
}
["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) "2021-09-23"
}
["rets_pending_date"]=>
array(1) {
[0]=>
string(10) "2021-09-23"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2021-10-27"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(10) "2485000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-07-09"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2021-10-27"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 735-4200"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(32) "jon.yamasato@locationshawaii.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(14) "Jon M Yamasato"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "26178"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "8843326"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "LOCA"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(7) "3485305"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(13) "Locations LLC"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 735-4200"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "6578.52"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "21043370"
}
}
Array
(
[agency] => Array
(
[0] => BHGRE Advantage Realty
)
[assd_val_imprv] => Array
(
[0] => 688000.00
)
[assd_val_land] => Array
(
[0] => 1266200.00
)
[assd_val_total] => Array
(
[0] => 1954200.00
)
[bedrooms] => Array
(
[0] => 4
)
[building_style] => Array
(
[0] => Detach Single Family
)
[city] => Array
(
[0] => Honolulu
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Inactive Licensed Owner,Property Disclosure Stmt
)
[easements] => Array
(
[0] => Sewer
)
[elementary_school] => Array
(
[0] => Aina Haina
)
[exclusions] => Array
(
[0] => Other
)
[floor_covering] => Array
(
[0] => Other,Vinyl,W/W Carpet
)
[full_baths] => Array
(
[0] => 3
)
[half_baths] => Array
(
[0] => 1
)
[high_school] => Array
(
[0] => Kalani
)
[home_exampt] => Array
(
[0] => 100,000
)
[lanai_sf] => Array
(
[0] => 317
)
[land_area_sf] => Array
(
[0] => 7562.00
)
[land_recorded] => Array
(
[0] => Regular System
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => MyronK@BetterHawaii.com
)
[list_agent_name] => Array
(
[0] => Myron N Kiriu
)
[list_agent_phone_number] => Array
(
[0] => (808) 738-3600
)
[list_date] => Array
(
[0] => 2021-09-17
)
[list_office_name] => Array
(
[0] => BHGRE Advantage Realty
)
[list_price] => Array
(
[0] => 2430000.00
)
[living_sf] => Array
(
[0] => 3347
)
[location] => Array
(
[0] => 1912 Alaweo Street, Honolulu, HI 96821
)
[middle_school] => Array
(
[0] => Niu Valley
)
[mls_] => Array
(
[0] => 202121671
)
[neighborhood] => Array
(
[0] => WAIALAE IKI
)
[number_of_parking_spaces] => Array
(
[0] => 2
)
[number_of_stories] => Array
(
[0] => Split Level
)
[office_mls_id] => Array
(
[0] => ADVG
)
[parking_features] => Array
(
[0] => 2 Car,Driveway,Garage,Street
)
[pool_] => Array
(
[0] => In Ground,Tile
)
[possession] => Array
(
[0] => At Closing
)
[postal_code] => Array
(
[0] => 96821
)
[property_condition] => Array
(
[0] => Above Average
)
[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] => 1
)
[rets_baths_total] => Array
(
[0] => 3.01
)
[rets_beds_total] => Array
(
[0] => 4
)
[rets_city] => Array
(
[0] => Honolulu
)
[rets_co_list_agent_direct_work_phone] => Array
(
[0] => (808) 738-3600
)
[rets_co_list_agent_email] => Array
(
[0] => taniad@betterhawaii.com
)
[rets_co_list_agent_full_name] => Array
(
[0] => Tania De Jesus
)
[rets_co_list_agent_mlsid] => Array
(
[0] => 50278
)
[rets_co_list_agent_mui] => Array
(
[0] => 15031786
)
[rets_co_list_office_mlsid] => Array
(
[0] => ADVG
)
[rets_co_list_office_mui] => Array
(
[0] => 9695164
)
[rets_co_list_office_name] => Array
(
[0] => BHGRE Advantage Realty
)
[rets_co_list_office_phone] => Array
(
[0] => (808) 738-3600
)
[rets_condo_property_regime_yn] => Array
(
[0] => 0
)
[rets_current_price] => Array
(
[0] => 2485000.00
)
[rets_dom] => Array
(
[0] => 7
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_elementary_school] => Array
(
[0] => Aina Haina
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_high_school] => Array
(
[0] => Kalani
)
[rets_id] => Array
(
[0] => 16122337
)
[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) 738-3600
)
[rets_list_agent_email] => Array
(
[0] => MyronK@BetterHawaii.com
)
[rets_list_agent_full_name] => Array
(
[0] => Myron N Kiriu
)
[rets_list_agent_mlsid] => Array
(
[0] => 17960
)
[rets_list_agent_mui] => Array
(
[0] => 3473447
)
[rets_list_office_mlsid] => Array
(
[0] => ADVG
)
[rets_list_office_mui] => Array
(
[0] => 9695164
)
[rets_list_office_name] => Array
(
[0] => BHGRE Advantage Realty
)
[rets_list_office_phone] => Array
(
[0] => (808) 738-3600
)
[rets_list_price] => Array
(
[0] => 2430000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2021-09-17
)
[rets_lot_size_area] => Array
(
[0] => 7562.00
)
[rets_matrix_modified_dt] => Array
(
[0] => 2021-10-27T11:08:14.160
)
[rets_matrix_unique_id] => Array
(
[0] => 16122337
)
[rets_middle_or_junior_school] => Array
(
[0] => Niu Valley
)
[rets_mls_number] => Array
(
[0] => 202121671
)
[rets_neighbourhood] => Array
(
[0] => WAIALAE IKI
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2021-09-17T08:17:03.803
)
[rets_original_list_price] => Array
(
[0] => 2430000.00
)
[rets_parcel_number] => Array
(
[0] => 1-3-5-070-005-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] => 2021-09-17T08:17:03.803
)
[rets_postal_code] => Array
(
[0] => 96821
)
[rets_price_change_timestamp] => Array
(
[0] => 2021-09-17T08:17:03.803
)
[rets_primary_key] => Array
(
[0] => 16122337
)
[rets_private_remarks] => Array
(
[0] => Please call/text/email Tania De Jesus at 808-387-7547; TaniaD@BetterHawaii.com for information and showings. For a detail tour of the home, please view our 360 degree virtual tour at https://my.matterport.com/show/?m=uiijHhNm1b4&mls=1
)
[rets_public_remarks] => Array
(
[0] => NEW LISTING!! Enjoy the enchanting panoramic ocean and Diamond Head views offered by this breezy 4 bdrm/3.5 bath executive style residence in highly desirable Waialae Iki Ridge. With over 3,000 sq. ft. of nicely maintained interior living space, features include fresh interior paint, new carpet and vinyl plank floors, an expansive open kitchen, high vaulted ceilings, a wraparound deck and your own private backyard oasis with an in-ground swimming pool and spa. Soak in the views from the spacious upper-level deck, perfect with a morning cup of coffee. Ideally located near beaches, parks and Kahala Mall with restaurants, shopping, and entertainment.
)
[rets_sqft_garage_carport] => Array
(
[0] => 477
)
[rets_sqft_lanai_open] => Array
(
[0] => 317
)
[rets_sqft_roofed_living] => Array
(
[0] => 3030
)
[rets_sqft_total] => Array
(
[0] => 3347
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2021-10-27T11:08:14.160
)
[rets_status_contractual_search_date] => Array
(
[0] => 2021-10-27
)
[rets_street_name] => Array
(
[0] => Alaweo
)
[rets_street_number] => Array
(
[0] => 1912
)
[rets_street_view_param] => Array
(
[0] => 1$21.286699$-157.765761$272.61$13.33$1.00$fFaBI7vxIKb9rEmnWvOzBA
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5
)
[rets_tax_amount] => Array
(
[0] => 548.21
)
[rets_tax_assessed_value] => Array
(
[0] => 1954200.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 688000.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 1266200.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/16122337/2a47f3fc2f8842d4e4b4f04fa0dbda03
)
[rets_tmk_area] => Array
(
[0] => 135
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 0
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 5
)
[rets_tmk_section] => Array
(
[0] => 5
)
[rets_tmk_zone] => Array
(
[0] => 3
)
[rets_tmkplat] => Array
(
[0] => 70
)
[rets_virtual_tour_url_unbranded] => Array
(
[0] => https://youtu.be/OSU1OL9_txY
)
[rets_year_built] => Array
(
[0] => 1981
)
[rets_year_remodeled] => Array
(
[0] =>
)
[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] => Alaweo
)
[street_number] => Array
(
[0] => 1912
)
[street_suffix] => Array
(
[0] => Street
)
[terms_accept] => Array
(
[0] => Cash,Conventional
)
[tmk] => Array
(
[0] => 1-3-5-070-005-0000
)
[topography] => Array
(
[0] => Clear
)
[view] => Array
(
[0] => City,Diamond Head,Ocean
)
[virtual_tour] => Array
(
[0] => https://youtu.be/OSU1OL9_txY
)
[wpp::rets_pk] => Array
(
[0] => 16122337
)
[wpp_gpid] => Array
(
[0] => 202121671
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1635368957
)
[year_built] => Array
(
[0] => 1981
)
[year_remodeled_] => Array
(
[0] => 2001
)
[zoning] => Array
(
[0] => 04 - R-7.5 Residential District
)
[new_attached_media] => Array
(
[0] => a:168:{i:0;i:20762858;i:1;i:20762859;i:2;i:20762860;i:3;i:20762861;i:4;i:20762862;i:5;i:20762863;i:6;i:20762864;i:7;i:20762865;i:8;i:20762866;i:9;i:20762867;i:10;i:20762868;i:11;i:20762869;i:12;i:20762870;i:13;i:20762871;i:14;i:20762872;i:15;i:20762873;i:16;i:20762874;i:17;i:20762875;i:18;i:20762876;i:19;i:20762877;i:20;i:20762878;i:21;i:20762900;i:22;i:20762901;i:23;i:20762902;i:24;i:20762903;i:25;i:20762904;i:26;i:20762905;i:27;i:20762906;i:28;i:20762907;i:29;i:20762908;i:30;i:20762909;i:31;i:20762910;i:32;i:20762911;i:33;i:20762912;i:34;i:20762913;i:35;i:20762914;i:36;i:20762915;i:37;i:20762916;i:38;i:20762917;i:39;i:20762918;i:40;i:20762919;i:41;i:20762920;i:42;i:20780301;i:43;i:20780302;i:44;i:20780303;i:45;i:20780304;i:46;i:20780305;i:47;i:20780306;i:48;i:20780307;i:49;i:20780308;i:50;i:20780309;i:51;i:20780310;i:52;i:20780311;i:53;i:20780312;i:54;i:20780313;i:55;i:20780314;i:56;i:20780315;i:57;i:20780316;i:58;i:20780317;i:59;i:20780318;i:60;i:20780319;i:61;i:20780320;i:62;i:20780321;i:63;i:20787425;i:64;i:20787426;i:65;i:20787427;i:66;i:20787428;i:67;i:20787429;i:68;i:20787430;i:69;i:20787431;i:70;i:20787432;i:71;i:20787433;i:72;i:20787434;i:73;i:20787435;i:74;i:20787436;i:75;i:20787437;i:76;i:20787438;i:77;i:20787439;i:78;i:20787440;i:79;i:20787441;i:80;i:20787442;i:81;i:20787443;i:82;i:20787444;i:83;i:20787445;i:84;i:20792626;i:85;i:20792627;i:86;i:20792628;i:87;i:20792629;i:88;i:20792630;i:89;i:20792631;i:90;i:20792632;i:91;i:20792633;i:92;i:20792634;i:93;i:20792635;i:94;i:20792636;i:95;i:20792637;i:96;i:20792638;i:97;i:20792639;i:98;i:20792640;i:99;i:20792641;i:100;i:20792642;i:101;i:20792643;i:102;i:20792644;i:103;i:20792645;i:104;i:20792646;i:105;i:20836655;i:106;i:20836656;i:107;i:20836657;i:108;i:20836658;i:109;i:20836659;i:110;i:20836660;i:111;i:20836661;i:112;i:20836662;i:113;i:20836663;i:114;i:20836664;i:115;i:20836665;i:116;i:20836666;i:117;i:20836667;i:118;i:20836668;i:119;i:20836669;i:120;i:20836670;i:121;i:20836671;i:122;i:20836672;i:123;i:20836673;i:124;i:20836674;i:125;i:20836675;i:126;i:20898466;i:127;i:20898467;i:128;i:20898468;i:129;i:20898469;i:130;i:20898470;i:131;i:20898471;i:132;i:20898472;i:133;i:20898473;i:134;i:20898474;i:135;i:20898475;i:136;i:20898476;i:137;i:20898477;i:138;i:20898478;i:139;i:20898479;i:140;i:20898480;i:141;i:20898481;i:142;i:20898482;i:143;i:20898483;i:144;i:20898484;i:145;i:20898485;i:146;i:20898486;i:147;i:21043370;i:148;i:21043371;i:149;i:21043372;i:150;i:21043373;i:151;i:21043374;i:152;i:21043375;i:153;i:21043376;i:154;i:21043377;i:155;i:21043378;i:156;i:21043379;i:157;i:21043380;i:158;i:21043381;i:159;i:21043382;i:160;i:21043383;i:161;i:21043384;i:162;i:21043385;i:163;i:21043386;i:164;i:21043387;i:165;i:21043388;i:166;i:21043389;i:167;i:21043390;}
)
[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] => 2021-09-23
)
[rets_pending_date] => Array
(
[0] => 2021-09-23
)
[rets_close_date] => Array
(
[0] => 2021-10-27
)
[rets_close_price] => Array
(
[0] => 2485000.00
)
[rets_expiration_date] => Array
(
[0] => 2022-07-09
)
[rets_off_market_date] => Array
(
[0] => 2021-10-27
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 735-4200
)
[rets_selling_agent_email] => Array
(
[0] => jon.yamasato@locationshawaii.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Jon M Yamasato
)
[rets_selling_agent_mlsid] => Array
(
[0] => 26178
)
[rets_selling_agent_mui] => Array
(
[0] => 8843326
)
[rets_selling_office_mlsid] => Array
(
[0] => LOCA
)
[rets_selling_office_mui] => Array
(
[0] => 3485305
)
[rets_selling_office_name] => Array
(
[0] => Locations LLC
)
[rets_selling_office_phone] => Array
(
[0] => (808) 735-4200
)
[rets_tax_annual_amount] => Array
(
[0] => 6578.52
)
[_thumbnail_id] => Array
(
[0] => 21043370
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446