This amazing Six bedroom 4 1/2 bath enjoys stunning panoramic views of Kailua Bay, mountains and Kailua Town. Wrap around deck constructed of balau, epai and stainless steel provides 300 sf of outside enjoyment. Vaulted ceilings, open floor plan, new white oak flooring, Baldwin hardware, 7 ceiling fans are included. Anderson, Pella and 6” Breeze way windows provide optimum ventilation. A separate studio has a private entrance. Owned solar panels (39), 4 batteries and solar water heater keep electric bills in check. Attached 2 car garage has generous workshop area. The third floor has 3 split system LG air conditioners. Tax Records don’t match, so Buyer/Buyer’s agent do your due diligence. Open House Thursday 03/24 11:00am – 1:30 pm, Sunday 03/27 2-5pm.
Listing by: Soldier To Soldier HI Realty
array(161) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "640100.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "747400.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(10) "1387500.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "6"
}
["building_style"]=>
array(1) {
[0]=>
string(35) "Detach Single Family,Studio Cottage"
}
["city"]=>
array(1) {
[0]=>
string(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"
}
["elementary_school"]=>
array(1) {
[0]=>
string(5) "Keolu"
}
["floor_covering"]=>
array(1) {
[0]=>
string(38) "Ceramic Tile,Hardwood,Vinyl,W/W Carpet"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "4"
}
["furnished"]=>
array(1) {
[0]=>
string(4) "None"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "1"
}
["high_school"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["home_exampt"]=>
array(1) {
[0]=>
string(3) "yes"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(3) "649"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(7) "6555.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(21) "wendy@lauleahomes.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(10) "Yanbo Liao"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 312-7884"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-03-22"
}
["list_office_name"]=>
array(1) {
[0]=>
string(28) "Soldier To Soldier HI Realty"
}
["list_price"]=>
array(1) {
[0]=>
string(10) "1950000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "4109"
}
["location"]=>
array(1) {
[0]=>
string(36) "1249 Aulepe Street, Kailua, HI 96734"
}
["middle_school"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202205411"
}
["neighborhood"]=>
array(1) {
[0]=>
string(9) "HILLCREST"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "4"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(6) "Three+"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "STSH"
}
["parking_features"]=>
array(1) {
[0]=>
string(29) "3 Car+,Driveway,Garage,Street"
}
["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(23) "Above Average,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) "4"
}
["rets_baths_half"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_baths_total"]=>
array(1) {
[0]=>
string(4) "4.01"
}
["rets_beds_total"]=>
array(1) {
[0]=>
string(1) "6"
}
["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) "1999999.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(2) "10"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_elementary_school"]=>
array(1) {
[0]=>
string(5) "Keolu"
}
["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) "16522662"
}
["rets_immoviewer_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["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) 312-7884"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(21) "wendy@lauleahomes.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(10) "Yanbo Liao"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "48969"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(8) "13070027"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "STSH"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(8) "10749024"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(28) "Soldier To Soldier HI Realty"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 312-7884"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(10) "1950000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-03-22"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(7) "6555.00"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-05-20T13:20:26.173"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16522662"
}
["rets_middle_or_junior_school"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202205411"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(9) "HILLCREST"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-03-21T20:08:50.820"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(10) "1950000.00"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-4-2-027-108-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-03-22T23:23:24.573"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96734"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-03-22T23:26:38.837"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16522662"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(443) "Open House Thursday 03/24 11:00am - 1:30 pm, Sunday 03/27 2-5pm. Private showings please go through SHOWINGTIME to request for tracking purpose. Seller request Jaysie Perkins at TG Hawaii for escrow. Please include AS IS, verification of funding and Pre-qualification letter with your offer. Seller requests to review all offers Tuesday 03/29 at noon, make sure offers in by that time and date. Sellers will respond no later than same day 5pm."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(771) "This amazing Six bedroom 4 1/2 bath enjoys stunning panoramic views of Kailua Bay, mountains and Kailua Town. Wrap around deck constructed of balau, epai and stainless steel provides 300 sf of outside enjoyment. Vaulted ceilings, open floor plan, new white oak flooring, Baldwin hardware, 7 ceiling fans are included. Anderson, Pella and 6” Breeze way windows provide optimum ventilation. A separate studio has a private entrance. Owned solar panels (39), 4 batteries and solar water heater keep electric bills in check. Attached 2 car garage has generous workshop area. The third floor has 3 split system LG air conditioners. Tax Records don’t match, so Buyer/Buyer’s agent do your due diligence. Open House Thursday 03/24 11:00am - 1:30 pm, Sunday 03/27 2-5pm."
}
["rets_sqft_garage_carport"]=>
array(1) {
[0]=>
string(3) "598"
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(3) "649"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "3460"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "4109"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-05-20T13:20:26.173"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-05-20"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(6) "Aulepe"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(4) "1249"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(63) "1$21.373128$-157.727721$98.06$13.33$1.00$K3mMDcG6gtbxP-cYlxLLDw"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "364.00"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "4368.00"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(10) "1387500.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "640100.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "747400.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(3) "yes"
}
["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/16522662/3ef7b856a34cf669b3c26ccaf22d1d1b"
}
["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) "108"
}
["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) "27"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1993"
}
["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(6) "Aulepe"
}
["street_number"]=>
array(1) {
[0]=>
string(4) "1249"
}
["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-2-027-108-0000"
}
["topography"]=>
array(1) {
[0]=>
string(5) "Clear"
}
["view"]=>
array(1) {
[0]=>
string(34) "City,Mountain,Ocean,Sunrise,Sunset"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16522662"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202205411"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1653088917"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1993"
}
["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(3111) "a:189:{i:0;i:21873822;i:1;i:21873823;i:2;i:21873824;i:3;i:21873825;i:4;i:21873826;i:5;i:21873827;i:6;i:21873828;i:7;i:21873829;i:8;i:21873830;i:9;i:21873831;i:10;i:21873832;i:11;i:21873833;i:12;i:21873834;i:13;i:21873835;i:14;i:21873836;i:15;i:21873837;i:16;i:21873838;i:17;i:21873839;i:18;i:21873840;i:19;i:21873841;i:20;i:21873842;i:21;i:21875385;i:22;i:21875386;i:23;i:21875387;i:24;i:21875388;i:25;i:21875389;i:26;i:21875390;i:27;i:21875391;i:28;i:21875392;i:29;i:21875393;i:30;i:21875394;i:31;i:21875395;i:32;i:21875396;i:33;i:21875397;i:34;i:21875398;i:35;i:21875399;i:36;i:21875400;i:37;i:21875401;i:38;i:21875402;i:39;i:21875403;i:40;i:21875404;i:41;i:21875405;i:42;i:21875651;i:43;i:21875652;i:44;i:21875653;i:45;i:21875654;i:46;i:21875655;i:47;i:21875656;i:48;i:21875657;i:49;i:21875658;i:50;i:21875659;i:51;i:21875660;i:52;i:21875661;i:53;i:21875662;i:54;i:21875663;i:55;i:21875664;i:56;i:21875665;i:57;i:21875666;i:58;i:21875667;i:59;i:21875668;i:60;i:21875669;i:61;i:21875670;i:62;i:21875671;i:63;i:21877204;i:64;i:21877205;i:65;i:21877206;i:66;i:21877207;i:67;i:21877208;i:68;i:21877209;i:69;i:21877210;i:70;i:21877211;i:71;i:21877212;i:72;i:21877213;i:73;i:21877214;i:74;i:21877215;i:75;i:21877216;i:76;i:21877217;i:77;i:21877218;i:78;i:21877219;i:79;i:21877220;i:80;i:21877221;i:81;i:21877222;i:82;i:21877223;i:83;i:21877224;i:84;i:21891137;i:85;i:21891138;i:86;i:21891139;i:87;i:21891140;i:88;i:21891141;i:89;i:21891142;i:90;i:21891143;i:91;i:21891144;i:92;i:21891145;i:93;i:21891146;i:94;i:21891147;i:95;i:21891148;i:96;i:21891149;i:97;i:21891150;i:98;i:21891151;i:99;i:21891152;i:100;i:21891153;i:101;i:21891154;i:102;i:21891155;i:103;i:21891156;i:104;i:21891157;i:105;i:21891306;i:106;i:21891307;i:107;i:21891308;i:108;i:21891309;i:109;i:21891310;i:110;i:21891311;i:111;i:21891312;i:112;i:21891313;i:113;i:21891314;i:114;i:21891315;i:115;i:21891316;i:116;i:21891317;i:117;i:21891318;i:118;i:21891319;i:119;i:21891320;i:120;i:21891321;i:121;i:21891322;i:122;i:21891323;i:123;i:21891324;i:124;i:21891325;i:125;i:21891326;i:126;i:21937481;i:127;i:21937482;i:128;i:21937483;i:129;i:21937484;i:130;i:21937485;i:131;i:21937486;i:132;i:21937487;i:133;i:21937488;i:134;i:21937489;i:135;i:21937490;i:136;i:21937491;i:137;i:21937492;i:138;i:21937493;i:139;i:21937494;i:140;i:21937495;i:141;i:21937496;i:142;i:21937497;i:143;i:21937498;i:144;i:21937499;i:145;i:21937500;i:146;i:21937501;i:147;i:21960479;i:148;i:21960480;i:149;i:21960481;i:150;i:21960482;i:151;i:21960483;i:152;i:21960484;i:153;i:21960485;i:154;i:21960486;i:155;i:21960487;i:156;i:21960488;i:157;i:21960489;i:158;i:21960490;i:159;i:21960491;i:160;i:21960492;i:161;i:21960493;i:162;i:21960494;i:163;i:21960495;i:164;i:21960496;i:165;i:21960497;i:166;i:21960498;i:167;i:21960499;i:168;i:22266781;i:169;i:22266782;i:170;i:22266783;i:171;i:22266784;i:172;i:22266785;i:173;i:22266786;i:174;i:22266787;i:175;i:22266788;i:176;i:22266789;i:177;i:22266790;i:178;i:22266791;i:179;i:22266792;i:180;i:22266793;i:181;i:22266794;i:182;i:22266795;i:183;i:22266796;i:184;i:22266797;i:185;i:22266798;i:186;i:22266799;i:187;i:22266800;i:188;i:22266801;}"
}
["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_supplement_count"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_supplement_modification_timestam"]=>
array(1) {
[0]=>
string(23) "2022-03-23T12:21:14.913"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-03-30"
}
["rets_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(69) "https://app.immoviewer.com/landing/unbranded/62432e5771803d51554e6d14"
}
["virtual_tour"]=>
array(1) {
[0]=>
string(69) "https://app.immoviewer.com/landing/unbranded/62432e5771803d51554e6d14"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-05-20"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(10) "1999999.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-09-22"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-05-20"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 393-9966"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(29) "cheyanne@alohahomesagents.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(16) "Cheyanne D LoBue"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "49440"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(8) "14227240"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "RMXA"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(8) "12873659"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(18) "RE/MAX ALOHA HOMES"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 393-9966"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "22266781"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 640100.00
)
[assd_val_land] => Array
(
[0] => 747400.00
)
[assd_val_total] => Array
(
[0] => 1387500.00
)
[bedrooms] => Array
(
[0] => 6
)
[building_style] => Array
(
[0] => Detach Single Family,Studio Cottage
)
[city] => Array
(
[0] => Kailua
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Property Disclosure Stmt
)
[easements] => Array
(
[0] => None
)
[elementary_school] => Array
(
[0] => Keolu
)
[floor_covering] => Array
(
[0] => Ceramic Tile,Hardwood,Vinyl,W/W Carpet
)
[full_baths] => Array
(
[0] => 4
)
[furnished] => Array
(
[0] => None
)
[half_baths] => Array
(
[0] => 1
)
[high_school] => Array
(
[0] => Kailua
)
[home_exampt] => Array
(
[0] => yes
)
[lanai_sf] => Array
(
[0] => 649
)
[land_area_sf] => Array
(
[0] => 6555.00
)
[land_recorded] => Array
(
[0] => Land Court
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => wendy@lauleahomes.com
)
[list_agent_name] => Array
(
[0] => Yanbo Liao
)
[list_agent_phone_number] => Array
(
[0] => (808) 312-7884
)
[list_date] => Array
(
[0] => 2022-03-22
)
[list_office_name] => Array
(
[0] => Soldier To Soldier HI Realty
)
[list_price] => Array
(
[0] => 1950000.00
)
[living_sf] => Array
(
[0] => 4109
)
[location] => Array
(
[0] => 1249 Aulepe Street, Kailua, HI 96734
)
[middle_school] => Array
(
[0] => Kailua
)
[mls_] => Array
(
[0] => 202205411
)
[neighborhood] => Array
(
[0] => HILLCREST
)
[number_of_parking_spaces] => Array
(
[0] => 4
)
[number_of_stories] => Array
(
[0] => Three+
)
[office_mls_id] => Array
(
[0] => STSH
)
[parking_features] => Array
(
[0] => 3 Car+,Driveway,Garage,Street
)
[pool_] => Array
(
[0] => None
)
[possession] => Array
(
[0] => At Closing
)
[postal_code] => Array
(
[0] => 96734
)
[property_condition] => Array
(
[0] => Above Average,Excellent
)
[property_type] => Array
(
[0] => single_family
)
[property_type_label] => Array
(
[0] => single_family
)
[region] => Array
(
[0] => Kailua
)
[rets_baths_full] => Array
(
[0] => 4
)
[rets_baths_half] => Array
(
[0] => 1
)
[rets_baths_total] => Array
(
[0] => 4.01
)
[rets_beds_total] => Array
(
[0] => 6
)
[rets_city] => Array
(
[0] => Kailua
)
[rets_compensation_method] => Array
(
[0] => %
)
[rets_condo_property_regime_yn] => Array
(
[0] => 0
)
[rets_current_price] => Array
(
[0] => 1999999.00
)
[rets_dom] => Array
(
[0] => 10
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_elementary_school] => Array
(
[0] => Keolu
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_high_school] => Array
(
[0] => Kailua
)
[rets_id] => Array
(
[0] => 16522662
)
[rets_immoviewer_yn] => Array
(
[0] => 1
)
[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) 312-7884
)
[rets_list_agent_email] => Array
(
[0] => wendy@lauleahomes.com
)
[rets_list_agent_full_name] => Array
(
[0] => Yanbo Liao
)
[rets_list_agent_mlsid] => Array
(
[0] => 48969
)
[rets_list_agent_mui] => Array
(
[0] => 13070027
)
[rets_list_office_mlsid] => Array
(
[0] => STSH
)
[rets_list_office_mui] => Array
(
[0] => 10749024
)
[rets_list_office_name] => Array
(
[0] => Soldier To Soldier HI Realty
)
[rets_list_office_phone] => Array
(
[0] => (808) 312-7884
)
[rets_list_price] => Array
(
[0] => 1950000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-03-22
)
[rets_lot_size_area] => Array
(
[0] => 6555.00
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-05-20T13:20:26.173
)
[rets_matrix_unique_id] => Array
(
[0] => 16522662
)
[rets_middle_or_junior_school] => Array
(
[0] => Kailua
)
[rets_mls_number] => Array
(
[0] => 202205411
)
[rets_neighbourhood] => Array
(
[0] => HILLCREST
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-03-21T20:08:50.820
)
[rets_original_list_price] => Array
(
[0] => 1950000.00
)
[rets_parcel_number] => Array
(
[0] => 1-4-2-027-108-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-03-22T23:23:24.573
)
[rets_postal_code] => Array
(
[0] => 96734
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-03-22T23:26:38.837
)
[rets_primary_key] => Array
(
[0] => 16522662
)
[rets_private_remarks] => Array
(
[0] => Open House Thursday 03/24 11:00am - 1:30 pm, Sunday 03/27 2-5pm. Private showings please go through SHOWINGTIME to request for tracking purpose. Seller request Jaysie Perkins at TG Hawaii for escrow. Please include AS IS, verification of funding and Pre-qualification letter with your offer. Seller requests to review all offers Tuesday 03/29 at noon, make sure offers in by that time and date. Sellers will respond no later than same day 5pm.
)
[rets_public_remarks] => Array
(
[0] => This amazing Six bedroom 4 1/2 bath enjoys stunning panoramic views of Kailua Bay, mountains and Kailua Town. Wrap around deck constructed of balau, epai and stainless steel provides 300 sf of outside enjoyment. Vaulted ceilings, open floor plan, new white oak flooring, Baldwin hardware, 7 ceiling fans are included. Anderson, Pella and 6” Breeze way windows provide optimum ventilation. A separate studio has a private entrance. Owned solar panels (39), 4 batteries and solar water heater keep electric bills in check. Attached 2 car garage has generous workshop area. The third floor has 3 split system LG air conditioners. Tax Records don’t match, so Buyer/Buyer’s agent do your due diligence. Open House Thursday 03/24 11:00am - 1:30 pm, Sunday 03/27 2-5pm.
)
[rets_sqft_garage_carport] => Array
(
[0] => 598
)
[rets_sqft_lanai_open] => Array
(
[0] => 649
)
[rets_sqft_roofed_living] => Array
(
[0] => 3460
)
[rets_sqft_total] => Array
(
[0] => 4109
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-05-20T13:20:26.173
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-05-20
)
[rets_street_name] => Array
(
[0] => Aulepe
)
[rets_street_number] => Array
(
[0] => 1249
)
[rets_street_view_param] => Array
(
[0] => 1$21.373128$-157.727721$98.06$13.33$1.00$K3mMDcG6gtbxP-cYlxLLDw
)
[rets_sub_agency_compensation] => Array
(
[0] => 2
)
[rets_tax_amount] => Array
(
[0] => 364.00
)
[rets_tax_annual_amount] => Array
(
[0] => 4368.00
)
[rets_tax_assessed_value] => Array
(
[0] => 1387500.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 640100.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 747400.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => yes
)
[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/16522662/3ef7b856a34cf669b3c26ccaf22d1d1b
)
[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] => 108
)
[rets_tmk_section] => Array
(
[0] => 2
)
[rets_tmk_zone] => Array
(
[0] => 4
)
[rets_tmkplat] => Array
(
[0] => 27
)
[rets_year_built] => Array
(
[0] => 1993
)
[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] => Aulepe
)
[street_number] => Array
(
[0] => 1249
)
[street_suffix] => Array
(
[0] => Street
)
[terms_accept] => Array
(
[0] => Cash,Conventional,VA
)
[tmk] => Array
(
[0] => 1-4-2-027-108-0000
)
[topography] => Array
(
[0] => Clear
)
[view] => Array
(
[0] => City,Mountain,Ocean,Sunrise,Sunset
)
[wpp::rets_pk] => Array
(
[0] => 16522662
)
[wpp_gpid] => Array
(
[0] => 202205411
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1653088917
)
[year_built] => Array
(
[0] => 1993
)
[year_remodeled_] => Array
(
[0] => 2022
)
[zoning] => Array
(
[0] => 05 - R-5 Residential District
)
[new_attached_media] => Array
(
[0] => a:189:{i:0;i:21873822;i:1;i:21873823;i:2;i:21873824;i:3;i:21873825;i:4;i:21873826;i:5;i:21873827;i:6;i:21873828;i:7;i:21873829;i:8;i:21873830;i:9;i:21873831;i:10;i:21873832;i:11;i:21873833;i:12;i:21873834;i:13;i:21873835;i:14;i:21873836;i:15;i:21873837;i:16;i:21873838;i:17;i:21873839;i:18;i:21873840;i:19;i:21873841;i:20;i:21873842;i:21;i:21875385;i:22;i:21875386;i:23;i:21875387;i:24;i:21875388;i:25;i:21875389;i:26;i:21875390;i:27;i:21875391;i:28;i:21875392;i:29;i:21875393;i:30;i:21875394;i:31;i:21875395;i:32;i:21875396;i:33;i:21875397;i:34;i:21875398;i:35;i:21875399;i:36;i:21875400;i:37;i:21875401;i:38;i:21875402;i:39;i:21875403;i:40;i:21875404;i:41;i:21875405;i:42;i:21875651;i:43;i:21875652;i:44;i:21875653;i:45;i:21875654;i:46;i:21875655;i:47;i:21875656;i:48;i:21875657;i:49;i:21875658;i:50;i:21875659;i:51;i:21875660;i:52;i:21875661;i:53;i:21875662;i:54;i:21875663;i:55;i:21875664;i:56;i:21875665;i:57;i:21875666;i:58;i:21875667;i:59;i:21875668;i:60;i:21875669;i:61;i:21875670;i:62;i:21875671;i:63;i:21877204;i:64;i:21877205;i:65;i:21877206;i:66;i:21877207;i:67;i:21877208;i:68;i:21877209;i:69;i:21877210;i:70;i:21877211;i:71;i:21877212;i:72;i:21877213;i:73;i:21877214;i:74;i:21877215;i:75;i:21877216;i:76;i:21877217;i:77;i:21877218;i:78;i:21877219;i:79;i:21877220;i:80;i:21877221;i:81;i:21877222;i:82;i:21877223;i:83;i:21877224;i:84;i:21891137;i:85;i:21891138;i:86;i:21891139;i:87;i:21891140;i:88;i:21891141;i:89;i:21891142;i:90;i:21891143;i:91;i:21891144;i:92;i:21891145;i:93;i:21891146;i:94;i:21891147;i:95;i:21891148;i:96;i:21891149;i:97;i:21891150;i:98;i:21891151;i:99;i:21891152;i:100;i:21891153;i:101;i:21891154;i:102;i:21891155;i:103;i:21891156;i:104;i:21891157;i:105;i:21891306;i:106;i:21891307;i:107;i:21891308;i:108;i:21891309;i:109;i:21891310;i:110;i:21891311;i:111;i:21891312;i:112;i:21891313;i:113;i:21891314;i:114;i:21891315;i:115;i:21891316;i:116;i:21891317;i:117;i:21891318;i:118;i:21891319;i:119;i:21891320;i:120;i:21891321;i:121;i:21891322;i:122;i:21891323;i:123;i:21891324;i:124;i:21891325;i:125;i:21891326;i:126;i:21937481;i:127;i:21937482;i:128;i:21937483;i:129;i:21937484;i:130;i:21937485;i:131;i:21937486;i:132;i:21937487;i:133;i:21937488;i:134;i:21937489;i:135;i:21937490;i:136;i:21937491;i:137;i:21937492;i:138;i:21937493;i:139;i:21937494;i:140;i:21937495;i:141;i:21937496;i:142;i:21937497;i:143;i:21937498;i:144;i:21937499;i:145;i:21937500;i:146;i:21937501;i:147;i:21960479;i:148;i:21960480;i:149;i:21960481;i:150;i:21960482;i:151;i:21960483;i:152;i:21960484;i:153;i:21960485;i:154;i:21960486;i:155;i:21960487;i:156;i:21960488;i:157;i:21960489;i:158;i:21960490;i:159;i:21960491;i:160;i:21960492;i:161;i:21960493;i:162;i:21960494;i:163;i:21960495;i:164;i:21960496;i:165;i:21960497;i:166;i:21960498;i:167;i:21960499;i:168;i:22266781;i:169;i:22266782;i:170;i:22266783;i:171;i:22266784;i:172;i:22266785;i:173;i:22266786;i:174;i:22266787;i:175;i:22266788;i:176;i:22266789;i:177;i:22266790;i:178;i:22266791;i:179;i:22266792;i:180;i:22266793;i:181;i:22266794;i:182;i:22266795;i:183;i:22266796;i:184;i:22266797;i:185;i:22266798;i:186;i:22266799;i:187;i:22266800;i:188;i:22266801;}
)
[rets_open_house_count] => Array
(
[0] => 2
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_open_house_upcoming] => Array
(
[0] =>
)
[rets_supplement_count] => Array
(
[0] => 1
)
[rets_supplement_modification_timestam] => Array
(
[0] => 2022-03-23T12:21:14.913
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-03-30
)
[rets_virtual_tour_url_unbranded] => Array
(
[0] => https://app.immoviewer.com/landing/unbranded/62432e5771803d51554e6d14
)
[virtual_tour] => Array
(
[0] => https://app.immoviewer.com/landing/unbranded/62432e5771803d51554e6d14
)
[rets_close_date] => Array
(
[0] => 2022-05-20
)
[rets_close_price] => Array
(
[0] => 1999999.00
)
[rets_expiration_date] => Array
(
[0] => 2022-09-22
)
[rets_off_market_date] => Array
(
[0] => 2022-05-20
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 393-9966
)
[rets_selling_agent_email] => Array
(
[0] => cheyanne@alohahomesagents.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Cheyanne D LoBue
)
[rets_selling_agent_mlsid] => Array
(
[0] => 49440
)
[rets_selling_agent_mui] => Array
(
[0] => 14227240
)
[rets_selling_office_mlsid] => Array
(
[0] => RMXA
)
[rets_selling_office_mui] => Array
(
[0] => 12873659
)
[rets_selling_office_name] => Array
(
[0] => RE/MAX ALOHA HOMES
)
[rets_selling_office_phone] => Array
(
[0] => (808) 393-9966
)
[_thumbnail_id] => Array
(
[0] => 22266781
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446