This beautifully renovated one-story home is nestled away off the main roads to give you privacy & serenity. Spacious entry opens to a large living room with beautiful porcelain tile flooring. Gorgeous eat in kitchen featuring Quartz countertops, tile backsplash, stainless steel appliances and pendant lighting. Split A/C in every room to keep you cool during the warm summer months. Lots of windows (replaced 2016) offer cool breezes and gorgeous views into the fully enclosed yard with potential to extend. There is also a mango, papaya and lime tree producing fresh fruit. Enjoy gatherings under the large covered lanai perfect for entertaining guests. Conveniently located near world-famous Kailua beaches, parks, shops & restaurants plus easy access to the H3 and Pali Highway (without having to fight the traffic in Kailua town). Put this home on your must see list!
Listing by: Redfin Corporation
array(163) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "317800.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(10) "1027500.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(10) "1345300.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "4"
}
["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(40) "Pet on Property,Property Disclosure Stmt"
}
["easements"]=>
array(1) {
[0]=>
string(4) "None"
}
["elementary_school"]=>
array(1) {
[0]=>
string(9) "Maunawili"
}
["floor_covering"]=>
array(1) {
[0]=>
string(24) "Ceramic Tile,Other,Vinyl"
}
["frontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "2"
}
["furnished"]=>
array(1) {
[0]=>
string(4) "None"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["high_school"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["home_exampt"]=>
array(1) {
[0]=>
string(6) "100000"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(3) "345"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(7) "7500.00"
}
["land_recorded"]=>
array(1) {
[0]=>
string(14) "Regular System"
}
["land_tenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["list_agent_email"]=>
array(1) {
[0]=>
string(23) "mike.demello@redfin.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(17) "Michael D DeMello"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 518-3429"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-06-22"
}
["list_office_name"]=>
array(1) {
[0]=>
string(18) "Redfin Corporation"
}
["list_price"]=>
array(1) {
[0]=>
string(10) "1450000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "1814"
}
["location"]=>
array(1) {
[0]=>
string(34) "558 Ulumu Street, Kailua, HI 96734"
}
["middle_school"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202211709"
}
["neighborhood"]=>
array(1) {
[0]=>
string(8) "POHAKUPU"
}
["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) "RFIN"
}
["parking_features"]=>
array(1) {
[0]=>
string(29) "2 Car,Carport,Driveway,Street"
}
["pool_"]=>
array(1) {
[0]=>
string(4) "None"
}
["possession"]=>
array(1) {
[0]=>
string(37) "45 Days or Less,At Closing,Negotiable"
}
["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) "4"
}
["rets_city"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["rets_compensation_method"]=>
array(1) {
[0]=>
string(1) "%"
}
["rets_condo_property_regime_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(10) "1510000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(1) "5"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_elementary_school"]=>
array(1) {
[0]=>
string(9) "Maunawili"
}
["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) "16711768"
}
["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) 518-3429"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(23) "mike.demello@redfin.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(17) "Michael D DeMello"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "25490"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "3475407"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "RFIN"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(7) "9626004"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(18) "Redfin Corporation"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 518-3429"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(10) "1450000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-06-22"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(7) "7500.00"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-07-27T09:20:43.760"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16711768"
}
["rets_middle_or_junior_school"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202211709"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(8) "POHAKUPU"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-22T10:07:11.903"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(10) "1450000.00"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-4-2-031-101-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-06-23T09:20:52.330"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96734"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-22T10:07:11.903"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16711768"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(353) "Owner-occupied but easy to show with 24-hour notice. For all showing requests/instructions please call Showing Time @ 800-746-9464 anytime 24/7. You may also use the Showing Time MLS or Mobile App. For any questions please email Mike.DeMello@redfin.com and copy coordinator William.Gilbert@redfin.com for fastest response. STR Disclosure in supplements."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(873) "This beautifully renovated one-story home is nestled away off the main roads to give you privacy & serenity. Spacious entry opens to a large living room with beautiful porcelain tile flooring. Gorgeous eat in kitchen featuring Quartz countertops, tile backsplash, stainless steel appliances and pendant lighting. Split A/C in every room to keep you cool during the warm summer months. Lots of windows (replaced 2016) offer cool breezes and gorgeous views into the fully enclosed yard with potential to extend. There is also a mango, papaya and lime tree producing fresh fruit. Enjoy gatherings under the large covered lanai perfect for entertaining guests. Conveniently located near world-famous Kailua beaches, parks, shops & restaurants plus easy access to the H3 and Pali Highway (without having to fight the traffic in Kailua town). Put this home on your must see list!"
}
["rets_sqft_garage_carport"]=>
array(1) {
[0]=>
string(3) "378"
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(3) "345"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "1469"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "1814"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-07-27T09:20:43.760"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-07-27"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(5) "Ulumu"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(3) "558"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(62) "1$21.380659$-157.75225$53.16$13.33$1.00$IpIKib-AlTh6uw60-PQLdA"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(3) "2.5"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "363.21"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "4358.52"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(10) "1345300.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "317800.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(10) "1027500.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(6) "100000"
}
["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/16711768/9ac8f13dcad5e1fb819d354cd6fe7206"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "142"
}
["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(3) "101"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(2) "31"
}
["rets_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(51) "https://my.matterport.com/show/?m=7TLAN8SLbnT&mls=1"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1959"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(4) "2004"
}
["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) "Ulumu"
}
["street_number"]=>
array(1) {
[0]=>
string(3) "558"
}
["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-031-101-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=7TLAN8SLbnT&mls=1"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16711768"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202211709"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1658949709"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1959"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "2004"
}
["zoning"]=>
array(1) {
[0]=>
string(31) "04 - R-7.5 Residential District"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(4182) "a:252:{i:0;i:22509201;i:1;i:22509202;i:2;i:22509203;i:3;i:22509204;i:4;i:22509205;i:5;i:22509206;i:6;i:22509207;i:7;i:22509208;i:8;i:22509209;i:9;i:22509210;i:10;i:22509211;i:11;i:22509212;i:12;i:22509213;i:13;i:22509214;i:14;i:22509215;i:15;i:22509216;i:16;i:22509217;i:17;i:22509218;i:18;i:22509219;i:19;i:22509220;i:20;i:22509221;i:21;i:22509222;i:22;i:22509223;i:23;i:22509224;i:24;i:22509225;i:25;i:22509226;i:26;i:22509227;i:27;i:22509228;i:28;i:22509229;i:29;i:22509230;i:30;i:22509231;i:31;i:22509232;i:32;i:22509233;i:33;i:22509234;i:34;i:22509235;i:35;i:22509236;i:36;i:22509237;i:37;i:22509238;i:38;i:22509239;i:39;i:22509240;i:40;i:22509241;i:41;i:22509242;i:42;i:22509250;i:43;i:22509251;i:44;i:22509252;i:45;i:22509253;i:46;i:22509254;i:47;i:22509255;i:48;i:22509256;i:49;i:22509257;i:50;i:22509258;i:51;i:22509259;i:52;i:22509260;i:53;i:22509261;i:54;i:22509262;i:55;i:22509263;i:56;i:22509264;i:57;i:22509265;i:58;i:22509266;i:59;i:22509267;i:60;i:22509268;i:61;i:22509269;i:62;i:22509270;i:63;i:22509426;i:64;i:22509427;i:65;i:22509428;i:66;i:22509429;i:67;i:22509430;i:68;i:22509431;i:69;i:22509432;i:70;i:22509433;i:71;i:22509434;i:72;i:22509435;i:73;i:22509436;i:74;i:22509437;i:75;i:22509438;i:76;i:22509439;i:77;i:22509440;i:78;i:22509441;i:79;i:22509442;i:80;i:22509443;i:81;i:22509444;i:82;i:22509445;i:83;i:22509446;i:84;i:22509720;i:85;i:22509721;i:86;i:22509722;i:87;i:22509723;i:88;i:22509724;i:89;i:22509725;i:90;i:22509726;i:91;i:22509727;i:92;i:22509728;i:93;i:22509729;i:94;i:22509730;i:95;i:22509731;i:96;i:22509732;i:97;i:22509733;i:98;i:22509734;i:99;i:22509735;i:100;i:22509736;i:101;i:22509737;i:102;i:22509738;i:103;i:22509739;i:104;i:22509740;i:105;i:22510758;i:106;i:22510759;i:107;i:22510760;i:108;i:22510761;i:109;i:22510762;i:110;i:22510763;i:111;i:22510764;i:112;i:22510765;i:113;i:22510766;i:114;i:22510767;i:115;i:22510768;i:116;i:22510769;i:117;i:22510770;i:118;i:22510771;i:119;i:22510772;i:120;i:22510773;i:121;i:22510774;i:122;i:22510775;i:123;i:22510776;i:124;i:22510777;i:125;i:22510778;i:126;i:22520383;i:127;i:22520384;i:128;i:22520385;i:129;i:22520386;i:130;i:22520387;i:131;i:22520388;i:132;i:22520389;i:133;i:22520390;i:134;i:22520391;i:135;i:22520392;i:136;i:22520393;i:137;i:22520394;i:138;i:22520395;i:139;i:22520396;i:140;i:22520397;i:141;i:22520398;i:142;i:22520399;i:143;i:22520400;i:144;i:22520401;i:145;i:22520402;i:146;i:22520403;i:147;i:22540531;i:148;i:22540532;i:149;i:22540533;i:150;i:22540534;i:151;i:22540535;i:152;i:22540536;i:153;i:22540537;i:154;i:22540538;i:155;i:22540539;i:156;i:22540540;i:157;i:22540541;i:158;i:22540542;i:159;i:22540543;i:160;i:22540544;i:161;i:22540545;i:162;i:22540546;i:163;i:22540547;i:164;i:22540548;i:165;i:22540549;i:166;i:22540550;i:167;i:22540551;i:168;i:22553257;i:169;i:22553258;i:170;i:22553259;i:171;i:22553260;i:172;i:22553261;i:173;i:22553262;i:174;i:22553263;i:175;i:22553264;i:176;i:22553265;i:177;i:22553266;i:178;i:22553267;i:179;i:22553268;i:180;i:22553269;i:181;i:22553270;i:182;i:22553271;i:183;i:22553272;i:184;i:22553273;i:185;i:22553274;i:186;i:22553275;i:187;i:22553276;i:188;i:22553277;i:189;i:22559663;i:190;i:22559664;i:191;i:22559665;i:192;i:22559666;i:193;i:22559667;i:194;i:22559668;i:195;i:22559669;i:196;i:22559670;i:197;i:22559671;i:198;i:22559672;i:199;i:22559673;i:200;i:22559674;i:201;i:22559675;i:202;i:22559676;i:203;i:22559677;i:204;i:22559678;i:205;i:22559679;i:206;i:22559680;i:207;i:22559681;i:208;i:22559682;i:209;i:22559683;i:210;i:22689858;i:211;i:22689859;i:212;i:22689860;i:213;i:22689861;i:214;i:22689862;i:215;i:22689863;i:216;i:22689864;i:217;i:22689865;i:218;i:22689866;i:219;i:22689867;i:220;i:22689868;i:221;i:22689869;i:222;i:22689870;i:223;i:22689871;i:224;i:22689872;i:225;i:22689873;i:226;i:22689874;i:227;i:22689875;i:228;i:22689876;i:229;i:22689877;i:230;i:22689878;i:231;i:22861355;i:232;i:22861356;i:233;i:22861357;i:234;i:22861358;i:235;i:22861359;i:236;i:22861360;i:237;i:22861361;i:238;i:22861362;i:239;i:22861363;i:240;i:22861364;i:241;i:22861365;i:242;i:22861366;i:243;i:22861367;i:244;i:22861368;i:245;i:22861369;i:246;i:22861370;i:247;i:22861371;i:248;i:22861372;i:249;i:22861373;i:250;i:22861374;i:251;i:22861375;}"
}
["rets_supplement_count"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_supplement_modification_timestam"]=>
array(1) {
[0]=>
string(23) "2022-06-22T10:10:06.400"
}
["rets_open_house_count"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_active_open_house_count"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_open_house_upcoming"]=>
array(1) {
[0]=>
string(0) ""
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-06-27"
}
["rets_pending_date"]=>
array(1) {
[0]=>
string(10) "2022-06-27"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-07-27"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(10) "1510000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-10-25"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-07-27"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 561-6143"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(18) "krealty2@gmail.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(18) "Kathleen K Morgado"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "24636"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "3474946"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "KKMK"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(7) "3487698"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(13) "K Realty, LLC"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 561-6143"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "22861355"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 317800.00
)
[assd_val_land] => Array
(
[0] => 1027500.00
)
[assd_val_total] => Array
(
[0] => 1345300.00
)
[bedrooms] => Array
(
[0] => 4
)
[building_style] => Array
(
[0] => Detach Single Family
)
[city] => Array
(
[0] => Kailua
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Pet on Property,Property Disclosure Stmt
)
[easements] => Array
(
[0] => None
)
[elementary_school] => Array
(
[0] => Maunawili
)
[floor_covering] => Array
(
[0] => Ceramic Tile,Other,Vinyl
)
[frontage] => Array
(
[0] => Other
)
[full_baths] => Array
(
[0] => 2
)
[furnished] => Array
(
[0] => None
)
[half_baths] => Array
(
[0] => 0
)
[high_school] => Array
(
[0] => Kailua
)
[home_exampt] => Array
(
[0] => 100000
)
[lanai_sf] => Array
(
[0] => 345
)
[land_area_sf] => Array
(
[0] => 7500.00
)
[land_recorded] => Array
(
[0] => Regular System
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => mike.demello@redfin.com
)
[list_agent_name] => Array
(
[0] => Michael D DeMello
)
[list_agent_phone_number] => Array
(
[0] => (808) 518-3429
)
[list_date] => Array
(
[0] => 2022-06-22
)
[list_office_name] => Array
(
[0] => Redfin Corporation
)
[list_price] => Array
(
[0] => 1450000.00
)
[living_sf] => Array
(
[0] => 1814
)
[location] => Array
(
[0] => 558 Ulumu Street, Kailua, HI 96734
)
[middle_school] => Array
(
[0] => Kailua
)
[mls_] => Array
(
[0] => 202211709
)
[neighborhood] => Array
(
[0] => POHAKUPU
)
[number_of_parking_spaces] => Array
(
[0] => 4
)
[number_of_stories] => Array
(
[0] => One
)
[office_mls_id] => Array
(
[0] => RFIN
)
[parking_features] => Array
(
[0] => 2 Car,Carport,Driveway,Street
)
[pool_] => Array
(
[0] => None
)
[possession] => Array
(
[0] => 45 Days or Less,At Closing,Negotiable
)
[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] => 4
)
[rets_city] => Array
(
[0] => Kailua
)
[rets_compensation_method] => Array
(
[0] => %
)
[rets_condo_property_regime_yn] => Array
(
[0] => 0
)
[rets_current_price] => Array
(
[0] => 1510000.00
)
[rets_dom] => Array
(
[0] => 5
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 1
)
[rets_elementary_school] => Array
(
[0] => Maunawili
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_high_school] => Array
(
[0] => Kailua
)
[rets_id] => Array
(
[0] => 16711768
)
[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) 518-3429
)
[rets_list_agent_email] => Array
(
[0] => mike.demello@redfin.com
)
[rets_list_agent_full_name] => Array
(
[0] => Michael D DeMello
)
[rets_list_agent_mlsid] => Array
(
[0] => 25490
)
[rets_list_agent_mui] => Array
(
[0] => 3475407
)
[rets_list_office_mlsid] => Array
(
[0] => RFIN
)
[rets_list_office_mui] => Array
(
[0] => 9626004
)
[rets_list_office_name] => Array
(
[0] => Redfin Corporation
)
[rets_list_office_phone] => Array
(
[0] => (808) 518-3429
)
[rets_list_price] => Array
(
[0] => 1450000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-06-22
)
[rets_lot_size_area] => Array
(
[0] => 7500.00
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-07-27T09:20:43.760
)
[rets_matrix_unique_id] => Array
(
[0] => 16711768
)
[rets_middle_or_junior_school] => Array
(
[0] => Kailua
)
[rets_mls_number] => Array
(
[0] => 202211709
)
[rets_neighbourhood] => Array
(
[0] => POHAKUPU
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-06-22T10:07:11.903
)
[rets_original_list_price] => Array
(
[0] => 1450000.00
)
[rets_parcel_number] => Array
(
[0] => 1-4-2-031-101-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-06-23T09:20:52.330
)
[rets_postal_code] => Array
(
[0] => 96734
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-06-22T10:07:11.903
)
[rets_primary_key] => Array
(
[0] => 16711768
)
[rets_private_remarks] => Array
(
[0] => Owner-occupied but easy to show with 24-hour notice. For all showing requests/instructions please call Showing Time @ 800-746-9464 anytime 24/7. You may also use the Showing Time MLS or Mobile App. For any questions please email Mike.DeMello@redfin.com and copy coordinator William.Gilbert@redfin.com for fastest response. STR Disclosure in supplements.
)
[rets_public_remarks] => Array
(
[0] => This beautifully renovated one-story home is nestled away off the main roads to give you privacy & serenity. Spacious entry opens to a large living room with beautiful porcelain tile flooring. Gorgeous eat in kitchen featuring Quartz countertops, tile backsplash, stainless steel appliances and pendant lighting. Split A/C in every room to keep you cool during the warm summer months. Lots of windows (replaced 2016) offer cool breezes and gorgeous views into the fully enclosed yard with potential to extend. There is also a mango, papaya and lime tree producing fresh fruit. Enjoy gatherings under the large covered lanai perfect for entertaining guests. Conveniently located near world-famous Kailua beaches, parks, shops & restaurants plus easy access to the H3 and Pali Highway (without having to fight the traffic in Kailua town). Put this home on your must see list!
)
[rets_sqft_garage_carport] => Array
(
[0] => 378
)
[rets_sqft_lanai_open] => Array
(
[0] => 345
)
[rets_sqft_roofed_living] => Array
(
[0] => 1469
)
[rets_sqft_total] => Array
(
[0] => 1814
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-07-27T09:20:43.760
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-07-27
)
[rets_street_name] => Array
(
[0] => Ulumu
)
[rets_street_number] => Array
(
[0] => 558
)
[rets_street_view_param] => Array
(
[0] => 1$21.380659$-157.75225$53.16$13.33$1.00$IpIKib-AlTh6uw60-PQLdA
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5
)
[rets_tax_amount] => Array
(
[0] => 363.21
)
[rets_tax_annual_amount] => Array
(
[0] => 4358.52
)
[rets_tax_assessed_value] => Array
(
[0] => 1345300.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 317800.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 1027500.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 100000
)
[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/16711768/9ac8f13dcad5e1fb819d354cd6fe7206
)
[rets_tmk_area] => Array
(
[0] => 142
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 0
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 101
)
[rets_tmk_section] => Array
(
[0] => 2
)
[rets_tmk_zone] => Array
(
[0] => 4
)
[rets_tmkplat] => Array
(
[0] => 31
)
[rets_virtual_tour_url_unbranded] => Array
(
[0] => https://my.matterport.com/show/?m=7TLAN8SLbnT&mls=1
)
[rets_year_built] => Array
(
[0] => 1959
)
[rets_year_remodeled] => Array
(
[0] => 2004
)
[security] => Array
(
[0] => Key
)
[setbacks] => Array
(
[0] => C&C
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Ulumu
)
[street_number] => Array
(
[0] => 558
)
[street_suffix] => Array
(
[0] => Street
)
[terms_accept] => Array
(
[0] => Cash,Conventional,FHA,VA
)
[tmk] => Array
(
[0] => 1-4-2-031-101-0000
)
[topography] => Array
(
[0] => Clear
)
[view] => Array
(
[0] => Garden
)
[virtual_tour] => Array
(
[0] => https://my.matterport.com/show/?m=7TLAN8SLbnT&mls=1
)
[wpp::rets_pk] => Array
(
[0] => 16711768
)
[wpp_gpid] => Array
(
[0] => 202211709
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1658949709
)
[year_built] => Array
(
[0] => 1959
)
[year_remodeled_] => Array
(
[0] => 2004
)
[zoning] => Array
(
[0] => 04 - R-7.5 Residential District
)
[new_attached_media] => Array
(
[0] => a:252:{i:0;i:22509201;i:1;i:22509202;i:2;i:22509203;i:3;i:22509204;i:4;i:22509205;i:5;i:22509206;i:6;i:22509207;i:7;i:22509208;i:8;i:22509209;i:9;i:22509210;i:10;i:22509211;i:11;i:22509212;i:12;i:22509213;i:13;i:22509214;i:14;i:22509215;i:15;i:22509216;i:16;i:22509217;i:17;i:22509218;i:18;i:22509219;i:19;i:22509220;i:20;i:22509221;i:21;i:22509222;i:22;i:22509223;i:23;i:22509224;i:24;i:22509225;i:25;i:22509226;i:26;i:22509227;i:27;i:22509228;i:28;i:22509229;i:29;i:22509230;i:30;i:22509231;i:31;i:22509232;i:32;i:22509233;i:33;i:22509234;i:34;i:22509235;i:35;i:22509236;i:36;i:22509237;i:37;i:22509238;i:38;i:22509239;i:39;i:22509240;i:40;i:22509241;i:41;i:22509242;i:42;i:22509250;i:43;i:22509251;i:44;i:22509252;i:45;i:22509253;i:46;i:22509254;i:47;i:22509255;i:48;i:22509256;i:49;i:22509257;i:50;i:22509258;i:51;i:22509259;i:52;i:22509260;i:53;i:22509261;i:54;i:22509262;i:55;i:22509263;i:56;i:22509264;i:57;i:22509265;i:58;i:22509266;i:59;i:22509267;i:60;i:22509268;i:61;i:22509269;i:62;i:22509270;i:63;i:22509426;i:64;i:22509427;i:65;i:22509428;i:66;i:22509429;i:67;i:22509430;i:68;i:22509431;i:69;i:22509432;i:70;i:22509433;i:71;i:22509434;i:72;i:22509435;i:73;i:22509436;i:74;i:22509437;i:75;i:22509438;i:76;i:22509439;i:77;i:22509440;i:78;i:22509441;i:79;i:22509442;i:80;i:22509443;i:81;i:22509444;i:82;i:22509445;i:83;i:22509446;i:84;i:22509720;i:85;i:22509721;i:86;i:22509722;i:87;i:22509723;i:88;i:22509724;i:89;i:22509725;i:90;i:22509726;i:91;i:22509727;i:92;i:22509728;i:93;i:22509729;i:94;i:22509730;i:95;i:22509731;i:96;i:22509732;i:97;i:22509733;i:98;i:22509734;i:99;i:22509735;i:100;i:22509736;i:101;i:22509737;i:102;i:22509738;i:103;i:22509739;i:104;i:22509740;i:105;i:22510758;i:106;i:22510759;i:107;i:22510760;i:108;i:22510761;i:109;i:22510762;i:110;i:22510763;i:111;i:22510764;i:112;i:22510765;i:113;i:22510766;i:114;i:22510767;i:115;i:22510768;i:116;i:22510769;i:117;i:22510770;i:118;i:22510771;i:119;i:22510772;i:120;i:22510773;i:121;i:22510774;i:122;i:22510775;i:123;i:22510776;i:124;i:22510777;i:125;i:22510778;i:126;i:22520383;i:127;i:22520384;i:128;i:22520385;i:129;i:22520386;i:130;i:22520387;i:131;i:22520388;i:132;i:22520389;i:133;i:22520390;i:134;i:22520391;i:135;i:22520392;i:136;i:22520393;i:137;i:22520394;i:138;i:22520395;i:139;i:22520396;i:140;i:22520397;i:141;i:22520398;i:142;i:22520399;i:143;i:22520400;i:144;i:22520401;i:145;i:22520402;i:146;i:22520403;i:147;i:22540531;i:148;i:22540532;i:149;i:22540533;i:150;i:22540534;i:151;i:22540535;i:152;i:22540536;i:153;i:22540537;i:154;i:22540538;i:155;i:22540539;i:156;i:22540540;i:157;i:22540541;i:158;i:22540542;i:159;i:22540543;i:160;i:22540544;i:161;i:22540545;i:162;i:22540546;i:163;i:22540547;i:164;i:22540548;i:165;i:22540549;i:166;i:22540550;i:167;i:22540551;i:168;i:22553257;i:169;i:22553258;i:170;i:22553259;i:171;i:22553260;i:172;i:22553261;i:173;i:22553262;i:174;i:22553263;i:175;i:22553264;i:176;i:22553265;i:177;i:22553266;i:178;i:22553267;i:179;i:22553268;i:180;i:22553269;i:181;i:22553270;i:182;i:22553271;i:183;i:22553272;i:184;i:22553273;i:185;i:22553274;i:186;i:22553275;i:187;i:22553276;i:188;i:22553277;i:189;i:22559663;i:190;i:22559664;i:191;i:22559665;i:192;i:22559666;i:193;i:22559667;i:194;i:22559668;i:195;i:22559669;i:196;i:22559670;i:197;i:22559671;i:198;i:22559672;i:199;i:22559673;i:200;i:22559674;i:201;i:22559675;i:202;i:22559676;i:203;i:22559677;i:204;i:22559678;i:205;i:22559679;i:206;i:22559680;i:207;i:22559681;i:208;i:22559682;i:209;i:22559683;i:210;i:22689858;i:211;i:22689859;i:212;i:22689860;i:213;i:22689861;i:214;i:22689862;i:215;i:22689863;i:216;i:22689864;i:217;i:22689865;i:218;i:22689866;i:219;i:22689867;i:220;i:22689868;i:221;i:22689869;i:222;i:22689870;i:223;i:22689871;i:224;i:22689872;i:225;i:22689873;i:226;i:22689874;i:227;i:22689875;i:228;i:22689876;i:229;i:22689877;i:230;i:22689878;i:231;i:22861355;i:232;i:22861356;i:233;i:22861357;i:234;i:22861358;i:235;i:22861359;i:236;i:22861360;i:237;i:22861361;i:238;i:22861362;i:239;i:22861363;i:240;i:22861364;i:241;i:22861365;i:242;i:22861366;i:243;i:22861367;i:244;i:22861368;i:245;i:22861369;i:246;i:22861370;i:247;i:22861371;i:248;i:22861372;i:249;i:22861373;i:250;i:22861374;i:251;i:22861375;}
)
[rets_supplement_count] => Array
(
[0] => 1
)
[rets_supplement_modification_timestam] => Array
(
[0] => 2022-06-22T10:10:06.400
)
[rets_open_house_count] => Array
(
[0] => 2
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_open_house_upcoming] => Array
(
[0] =>
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-06-27
)
[rets_pending_date] => Array
(
[0] => 2022-06-27
)
[rets_close_date] => Array
(
[0] => 2022-07-27
)
[rets_close_price] => Array
(
[0] => 1510000.00
)
[rets_expiration_date] => Array
(
[0] => 2022-10-25
)
[rets_off_market_date] => Array
(
[0] => 2022-07-27
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 561-6143
)
[rets_selling_agent_email] => Array
(
[0] => krealty2@gmail.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Kathleen K Morgado
)
[rets_selling_agent_mlsid] => Array
(
[0] => 24636
)
[rets_selling_agent_mui] => Array
(
[0] => 3474946
)
[rets_selling_office_mlsid] => Array
(
[0] => KKMK
)
[rets_selling_office_mui] => Array
(
[0] => 3487698
)
[rets_selling_office_name] => Array
(
[0] => K Realty, LLC
)
[rets_selling_office_phone] => Array
(
[0] => (808) 561-6143
)
[_thumbnail_id] => Array
(
[0] => 22861355
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446