NEW LISTING! RARELY Available single family home on Sea View Ave in Lower Manoa! This 4 bedroom and 2 bath home sits on almost 6,400sqft of land with a beautiful city view & Diamond Head views! Sea View Ave is conveniently located just a couple minutes from freeway access, the University of Hawaii, schools, parks & more! A Must See!
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446
array(151) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "248600.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(10) "1025200.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(10) "1273800.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "4"
}
["building_style"]=>
array(1) {
[0]=>
string(20) "Detach Single Family"
}
["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(7) "Noelani"
}
["exclusions"]=>
array(1) {
[0]=>
string(18) "Other,Refrigerator"
}
["floor_covering"]=>
array(1) {
[0]=>
string(16) "Vinyl,W/W Carpet"
}
["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(9) "Roosevelt"
}
["home_exampt"]=>
array(1) {
[0]=>
string(7) "100,000"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(7) "6391.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) "ColinL@BetterHawaii.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(11) "Colin A Lee"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 738-3600"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2021-04-09"
}
["list_office_name"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["list_price"]=>
array(1) {
[0]=>
string(10) "1199000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "1766"
}
["location"]=>
array(1) {
[0]=>
string(40) "2238 Sea View Avenue, Honolulu, HI 96822"
}
["middle_school"]=>
array(1) {
[0]=>
string(9) "Stevenson"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202108782"
}
["neighborhood"]=>
array(1) {
[0]=>
string(11) "MANOA-LOWER"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "3"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(3) "Two"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(4) "ADVG"
}
["parking_features"]=>
array(1) {
[0]=>
string(14) "3 Car+,Carport"
}
["pool_"]=>
array(1) {
[0]=>
string(4) "None"
}
["possession"]=>
array(1) {
[0]=>
string(10) "At Closing"
}
["property_condition"]=>
array(1) {
[0]=>
string(21) "Above Average,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(5) "Metro"
}
["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(8) "Honolulu"
}
["rets_condo_property_regime_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(10) "1300000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(1) "7"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_elementary_school"]=>
array(1) {
[0]=>
string(7) "Noelani"
}
["rets_fractional_ownership_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_high_school"]=>
array(1) {
[0]=>
string(9) "Roosevelt"
}
["rets_id"]=>
array(1) {
[0]=>
string(8) "15838830"
}
["rets_immoviewer_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 738-3600"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(23) "ColinL@BetterHawaii.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(11) "Colin A Lee"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "44629"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "9195071"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(4) "ADVG"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(7) "9695164"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 738-3600"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(10) "1199000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2021-04-09"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(7) "6391.00"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2021-05-28T08:23:30.350"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "15838830"
}
["rets_middle_or_junior_school"]=>
array(1) {
[0]=>
string(9) "Stevenson"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202108782"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(11) "MANOA-LOWER"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2021-04-09T12:38:32.593"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(10) "1199000.00"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-2-8-016-061-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) "21"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2021-04-09T16:24:13.520"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96822"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2021-04-09T12:38:32.593"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "15838830"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(211) "For ALL showing requests, please call/text/email Chelsea @ (808) 729-6780 or ChelseaL@BetterHawaii.com. First showing at Open House this Sunday 4/11/2021 from 2-5pm. Please Note: TMK records do not match actual."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(334) "NEW LISTING! RARELY Available single family home on Sea View Ave in Lower Manoa! This 4 bedroom and 2 bath home sits on almost 6,400sqft of land with a beautiful city view & Diamond Head views! Sea View Ave is conveniently located just a couple minutes from freeway access, the University of Hawaii, schools, parks & more! A Must See!"
}
["rets_sqft_garage_carport"]=>
array(1) {
[0]=>
string(3) "440"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "1404"
}
["rets_sqft_roofed_other"]=>
array(1) {
[0]=>
string(3) "362"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "1766"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2021-05-28T08:23:30.350"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2021-05-28"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(8) "Sea View"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(4) "2238"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(64) "1$21.300392$-157.823414$336.35$13.33$1.00$PL4ngCmthyRMeCmZ4BCbhA"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(3) "2.5"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "345.16"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(10) "1273800.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "248600.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(10) "1025200.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(7) "100,000"
}
["rets_tax_paid_by_seller_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_tax_year"]=>
array(1) {
[0]=>
string(4) "2020"
}
["rets_thumbnail_url"]=>
array(1) {
[0]=>
string(81) "https://cdn.rets.ci/marcusrealty-images/15838830/eb0e87a1aecebd15d06922fd00c6ae4b"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "128"
}
["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) "61"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "8"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(2) "16"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1953"
}
["setbacks"]=>
array(1) {
[0]=>
string(9) "Of Record"
}
["status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["terms_accept"]=>
array(1) {
[0]=>
string(20) "Cash,Conventional,VA"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-2-8-016-061-0000"
}
["topography"]=>
array(1) {
[0]=>
string(5) "Clear"
}
["view"]=>
array(1) {
[0]=>
string(17) "City,Diamond Head"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "15838830"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202108782"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1628921863"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1953"
}
["zoning"]=>
array(1) {
[0]=>
string(29) "05 - R-5 Residential District"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(2958) "a:180:{i:0;i:19765751;i:1;i:19765752;i:2;i:19765753;i:3;i:19765754;i:4;i:19765755;i:5;i:19765756;i:6;i:19765757;i:7;i:19765758;i:8;i:19765759;i:9;i:19765760;i:10;i:19765761;i:11;i:19765762;i:12;i:19765763;i:13;i:19765764;i:14;i:19765765;i:15;i:19765766;i:16;i:19765767;i:17;i:19765768;i:18;i:19765769;i:19;i:19765770;i:20;i:19765771;i:21;i:19765772;i:22;i:19765773;i:23;i:19765774;i:24;i:19765775;i:25;i:19765776;i:26;i:19765777;i:27;i:19765778;i:28;i:19765779;i:29;i:19765780;i:30;i:19765781;i:31;i:19765782;i:32;i:19765783;i:33;i:19765784;i:34;i:19765785;i:35;i:19765786;i:36;i:19765787;i:37;i:19765788;i:38;i:19765789;i:39;i:19765790;i:40;i:19766759;i:41;i:19766760;i:42;i:19766761;i:43;i:19766762;i:44;i:19766763;i:45;i:19766764;i:46;i:19766765;i:47;i:19766766;i:48;i:19766767;i:49;i:19766768;i:50;i:19766769;i:51;i:19766770;i:52;i:19766771;i:53;i:19766772;i:54;i:19766773;i:55;i:19766774;i:56;i:19766775;i:57;i:19766776;i:58;i:19766777;i:59;i:19766778;i:60;i:19768570;i:61;i:19768571;i:62;i:19768572;i:63;i:19768573;i:64;i:19768574;i:65;i:19768575;i:66;i:19768576;i:67;i:19768577;i:68;i:19768578;i:69;i:19768579;i:70;i:19768580;i:71;i:19768581;i:72;i:19768582;i:73;i:19768583;i:74;i:19768584;i:75;i:19768585;i:76;i:19768586;i:77;i:19768587;i:78;i:19768588;i:79;i:19768589;i:80;i:19786280;i:81;i:19786281;i:82;i:19786282;i:83;i:19786283;i:84;i:19786284;i:85;i:19786285;i:86;i:19786286;i:87;i:19786287;i:88;i:19786288;i:89;i:19786289;i:90;i:19786290;i:91;i:19786291;i:92;i:19786292;i:93;i:19786293;i:94;i:19786294;i:95;i:19786295;i:96;i:19786296;i:97;i:19786297;i:98;i:19786298;i:99;i:19786299;i:100;i:19811507;i:101;i:19811508;i:102;i:19811509;i:103;i:19811510;i:104;i:19811511;i:105;i:19811512;i:106;i:19811513;i:107;i:19811514;i:108;i:19811515;i:109;i:19811516;i:110;i:19811517;i:111;i:19811518;i:112;i:19811519;i:113;i:19811520;i:114;i:19811521;i:115;i:19811522;i:116;i:19811523;i:117;i:19811524;i:118;i:19811525;i:119;i:19811526;i:120;i:19890247;i:121;i:19890248;i:122;i:19890249;i:123;i:19890250;i:124;i:19890251;i:125;i:19890252;i:126;i:19890253;i:127;i:19890254;i:128;i:19890255;i:129;i:19890256;i:130;i:19890257;i:131;i:19890258;i:132;i:19890259;i:133;i:19890260;i:134;i:19890261;i:135;i:19890262;i:136;i:19890263;i:137;i:19890264;i:138;i:19890265;i:139;i:19890266;i:140;i:20051583;i:141;i:20051584;i:142;i:20051585;i:143;i:20051586;i:144;i:20051587;i:145;i:20051588;i:146;i:20051589;i:147;i:20051590;i:148;i:20051591;i:149;i:20051592;i:150;i:20051593;i:151;i:20051594;i:152;i:20051595;i:153;i:20051596;i:154;i:20051597;i:155;i:20051598;i:156;i:20051599;i:157;i:20051600;i:158;i:20051601;i:159;i:20051602;i:160;i:20299795;i:161;i:20299796;i:162;i:20299797;i:163;i:20299798;i:164;i:20299799;i:165;i:20299800;i:166;i:20299801;i:167;i:20299802;i:168;i:20299803;i:169;i:20299804;i:170;i:20299805;i:171;i:20299806;i:172;i:20299807;i:173;i:20299808;i:174;i:20299809;i:175;i:20299810;i:176;i:20299811;i:177;i:20299812;i:178;i:20299813;i:179;i:20299814;}"
}
["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_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(69) "https://app.immoviewer.com/landing/unbranded/60754c9c4b77e566b63b25fd"
}
["virtual_tour"]=>
array(1) {
[0]=>
string(69) "https://app.immoviewer.com/landing/unbranded/60754c9c4b77e566b63b25fd"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2021-04-15"
}
["rets_pending_date"]=>
array(1) {
[0]=>
string(10) "2021-04-15"
}
["city"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96822"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2021-05-28"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(10) "1300000.00"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2021-05-28"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 739-2291"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(20) "dorothy810@gmail.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(12) "Dorothy Yung"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "32783"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "3479531"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "LORE"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(7) "3487881"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(17) "Loyal Realty, LLC"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 739-2291"
}
["state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["street_name"]=>
array(1) {
[0]=>
string(8) "Sea View"
}
["street_number"]=>
array(1) {
[0]=>
string(4) "2238"
}
["street_suffix"]=>
array(1) {
[0]=>
string(6) "Avenue"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "20299795"
}
}