Rare opportunity to purchase a newer remodeled unit at Koolau Vista in Kailua. Located away from the street, this quiet, colorful unit has beautiful views of Olomana & the Koolaus from the living room and one of the bedrooms upstairs. 2020 upgrades include new kitchen cabinets with white quartz countertops, new stainless steel appliances, a new sink, new fixtures, new faux wood vinyl flooring & new powder room. About 5 years ago, the upstairs bathroom was remodeled & lower level popcorn ceiling was removed. The washer/dryer was new in November of 2021. 2 window AC units, 1 in the living room & 1 in a bedroom. Almost everything you need is a short distance from your door…world-famous Kailua Beach, Whole Foods Market, Target, restaurants, gyms, yoga studios, coffee shops, schools, multiple weekly farmer’s markets and so much more. Monthly HOA fees are low & the building has plenty of money in reserves.
Listing by: eXp Realty
array(175) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "350300.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "124200.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "474500.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "2"
}
["building_name"]=>
array(1) {
[0]=>
string(12) "Koolau Vista"
}
["building_style"]=>
array(1) {
[0]=>
string(26) "Low-Rise 6 or Less Stories"
}
["city"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(24) "Property Disclosure Stmt"
}
["elementary_school"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["floor_covering"]=>
array(1) {
[0]=>
string(16) "Vinyl,W/W Carpet"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "1"
}
["furnished"]=>
array(1) {
[0]=>
string(4) "None"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "1"
}
["high_school"]=>
array(1) {
[0]=>
string(7) "Kalaheo"
}
["home_exampt"]=>
array(1) {
[0]=>
string(1) "0"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(9) "151774.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(16) "Team@OBHomes.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(16) "John W Stallings"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 725-2794"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-04-13"
}
["list_office_name"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["list_price"]=>
array(1) {
[0]=>
string(9) "595000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(3) "783"
}
["location"]=>
array(1) {
[0]=>
string(44) "350 Aoloa Street Unit A230, Kailua, HI 96734"
}
["maintenance_fees"]=>
array(1) {
[0]=>
string(6) "512.01"
}
["middle_school"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202206697"
}
["neighborhood"]=>
array(1) {
[0]=>
string(11) "KAILUA TOWN"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "1"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(3) "Two"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "EXPI"
}
["parking_features"]=>
array(1) {
[0]=>
string(40) "Assigned,Covered - 1,Garage,Guest,Street"
}
["possession"]=>
array(1) {
[0]=>
string(10) "At Closing"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96734"
}
["property_condition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["property_type"]=>
array(1) {
[0]=>
string(15) "condo_townhouse"
}
["property_type_label"]=>
array(1) {
[0]=>
string(15) "Condo Townhouse"
}
["region"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["rets_association_fee_total"]=>
array(1) {
[0]=>
string(3) "512"
}
["rets_baths_full"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_baths_half"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_baths_total"]=>
array(1) {
[0]=>
string(4) "1.01"
}
["rets_beds_total"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_building_name"]=>
array(1) {
[0]=>
string(12) "Koolau Vista"
}
["rets_city"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["rets_condo_parking_unit"]=>
array(1) {
[0]=>
string(3) "57a"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(9) "625000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(1) "9"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_elementary_school"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["rets_floor_number"]=>
array(1) {
[0]=>
string(1) "2"
}
["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) "16555451"
}
["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) 725-2794"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(16) "Team@OBHomes.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(16) "John W Stallings"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "25914"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "3475685"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "EXPI"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(8) "10013908"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 725-2794"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(9) "595000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-04-13"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(9) "151774.00"
}
["rets_maintenance_expense"]=>
array(1) {
[0]=>
string(6) "512.01"
}
["rets_management_company_name"]=>
array(1) {
[0]=>
string(10) "Touchstone"
}
["rets_management_company_phone"]=>
array(1) {
[0]=>
string(12) "808-566-4100"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-06-02T15:56:53.387"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16555451"
}
["rets_middle_or_junior_school"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202206697"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(11) "KAILUA TOWN"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-08T06:32:39.803"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(9) "595000.00"
}
["rets_owner_occupancy_percentage"]=>
array(1) {
[0]=>
string(2) "31"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-4-2-001-045-0062"
}
["rets_parking_additional"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_parking_total"]=>
array(1) {
[0]=>
string(1) "1"
}
["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) "14"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-13T11:32:52.167"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96734"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-04-13T06:49:36.873"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16555451"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(449) "Please use Showing Time to schedule showings and please text or email the agent. The seller prefers Jasmine Bishaw at Fidelity National Title and Escrow. Please see the supplement section in MLS for documents required with the offer. The property will be open Thursday, April 14th from 9:30 to 11:30, Saturday, April 16 from 2 pm to 4 pm, and Sunday, April 17th from 2 pm to 5 pm. Offers due Tuesday, April 19th by noon to Team@OBHomes.com. No Pets!"
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(916) "Rare opportunity to purchase a newer remodeled unit at Koolau Vista in Kailua. Located away from the street, this quiet, colorful unit has beautiful views of Olomana & the Koolaus from the living room and one of the bedrooms upstairs. 2020 upgrades include new kitchen cabinets with white quartz countertops, new stainless steel appliances, a new sink, new fixtures, new faux wood vinyl flooring & new powder room. About 5 years ago, the upstairs bathroom was remodeled & lower level popcorn ceiling was removed. The washer/dryer was new in November of 2021. 2 window AC units, 1 in the living room & 1 in a bedroom. Almost everything you need is a short distance from your door...world-famous Kailua Beach, Whole Foods Market, Target, restaurants, gyms, yoga studios, coffee shops, schools, multiple weekly farmer's markets and so much more. Monthly HOA fees are low & the building has plenty of money in reserves."
}
["rets_public_report_number"]=>
array(1) {
[0]=>
string(4) "1560"
}
["rets_room_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(3) "783"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(3) "783"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-02T15:56:53.387"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-06-02"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(5) "Aoloa"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(3) "350"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(106) "1$21.390682$-157.738728$346.79$13.33$1.00$CAoSLEFGMVFpcE9TcG9SbkdjSDR3LThja0RNQ1lUYW1jQzVlZFJmQTNOazdoM1Fh"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(4) "2.25"
}
["rets_supplement_count"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_supplement_modification_timestam"]=>
array(1) {
[0]=>
string(23) "2022-04-15T06:45:38.100"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "110.00"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "1320.00"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "474500.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "350300.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "124200.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/16555451/6c828327ff64875d4d0fa0ac94c7b1a4"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "142"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(2) "62"
}
["rets_tmk_division"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tmk_parcel"]=>
array(1) {
[0]=>
string(2) "45"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_unit_number"]=>
array(1) {
[0]=>
string(4) "A230"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1985"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(4) "2020"
}
["state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["street_name"]=>
array(1) {
[0]=>
string(5) "Aoloa"
}
["street_number"]=>
array(1) {
[0]=>
string(3) "350"
}
["street_suffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["terms_accept"]=>
array(1) {
[0]=>
string(24) "Cash,Conventional,FHA,VA"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-4-2-001-045-0062"
}
["unit"]=>
array(1) {
[0]=>
string(30) "Even# Unit,Multi Level,Storage"
}
["unit_number"]=>
array(1) {
[0]=>
string(4) "A230"
}
["view"]=>
array(1) {
[0]=>
string(16) "Mountain,Sunrise"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16555451"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202206697"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1654221475"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1985"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "2020"
}
["zoning"]=>
array(1) {
[0]=>
string(31) "12 - A-2 Medium Density Apartme"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(2040) "a:126:{i:0;i:22010158;i:1;i:22010159;i:2;i:22010160;i:3;i:22010161;i:4;i:22010162;i:5;i:22010163;i:6;i:22010164;i:7;i:22010165;i:8;i:22010166;i:9;i:22010167;i:10;i:22010168;i:11;i:22010169;i:12;i:22010170;i:13;i:22010171;i:14;i:22010930;i:15;i:22010931;i:16;i:22010932;i:17;i:22010933;i:18;i:22010934;i:19;i:22010935;i:20;i:22010936;i:21;i:22010937;i:22;i:22010938;i:23;i:22010939;i:24;i:22010940;i:25;i:22010941;i:26;i:22010942;i:27;i:22010943;i:28;i:22012593;i:29;i:22012594;i:30;i:22012595;i:31;i:22012596;i:32;i:22012597;i:33;i:22012598;i:34;i:22012599;i:35;i:22012600;i:36;i:22012601;i:37;i:22012602;i:38;i:22012603;i:39;i:22012604;i:40;i:22012605;i:41;i:22012606;i:42;i:22013202;i:43;i:22013203;i:44;i:22013204;i:45;i:22013205;i:46;i:22013206;i:47;i:22013207;i:48;i:22013208;i:49;i:22013209;i:50;i:22013210;i:51;i:22013211;i:52;i:22013212;i:53;i:22013213;i:54;i:22013214;i:55;i:22013215;i:56;i:22015783;i:57;i:22015784;i:58;i:22015785;i:59;i:22015786;i:60;i:22015787;i:61;i:22015788;i:62;i:22015789;i:63;i:22015790;i:64;i:22015791;i:65;i:22015792;i:66;i:22015793;i:67;i:22015794;i:68;i:22015795;i:69;i:22015796;i:70;i:22023439;i:71;i:22023440;i:72;i:22023441;i:73;i:22023442;i:74;i:22023443;i:75;i:22023444;i:76;i:22023445;i:77;i:22023446;i:78;i:22023447;i:79;i:22023448;i:80;i:22023449;i:81;i:22023450;i:82;i:22023451;i:83;i:22023452;i:84;i:22074930;i:85;i:22074931;i:86;i:22074932;i:87;i:22074933;i:88;i:22074934;i:89;i:22074935;i:90;i:22074936;i:91;i:22074937;i:92;i:22074938;i:93;i:22074939;i:94;i:22074940;i:95;i:22074941;i:96;i:22074942;i:97;i:22074943;i:98;i:22240134;i:99;i:22240135;i:100;i:22240136;i:101;i:22240137;i:102;i:22240138;i:103;i:22240139;i:104;i:22240140;i:105;i:22240141;i:106;i:22240142;i:107;i:22240143;i:108;i:22240144;i:109;i:22240145;i:110;i:22240146;i:111;i:22240147;i:112;i:22352505;i:113;i:22352506;i:114;i:22352507;i:115;i:22352508;i:116;i:22352509;i:117;i:22352510;i:118;i:22352511;i:119;i:22352512;i:120;i:22352513;i:121;i:22352514;i:122;i:22352515;i:123;i:22352516;i:124;i:22352517;i:125;i:22352518;}"
}
["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-04-20"
}
["rets_pending_date"]=>
array(1) {
[0]=>
string(10) "2022-04-20"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-06-02"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(9) "625000.00"
}
["rets_co_selling_agent_direct_work_pho"]=>
array(1) {
[0]=>
string(14) "(808) 725-2794"
}
["rets_co_selling_agent_email"]=>
array(1) {
[0]=>
string(23) "jasmine@hihomegroup.com"
}
["rets_co_selling_agent_full_name"]=>
array(1) {
[0]=>
string(12) "Jasmine Bell"
}
["rets_co_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "49202"
}
["rets_co_selling_agent_mui"]=>
array(1) {
[0]=>
string(8) "14033929"
}
["rets_co_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "EXPI"
}
["rets_co_selling_office_mui"]=>
array(1) {
[0]=>
string(8) "10013908"
}
["rets_co_selling_office_name"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["rets_co_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 725-2794"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-10-12"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-06-02"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 725-2794"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(23) "kirsten@hihomegroup.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(17) "Kirsten T Connell"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "51536"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(8) "16040955"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "EXPI"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(8) "10013908"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 725-2794"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "22352505"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 350300.00
)
[assd_val_land] => Array
(
[0] => 124200.00
)
[assd_val_total] => Array
(
[0] => 474500.00
)
[bedrooms] => Array
(
[0] => 2
)
[building_name] => Array
(
[0] => Koolau Vista
)
[building_style] => Array
(
[0] => Low-Rise 6 or Less Stories
)
[city] => Array
(
[0] => Kailua
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Property Disclosure Stmt
)
[elementary_school] => Array
(
[0] => Kailua
)
[floor_covering] => Array
(
[0] => Vinyl,W/W Carpet
)
[full_baths] => Array
(
[0] => 1
)
[furnished] => Array
(
[0] => None
)
[half_baths] => Array
(
[0] => 1
)
[high_school] => Array
(
[0] => Kalaheo
)
[home_exampt] => Array
(
[0] => 0
)
[land_area_sf] => Array
(
[0] => 151774.00
)
[land_recorded] => Array
(
[0] => Regular System
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => Team@OBHomes.com
)
[list_agent_name] => Array
(
[0] => John W Stallings
)
[list_agent_phone_number] => Array
(
[0] => (808) 725-2794
)
[list_date] => Array
(
[0] => 2022-04-13
)
[list_office_name] => Array
(
[0] => eXp Realty
)
[list_price] => Array
(
[0] => 595000.00
)
[living_sf] => Array
(
[0] => 783
)
[location] => Array
(
[0] => 350 Aoloa Street Unit A230, Kailua, HI 96734
)
[maintenance_fees] => Array
(
[0] => 512.01
)
[middle_school] => Array
(
[0] => Kailua
)
[mls_] => Array
(
[0] => 202206697
)
[neighborhood] => Array
(
[0] => KAILUA TOWN
)
[number_of_parking_spaces] => Array
(
[0] => 1
)
[number_of_stories] => Array
(
[0] => Two
)
[office_mls_id] => Array
(
[0] => EXPI
)
[parking_features] => Array
(
[0] => Assigned,Covered - 1,Garage,Guest,Street
)
[possession] => Array
(
[0] => At Closing
)
[postal_code] => Array
(
[0] => 96734
)
[property_condition] => Array
(
[0] => Excellent
)
[property_type] => Array
(
[0] => condo_townhouse
)
[property_type_label] => Array
(
[0] => Condo Townhouse
)
[region] => Array
(
[0] => Kailua
)
[rets_association_fee_total] => Array
(
[0] => 512
)
[rets_baths_full] => Array
(
[0] => 1
)
[rets_baths_half] => Array
(
[0] => 1
)
[rets_baths_total] => Array
(
[0] => 1.01
)
[rets_beds_total] => Array
(
[0] => 2
)
[rets_building_name] => Array
(
[0] => Koolau Vista
)
[rets_city] => Array
(
[0] => Kailua
)
[rets_condo_parking_unit] => Array
(
[0] => 57a
)
[rets_current_price] => Array
(
[0] => 625000.00
)
[rets_dom] => Array
(
[0] => 9
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_elementary_school] => Array
(
[0] => Kailua
)
[rets_floor_number] => Array
(
[0] => 2
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_high_school] => Array
(
[0] => Kalaheo
)
[rets_id] => Array
(
[0] => 16555451
)
[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) 725-2794
)
[rets_list_agent_email] => Array
(
[0] => Team@OBHomes.com
)
[rets_list_agent_full_name] => Array
(
[0] => John W Stallings
)
[rets_list_agent_mlsid] => Array
(
[0] => 25914
)
[rets_list_agent_mui] => Array
(
[0] => 3475685
)
[rets_list_office_mlsid] => Array
(
[0] => EXPI
)
[rets_list_office_mui] => Array
(
[0] => 10013908
)
[rets_list_office_name] => Array
(
[0] => eXp Realty
)
[rets_list_office_phone] => Array
(
[0] => (808) 725-2794
)
[rets_list_price] => Array
(
[0] => 595000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-04-13
)
[rets_lot_size_area] => Array
(
[0] => 151774.00
)
[rets_maintenance_expense] => Array
(
[0] => 512.01
)
[rets_management_company_name] => Array
(
[0] => Touchstone
)
[rets_management_company_phone] => Array
(
[0] => 808-566-4100
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-06-02T15:56:53.387
)
[rets_matrix_unique_id] => Array
(
[0] => 16555451
)
[rets_middle_or_junior_school] => Array
(
[0] => Kailua
)
[rets_mls_number] => Array
(
[0] => 202206697
)
[rets_neighbourhood] => Array
(
[0] => KAILUA TOWN
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-04-08T06:32:39.803
)
[rets_original_list_price] => Array
(
[0] => 595000.00
)
[rets_owner_occupancy_percentage] => Array
(
[0] => 31
)
[rets_parcel_number] => Array
(
[0] => 1-4-2-001-045-0062
)
[rets_parking_additional] => Array
(
[0] => 0
)
[rets_parking_total] => Array
(
[0] => 1
)
[rets_permit_address_internet_yn] => Array
(
[0] => 1
)
[rets_permit_internet_yn] => Array
(
[0] => 1
)
[rets_photo_count] => Array
(
[0] => 14
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2022-04-13T11:32:52.167
)
[rets_postal_code] => Array
(
[0] => 96734
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-04-13T06:49:36.873
)
[rets_primary_key] => Array
(
[0] => 16555451
)
[rets_private_remarks] => Array
(
[0] => Please use Showing Time to schedule showings and please text or email the agent. The seller prefers Jasmine Bishaw at Fidelity National Title and Escrow. Please see the supplement section in MLS for documents required with the offer. The property will be open Thursday, April 14th from 9:30 to 11:30, Saturday, April 16 from 2 pm to 4 pm, and Sunday, April 17th from 2 pm to 5 pm. Offers due Tuesday, April 19th by noon to Team@OBHomes.com. No Pets!
)
[rets_public_remarks] => Array
(
[0] => Rare opportunity to purchase a newer remodeled unit at Koolau Vista in Kailua. Located away from the street, this quiet, colorful unit has beautiful views of Olomana & the Koolaus from the living room and one of the bedrooms upstairs. 2020 upgrades include new kitchen cabinets with white quartz countertops, new stainless steel appliances, a new sink, new fixtures, new faux wood vinyl flooring & new powder room. About 5 years ago, the upstairs bathroom was remodeled & lower level popcorn ceiling was removed. The washer/dryer was new in November of 2021. 2 window AC units, 1 in the living room & 1 in a bedroom. Almost everything you need is a short distance from your door...world-famous Kailua Beach, Whole Foods Market, Target, restaurants, gyms, yoga studios, coffee shops, schools, multiple weekly farmer's markets and so much more. Monthly HOA fees are low & the building has plenty of money in reserves.
)
[rets_public_report_number] => Array
(
[0] => 1560
)
[rets_room_count] => Array
(
[0] => 0
)
[rets_sqft_roofed_living] => Array
(
[0] => 783
)
[rets_sqft_total] => Array
(
[0] => 783
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-06-02T15:56:53.387
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-06-02
)
[rets_street_name] => Array
(
[0] => Aoloa
)
[rets_street_number] => Array
(
[0] => 350
)
[rets_street_view_param] => Array
(
[0] => 1$21.390682$-157.738728$346.79$13.33$1.00$CAoSLEFGMVFpcE9TcG9SbkdjSDR3LThja0RNQ1lUYW1jQzVlZFJmQTNOazdoM1Fh
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.25
)
[rets_supplement_count] => Array
(
[0] => 4
)
[rets_supplement_modification_timestam] => Array
(
[0] => 2022-04-15T06:45:38.100
)
[rets_tax_amount] => Array
(
[0] => 110.00
)
[rets_tax_annual_amount] => Array
(
[0] => 1320.00
)
[rets_tax_assessed_value] => Array
(
[0] => 474500.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 350300.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 124200.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/16555451/6c828327ff64875d4d0fa0ac94c7b1a4
)
[rets_tmk_area] => Array
(
[0] => 142
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 62
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 45
)
[rets_tmk_section] => Array
(
[0] => 2
)
[rets_tmk_zone] => Array
(
[0] => 4
)
[rets_tmkplat] => Array
(
[0] => 1
)
[rets_unit_number] => Array
(
[0] => A230
)
[rets_year_built] => Array
(
[0] => 1985
)
[rets_year_remodeled] => Array
(
[0] => 2020
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Aoloa
)
[street_number] => Array
(
[0] => 350
)
[street_suffix] => Array
(
[0] => Street
)
[terms_accept] => Array
(
[0] => Cash,Conventional,FHA,VA
)
[tmk] => Array
(
[0] => 1-4-2-001-045-0062
)
[unit] => Array
(
[0] => Even# Unit,Multi Level,Storage
)
[unit_number] => Array
(
[0] => A230
)
[view] => Array
(
[0] => Mountain,Sunrise
)
[wpp::rets_pk] => Array
(
[0] => 16555451
)
[wpp_gpid] => Array
(
[0] => 202206697
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1654221475
)
[year_built] => Array
(
[0] => 1985
)
[year_remodeled_] => Array
(
[0] => 2020
)
[zoning] => Array
(
[0] => 12 - A-2 Medium Density Apartme
)
[new_attached_media] => Array
(
[0] => a:126:{i:0;i:22010158;i:1;i:22010159;i:2;i:22010160;i:3;i:22010161;i:4;i:22010162;i:5;i:22010163;i:6;i:22010164;i:7;i:22010165;i:8;i:22010166;i:9;i:22010167;i:10;i:22010168;i:11;i:22010169;i:12;i:22010170;i:13;i:22010171;i:14;i:22010930;i:15;i:22010931;i:16;i:22010932;i:17;i:22010933;i:18;i:22010934;i:19;i:22010935;i:20;i:22010936;i:21;i:22010937;i:22;i:22010938;i:23;i:22010939;i:24;i:22010940;i:25;i:22010941;i:26;i:22010942;i:27;i:22010943;i:28;i:22012593;i:29;i:22012594;i:30;i:22012595;i:31;i:22012596;i:32;i:22012597;i:33;i:22012598;i:34;i:22012599;i:35;i:22012600;i:36;i:22012601;i:37;i:22012602;i:38;i:22012603;i:39;i:22012604;i:40;i:22012605;i:41;i:22012606;i:42;i:22013202;i:43;i:22013203;i:44;i:22013204;i:45;i:22013205;i:46;i:22013206;i:47;i:22013207;i:48;i:22013208;i:49;i:22013209;i:50;i:22013210;i:51;i:22013211;i:52;i:22013212;i:53;i:22013213;i:54;i:22013214;i:55;i:22013215;i:56;i:22015783;i:57;i:22015784;i:58;i:22015785;i:59;i:22015786;i:60;i:22015787;i:61;i:22015788;i:62;i:22015789;i:63;i:22015790;i:64;i:22015791;i:65;i:22015792;i:66;i:22015793;i:67;i:22015794;i:68;i:22015795;i:69;i:22015796;i:70;i:22023439;i:71;i:22023440;i:72;i:22023441;i:73;i:22023442;i:74;i:22023443;i:75;i:22023444;i:76;i:22023445;i:77;i:22023446;i:78;i:22023447;i:79;i:22023448;i:80;i:22023449;i:81;i:22023450;i:82;i:22023451;i:83;i:22023452;i:84;i:22074930;i:85;i:22074931;i:86;i:22074932;i:87;i:22074933;i:88;i:22074934;i:89;i:22074935;i:90;i:22074936;i:91;i:22074937;i:92;i:22074938;i:93;i:22074939;i:94;i:22074940;i:95;i:22074941;i:96;i:22074942;i:97;i:22074943;i:98;i:22240134;i:99;i:22240135;i:100;i:22240136;i:101;i:22240137;i:102;i:22240138;i:103;i:22240139;i:104;i:22240140;i:105;i:22240141;i:106;i:22240142;i:107;i:22240143;i:108;i:22240144;i:109;i:22240145;i:110;i:22240146;i:111;i:22240147;i:112;i:22352505;i:113;i:22352506;i:114;i:22352507;i:115;i:22352508;i:116;i:22352509;i:117;i:22352510;i:118;i:22352511;i:119;i:22352512;i:120;i:22352513;i:121;i:22352514;i:122;i:22352515;i:123;i:22352516;i:124;i:22352517;i:125;i:22352518;}
)
[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-04-20
)
[rets_pending_date] => Array
(
[0] => 2022-04-20
)
[rets_close_date] => Array
(
[0] => 2022-06-02
)
[rets_close_price] => Array
(
[0] => 625000.00
)
[rets_co_selling_agent_direct_work_pho] => Array
(
[0] => (808) 725-2794
)
[rets_co_selling_agent_email] => Array
(
[0] => jasmine@hihomegroup.com
)
[rets_co_selling_agent_full_name] => Array
(
[0] => Jasmine Bell
)
[rets_co_selling_agent_mlsid] => Array
(
[0] => 49202
)
[rets_co_selling_agent_mui] => Array
(
[0] => 14033929
)
[rets_co_selling_office_mlsid] => Array
(
[0] => EXPI
)
[rets_co_selling_office_mui] => Array
(
[0] => 10013908
)
[rets_co_selling_office_name] => Array
(
[0] => eXp Realty
)
[rets_co_selling_office_phone] => Array
(
[0] => (808) 725-2794
)
[rets_expiration_date] => Array
(
[0] => 2022-10-12
)
[rets_off_market_date] => Array
(
[0] => 2022-06-02
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 725-2794
)
[rets_selling_agent_email] => Array
(
[0] => kirsten@hihomegroup.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Kirsten T Connell
)
[rets_selling_agent_mlsid] => Array
(
[0] => 51536
)
[rets_selling_agent_mui] => Array
(
[0] => 16040955
)
[rets_selling_office_mlsid] => Array
(
[0] => EXPI
)
[rets_selling_office_mui] => Array
(
[0] => 10013908
)
[rets_selling_office_name] => Array
(
[0] => eXp Realty
)
[rets_selling_office_phone] => Array
(
[0] => (808) 725-2794
)
[_thumbnail_id] => Array
(
[0] => 22352505
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446