Fantastic street appeal on this great Kailua double-wall single level home w/ 4 bdrms 2 newly renovated bathrms & a bonus half bath/laundry room. PLUS an attached 1/1 (with its own laundry) – currently configured as a hair salon + studio. This home has been lovingly renovated through the years with new LVP laminate flooring, fresh paint, plantation shutters, breezeway windows, french doors, new ceiling fans, lighting and much, much more. Nice entry foyer that goes to each unit…. Excellent home office option, in-law suite or other. Very nicely landscaped w/lots of unique plants & a fruit bearing Kalamansi tree! Attached carport & lots of storage throughout… Great lanai off the back yard for the Tiki bar experience (with bathroom!) Upgraded 200 amp electrical service, solar water heating, new roof in 2016, 35 owned PV panels & split AC’s are a few of the great features. Plus a deeded 1/3 interest in adjacent driveway for drive in access to the back yard (boat?)… Auwai Street is one of Coconut Grove’s nice, wider streets with close proximity to Kailua town and Kailua’s famous white sand beaches! A definite must see if you’re thinking about Kailua…
Listing by: BHGRE Advantage Realty
array(158) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "180400.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "996700.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(10) "1177100.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "5"
}
["building_style"]=>
array(1) {
[0]=>
string(38) "1 Bedroom Cottage,Detach Single Family"
}
["city"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(45) "Property Disclosure Stmt,Relative of Licensee"
}
["easements"]=>
array(1) {
[0]=>
string(4) "None"
}
["elementary_school"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["exclusions"]=>
array(1) {
[0]=>
string(5) "Other"
}
["floor_covering"]=>
array(1) {
[0]=>
string(14) "Laminate,Vinyl"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "3"
}
["furnished"]=>
array(1) {
[0]=>
string(7) "Partial"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "1"
}
["high_school"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["home_exampt"]=>
array(1) {
[0]=>
string(7) "100,000"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(7) "5775.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(23) "gracek@BetterHawaii.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(16) "Grace M Koreyasu"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 261-1800"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-05-03"
}
["list_office_name"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["list_price"]=>
array(1) {
[0]=>
string(10) "1535000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "2076"
}
["location"]=>
array(1) {
[0]=>
string(34) "551 Auwai Street, Kailua, HI 96734"
}
["middle_school"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202208364"
}
["neighborhood"]=>
array(1) {
[0]=>
string(13) "COCONUT GROVE"
}
["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(6) "ADVG02"
}
["parking_features"]=>
array(1) {
[0]=>
string(35) "3 Car+,Boat,Carport,Driveway,Street"
}
["pool_"]=>
array(1) {
[0]=>
string(4) "None"
}
["possession"]=>
array(1) {
[0]=>
string(26) "45 Days or Less,At Closing"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96734"
}
["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(6) "Kailua"
}
["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) "5"
}
["rets_city"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["rets_condo_property_regime_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(10) "1600000.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_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) "Kailua"
}
["rets_id"]=>
array(1) {
[0]=>
string(8) "16623702"
}
["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) 261-1800"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(23) "gracek@BetterHawaii.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(16) "Grace M Koreyasu"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "20458"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "3473763"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(6) "ADVG02"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(8) "10139093"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 261-1800"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(10) "1535000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-05-03"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(7) "5775.00"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-06-27T14:08:50.160"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16623702"
}
["rets_middle_or_junior_school"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202208364"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(13) "COCONUT GROVE"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_open_house_count"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-05-03T18:33:40.587"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(10) "1535000.00"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-4-3-062-017-0000"
}
["rets_parking_total"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_permit_address_internet_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_permit_internet_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_photo_count"]=>
array(1) {
[0]=>
string(2) "25"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-05-04T11:15:26.917"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96734"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-05-03T18:33:40.587"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16623702"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(357) "text/email/call Grace directly for all showings. Day prior notice please. EZ to see! Please use: Fidelity National Title, Kailua (Kristin Piasecki). Also, include BHG Addendum, Affiliated Bus Disclosure - attached in MLS. Offers will be presented as they come in. Property tax amount noted is based on 2021 assessed values. Brokers Open 5/5/2022 9:30-noon."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(1188) "Fantastic street appeal on this great Kailua double-wall single level home w/ 4 bdrms 2 newly renovated bathrms & a bonus half bath/laundry room. PLUS an attached 1/1 (with its own laundry) – currently configured as a hair salon + studio. This home has been lovingly renovated through the years with new LVP laminate flooring, fresh paint, plantation shutters, breezeway windows, french doors, new ceiling fans, lighting and much, much more. Nice entry foyer that goes to each unit…. Excellent home office option, in-law suite or other. Very nicely landscaped w/lots of unique plants & a fruit bearing Kalamansi tree! Attached carport & lots of storage throughout… Great lanai off the back yard for the Tiki bar experience (with bathroom!) Upgraded 200 amp electrical service, solar water heating, new roof in 2016, 35 owned PV panels & split AC’s are a few of the great features. Plus a deeded 1/3 interest in adjacent driveway for drive in access to the back yard (boat?)… Auwai Street is one of Coconut Grove's nice, wider streets with close proximity to Kailua town and Kailua’s famous white sand beaches! A definite must see if you’re thinking about Kailua…"
}
["rets_sqft_garage_carport"]=>
array(1) {
[0]=>
string(3) "380"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "2076"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "2076"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-27T14:08:50.160"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-06-27"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(5) "Auwai"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(3) "551"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(64) "1$21.398721$-157.749006$114.31$13.33$1.00$yJ8D1RFkM_1mX24k56YnyA"
}
["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-05-03T18:33:20.353"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "256.96"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "3083.52"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(10) "1177100.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "180400.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "996700.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(7) "100,000"
}
["rets_tax_paid_by_seller_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tax_year"]=>
array(1) {
[0]=>
string(4) "2022"
}
["rets_thumbnail_url"]=>
array(1) {
[0]=>
string(81) "https://cdn.rets.ci/marcusrealty-images/16623702/556e78e32baca9e5d0f26f02e8c41a78"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "143"
}
["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) "17"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "3"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(2) "62"
}
["rets_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(51) "https://my.matterport.com/show/?m=Q7Qchafb85n&mls=1"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1972"
}
["security"]=>
array(1) {
[0]=>
string(3) "Key"
}
["setbacks"]=>
array(1) {
[0]=>
string(3) "C&C"
}
["state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["street_name"]=>
array(1) {
[0]=>
string(5) "Auwai"
}
["street_number"]=>
array(1) {
[0]=>
string(3) "551"
}
["street_suffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["terms_accept"]=>
array(1) {
[0]=>
string(20) "Cash,Conventional,VA"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-4-3-062-017-0000"
}
["topography"]=>
array(1) {
[0]=>
string(5) "Clear"
}
["view"]=>
array(1) {
[0]=>
string(6) "Garden"
}
["virtual_tour"]=>
array(1) {
[0]=>
string(51) "https://my.matterport.com/show/?m=Q7Qchafb85n&mls=1"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16623702"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202208364"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1656374944"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1972"
}
["zoning"]=>
array(1) {
[0]=>
string(29) "05 - R-5 Residential District"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(2040) "a:126:{i:0;i:22149609;i:1;i:22149610;i:2;i:22149611;i:3;i:22149612;i:4;i:22149613;i:5;i:22149614;i:6;i:22149615;i:7;i:22149616;i:8;i:22149617;i:9;i:22149618;i:10;i:22149619;i:11;i:22149620;i:12;i:22149621;i:13;i:22149622;i:14;i:22149623;i:15;i:22149624;i:16;i:22149625;i:17;i:22149626;i:18;i:22149627;i:19;i:22149628;i:20;i:22149629;i:21;i:22149690;i:22;i:22149691;i:23;i:22149692;i:24;i:22149693;i:25;i:22149694;i:26;i:22149695;i:27;i:22149696;i:28;i:22149697;i:29;i:22149698;i:30;i:22149699;i:31;i:22149700;i:32;i:22149701;i:33;i:22149702;i:34;i:22149703;i:35;i:22149704;i:36;i:22149705;i:37;i:22149706;i:38;i:22149707;i:39;i:22149708;i:40;i:22149709;i:41;i:22149710;i:42;i:22153354;i:43;i:22153355;i:44;i:22153356;i:45;i:22153357;i:46;i:22153358;i:47;i:22153359;i:48;i:22153360;i:49;i:22153361;i:50;i:22153362;i:51;i:22153363;i:52;i:22153364;i:53;i:22153365;i:54;i:22153366;i:55;i:22153367;i:56;i:22153368;i:57;i:22153369;i:58;i:22153370;i:59;i:22153371;i:60;i:22153372;i:61;i:22153373;i:62;i:22153374;i:63;i:22208656;i:64;i:22208657;i:65;i:22208658;i:66;i:22208659;i:67;i:22208660;i:68;i:22208661;i:69;i:22208662;i:70;i:22208663;i:71;i:22208664;i:72;i:22208665;i:73;i:22208666;i:74;i:22208667;i:75;i:22208668;i:76;i:22208669;i:77;i:22208670;i:78;i:22208671;i:79;i:22208672;i:80;i:22208673;i:81;i:22208674;i:82;i:22208675;i:83;i:22208676;i:84;i:22277945;i:85;i:22277946;i:86;i:22277947;i:87;i:22277948;i:88;i:22277949;i:89;i:22277950;i:90;i:22277951;i:91;i:22277952;i:92;i:22277953;i:93;i:22277954;i:94;i:22277955;i:95;i:22277956;i:96;i:22277957;i:97;i:22277958;i:98;i:22277959;i:99;i:22277960;i:100;i:22277961;i:101;i:22277962;i:102;i:22277963;i:103;i:22277964;i:104;i:22277965;i:105;i:22559537;i:106;i:22559538;i:107;i:22559539;i:108;i:22559540;i:109;i:22559541;i:110;i:22559542;i:111;i:22559543;i:112;i:22559544;i:113;i:22559545;i:114;i:22559546;i:115;i:22559547;i:116;i:22559548;i:117;i:22559549;i:118;i:22559550;i:119;i:22559551;i:120;i:22559552;i:121;i:22559553;i:122;i:22559554;i:123;i:22559555;i:124;i:22559556;i:125;i:22559557;}"
}
["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-05-11"
}
["rets_pending_date"]=>
array(1) {
[0]=>
string(10) "2022-05-11"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-06-27"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(10) "1600000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2023-04-26"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-06-27"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 792-3910"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(19) "lizb@bhhshawaii.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(9) "Liz Bills"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "50474"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(8) "15250534"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(6) "BHHR02"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(8) "10102444"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(30) "Berkshire Hathaway HmSvc HI RE"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 792-3910"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "22559537"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 180400.00
)
[assd_val_land] => Array
(
[0] => 996700.00
)
[assd_val_total] => Array
(
[0] => 1177100.00
)
[bedrooms] => Array
(
[0] => 5
)
[building_style] => Array
(
[0] => 1 Bedroom Cottage,Detach Single Family
)
[city] => Array
(
[0] => Kailua
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Property Disclosure Stmt,Relative of Licensee
)
[easements] => Array
(
[0] => None
)
[elementary_school] => Array
(
[0] => Kailua
)
[exclusions] => Array
(
[0] => Other
)
[floor_covering] => Array
(
[0] => Laminate,Vinyl
)
[full_baths] => Array
(
[0] => 3
)
[furnished] => Array
(
[0] => Partial
)
[half_baths] => Array
(
[0] => 1
)
[high_school] => Array
(
[0] => Kailua
)
[home_exampt] => Array
(
[0] => 100,000
)
[land_area_sf] => Array
(
[0] => 5775.00
)
[land_recorded] => Array
(
[0] => Land Court
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => gracek@BetterHawaii.com
)
[list_agent_name] => Array
(
[0] => Grace M Koreyasu
)
[list_agent_phone_number] => Array
(
[0] => (808) 261-1800
)
[list_date] => Array
(
[0] => 2022-05-03
)
[list_office_name] => Array
(
[0] => BHGRE Advantage Realty
)
[list_price] => Array
(
[0] => 1535000.00
)
[living_sf] => Array
(
[0] => 2076
)
[location] => Array
(
[0] => 551 Auwai Street, Kailua, HI 96734
)
[middle_school] => Array
(
[0] => Kailua
)
[mls_] => Array
(
[0] => 202208364
)
[neighborhood] => Array
(
[0] => COCONUT GROVE
)
[number_of_parking_spaces] => Array
(
[0] => 4
)
[number_of_stories] => Array
(
[0] => One
)
[office_mls_id] => Array
(
[0] => ADVG02
)
[parking_features] => Array
(
[0] => 3 Car+,Boat,Carport,Driveway,Street
)
[pool_] => Array
(
[0] => None
)
[possession] => Array
(
[0] => 45 Days or Less,At Closing
)
[postal_code] => Array
(
[0] => 96734
)
[property_condition] => Array
(
[0] => Above Average
)
[property_type] => Array
(
[0] => single_family
)
[property_type_label] => Array
(
[0] => single_family
)
[region] => Array
(
[0] => Kailua
)
[rets_baths_full] => Array
(
[0] => 3
)
[rets_baths_half] => Array
(
[0] => 1
)
[rets_baths_total] => Array
(
[0] => 3.01
)
[rets_beds_total] => Array
(
[0] => 5
)
[rets_city] => Array
(
[0] => Kailua
)
[rets_condo_property_regime_yn] => Array
(
[0] => 0
)
[rets_current_price] => Array
(
[0] => 1600000.00
)
[rets_dom] => Array
(
[0] => 9
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_elementary_school] => Array
(
[0] => Kailua
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_high_school] => Array
(
[0] => Kailua
)
[rets_id] => Array
(
[0] => 16623702
)
[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) 261-1800
)
[rets_list_agent_email] => Array
(
[0] => gracek@BetterHawaii.com
)
[rets_list_agent_full_name] => Array
(
[0] => Grace M Koreyasu
)
[rets_list_agent_mlsid] => Array
(
[0] => 20458
)
[rets_list_agent_mui] => Array
(
[0] => 3473763
)
[rets_list_office_mlsid] => Array
(
[0] => ADVG02
)
[rets_list_office_mui] => Array
(
[0] => 10139093
)
[rets_list_office_name] => Array
(
[0] => BHGRE Advantage Realty
)
[rets_list_office_phone] => Array
(
[0] => (808) 261-1800
)
[rets_list_price] => Array
(
[0] => 1535000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-05-03
)
[rets_lot_size_area] => Array
(
[0] => 5775.00
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-06-27T14:08:50.160
)
[rets_matrix_unique_id] => Array
(
[0] => 16623702
)
[rets_middle_or_junior_school] => Array
(
[0] => Kailua
)
[rets_mls_number] => Array
(
[0] => 202208364
)
[rets_neighbourhood] => Array
(
[0] => COCONUT GROVE
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_open_house_count] => Array
(
[0] => 1
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-05-03T18:33:40.587
)
[rets_original_list_price] => Array
(
[0] => 1535000.00
)
[rets_parcel_number] => Array
(
[0] => 1-4-3-062-017-0000
)
[rets_parking_total] => Array
(
[0] => 4
)
[rets_permit_address_internet_yn] => Array
(
[0] => 1
)
[rets_permit_internet_yn] => Array
(
[0] => 1
)
[rets_photo_count] => Array
(
[0] => 25
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2022-05-04T11:15:26.917
)
[rets_postal_code] => Array
(
[0] => 96734
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-05-03T18:33:40.587
)
[rets_primary_key] => Array
(
[0] => 16623702
)
[rets_private_remarks] => Array
(
[0] => text/email/call Grace directly for all showings. Day prior notice please. EZ to see! Please use: Fidelity National Title, Kailua (Kristin Piasecki). Also, include BHG Addendum, Affiliated Bus Disclosure - attached in MLS. Offers will be presented as they come in. Property tax amount noted is based on 2021 assessed values. Brokers Open 5/5/2022 9:30-noon.
)
[rets_public_remarks] => Array
(
[0] => Fantastic street appeal on this great Kailua double-wall single level home w/ 4 bdrms 2 newly renovated bathrms & a bonus half bath/laundry room. PLUS an attached 1/1 (with its own laundry) – currently configured as a hair salon + studio. This home has been lovingly renovated through the years with new LVP laminate flooring, fresh paint, plantation shutters, breezeway windows, french doors, new ceiling fans, lighting and much, much more. Nice entry foyer that goes to each unit…. Excellent home office option, in-law suite or other. Very nicely landscaped w/lots of unique plants & a fruit bearing Kalamansi tree! Attached carport & lots of storage throughout… Great lanai off the back yard for the Tiki bar experience (with bathroom!) Upgraded 200 amp electrical service, solar water heating, new roof in 2016, 35 owned PV panels & split AC’s are a few of the great features. Plus a deeded 1/3 interest in adjacent driveway for drive in access to the back yard (boat?)… Auwai Street is one of Coconut Grove's nice, wider streets with close proximity to Kailua town and Kailua’s famous white sand beaches! A definite must see if you’re thinking about Kailua…
)
[rets_sqft_garage_carport] => Array
(
[0] => 380
)
[rets_sqft_roofed_living] => Array
(
[0] => 2076
)
[rets_sqft_total] => Array
(
[0] => 2076
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-06-27T14:08:50.160
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-06-27
)
[rets_street_name] => Array
(
[0] => Auwai
)
[rets_street_number] => Array
(
[0] => 551
)
[rets_street_view_param] => Array
(
[0] => 1$21.398721$-157.749006$114.31$13.33$1.00$yJ8D1RFkM_1mX24k56YnyA
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5
)
[rets_supplement_count] => Array
(
[0] => 2
)
[rets_supplement_modification_timestam] => Array
(
[0] => 2022-05-03T18:33:20.353
)
[rets_tax_amount] => Array
(
[0] => 256.96
)
[rets_tax_annual_amount] => Array
(
[0] => 3083.52
)
[rets_tax_assessed_value] => Array
(
[0] => 1177100.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 180400.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 996700.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 100,000
)
[rets_tax_paid_by_seller_yn] => Array
(
[0] => 1
)
[rets_tax_year] => Array
(
[0] => 2022
)
[rets_thumbnail_url] => Array
(
[0] => https://cdn.rets.ci/marcusrealty-images/16623702/556e78e32baca9e5d0f26f02e8c41a78
)
[rets_tmk_area] => Array
(
[0] => 143
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 0
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 17
)
[rets_tmk_section] => Array
(
[0] => 3
)
[rets_tmk_zone] => Array
(
[0] => 4
)
[rets_tmkplat] => Array
(
[0] => 62
)
[rets_virtual_tour_url_unbranded] => Array
(
[0] => https://my.matterport.com/show/?m=Q7Qchafb85n&mls=1
)
[rets_year_built] => Array
(
[0] => 1972
)
[security] => Array
(
[0] => Key
)
[setbacks] => Array
(
[0] => C&C
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Auwai
)
[street_number] => Array
(
[0] => 551
)
[street_suffix] => Array
(
[0] => Street
)
[terms_accept] => Array
(
[0] => Cash,Conventional,VA
)
[tmk] => Array
(
[0] => 1-4-3-062-017-0000
)
[topography] => Array
(
[0] => Clear
)
[view] => Array
(
[0] => Garden
)
[virtual_tour] => Array
(
[0] => https://my.matterport.com/show/?m=Q7Qchafb85n&mls=1
)
[wpp::rets_pk] => Array
(
[0] => 16623702
)
[wpp_gpid] => Array
(
[0] => 202208364
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1656374944
)
[year_built] => Array
(
[0] => 1972
)
[zoning] => Array
(
[0] => 05 - R-5 Residential District
)
[new_attached_media] => Array
(
[0] => a:126:{i:0;i:22149609;i:1;i:22149610;i:2;i:22149611;i:3;i:22149612;i:4;i:22149613;i:5;i:22149614;i:6;i:22149615;i:7;i:22149616;i:8;i:22149617;i:9;i:22149618;i:10;i:22149619;i:11;i:22149620;i:12;i:22149621;i:13;i:22149622;i:14;i:22149623;i:15;i:22149624;i:16;i:22149625;i:17;i:22149626;i:18;i:22149627;i:19;i:22149628;i:20;i:22149629;i:21;i:22149690;i:22;i:22149691;i:23;i:22149692;i:24;i:22149693;i:25;i:22149694;i:26;i:22149695;i:27;i:22149696;i:28;i:22149697;i:29;i:22149698;i:30;i:22149699;i:31;i:22149700;i:32;i:22149701;i:33;i:22149702;i:34;i:22149703;i:35;i:22149704;i:36;i:22149705;i:37;i:22149706;i:38;i:22149707;i:39;i:22149708;i:40;i:22149709;i:41;i:22149710;i:42;i:22153354;i:43;i:22153355;i:44;i:22153356;i:45;i:22153357;i:46;i:22153358;i:47;i:22153359;i:48;i:22153360;i:49;i:22153361;i:50;i:22153362;i:51;i:22153363;i:52;i:22153364;i:53;i:22153365;i:54;i:22153366;i:55;i:22153367;i:56;i:22153368;i:57;i:22153369;i:58;i:22153370;i:59;i:22153371;i:60;i:22153372;i:61;i:22153373;i:62;i:22153374;i:63;i:22208656;i:64;i:22208657;i:65;i:22208658;i:66;i:22208659;i:67;i:22208660;i:68;i:22208661;i:69;i:22208662;i:70;i:22208663;i:71;i:22208664;i:72;i:22208665;i:73;i:22208666;i:74;i:22208667;i:75;i:22208668;i:76;i:22208669;i:77;i:22208670;i:78;i:22208671;i:79;i:22208672;i:80;i:22208673;i:81;i:22208674;i:82;i:22208675;i:83;i:22208676;i:84;i:22277945;i:85;i:22277946;i:86;i:22277947;i:87;i:22277948;i:88;i:22277949;i:89;i:22277950;i:90;i:22277951;i:91;i:22277952;i:92;i:22277953;i:93;i:22277954;i:94;i:22277955;i:95;i:22277956;i:96;i:22277957;i:97;i:22277958;i:98;i:22277959;i:99;i:22277960;i:100;i:22277961;i:101;i:22277962;i:102;i:22277963;i:103;i:22277964;i:104;i:22277965;i:105;i:22559537;i:106;i:22559538;i:107;i:22559539;i:108;i:22559540;i:109;i:22559541;i:110;i:22559542;i:111;i:22559543;i:112;i:22559544;i:113;i:22559545;i:114;i:22559546;i:115;i:22559547;i:116;i:22559548;i:117;i:22559549;i:118;i:22559550;i:119;i:22559551;i:120;i:22559552;i:121;i:22559553;i:122;i:22559554;i:123;i:22559555;i:124;i:22559556;i:125;i:22559557;}
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_open_house_upcoming] => Array
(
[0] =>
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-05-11
)
[rets_pending_date] => Array
(
[0] => 2022-05-11
)
[rets_close_date] => Array
(
[0] => 2022-06-27
)
[rets_close_price] => Array
(
[0] => 1600000.00
)
[rets_expiration_date] => Array
(
[0] => 2023-04-26
)
[rets_off_market_date] => Array
(
[0] => 2022-06-27
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 792-3910
)
[rets_selling_agent_email] => Array
(
[0] => lizb@bhhshawaii.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Liz Bills
)
[rets_selling_agent_mlsid] => Array
(
[0] => 50474
)
[rets_selling_agent_mui] => Array
(
[0] => 15250534
)
[rets_selling_office_mlsid] => Array
(
[0] => BHHR02
)
[rets_selling_office_mui] => Array
(
[0] => 10102444
)
[rets_selling_office_name] => Array
(
[0] => Berkshire Hathaway HmSvc HI RE
)
[rets_selling_office_phone] => Array
(
[0] => (808) 792-3910
)
[_thumbnail_id] => Array
(
[0] => 22559537
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446