Splendid Waialae Golf course frontage! Famed architect Albert Ives designed home of this quality and location rarely comes in the market! Create your family sanctuary on large 16,150 sq.ft prime land! All in one level 4bd 4bath main home + pool house w full bath + Japanese Tea House w full bath. Fully renovated in 2021-custom built gourmet kitchen with subzero, wolf appliances, Cambria countertop – large master closet and master suite with modern soaking bathtub. House is quipped with Photovoltaic panels for energy savings! Pool and tea house can be both guest cottage and great for entertainment! Endless potential to create your own family compound in this quite street. Don’t miss out this great house!
Listing by: Coldwell Banker Realty
array(158) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "609000.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(10) "2235800.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(10) "2844800.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "6"
}
["building_style"]=>
array(1) {
[0]=>
string(35) "Detach Single Family,Studio Cottage"
}
["city"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(4) "None"
}
["easements"]=>
array(1) {
[0]=>
string(5) "Other"
}
["elementary_school"]=>
array(1) {
[0]=>
string(6) "Kahala"
}
["floor_covering"]=>
array(1) {
[0]=>
string(25) "Hardwood,Other,W/W Carpet"
}
["frontage"]=>
array(1) {
[0]=>
string(11) "Golf Course"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "6"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["high_school"]=>
array(1) {
[0]=>
string(6) "Kalani"
}
["home_exampt"]=>
array(1) {
[0]=>
string(1) "0"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(3) "320"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(8) "16150.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(20) "mariah@cbpacific.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(9) "Maria Hsu"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 596-0456"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2021-10-15"
}
["list_office_name"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["list_price"]=>
array(1) {
[0]=>
string(10) "4485000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "4397"
}
["location"]=>
array(1) {
[0]=>
string(39) "4645 Waipahee Place, Honolulu, HI 96821"
}
["middle_school"]=>
array(1) {
[0]=>
string(7) "Kaimuki"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202126027"
}
["neighborhood"]=>
array(1) {
[0]=>
string(11) "WAIALAE G/C"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "4"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(3) "One"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "CBPP"
}
["parking_features"]=>
array(1) {
[0]=>
string(27) "3 Car+,Boat,Driveway,Garage"
}
["pool_"]=>
array(1) {
[0]=>
string(9) "In Ground"
}
["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) "6"
}
["rets_baths_half"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_baths_total"]=>
array(1) {
[0]=>
string(4) "6.00"
}
["rets_beds_total"]=>
array(1) {
[0]=>
string(1) "6"
}
["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) "4250000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(2) "14"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_elementary_school"]=>
array(1) {
[0]=>
string(6) "Kahala"
}
["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) "Kalani"
}
["rets_id"]=>
array(1) {
[0]=>
string(8) "16229498"
}
["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(20) "mariah@cbpacific.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(9) "Maria Hsu"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "24922"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "8843230"
}
["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) "4485000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2021-10-15"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(8) "16150.00"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2021-11-22T13:10:14.243"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16229498"
}
["rets_middle_or_junior_school"]=>
array(1) {
[0]=>
string(7) "Kaimuki"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202126027"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(11) "WAIALAE G/C"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2021-10-15T14:41:09.407"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(10) "4485000.00"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-3-5-043-012-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) "2021-10-15T14:41:09.407"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96821"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16229498"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(165) "Easy to show!! Please text/email or call listing agent, Maria Hsu at 808-256-5555 or mariah@cbrealty.com with buyer's prequalification and full names/info. Must see!"
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(715) "Splendid Waialae Golf course frontage! Famed architect Albert Ives designed home of this quality and location rarely comes in the market! Create your family sanctuary on large 16,150 sq.ft prime land! All in one level 4bd 4bath main home + pool house w full bath + Japanese Tea House w full bath. Fully renovated in 2021-custom built gourmet kitchen with subzero, wolf appliances, Cambria countertop - large master closet and master suite with modern soaking bathtub. House is quipped with Photovoltaic panels for energy savings! Pool and tea house can be both guest cottage and great for entertainment! Endless potential to create your own family compound in this quite street. Don’t miss out this great house!"
}
["rets_room_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_sqft_garage_carport"]=>
array(1) {
[0]=>
string(3) "400"
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(3) "320"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "4077"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "4397"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2021-11-22T13:10:14.243"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2021-11-22"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(8) "Waipahee"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(4) "4645"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(64) "1$21.273573$-157.777887$254.76$13.33$1.00$9Q-dUaTe78qbbw0abYMVpQ"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(3) "2.5"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(7) "1989.20"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(8) "23870.40"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(10) "2844800.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "609000.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(10) "2235800.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_tax_paid_by_seller_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_tax_year"]=>
array(1) {
[0]=>
string(4) "2021"
}
["rets_thumbnail_url"]=>
array(1) {
[0]=>
string(81) "https://cdn.rets.ci/marcusrealty-images/16229498/bd3aa386e1b517e9cac9125d5ebb093a"
}
["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(2) "12"
}
["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) "43"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1960"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(4) "2021"
}
["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(8) "Waipahee"
}
["street_number"]=>
array(1) {
[0]=>
string(4) "4645"
}
["street_suffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["terms_accept"]=>
array(1) {
[0]=>
string(17) "Cash,Conventional"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-3-5-043-012-0000"
}
["topography"]=>
array(1) {
[0]=>
string(5) "Other"
}
["view"]=>
array(1) {
[0]=>
string(11) "Golf Course"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16229498"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202126027"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1637622632"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1960"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "2021"
}
["zoning"]=>
array(1) {
[0]=>
string(31) "03 - R10 - Residential District"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(2278) "a:140:{i:0;i:20972296;i:1;i:20972297;i:2;i:20972298;i:3;i:20972299;i:4;i:20972300;i:5;i:20972301;i:6;i:20972302;i:7;i:20972303;i:8;i:20972304;i:9;i:20972305;i:10;i:20972306;i:11;i:20972307;i:12;i:20972308;i:13;i:20972309;i:14;i:20972310;i:15;i:20972311;i:16;i:20972312;i:17;i:20972313;i:18;i:20972314;i:19;i:20972315;i:20;i:20981869;i:21;i:20981870;i:22;i:20981871;i:23;i:20981872;i:24;i:20981873;i:25;i:20981874;i:26;i:20981875;i:27;i:20981876;i:28;i:20981877;i:29;i:20981878;i:30;i:20981879;i:31;i:20981880;i:32;i:20981881;i:33;i:20981882;i:34;i:20981883;i:35;i:20981884;i:36;i:20981885;i:37;i:20981886;i:38;i:20981887;i:39;i:20981888;i:40;i:20982022;i:41;i:20982023;i:42;i:20982024;i:43;i:20982025;i:44;i:20982026;i:45;i:20982027;i:46;i:20982028;i:47;i:20982029;i:48;i:20982030;i:49;i:20982031;i:50;i:20982032;i:51;i:20982033;i:52;i:20982034;i:53;i:20982035;i:54;i:20982036;i:55;i:20982037;i:56;i:20982038;i:57;i:20982039;i:58;i:20982040;i:59;i:20982041;i:60;i:20992344;i:61;i:20992345;i:62;i:20992346;i:63;i:20992347;i:64;i:20992348;i:65;i:20992349;i:66;i:20992350;i:67;i:20992351;i:68;i:20992352;i:69;i:20992353;i:70;i:20992354;i:71;i:20992355;i:72;i:20992356;i:73;i:20992357;i:74;i:20992358;i:75;i:20992359;i:76;i:20992360;i:77;i:20992361;i:78;i:20992362;i:79;i:20992363;i:80;i:21000541;i:81;i:21000542;i:82;i:21000543;i:83;i:21000544;i:84;i:21000545;i:85;i:21000546;i:86;i:21000547;i:87;i:21000548;i:88;i:21000549;i:89;i:21000550;i:90;i:21000551;i:91;i:21000552;i:92;i:21000553;i:93;i:21000554;i:94;i:21000555;i:95;i:21000556;i:96;i:21000557;i:97;i:21000558;i:98;i:21000559;i:99;i:21000560;i:100;i:21058852;i:101;i:21058853;i:102;i:21058854;i:103;i:21058855;i:104;i:21058856;i:105;i:21058857;i:106;i:21058858;i:107;i:21058859;i:108;i:21058860;i:109;i:21058861;i:110;i:21058862;i:111;i:21058863;i:112;i:21058864;i:113;i:21058865;i:114;i:21058866;i:115;i:21058867;i:116;i:21058868;i:117;i:21058869;i:118;i:21058870;i:119;i:21058871;i:120;i:21208213;i:121;i:21208214;i:122;i:21208215;i:123;i:21208216;i:124;i:21208217;i:125;i:21208218;i:126;i:21208219;i:127;i:21208220;i:128;i:21208221;i:129;i:21208222;i:130;i:21208223;i:131;i:21208224;i:132;i:21208225;i:133;i:21208226;i:134;i:21208227;i:135;i:21208228;i:136;i:21208229;i:137;i:21208230;i:138;i:21208231;i:139;i:21208232;}"
}
["rets_open_house_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_active_open_house_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_open_house_upcoming"]=>
array(1) {
[0]=>
string(0) ""
}
["rets_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(38) "https://vimeo.com/607103267/8dec4823c2"
}
["virtual_tour"]=>
array(1) {
[0]=>
string(38) "https://vimeo.com/607103267/8dec4823c2"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2021-10-28"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2021-11-22"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(10) "4250000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-10-14"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2021-11-22"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 518-3429"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(25) "tyler.hinderer@redfin.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(14) "Tyler Hinderer"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "44286"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "9013691"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "RFIN"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(7) "9626004"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(18) "Redfin Corporation"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 518-3429"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "21208213"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 609000.00
)
[assd_val_land] => Array
(
[0] => 2235800.00
)
[assd_val_total] => Array
(
[0] => 2844800.00
)
[bedrooms] => Array
(
[0] => 6
)
[building_style] => Array
(
[0] => Detach Single Family,Studio Cottage
)
[city] => Array
(
[0] => Honolulu
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => None
)
[easements] => Array
(
[0] => Other
)
[elementary_school] => Array
(
[0] => Kahala
)
[floor_covering] => Array
(
[0] => Hardwood,Other,W/W Carpet
)
[frontage] => Array
(
[0] => Golf Course
)
[full_baths] => Array
(
[0] => 6
)
[half_baths] => Array
(
[0] => 0
)
[high_school] => Array
(
[0] => Kalani
)
[home_exampt] => Array
(
[0] => 0
)
[lanai_sf] => Array
(
[0] => 320
)
[land_area_sf] => Array
(
[0] => 16150.00
)
[land_recorded] => Array
(
[0] => Land Court
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => mariah@cbpacific.com
)
[list_agent_name] => Array
(
[0] => Maria Hsu
)
[list_agent_phone_number] => Array
(
[0] => (808) 596-0456
)
[list_date] => Array
(
[0] => 2021-10-15
)
[list_office_name] => Array
(
[0] => Coldwell Banker Realty
)
[list_price] => Array
(
[0] => 4485000.00
)
[living_sf] => Array
(
[0] => 4397
)
[location] => Array
(
[0] => 4645 Waipahee Place, Honolulu, HI 96821
)
[middle_school] => Array
(
[0] => Kaimuki
)
[mls_] => Array
(
[0] => 202126027
)
[neighborhood] => Array
(
[0] => WAIALAE G/C
)
[number_of_parking_spaces] => Array
(
[0] => 4
)
[number_of_stories] => Array
(
[0] => One
)
[office_mls_id] => Array
(
[0] => CBPP
)
[parking_features] => Array
(
[0] => 3 Car+,Boat,Driveway,Garage
)
[pool_] => Array
(
[0] => In Ground
)
[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] => 6
)
[rets_baths_half] => Array
(
[0] => 0
)
[rets_baths_total] => Array
(
[0] => 6.00
)
[rets_beds_total] => Array
(
[0] => 6
)
[rets_city] => Array
(
[0] => Honolulu
)
[rets_condo_property_regime_yn] => Array
(
[0] => 0
)
[rets_current_price] => Array
(
[0] => 4250000.00
)
[rets_dom] => Array
(
[0] => 14
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_elementary_school] => Array
(
[0] => Kahala
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_high_school] => Array
(
[0] => Kalani
)
[rets_id] => Array
(
[0] => 16229498
)
[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] => mariah@cbpacific.com
)
[rets_list_agent_full_name] => Array
(
[0] => Maria Hsu
)
[rets_list_agent_mlsid] => Array
(
[0] => 24922
)
[rets_list_agent_mui] => Array
(
[0] => 8843230
)
[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] => 4485000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2021-10-15
)
[rets_lot_size_area] => Array
(
[0] => 16150.00
)
[rets_matrix_modified_dt] => Array
(
[0] => 2021-11-22T13:10:14.243
)
[rets_matrix_unique_id] => Array
(
[0] => 16229498
)
[rets_middle_or_junior_school] => Array
(
[0] => Kaimuki
)
[rets_mls_number] => Array
(
[0] => 202126027
)
[rets_neighbourhood] => Array
(
[0] => WAIALAE G/C
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2021-10-15T14:41:09.407
)
[rets_original_list_price] => Array
(
[0] => 4485000.00
)
[rets_parcel_number] => Array
(
[0] => 1-3-5-043-012-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] => 2021-10-15T14:41:09.407
)
[rets_postal_code] => Array
(
[0] => 96821
)
[rets_primary_key] => Array
(
[0] => 16229498
)
[rets_private_remarks] => Array
(
[0] => Easy to show!! Please text/email or call listing agent, Maria Hsu at 808-256-5555 or mariah@cbrealty.com with buyer's prequalification and full names/info. Must see!
)
[rets_public_remarks] => Array
(
[0] => Splendid Waialae Golf course frontage! Famed architect Albert Ives designed home of this quality and location rarely comes in the market! Create your family sanctuary on large 16,150 sq.ft prime land! All in one level 4bd 4bath main home + pool house w full bath + Japanese Tea House w full bath. Fully renovated in 2021-custom built gourmet kitchen with subzero, wolf appliances, Cambria countertop - large master closet and master suite with modern soaking bathtub. House is quipped with Photovoltaic panels for energy savings! Pool and tea house can be both guest cottage and great for entertainment! Endless potential to create your own family compound in this quite street. Don’t miss out this great house!
)
[rets_room_count] => Array
(
[0] => 0
)
[rets_sqft_garage_carport] => Array
(
[0] => 400
)
[rets_sqft_lanai_open] => Array
(
[0] => 320
)
[rets_sqft_roofed_living] => Array
(
[0] => 4077
)
[rets_sqft_total] => Array
(
[0] => 4397
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2021-11-22T13:10:14.243
)
[rets_status_contractual_search_date] => Array
(
[0] => 2021-11-22
)
[rets_street_name] => Array
(
[0] => Waipahee
)
[rets_street_number] => Array
(
[0] => 4645
)
[rets_street_view_param] => Array
(
[0] => 1$21.273573$-157.777887$254.76$13.33$1.00$9Q-dUaTe78qbbw0abYMVpQ
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5
)
[rets_tax_amount] => Array
(
[0] => 1989.20
)
[rets_tax_annual_amount] => Array
(
[0] => 23870.40
)
[rets_tax_assessed_value] => Array
(
[0] => 2844800.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 609000.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 2235800.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 0
)
[rets_tax_paid_by_seller_yn] => Array
(
[0] => 0
)
[rets_tax_year] => Array
(
[0] => 2021
)
[rets_thumbnail_url] => Array
(
[0] => https://cdn.rets.ci/marcusrealty-images/16229498/bd3aa386e1b517e9cac9125d5ebb093a
)
[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] => 12
)
[rets_tmk_section] => Array
(
[0] => 5
)
[rets_tmk_zone] => Array
(
[0] => 3
)
[rets_tmkplat] => Array
(
[0] => 43
)
[rets_year_built] => Array
(
[0] => 1960
)
[rets_year_remodeled] => Array
(
[0] => 2021
)
[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] => Waipahee
)
[street_number] => Array
(
[0] => 4645
)
[street_suffix] => Array
(
[0] => Place
)
[terms_accept] => Array
(
[0] => Cash,Conventional
)
[tmk] => Array
(
[0] => 1-3-5-043-012-0000
)
[topography] => Array
(
[0] => Other
)
[view] => Array
(
[0] => Golf Course
)
[wpp::rets_pk] => Array
(
[0] => 16229498
)
[wpp_gpid] => Array
(
[0] => 202126027
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1637622632
)
[year_built] => Array
(
[0] => 1960
)
[year_remodeled_] => Array
(
[0] => 2021
)
[zoning] => Array
(
[0] => 03 - R10 - Residential District
)
[new_attached_media] => Array
(
[0] => a:140:{i:0;i:20972296;i:1;i:20972297;i:2;i:20972298;i:3;i:20972299;i:4;i:20972300;i:5;i:20972301;i:6;i:20972302;i:7;i:20972303;i:8;i:20972304;i:9;i:20972305;i:10;i:20972306;i:11;i:20972307;i:12;i:20972308;i:13;i:20972309;i:14;i:20972310;i:15;i:20972311;i:16;i:20972312;i:17;i:20972313;i:18;i:20972314;i:19;i:20972315;i:20;i:20981869;i:21;i:20981870;i:22;i:20981871;i:23;i:20981872;i:24;i:20981873;i:25;i:20981874;i:26;i:20981875;i:27;i:20981876;i:28;i:20981877;i:29;i:20981878;i:30;i:20981879;i:31;i:20981880;i:32;i:20981881;i:33;i:20981882;i:34;i:20981883;i:35;i:20981884;i:36;i:20981885;i:37;i:20981886;i:38;i:20981887;i:39;i:20981888;i:40;i:20982022;i:41;i:20982023;i:42;i:20982024;i:43;i:20982025;i:44;i:20982026;i:45;i:20982027;i:46;i:20982028;i:47;i:20982029;i:48;i:20982030;i:49;i:20982031;i:50;i:20982032;i:51;i:20982033;i:52;i:20982034;i:53;i:20982035;i:54;i:20982036;i:55;i:20982037;i:56;i:20982038;i:57;i:20982039;i:58;i:20982040;i:59;i:20982041;i:60;i:20992344;i:61;i:20992345;i:62;i:20992346;i:63;i:20992347;i:64;i:20992348;i:65;i:20992349;i:66;i:20992350;i:67;i:20992351;i:68;i:20992352;i:69;i:20992353;i:70;i:20992354;i:71;i:20992355;i:72;i:20992356;i:73;i:20992357;i:74;i:20992358;i:75;i:20992359;i:76;i:20992360;i:77;i:20992361;i:78;i:20992362;i:79;i:20992363;i:80;i:21000541;i:81;i:21000542;i:82;i:21000543;i:83;i:21000544;i:84;i:21000545;i:85;i:21000546;i:86;i:21000547;i:87;i:21000548;i:88;i:21000549;i:89;i:21000550;i:90;i:21000551;i:91;i:21000552;i:92;i:21000553;i:93;i:21000554;i:94;i:21000555;i:95;i:21000556;i:96;i:21000557;i:97;i:21000558;i:98;i:21000559;i:99;i:21000560;i:100;i:21058852;i:101;i:21058853;i:102;i:21058854;i:103;i:21058855;i:104;i:21058856;i:105;i:21058857;i:106;i:21058858;i:107;i:21058859;i:108;i:21058860;i:109;i:21058861;i:110;i:21058862;i:111;i:21058863;i:112;i:21058864;i:113;i:21058865;i:114;i:21058866;i:115;i:21058867;i:116;i:21058868;i:117;i:21058869;i:118;i:21058870;i:119;i:21058871;i:120;i:21208213;i:121;i:21208214;i:122;i:21208215;i:123;i:21208216;i:124;i:21208217;i:125;i:21208218;i:126;i:21208219;i:127;i:21208220;i:128;i:21208221;i:129;i:21208222;i:130;i:21208223;i:131;i:21208224;i:132;i:21208225;i:133;i:21208226;i:134;i:21208227;i:135;i:21208228;i:136;i:21208229;i:137;i:21208230;i:138;i:21208231;i:139;i:21208232;}
)
[rets_open_house_count] => Array
(
[0] => 0
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_open_house_upcoming] => Array
(
[0] =>
)
[rets_virtual_tour_url_unbranded] => Array
(
[0] => https://vimeo.com/607103267/8dec4823c2
)
[virtual_tour] => Array
(
[0] => https://vimeo.com/607103267/8dec4823c2
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2021-10-28
)
[rets_close_date] => Array
(
[0] => 2021-11-22
)
[rets_close_price] => Array
(
[0] => 4250000.00
)
[rets_expiration_date] => Array
(
[0] => 2022-10-14
)
[rets_off_market_date] => Array
(
[0] => 2021-11-22
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 518-3429
)
[rets_selling_agent_email] => Array
(
[0] => tyler.hinderer@redfin.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Tyler Hinderer
)
[rets_selling_agent_mlsid] => Array
(
[0] => 44286
)
[rets_selling_agent_mui] => Array
(
[0] => 9013691
)
[rets_selling_office_mlsid] => Array
(
[0] => RFIN
)
[rets_selling_office_mui] => Array
(
[0] => 9626004
)
[rets_selling_office_name] => Array
(
[0] => Redfin Corporation
)
[rets_selling_office_phone] => Array
(
[0] => (808) 518-3429
)
[_thumbnail_id] => Array
(
[0] => 21208213
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446