1st time to market! Come home to this Windward side wonder nestled in the desirable Crown Terrace community with majestic views of the Ko’olau mountain range! This single level 3-bedroom corner lot house has been lovingly cared for by the same family for generations! Featuring updated paint, vinyl flooring, large back patio for entertaining, vinyl fencing, some newer appliances, both a living and family room–this home is ready for your personal touches, ideas and possible expansion. Conveniently located near Windward Mall, schools, Kaneohe Marine Base with easy access to shopping, dining, entertainment, the Pali & Likelike Highways, and H-3 to Joint Base Pearl Harbor. Don’t miss your opportunity on this rarely available large corner lot house in a coveted neighborhood. Schedule your viewing today!
Listing by: Five Star Realty, Inc. (808) 382-6871
array(165) {
["agency"]=>
array(1) {
[0]=>
string(22) "Five Star Realty, Inc."
}
["assd_val_imprv"]=>
array(1) {
[0]=>
string(8) "87800.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "792200.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "880000.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "3"
}
["building_style"]=>
array(1) {
[0]=>
string(20) "Detach Single Family"
}
["city"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["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) "Heeia"
}
["floor_covering"]=>
array(1) {
[0]=>
string(14) "Laminate,Vinyl"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "2"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["high_school"]=>
array(1) {
[0]=>
string(6) "Castle"
}
["home_exampt"]=>
array(1) {
[0]=>
string(6) "140000"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(7) "6107.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) "Ky@FiveStarRealty.org"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(6) "Ky Lao"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 382-6871"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-06-21"
}
["list_office_name"]=>
array(1) {
[0]=>
string(22) "Five Star Realty, Inc."
}
["list_price"]=>
array(1) {
[0]=>
string(9) "995000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "1221"
}
["location"]=>
array(1) {
[0]=>
string(38) "46-248 Aeloa Street, Kaneohe, HI 96744"
}
["middle_school"]=>
array(1) {
[0]=>
string(4) "King"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202211757"
}
["neighborhood"]=>
array(1) {
[0]=>
string(13) "CROWN TERRACE"
}
["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) "FIVE"
}
["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(10) "At Closing"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96744"
}
["property_condition"]=>
array(1) {
[0]=>
string(7) "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(7) "Kaneohe"
}
["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(7) "Kaneohe"
}
["rets_co_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 382-6871"
}
["rets_co_list_agent_email"]=>
array(1) {
[0]=>
string(27) "brandonmitsuda888@gmail.com"
}
["rets_co_list_agent_full_name"]=>
array(1) {
[0]=>
string(15) "Brandon Mitsuda"
}
["rets_co_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "52119"
}
["rets_co_list_agent_mui"]=>
array(1) {
[0]=>
string(8) "16444729"
}
["rets_co_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "FIVE"
}
["rets_co_list_office_mui"]=>
array(1) {
[0]=>
string(7) "3486552"
}
["rets_co_list_office_name"]=>
array(1) {
[0]=>
string(22) "Five Star Realty, Inc."
}
["rets_co_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 382-6871"
}
["rets_condo_property_regime_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(10) "1055000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(2) "11"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_elementary_school"]=>
array(1) {
[0]=>
string(5) "Heeia"
}
["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) "Castle"
}
["rets_id"]=>
array(1) {
[0]=>
string(8) "16713320"
}
["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) 382-6871"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(21) "Ky@FiveStarRealty.org"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(6) "Ky Lao"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "45384"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "9677937"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "FIVE"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(7) "3486552"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(22) "Five Star Realty, Inc."
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 382-6871"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(9) "995000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-06-21"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(7) "6107.00"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-08-24T16:11:50.830"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16713320"
}
["rets_middle_or_junior_school"]=>
array(1) {
[0]=>
string(4) "King"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202211757"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(13) "CROWN TERRACE"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-21T10:53:26.450"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(9) "995000.00"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-4-6-024-054-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-21T10:56:03.710"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96744"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-21T10:53:26.450"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16713320"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(474) "1st Open House Sunday 6/26/22 from 2-5PM. Vacant and easy to see! Please use SHOWING TIME for all showing requests. Sellers are kindly requesting offers if any to be submitted by Thursday, 6/30/22 at 5 pm. Seller prefers Title Guaranty, Escrow Officer Bobby Arre, Queen St Office. Monthly Taxes are based on 2021 payments. Survey (K-2), Cleaning (J-9) completed and preventative termite maintenance with warranty to 2023. Buyers to conduct their own due diligence. Mahalo!"
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(814) "1st time to market! Come home to this Windward side wonder nestled in the desirable Crown Terrace community with majestic views of the Ko'olau mountain range! This single level 3-bedroom corner lot house has been lovingly cared for by the same family for generations! Featuring updated paint, vinyl flooring, large back patio for entertaining, vinyl fencing, some newer appliances, both a living and family room--this home is ready for your personal touches, ideas and possible expansion. Conveniently located near Windward Mall, schools, Kaneohe Marine Base with easy access to shopping, dining, entertainment, the Pali & Likelike Highways, and H-3 to Joint Base Pearl Harbor. Don't miss your opportunity on this rarely available large corner lot house in a coveted neighborhood. Schedule your viewing today!"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "1221"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "1221"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-08-24T16:11:50.830"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-08-23"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(5) "Aeloa"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(6) "46-248"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(62) "1$21.419986$-157.809797$8.69$13.33$1.00$ZYBi0zRntxXxdKck4iCtwA"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(3) "2.5"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "200.09"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "2401.08"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "880000.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(8) "87800.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "792200.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(6) "140000"
}
["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/16713320/9879718ae089de656d73ea9c9f2917ae"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "146"
}
["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) "54"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "6"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(2) "24"
}
["rets_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(51) "https://my.matterport.com/show/?m=cMfiMMKgKre&mls=1"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1964"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(4) "2022"
}
["security"]=>
array(1) {
[0]=>
string(3) "Key"
}
["setbacks"]=>
array(1) {
[0]=>
string(9) "Of Record"
}
["state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["street_name"]=>
array(1) {
[0]=>
string(5) "Aeloa"
}
["street_number"]=>
array(1) {
[0]=>
string(6) "46-248"
}
["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-6-024-054-0000"
}
["topography"]=>
array(1) {
[0]=>
string(5) "Clear"
}
["view"]=>
array(1) {
[0]=>
string(13) "City,Mountain"
}
["virtual_tour"]=>
array(1) {
[0]=>
string(51) "https://my.matterport.com/show/?m=cMfiMMKgKre&mls=1"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16713320"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202211757"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1661393574"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1964"
}
["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(2754) "a:168:{i:0;i:22497997;i:1;i:22497998;i:2;i:22497999;i:3;i:22498000;i:4;i:22498001;i:5;i:22498002;i:6;i:22498003;i:7;i:22498004;i:8;i:22498005;i:9;i:22498006;i:10;i:22498007;i:11;i:22498008;i:12;i:22498009;i:13;i:22498010;i:14;i:22498011;i:15;i:22498012;i:16;i:22498013;i:17;i:22498014;i:18;i:22498015;i:19;i:22498016;i:20;i:22498017;i:21;i:22498081;i:22;i:22498082;i:23;i:22498083;i:24;i:22498084;i:25;i:22498085;i:26;i:22498086;i:27;i:22498087;i:28;i:22498088;i:29;i:22498089;i:30;i:22498090;i:31;i:22498091;i:32;i:22498092;i:33;i:22498093;i:34;i:22498094;i:35;i:22498095;i:36;i:22498096;i:37;i:22498097;i:38;i:22498098;i:39;i:22498099;i:40;i:22498100;i:41;i:22498101;i:42;i:22498123;i:43;i:22498124;i:44;i:22498125;i:45;i:22498126;i:46;i:22498127;i:47;i:22498128;i:48;i:22498129;i:49;i:22498130;i:50;i:22498131;i:51;i:22498132;i:52;i:22498133;i:53;i:22498134;i:54;i:22498135;i:55;i:22498136;i:56;i:22498137;i:57;i:22498138;i:58;i:22498139;i:59;i:22498140;i:60;i:22498141;i:61;i:22498142;i:62;i:22498143;i:63;i:22498278;i:64;i:22498279;i:65;i:22498280;i:66;i:22498281;i:67;i:22498282;i:68;i:22498283;i:69;i:22498284;i:70;i:22498285;i:71;i:22498286;i:72;i:22498287;i:73;i:22498288;i:74;i:22498289;i:75;i:22498290;i:76;i:22498291;i:77;i:22498292;i:78;i:22498293;i:79;i:22498294;i:80;i:22498295;i:81;i:22498296;i:82;i:22498297;i:83;i:22498298;i:84;i:22551945;i:85;i:22551946;i:86;i:22551947;i:87;i:22551948;i:88;i:22551949;i:89;i:22551950;i:90;i:22551951;i:91;i:22551952;i:92;i:22551953;i:93;i:22551954;i:94;i:22551955;i:95;i:22551956;i:96;i:22551957;i:97;i:22551958;i:98;i:22551959;i:99;i:22551960;i:100;i:22551961;i:101;i:22551962;i:102;i:22551963;i:103;i:22551964;i:104;i:22551965;i:105;i:22610302;i:106;i:22610303;i:107;i:22610304;i:108;i:22610305;i:109;i:22610306;i:110;i:22610307;i:111;i:22610308;i:112;i:22610309;i:113;i:22610310;i:114;i:22610311;i:115;i:22610312;i:116;i:22610313;i:117;i:22610314;i:118;i:22610315;i:119;i:22610316;i:120;i:22610317;i:121;i:22610318;i:122;i:22610319;i:123;i:22610320;i:124;i:22610321;i:125;i:22610322;i:126;i:23035169;i:127;i:23035170;i:128;i:23035171;i:129;i:23035172;i:130;i:23035173;i:131;i:23035174;i:132;i:23035175;i:133;i:23035176;i:134;i:23035177;i:135;i:23035178;i:136;i:23035179;i:137;i:23035180;i:138;i:23035181;i:139;i:23035182;i:140;i:23035183;i:141;i:23035184;i:142;i:23035185;i:143;i:23035186;i:144;i:23035187;i:145;i:23035188;i:146;i:23035189;i:147;i:23150322;i:148;i:23150323;i:149;i:23150324;i:150;i:23150325;i:151;i:23150326;i:152;i:23150327;i:153;i:23150328;i:154;i:23150329;i:155;i:23150330;i:156;i:23150331;i:157;i:23150332;i:158;i:23150333;i:159;i:23150334;i:160;i:23150335;i:161;i:23150336;i:162;i:23150337;i:163;i:23150338;i:164;i:23150339;i:165;i:23150340;i:166;i:23150341;i:167;i:23150342;}"
}
["rets_open_house_count"]=>
array(1) {
[0]=>
string(1) "1"
}
["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-07-01"
}
["rets_pending_date"]=>
array(1) {
[0]=>
string(10) "2022-07-01"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-08-23"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(10) "1055000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2023-07-20"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-08-23"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 382-6871"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(26) "Vincent@FiveStarRealty.org"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(11) "Vincent Lao"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "22205"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "3474247"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "FIVE"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(7) "3486552"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(22) "Five Star Realty, Inc."
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 382-6871"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "23150322"
}
}
Array
(
[agency] => Array
(
[0] => Five Star Realty, Inc.
)
[assd_val_imprv] => Array
(
[0] => 87800.00
)
[assd_val_land] => Array
(
[0] => 792200.00
)
[assd_val_total] => Array
(
[0] => 880000.00
)
[bedrooms] => Array
(
[0] => 3
)
[building_style] => Array
(
[0] => Detach Single Family
)
[city] => Array
(
[0] => Kaneohe
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Property Disclosure Stmt
)
[easements] => Array
(
[0] => None
)
[elementary_school] => Array
(
[0] => Heeia
)
[floor_covering] => Array
(
[0] => Laminate,Vinyl
)
[full_baths] => Array
(
[0] => 2
)
[half_baths] => Array
(
[0] => 0
)
[high_school] => Array
(
[0] => Castle
)
[home_exampt] => Array
(
[0] => 140000
)
[land_area_sf] => Array
(
[0] => 6107.00
)
[land_recorded] => Array
(
[0] => Land Court
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => Ky@FiveStarRealty.org
)
[list_agent_name] => Array
(
[0] => Ky Lao
)
[list_agent_phone_number] => Array
(
[0] => (808) 382-6871
)
[list_date] => Array
(
[0] => 2022-06-21
)
[list_office_name] => Array
(
[0] => Five Star Realty, Inc.
)
[list_price] => Array
(
[0] => 995000.00
)
[living_sf] => Array
(
[0] => 1221
)
[location] => Array
(
[0] => 46-248 Aeloa Street, Kaneohe, HI 96744
)
[middle_school] => Array
(
[0] => King
)
[mls_] => Array
(
[0] => 202211757
)
[neighborhood] => Array
(
[0] => CROWN TERRACE
)
[number_of_parking_spaces] => Array
(
[0] => 4
)
[number_of_stories] => Array
(
[0] => One
)
[office_mls_id] => Array
(
[0] => FIVE
)
[parking_features] => Array
(
[0] => 3 Car+,Boat,Carport,Driveway,Street
)
[pool_] => Array
(
[0] => None
)
[possession] => Array
(
[0] => At Closing
)
[postal_code] => Array
(
[0] => 96744
)
[property_condition] => Array
(
[0] => Average
)
[property_type] => Array
(
[0] => single_family
)
[property_type_label] => Array
(
[0] => single_family
)
[region] => Array
(
[0] => Kaneohe
)
[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] => Kaneohe
)
[rets_co_list_agent_direct_work_phone] => Array
(
[0] => (808) 382-6871
)
[rets_co_list_agent_email] => Array
(
[0] => brandonmitsuda888@gmail.com
)
[rets_co_list_agent_full_name] => Array
(
[0] => Brandon Mitsuda
)
[rets_co_list_agent_mlsid] => Array
(
[0] => 52119
)
[rets_co_list_agent_mui] => Array
(
[0] => 16444729
)
[rets_co_list_office_mlsid] => Array
(
[0] => FIVE
)
[rets_co_list_office_mui] => Array
(
[0] => 3486552
)
[rets_co_list_office_name] => Array
(
[0] => Five Star Realty, Inc.
)
[rets_co_list_office_phone] => Array
(
[0] => (808) 382-6871
)
[rets_condo_property_regime_yn] => Array
(
[0] => 0
)
[rets_current_price] => Array
(
[0] => 1055000.00
)
[rets_dom] => Array
(
[0] => 11
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_elementary_school] => Array
(
[0] => Heeia
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_high_school] => Array
(
[0] => Castle
)
[rets_id] => Array
(
[0] => 16713320
)
[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) 382-6871
)
[rets_list_agent_email] => Array
(
[0] => Ky@FiveStarRealty.org
)
[rets_list_agent_full_name] => Array
(
[0] => Ky Lao
)
[rets_list_agent_mlsid] => Array
(
[0] => 45384
)
[rets_list_agent_mui] => Array
(
[0] => 9677937
)
[rets_list_office_mlsid] => Array
(
[0] => FIVE
)
[rets_list_office_mui] => Array
(
[0] => 3486552
)
[rets_list_office_name] => Array
(
[0] => Five Star Realty, Inc.
)
[rets_list_office_phone] => Array
(
[0] => (808) 382-6871
)
[rets_list_price] => Array
(
[0] => 995000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-06-21
)
[rets_lot_size_area] => Array
(
[0] => 6107.00
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-08-24T16:11:50.830
)
[rets_matrix_unique_id] => Array
(
[0] => 16713320
)
[rets_middle_or_junior_school] => Array
(
[0] => King
)
[rets_mls_number] => Array
(
[0] => 202211757
)
[rets_neighbourhood] => Array
(
[0] => CROWN TERRACE
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-06-21T10:53:26.450
)
[rets_original_list_price] => Array
(
[0] => 995000.00
)
[rets_parcel_number] => Array
(
[0] => 1-4-6-024-054-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-21T10:56:03.710
)
[rets_postal_code] => Array
(
[0] => 96744
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-06-21T10:53:26.450
)
[rets_primary_key] => Array
(
[0] => 16713320
)
[rets_private_remarks] => Array
(
[0] => 1st Open House Sunday 6/26/22 from 2-5PM. Vacant and easy to see! Please use SHOWING TIME for all showing requests. Sellers are kindly requesting offers if any to be submitted by Thursday, 6/30/22 at 5 pm. Seller prefers Title Guaranty, Escrow Officer Bobby Arre, Queen St Office. Monthly Taxes are based on 2021 payments. Survey (K-2), Cleaning (J-9) completed and preventative termite maintenance with warranty to 2023. Buyers to conduct their own due diligence. Mahalo!
)
[rets_public_remarks] => Array
(
[0] => 1st time to market! Come home to this Windward side wonder nestled in the desirable Crown Terrace community with majestic views of the Ko'olau mountain range! This single level 3-bedroom corner lot house has been lovingly cared for by the same family for generations! Featuring updated paint, vinyl flooring, large back patio for entertaining, vinyl fencing, some newer appliances, both a living and family room--this home is ready for your personal touches, ideas and possible expansion. Conveniently located near Windward Mall, schools, Kaneohe Marine Base with easy access to shopping, dining, entertainment, the Pali & Likelike Highways, and H-3 to Joint Base Pearl Harbor. Don't miss your opportunity on this rarely available large corner lot house in a coveted neighborhood. Schedule your viewing today!
)
[rets_sqft_roofed_living] => Array
(
[0] => 1221
)
[rets_sqft_total] => Array
(
[0] => 1221
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-08-24T16:11:50.830
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-08-23
)
[rets_street_name] => Array
(
[0] => Aeloa
)
[rets_street_number] => Array
(
[0] => 46-248
)
[rets_street_view_param] => Array
(
[0] => 1$21.419986$-157.809797$8.69$13.33$1.00$ZYBi0zRntxXxdKck4iCtwA
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5
)
[rets_tax_amount] => Array
(
[0] => 200.09
)
[rets_tax_annual_amount] => Array
(
[0] => 2401.08
)
[rets_tax_assessed_value] => Array
(
[0] => 880000.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 87800.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 792200.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 140000
)
[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/16713320/9879718ae089de656d73ea9c9f2917ae
)
[rets_tmk_area] => Array
(
[0] => 146
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 0
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 54
)
[rets_tmk_section] => Array
(
[0] => 6
)
[rets_tmk_zone] => Array
(
[0] => 4
)
[rets_tmkplat] => Array
(
[0] => 24
)
[rets_virtual_tour_url_unbranded] => Array
(
[0] => https://my.matterport.com/show/?m=cMfiMMKgKre&mls=1
)
[rets_year_built] => Array
(
[0] => 1964
)
[rets_year_remodeled] => Array
(
[0] => 2022
)
[security] => Array
(
[0] => Key
)
[setbacks] => Array
(
[0] => Of Record
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Aeloa
)
[street_number] => Array
(
[0] => 46-248
)
[street_suffix] => Array
(
[0] => Street
)
[terms_accept] => Array
(
[0] => Cash,Conventional,VA
)
[tmk] => Array
(
[0] => 1-4-6-024-054-0000
)
[topography] => Array
(
[0] => Clear
)
[view] => Array
(
[0] => City,Mountain
)
[virtual_tour] => Array
(
[0] => https://my.matterport.com/show/?m=cMfiMMKgKre&mls=1
)
[wpp::rets_pk] => Array
(
[0] => 16713320
)
[wpp_gpid] => Array
(
[0] => 202211757
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1661393574
)
[year_built] => Array
(
[0] => 1964
)
[year_remodeled_] => Array
(
[0] => 2022
)
[zoning] => Array
(
[0] => 05 - R-5 Residential District
)
[new_attached_media] => Array
(
[0] => a:168:{i:0;i:22497997;i:1;i:22497998;i:2;i:22497999;i:3;i:22498000;i:4;i:22498001;i:5;i:22498002;i:6;i:22498003;i:7;i:22498004;i:8;i:22498005;i:9;i:22498006;i:10;i:22498007;i:11;i:22498008;i:12;i:22498009;i:13;i:22498010;i:14;i:22498011;i:15;i:22498012;i:16;i:22498013;i:17;i:22498014;i:18;i:22498015;i:19;i:22498016;i:20;i:22498017;i:21;i:22498081;i:22;i:22498082;i:23;i:22498083;i:24;i:22498084;i:25;i:22498085;i:26;i:22498086;i:27;i:22498087;i:28;i:22498088;i:29;i:22498089;i:30;i:22498090;i:31;i:22498091;i:32;i:22498092;i:33;i:22498093;i:34;i:22498094;i:35;i:22498095;i:36;i:22498096;i:37;i:22498097;i:38;i:22498098;i:39;i:22498099;i:40;i:22498100;i:41;i:22498101;i:42;i:22498123;i:43;i:22498124;i:44;i:22498125;i:45;i:22498126;i:46;i:22498127;i:47;i:22498128;i:48;i:22498129;i:49;i:22498130;i:50;i:22498131;i:51;i:22498132;i:52;i:22498133;i:53;i:22498134;i:54;i:22498135;i:55;i:22498136;i:56;i:22498137;i:57;i:22498138;i:58;i:22498139;i:59;i:22498140;i:60;i:22498141;i:61;i:22498142;i:62;i:22498143;i:63;i:22498278;i:64;i:22498279;i:65;i:22498280;i:66;i:22498281;i:67;i:22498282;i:68;i:22498283;i:69;i:22498284;i:70;i:22498285;i:71;i:22498286;i:72;i:22498287;i:73;i:22498288;i:74;i:22498289;i:75;i:22498290;i:76;i:22498291;i:77;i:22498292;i:78;i:22498293;i:79;i:22498294;i:80;i:22498295;i:81;i:22498296;i:82;i:22498297;i:83;i:22498298;i:84;i:22551945;i:85;i:22551946;i:86;i:22551947;i:87;i:22551948;i:88;i:22551949;i:89;i:22551950;i:90;i:22551951;i:91;i:22551952;i:92;i:22551953;i:93;i:22551954;i:94;i:22551955;i:95;i:22551956;i:96;i:22551957;i:97;i:22551958;i:98;i:22551959;i:99;i:22551960;i:100;i:22551961;i:101;i:22551962;i:102;i:22551963;i:103;i:22551964;i:104;i:22551965;i:105;i:22610302;i:106;i:22610303;i:107;i:22610304;i:108;i:22610305;i:109;i:22610306;i:110;i:22610307;i:111;i:22610308;i:112;i:22610309;i:113;i:22610310;i:114;i:22610311;i:115;i:22610312;i:116;i:22610313;i:117;i:22610314;i:118;i:22610315;i:119;i:22610316;i:120;i:22610317;i:121;i:22610318;i:122;i:22610319;i:123;i:22610320;i:124;i:22610321;i:125;i:22610322;i:126;i:23035169;i:127;i:23035170;i:128;i:23035171;i:129;i:23035172;i:130;i:23035173;i:131;i:23035174;i:132;i:23035175;i:133;i:23035176;i:134;i:23035177;i:135;i:23035178;i:136;i:23035179;i:137;i:23035180;i:138;i:23035181;i:139;i:23035182;i:140;i:23035183;i:141;i:23035184;i:142;i:23035185;i:143;i:23035186;i:144;i:23035187;i:145;i:23035188;i:146;i:23035189;i:147;i:23150322;i:148;i:23150323;i:149;i:23150324;i:150;i:23150325;i:151;i:23150326;i:152;i:23150327;i:153;i:23150328;i:154;i:23150329;i:155;i:23150330;i:156;i:23150331;i:157;i:23150332;i:158;i:23150333;i:159;i:23150334;i:160;i:23150335;i:161;i:23150336;i:162;i:23150337;i:163;i:23150338;i:164;i:23150339;i:165;i:23150340;i:166;i:23150341;i:167;i:23150342;}
)
[rets_open_house_count] => Array
(
[0] => 1
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_open_house_upcoming] => Array
(
[0] =>
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-07-01
)
[rets_pending_date] => Array
(
[0] => 2022-07-01
)
[rets_close_date] => Array
(
[0] => 2022-08-23
)
[rets_close_price] => Array
(
[0] => 1055000.00
)
[rets_expiration_date] => Array
(
[0] => 2023-07-20
)
[rets_off_market_date] => Array
(
[0] => 2022-08-23
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 382-6871
)
[rets_selling_agent_email] => Array
(
[0] => Vincent@FiveStarRealty.org
)
[rets_selling_agent_full_name] => Array
(
[0] => Vincent Lao
)
[rets_selling_agent_mlsid] => Array
(
[0] => 22205
)
[rets_selling_agent_mui] => Array
(
[0] => 3474247
)
[rets_selling_office_mlsid] => Array
(
[0] => FIVE
)
[rets_selling_office_mui] => Array
(
[0] => 3486552
)
[rets_selling_office_name] => Array
(
[0] => Five Star Realty, Inc.
)
[rets_selling_office_phone] => Array
(
[0] => (808) 382-6871
)
[_thumbnail_id] => Array
(
[0] => 23150322
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446