Charming Turnkey Modern Finish Home in the Heart of Kailua Town. Newly Renovated! Open Concept Kitchen with Glass Tile Backsplash, Quartz Countertops and Extended Island Dinning with Built in Storage will be perfect for entertaining. Spacious 3 Bedroom / 2 Bathroom has newly installed Split AC System and Luxury Vinyl Planking throughout the home in a neutral grey tone that makes it easy to furnish to your liking. Custom tile bathrooms in a modern aesthetic with built in niches, newly installed vanities and coordinating matte black hardware throughout. Whether entering in through the porch to immediately experience the Open Floor Plan Living Room or walking out from the Kitchen to enjoy entertaining your guest under the large covered area out back facing the beautiful yard with mature plumeria tree… YOU ARE GOING TO LOVE Living this Lifestyle in Kailua!
Listing by: eXp Realty
array(153) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "774000.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "728800.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "806200.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "3"
}
["building_style"]=>
array(1) {
[0]=>
string(20) "Detach Single Family"
}
["city"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(24) "Property Disclosure Stmt"
}
["easements"]=>
array(1) {
[0]=>
string(4) "None"
}
["floor_covering"]=>
array(1) {
[0]=>
string(5) "Vinyl"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "2"
}
["furnished"]=>
array(1) {
[0]=>
string(4) "None"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["home_exampt"]=>
array(1) {
[0]=>
string(2) "No"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(3) "274"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(7) "5000.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(30) "tiarelando@legacylivingnow.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(11) "Tiare Lando"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 725-2794"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-05-20"
}
["list_office_name"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["list_price"]=>
array(1) {
[0]=>
string(10) "1250000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "1262"
}
["location"]=>
array(1) {
[0]=>
string(41) "524 Auwai Street Unit A, Kailua, HI 96734"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202209752"
}
["neighborhood"]=>
array(1) {
[0]=>
string(13) "COCONUT GROVE"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "3"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(3) "One"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "EXPI"
}
["parking_features"]=>
array(1) {
[0]=>
string(6) "3 Car+"
}
["pool_"]=>
array(1) {
[0]=>
string(4) "None"
}
["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(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) "2"
}
["rets_baths_half"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_baths_total"]=>
array(1) {
[0]=>
string(4) "2.00"
}
["rets_beds_total"]=>
array(1) {
[0]=>
string(1) "3"
}
["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) "1275000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(2) "18"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_foreclosure_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_fractional_ownership_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_id"]=>
array(1) {
[0]=>
string(8) "16659336"
}
["rets_immoviewer_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_internet_automated_valuation_dis"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_internet_consumer_comment_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 725-2794"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(30) "tiarelando@legacylivingnow.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(11) "Tiare Lando"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "47663"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(8) "12135311"
}
["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(10) "1250000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-05-20"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(7) "5000.00"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-07-12T15:43:43.247"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16659336"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202209752"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(13) "COCONUT GROVE"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-05-20T21:56:40.917"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(10) "1250000.00"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-4-3-062-047-0000"
}
["rets_parking_total"]=>
array(1) {
[0]=>
string(1) "3"
}
["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-20T22:13:01.320"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96734"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16659336"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(397) "Aloha Agents! Please Use Showing Time. Vacant & Easy to Show. Seller prefers Title Guaranty Kailua: Kelena Palencia (808)373-6188 TeamKelena@tghawaii.com Brokers Open Thursday, June 2nd 9:30 am - 12pm Open Home Sun June 5th, 2 pm - 5 pm. Contact Listing Agent Tiare Lando with Questions Text (808)381-7824 TiareLando@legacylivingnow.com. Buyer to perform due diligence. TMK does not match. Mahalo!"
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(866) "Charming Turnkey Modern Finish Home in the Heart of Kailua Town. Newly Renovated! Open Concept Kitchen with Glass Tile Backsplash, Quartz Countertops and Extended Island Dinning with Built in Storage will be perfect for entertaining. Spacious 3 Bedroom / 2 Bathroom has newly installed Split AC System and Luxury Vinyl Planking throughout the home in a neutral grey tone that makes it easy to furnish to your liking. Custom tile bathrooms in a modern aesthetic with built in niches, newly installed vanities and coordinating matte black hardware throughout. Whether entering in through the porch to immediately experience the Open Floor Plan Living Room or walking out from the Kitchen to enjoy entertaining your guest under the large covered area out back facing the beautiful yard with mature plumeria tree... YOU ARE GOING TO LOVE Living this Lifestyle in Kailua!"
}
["rets_sqft_garage_carport"]=>
array(1) {
[0]=>
string(3) "200"
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(3) "274"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(3) "988"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "1262"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-07-12T15:43:43.247"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-07-08"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(5) "Auwai"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(3) "524"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(64) "1$21.399466$-157.748403$153.82$13.33$1.00$eta84z1wluYt0mCnV3WGRw"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "194.00"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "2328.00"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "806200.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "774000.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "728800.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(2) "No"
}
["rets_tax_paid_by_seller_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tax_year"]=>
array(1) {
[0]=>
string(4) "2021"
}
["rets_thumbnail_url"]=>
array(1) {
[0]=>
string(81) "https://cdn.rets.ci/marcusrealty-images/16659336/5bb7f10a27a59893ea320b7f67a58657"
}
["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) "47"
}
["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_unit_number"]=>
array(1) {
[0]=>
string(1) "A"
}
["rets_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(177) "https://player.vimeo.com/progressive_redirect/playback/712299168/rendition/1080p/file.mp4?loc=external&signature=0acee86cdf70df3f68b9c24007f79efaa8c18b0d68eb150c5fdfaf22abb97bcd"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1952"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(4) "2022"
}
["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) "524"
}
["street_suffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["terms_accept"]=>
array(1) {
[0]=>
string(17) "Cash,Conventional"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-4-3-062-047-0000"
}
["topography"]=>
array(1) {
[0]=>
string(5) "Clear"
}
["unit_number"]=>
array(1) {
[0]=>
string(1) "A"
}
["view"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["virtual_tour"]=>
array(1) {
[0]=>
string(177) "https://player.vimeo.com/progressive_redirect/playback/712299168/rendition/1080p/file.mp4?loc=external&signature=0acee86cdf70df3f68b9c24007f79efaa8c18b0d68eb150c5fdfaf22abb97bcd"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16659336"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202209752"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1657676639"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1952"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "2022"
}
["zoning"]=>
array(1) {
[0]=>
string(29) "05 - R-5 Residential District"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(4896) "a:294:{i:0;i:22271252;i:1;i:22271253;i:2;i:22271254;i:3;i:22271255;i:4;i:22271256;i:5;i:22271257;i:6;i:22271258;i:7;i:22271259;i:8;i:22271260;i:9;i:22271261;i:10;i:22271262;i:11;i:22271263;i:12;i:22271264;i:13;i:22271265;i:14;i:22271266;i:15;i:22271267;i:16;i:22271268;i:17;i:22271269;i:18;i:22271270;i:19;i:22271271;i:20;i:22271272;i:21;i:22271294;i:22;i:22271295;i:23;i:22271296;i:24;i:22271297;i:25;i:22271298;i:26;i:22271299;i:27;i:22271300;i:28;i:22271301;i:29;i:22271302;i:30;i:22271303;i:31;i:22271304;i:32;i:22271305;i:33;i:22271306;i:34;i:22271307;i:35;i:22271308;i:36;i:22271309;i:37;i:22271310;i:38;i:22271311;i:39;i:22271312;i:40;i:22271313;i:41;i:22271314;i:42;i:22271378;i:43;i:22271379;i:44;i:22271380;i:45;i:22271381;i:46;i:22271382;i:47;i:22271383;i:48;i:22271384;i:49;i:22271385;i:50;i:22271386;i:51;i:22271387;i:52;i:22271388;i:53;i:22271389;i:54;i:22271390;i:55;i:22271391;i:56;i:22271392;i:57;i:22271393;i:58;i:22271394;i:59;i:22271395;i:60;i:22271396;i:61;i:22271397;i:62;i:22271398;i:63;i:22271399;i:64;i:22271400;i:65;i:22271401;i:66;i:22271402;i:67;i:22271403;i:68;i:22271404;i:69;i:22271405;i:70;i:22271406;i:71;i:22271407;i:72;i:22271408;i:73;i:22271409;i:74;i:22271410;i:75;i:22271411;i:76;i:22271412;i:77;i:22271413;i:78;i:22271414;i:79;i:22271415;i:80;i:22271416;i:81;i:22271417;i:82;i:22271418;i:83;i:22271419;i:84;i:22274227;i:85;i:22274228;i:86;i:22274229;i:87;i:22274230;i:88;i:22274231;i:89;i:22274232;i:90;i:22274233;i:91;i:22274234;i:92;i:22274235;i:93;i:22274236;i:94;i:22274237;i:95;i:22274238;i:96;i:22274239;i:97;i:22274240;i:98;i:22274241;i:99;i:22274242;i:100;i:22274243;i:101;i:22274244;i:102;i:22274245;i:103;i:22274246;i:104;i:22274247;i:105;i:22278363;i:106;i:22278364;i:107;i:22278365;i:108;i:22278366;i:109;i:22278367;i:110;i:22278368;i:111;i:22278369;i:112;i:22278370;i:113;i:22278371;i:114;i:22278372;i:115;i:22278373;i:116;i:22278374;i:117;i:22278375;i:118;i:22278376;i:119;i:22278377;i:120;i:22278378;i:121;i:22278379;i:122;i:22278380;i:123;i:22278381;i:124;i:22278382;i:125;i:22278383;i:126;i:22321607;i:127;i:22321608;i:128;i:22321609;i:129;i:22321610;i:130;i:22321611;i:131;i:22321612;i:132;i:22321613;i:133;i:22321614;i:134;i:22321615;i:135;i:22321616;i:136;i:22321617;i:137;i:22321618;i:138;i:22321619;i:139;i:22321620;i:140;i:22321621;i:141;i:22321622;i:142;i:22321623;i:143;i:22321624;i:144;i:22321625;i:145;i:22321626;i:146;i:22321627;i:147;i:22325659;i:148;i:22325660;i:149;i:22325661;i:150;i:22325662;i:151;i:22325663;i:152;i:22325664;i:153;i:22325665;i:154;i:22325666;i:155;i:22325667;i:156;i:22325668;i:157;i:22325669;i:158;i:22325670;i:159;i:22325671;i:160;i:22325672;i:161;i:22325673;i:162;i:22325674;i:163;i:22325675;i:164;i:22325676;i:165;i:22325677;i:166;i:22325678;i:167;i:22325679;i:168;i:22326057;i:169;i:22326058;i:170;i:22326059;i:171;i:22326060;i:172;i:22326061;i:173;i:22326062;i:174;i:22326063;i:175;i:22326064;i:176;i:22326065;i:177;i:22326066;i:178;i:22326067;i:179;i:22326068;i:180;i:22326069;i:181;i:22326070;i:182;i:22326071;i:183;i:22326072;i:184;i:22326073;i:185;i:22326074;i:186;i:22326075;i:187;i:22326076;i:188;i:22326077;i:189;i:22326078;i:190;i:22326079;i:191;i:22326080;i:192;i:22326081;i:193;i:22326082;i:194;i:22326083;i:195;i:22326084;i:196;i:22326085;i:197;i:22326086;i:198;i:22326087;i:199;i:22326088;i:200;i:22326089;i:201;i:22326090;i:202;i:22326091;i:203;i:22326092;i:204;i:22326093;i:205;i:22326094;i:206;i:22326095;i:207;i:22326096;i:208;i:22326097;i:209;i:22326098;i:210;i:22333964;i:211;i:22333965;i:212;i:22333966;i:213;i:22333967;i:214;i:22333968;i:215;i:22333969;i:216;i:22333970;i:217;i:22333971;i:218;i:22333972;i:219;i:22333973;i:220;i:22333974;i:221;i:22333975;i:222;i:22333976;i:223;i:22333977;i:224;i:22333978;i:225;i:22333979;i:226;i:22333980;i:227;i:22333981;i:228;i:22333982;i:229;i:22333983;i:230;i:22333984;i:231;i:22334027;i:232;i:22334028;i:233;i:22334029;i:234;i:22334030;i:235;i:22334031;i:236;i:22334032;i:237;i:22334033;i:238;i:22334034;i:239;i:22334035;i:240;i:22334036;i:241;i:22334037;i:242;i:22334038;i:243;i:22334039;i:244;i:22334040;i:245;i:22334041;i:246;i:22334042;i:247;i:22334043;i:248;i:22334044;i:249;i:22334045;i:250;i:22334046;i:251;i:22334047;i:252;i:22384605;i:253;i:22384606;i:254;i:22384607;i:255;i:22384608;i:256;i:22384609;i:257;i:22384610;i:258;i:22384611;i:259;i:22384612;i:260;i:22384613;i:261;i:22384614;i:262;i:22384615;i:263;i:22384616;i:264;i:22384617;i:265;i:22384618;i:266;i:22384619;i:267;i:22384620;i:268;i:22384621;i:269;i:22384622;i:270;i:22384623;i:271;i:22384624;i:272;i:22384625;i:273;i:22704013;i:274;i:22704014;i:275;i:22704015;i:276;i:22704016;i:277;i:22704017;i:278;i:22704018;i:279;i:22704019;i:280;i:22704020;i:281;i:22704021;i:282;i:22704022;i:283;i:22704023;i:284;i:22704024;i:285;i:22704025;i:286;i:22704026;i:287;i:22704027;i:288;i:22704028;i:289;i:22704029;i:290;i:22704030;i:291;i:22704031;i:292;i:22704032;i:293;i:22704033;}"
}
["rets_open_house_count"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_active_open_house_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_open_house_upcoming"]=>
array(1) {
[0]=>
string(0) ""
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-06-03"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-07-08"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(10) "1275000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2023-05-20"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-07-08"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 725-2794"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(31) "elgineonaka@legacylivingnow.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(12) "Elgine Onaka"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "50824"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(8) "15514810"
}
["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) "22704013"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 774000.00
)
[assd_val_land] => Array
(
[0] => 728800.00
)
[assd_val_total] => Array
(
[0] => 806200.00
)
[bedrooms] => Array
(
[0] => 3
)
[building_style] => Array
(
[0] => Detach Single Family
)
[city] => Array
(
[0] => Kailua
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Property Disclosure Stmt
)
[easements] => Array
(
[0] => None
)
[floor_covering] => Array
(
[0] => Vinyl
)
[full_baths] => Array
(
[0] => 2
)
[furnished] => Array
(
[0] => None
)
[half_baths] => Array
(
[0] => 0
)
[home_exampt] => Array
(
[0] => No
)
[lanai_sf] => Array
(
[0] => 274
)
[land_area_sf] => Array
(
[0] => 5000.00
)
[land_recorded] => Array
(
[0] => Regular System
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => tiarelando@legacylivingnow.com
)
[list_agent_name] => Array
(
[0] => Tiare Lando
)
[list_agent_phone_number] => Array
(
[0] => (808) 725-2794
)
[list_date] => Array
(
[0] => 2022-05-20
)
[list_office_name] => Array
(
[0] => eXp Realty
)
[list_price] => Array
(
[0] => 1250000.00
)
[living_sf] => Array
(
[0] => 1262
)
[location] => Array
(
[0] => 524 Auwai Street Unit A, Kailua, HI 96734
)
[mls_] => Array
(
[0] => 202209752
)
[neighborhood] => Array
(
[0] => COCONUT GROVE
)
[number_of_parking_spaces] => Array
(
[0] => 3
)
[number_of_stories] => Array
(
[0] => One
)
[office_mls_id] => Array
(
[0] => EXPI
)
[parking_features] => Array
(
[0] => 3 Car+
)
[pool_] => Array
(
[0] => None
)
[possession] => Array
(
[0] => At Closing
)
[postal_code] => Array
(
[0] => 96734
)
[property_condition] => Array
(
[0] => Excellent
)
[property_type] => Array
(
[0] => single_family
)
[property_type_label] => Array
(
[0] => single_family
)
[region] => Array
(
[0] => Kailua
)
[rets_baths_full] => Array
(
[0] => 2
)
[rets_baths_half] => Array
(
[0] => 0
)
[rets_baths_total] => Array
(
[0] => 2.00
)
[rets_beds_total] => Array
(
[0] => 3
)
[rets_city] => Array
(
[0] => Kailua
)
[rets_condo_property_regime_yn] => Array
(
[0] => 0
)
[rets_current_price] => Array
(
[0] => 1275000.00
)
[rets_dom] => Array
(
[0] => 18
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_id] => Array
(
[0] => 16659336
)
[rets_immoviewer_yn] => Array
(
[0] => 0
)
[rets_internet_automated_valuation_dis] => Array
(
[0] => 0
)
[rets_internet_consumer_comment_yn] => Array
(
[0] => 0
)
[rets_list_agent_direct_work_phone] => Array
(
[0] => (808) 725-2794
)
[rets_list_agent_email] => Array
(
[0] => tiarelando@legacylivingnow.com
)
[rets_list_agent_full_name] => Array
(
[0] => Tiare Lando
)
[rets_list_agent_mlsid] => Array
(
[0] => 47663
)
[rets_list_agent_mui] => Array
(
[0] => 12135311
)
[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] => 1250000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-05-20
)
[rets_lot_size_area] => Array
(
[0] => 5000.00
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-07-12T15:43:43.247
)
[rets_matrix_unique_id] => Array
(
[0] => 16659336
)
[rets_mls_number] => Array
(
[0] => 202209752
)
[rets_neighbourhood] => Array
(
[0] => COCONUT GROVE
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-05-20T21:56:40.917
)
[rets_original_list_price] => Array
(
[0] => 1250000.00
)
[rets_parcel_number] => Array
(
[0] => 1-4-3-062-047-0000
)
[rets_parking_total] => Array
(
[0] => 3
)
[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-20T22:13:01.320
)
[rets_postal_code] => Array
(
[0] => 96734
)
[rets_primary_key] => Array
(
[0] => 16659336
)
[rets_private_remarks] => Array
(
[0] => Aloha Agents! Please Use Showing Time. Vacant & Easy to Show. Seller prefers Title Guaranty Kailua: Kelena Palencia (808)373-6188 TeamKelena@tghawaii.com Brokers Open Thursday, June 2nd 9:30 am - 12pm Open Home Sun June 5th, 2 pm - 5 pm. Contact Listing Agent Tiare Lando with Questions Text (808)381-7824 TiareLando@legacylivingnow.com. Buyer to perform due diligence. TMK does not match. Mahalo!
)
[rets_public_remarks] => Array
(
[0] => Charming Turnkey Modern Finish Home in the Heart of Kailua Town. Newly Renovated! Open Concept Kitchen with Glass Tile Backsplash, Quartz Countertops and Extended Island Dinning with Built in Storage will be perfect for entertaining. Spacious 3 Bedroom / 2 Bathroom has newly installed Split AC System and Luxury Vinyl Planking throughout the home in a neutral grey tone that makes it easy to furnish to your liking. Custom tile bathrooms in a modern aesthetic with built in niches, newly installed vanities and coordinating matte black hardware throughout. Whether entering in through the porch to immediately experience the Open Floor Plan Living Room or walking out from the Kitchen to enjoy entertaining your guest under the large covered area out back facing the beautiful yard with mature plumeria tree... YOU ARE GOING TO LOVE Living this Lifestyle in Kailua!
)
[rets_sqft_garage_carport] => Array
(
[0] => 200
)
[rets_sqft_lanai_open] => Array
(
[0] => 274
)
[rets_sqft_roofed_living] => Array
(
[0] => 988
)
[rets_sqft_total] => Array
(
[0] => 1262
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-07-12T15:43:43.247
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-07-08
)
[rets_street_name] => Array
(
[0] => Auwai
)
[rets_street_number] => Array
(
[0] => 524
)
[rets_street_view_param] => Array
(
[0] => 1$21.399466$-157.748403$153.82$13.33$1.00$eta84z1wluYt0mCnV3WGRw
)
[rets_sub_agency_compensation] => Array
(
[0] => 2
)
[rets_tax_amount] => Array
(
[0] => 194.00
)
[rets_tax_annual_amount] => Array
(
[0] => 2328.00
)
[rets_tax_assessed_value] => Array
(
[0] => 806200.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 774000.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 728800.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => No
)
[rets_tax_paid_by_seller_yn] => Array
(
[0] => 1
)
[rets_tax_year] => Array
(
[0] => 2021
)
[rets_thumbnail_url] => Array
(
[0] => https://cdn.rets.ci/marcusrealty-images/16659336/5bb7f10a27a59893ea320b7f67a58657
)
[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] => 47
)
[rets_tmk_section] => Array
(
[0] => 3
)
[rets_tmk_zone] => Array
(
[0] => 4
)
[rets_tmkplat] => Array
(
[0] => 62
)
[rets_unit_number] => Array
(
[0] => A
)
[rets_virtual_tour_url_unbranded] => Array
(
[0] => https://player.vimeo.com/progressive_redirect/playback/712299168/rendition/1080p/file.mp4?loc=external&signature=0acee86cdf70df3f68b9c24007f79efaa8c18b0d68eb150c5fdfaf22abb97bcd
)
[rets_year_built] => Array
(
[0] => 1952
)
[rets_year_remodeled] => Array
(
[0] => 2022
)
[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] => 524
)
[street_suffix] => Array
(
[0] => Street
)
[terms_accept] => Array
(
[0] => Cash,Conventional
)
[tmk] => Array
(
[0] => 1-4-3-062-047-0000
)
[topography] => Array
(
[0] => Clear
)
[unit_number] => Array
(
[0] => A
)
[view] => Array
(
[0] => Mountain
)
[virtual_tour] => Array
(
[0] => https://player.vimeo.com/progressive_redirect/playback/712299168/rendition/1080p/file.mp4?loc=external&signature=0acee86cdf70df3f68b9c24007f79efaa8c18b0d68eb150c5fdfaf22abb97bcd
)
[wpp::rets_pk] => Array
(
[0] => 16659336
)
[wpp_gpid] => Array
(
[0] => 202209752
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1657676639
)
[year_built] => Array
(
[0] => 1952
)
[year_remodeled_] => Array
(
[0] => 2022
)
[zoning] => Array
(
[0] => 05 - R-5 Residential District
)
[new_attached_media] => Array
(
[0] => a:294:{i:0;i:22271252;i:1;i:22271253;i:2;i:22271254;i:3;i:22271255;i:4;i:22271256;i:5;i:22271257;i:6;i:22271258;i:7;i:22271259;i:8;i:22271260;i:9;i:22271261;i:10;i:22271262;i:11;i:22271263;i:12;i:22271264;i:13;i:22271265;i:14;i:22271266;i:15;i:22271267;i:16;i:22271268;i:17;i:22271269;i:18;i:22271270;i:19;i:22271271;i:20;i:22271272;i:21;i:22271294;i:22;i:22271295;i:23;i:22271296;i:24;i:22271297;i:25;i:22271298;i:26;i:22271299;i:27;i:22271300;i:28;i:22271301;i:29;i:22271302;i:30;i:22271303;i:31;i:22271304;i:32;i:22271305;i:33;i:22271306;i:34;i:22271307;i:35;i:22271308;i:36;i:22271309;i:37;i:22271310;i:38;i:22271311;i:39;i:22271312;i:40;i:22271313;i:41;i:22271314;i:42;i:22271378;i:43;i:22271379;i:44;i:22271380;i:45;i:22271381;i:46;i:22271382;i:47;i:22271383;i:48;i:22271384;i:49;i:22271385;i:50;i:22271386;i:51;i:22271387;i:52;i:22271388;i:53;i:22271389;i:54;i:22271390;i:55;i:22271391;i:56;i:22271392;i:57;i:22271393;i:58;i:22271394;i:59;i:22271395;i:60;i:22271396;i:61;i:22271397;i:62;i:22271398;i:63;i:22271399;i:64;i:22271400;i:65;i:22271401;i:66;i:22271402;i:67;i:22271403;i:68;i:22271404;i:69;i:22271405;i:70;i:22271406;i:71;i:22271407;i:72;i:22271408;i:73;i:22271409;i:74;i:22271410;i:75;i:22271411;i:76;i:22271412;i:77;i:22271413;i:78;i:22271414;i:79;i:22271415;i:80;i:22271416;i:81;i:22271417;i:82;i:22271418;i:83;i:22271419;i:84;i:22274227;i:85;i:22274228;i:86;i:22274229;i:87;i:22274230;i:88;i:22274231;i:89;i:22274232;i:90;i:22274233;i:91;i:22274234;i:92;i:22274235;i:93;i:22274236;i:94;i:22274237;i:95;i:22274238;i:96;i:22274239;i:97;i:22274240;i:98;i:22274241;i:99;i:22274242;i:100;i:22274243;i:101;i:22274244;i:102;i:22274245;i:103;i:22274246;i:104;i:22274247;i:105;i:22278363;i:106;i:22278364;i:107;i:22278365;i:108;i:22278366;i:109;i:22278367;i:110;i:22278368;i:111;i:22278369;i:112;i:22278370;i:113;i:22278371;i:114;i:22278372;i:115;i:22278373;i:116;i:22278374;i:117;i:22278375;i:118;i:22278376;i:119;i:22278377;i:120;i:22278378;i:121;i:22278379;i:122;i:22278380;i:123;i:22278381;i:124;i:22278382;i:125;i:22278383;i:126;i:22321607;i:127;i:22321608;i:128;i:22321609;i:129;i:22321610;i:130;i:22321611;i:131;i:22321612;i:132;i:22321613;i:133;i:22321614;i:134;i:22321615;i:135;i:22321616;i:136;i:22321617;i:137;i:22321618;i:138;i:22321619;i:139;i:22321620;i:140;i:22321621;i:141;i:22321622;i:142;i:22321623;i:143;i:22321624;i:144;i:22321625;i:145;i:22321626;i:146;i:22321627;i:147;i:22325659;i:148;i:22325660;i:149;i:22325661;i:150;i:22325662;i:151;i:22325663;i:152;i:22325664;i:153;i:22325665;i:154;i:22325666;i:155;i:22325667;i:156;i:22325668;i:157;i:22325669;i:158;i:22325670;i:159;i:22325671;i:160;i:22325672;i:161;i:22325673;i:162;i:22325674;i:163;i:22325675;i:164;i:22325676;i:165;i:22325677;i:166;i:22325678;i:167;i:22325679;i:168;i:22326057;i:169;i:22326058;i:170;i:22326059;i:171;i:22326060;i:172;i:22326061;i:173;i:22326062;i:174;i:22326063;i:175;i:22326064;i:176;i:22326065;i:177;i:22326066;i:178;i:22326067;i:179;i:22326068;i:180;i:22326069;i:181;i:22326070;i:182;i:22326071;i:183;i:22326072;i:184;i:22326073;i:185;i:22326074;i:186;i:22326075;i:187;i:22326076;i:188;i:22326077;i:189;i:22326078;i:190;i:22326079;i:191;i:22326080;i:192;i:22326081;i:193;i:22326082;i:194;i:22326083;i:195;i:22326084;i:196;i:22326085;i:197;i:22326086;i:198;i:22326087;i:199;i:22326088;i:200;i:22326089;i:201;i:22326090;i:202;i:22326091;i:203;i:22326092;i:204;i:22326093;i:205;i:22326094;i:206;i:22326095;i:207;i:22326096;i:208;i:22326097;i:209;i:22326098;i:210;i:22333964;i:211;i:22333965;i:212;i:22333966;i:213;i:22333967;i:214;i:22333968;i:215;i:22333969;i:216;i:22333970;i:217;i:22333971;i:218;i:22333972;i:219;i:22333973;i:220;i:22333974;i:221;i:22333975;i:222;i:22333976;i:223;i:22333977;i:224;i:22333978;i:225;i:22333979;i:226;i:22333980;i:227;i:22333981;i:228;i:22333982;i:229;i:22333983;i:230;i:22333984;i:231;i:22334027;i:232;i:22334028;i:233;i:22334029;i:234;i:22334030;i:235;i:22334031;i:236;i:22334032;i:237;i:22334033;i:238;i:22334034;i:239;i:22334035;i:240;i:22334036;i:241;i:22334037;i:242;i:22334038;i:243;i:22334039;i:244;i:22334040;i:245;i:22334041;i:246;i:22334042;i:247;i:22334043;i:248;i:22334044;i:249;i:22334045;i:250;i:22334046;i:251;i:22334047;i:252;i:22384605;i:253;i:22384606;i:254;i:22384607;i:255;i:22384608;i:256;i:22384609;i:257;i:22384610;i:258;i:22384611;i:259;i:22384612;i:260;i:22384613;i:261;i:22384614;i:262;i:22384615;i:263;i:22384616;i:264;i:22384617;i:265;i:22384618;i:266;i:22384619;i:267;i:22384620;i:268;i:22384621;i:269;i:22384622;i:270;i:22384623;i:271;i:22384624;i:272;i:22384625;i:273;i:22704013;i:274;i:22704014;i:275;i:22704015;i:276;i:22704016;i:277;i:22704017;i:278;i:22704018;i:279;i:22704019;i:280;i:22704020;i:281;i:22704021;i:282;i:22704022;i:283;i:22704023;i:284;i:22704024;i:285;i:22704025;i:286;i:22704026;i:287;i:22704027;i:288;i:22704028;i:289;i:22704029;i:290;i:22704030;i:291;i:22704031;i:292;i:22704032;i:293;i:22704033;}
)
[rets_open_house_count] => Array
(
[0] => 4
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_open_house_upcoming] => Array
(
[0] =>
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-06-03
)
[rets_close_date] => Array
(
[0] => 2022-07-08
)
[rets_close_price] => Array
(
[0] => 1275000.00
)
[rets_expiration_date] => Array
(
[0] => 2023-05-20
)
[rets_off_market_date] => Array
(
[0] => 2022-07-08
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 725-2794
)
[rets_selling_agent_email] => Array
(
[0] => elgineonaka@legacylivingnow.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Elgine Onaka
)
[rets_selling_agent_mlsid] => Array
(
[0] => 50824
)
[rets_selling_agent_mui] => Array
(
[0] => 15514810
)
[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] => 22704013
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446