Tucked away, stunningly remodeled throughout, high ceilings, looking out to tropical green flora, no neighbors behind… this most desirable floorplan offers spaciousness and privacy. Enter the front door to your personal haven. Open, airy, peaceful vibes. Enjoy nature views while chilling in AC. Deck lanai off dining room for easy grilling and enjoying the outdoors. Primary bedroom, full bath, two vanities on main level, opens to enclosed courtyard. Downstairs, two bedrooms, vinyl sliders, small lanais and luscious green yard space. Brand new water heater, newer windows & sliders throughout, split ACs just serviced, keep you cool and comfortable. Newer kitchen features wood cabinets, stainless steel, island, two pantries w/pull-outs, soft close, under cab lights. Newer washer and dryer, brand new luxury vinyl plank floor/moulding in all bedrooms, downstairs hallways. No carpet. Fenced courtyard in front, deck lanai off living/dining area, two small open lanais and plenty grass downstairs. Close to highways H-3, Likelike, Kaneohe MCBH. Dining, shopping, movies nearby. Community pool. Two parking spots plus guest and street parking for visitors. Turn-key opportunity, low maint fee.
Listing by: Coldwell Banker Realty
array(167) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(9) "315200.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "378700.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "693900.00"
}
["bedrooms"]=>
array(1) {
[0]=>
string(1) "3"
}
["building_name"]=>
array(1) {
[0]=>
string(19) "Club View Gardens 2"
}
["building_style"]=>
array(1) {
[0]=>
string(9) "Townhouse"
}
["city"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(46) "Pets Allowed (Verify),Property Disclosure Stmt"
}
["elementary_school"]=>
array(1) {
[0]=>
string(8) "Ahuimanu"
}
["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(7) "Partial"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["high_school"]=>
array(1) {
[0]=>
string(6) "Castle"
}
["home_exampt"]=>
array(1) {
[0]=>
string(1) "0"
}
["lanai_sf"]=>
array(1) {
[0]=>
string(3) "228"
}
["land_area_sf"]=>
array(1) {
[0]=>
string(9) "919160.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(25) "shari.hooks@cbpacific.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(13) "Shari M Hooks"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 261-3314"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2022-05-20"
}
["list_office_name"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["list_price"]=>
array(1) {
[0]=>
string(9) "815000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "1549"
}
["location"]=>
array(1) {
[0]=>
string(51) "47-718 Hui Kelu Street Unit 1502, Kaneohe, HI 96744"
}
["maintenance_fees"]=>
array(1) {
[0]=>
string(6) "632.00"
}
["middle_school"]=>
array(1) {
[0]=>
string(4) "King"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202209668"
}
["neighborhood"]=>
array(1) {
[0]=>
string(13) "TEMPLE VALLEY"
}
["number_of_parking_spaces"]=>
array(1) {
[0]=>
string(1) "2"
}
["number_of_stories"]=>
array(1) {
[0]=>
string(3) "Two"
}
["office_mls_id"]=>
array(1) {
[0]=>
string(6) "CBPP04"
}
["parking_features"]=>
array(1) {
[0]=>
string(17) "Assigned,Open - 2"
}
["possession"]=>
array(1) {
[0]=>
string(42) "45 Days or Less,Early Occupancy,Negotiable"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96744"
}
["property_condition"]=>
array(1) {
[0]=>
string(23) "Above Average,Excellent"
}
["property_type"]=>
array(1) {
[0]=>
string(15) "condo_townhouse"
}
["property_type_label"]=>
array(1) {
[0]=>
string(15) "Condo Townhouse"
}
["region"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["rets_association_fee_total"]=>
array(1) {
[0]=>
string(3) "632"
}
["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_building_name"]=>
array(1) {
[0]=>
string(19) "Club View Gardens 2"
}
["rets_city"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["rets_condo_parking_unit"]=>
array(1) {
[0]=>
string(3) "1,2"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(9) "820000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(1) "6"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_elementary_school"]=>
array(1) {
[0]=>
string(8) "Ahuimanu"
}
["rets_floor_number"]=>
array(1) {
[0]=>
string(1) "1"
}
["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) "16657134"
}
["rets_immoviewer_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_internet_automated_valuation_dis"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_internet_consumer_comment_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_list_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 261-3314"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(25) "shari.hooks@cbpacific.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(13) "Shari M Hooks"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "43870"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "3483868"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(6) "CBPP04"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(7) "3484714"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 261-3314"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(9) "815000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2022-05-20"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(9) "919160.00"
}
["rets_maintenance_expense"]=>
array(1) {
[0]=>
string(6) "632.00"
}
["rets_management_company_name"]=>
array(1) {
[0]=>
string(13) "Hawaiian Prop"
}
["rets_management_company_phone"]=>
array(1) {
[0]=>
string(12) "808-539-9777"
}
["rets_matrix_modified_dt"]=>
array(1) {
[0]=>
string(23) "2022-06-28T15:16:28.123"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16657134"
}
["rets_middle_or_junior_school"]=>
array(1) {
[0]=>
string(4) "King"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202209668"
}
["rets_neighbourhood"]=>
array(1) {
[0]=>
string(13) "TEMPLE VALLEY"
}
["rets_new_development_construction_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_original_entry_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-05-19T20:49:36.500"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(9) "815000.00"
}
["rets_owner_occupancy_percentage"]=>
array(1) {
[0]=>
string(2) "80"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-4-7-004-027-0097"
}
["rets_parking_additional"]=>
array(1) {
[0]=>
string(1) "3"
}
["rets_parking_total"]=>
array(1) {
[0]=>
string(1) "2"
}
["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) "23"
}
["rets_photo_modification_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-05-21T10:58:59.820"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96744"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-05-21T11:19:15.793"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16657134"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(244) "Use Showingtime to schedule. Text Shari to inquire. Sold as-is. 7 day J-1. Include AS-IS and CB Standard. Show verification of funds even if 100% financed. Offers please by Wed 5/25 noon for reply no later than Thursday 7pm. Vacant-easy to see."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(1199) "Tucked away, stunningly remodeled throughout, high ceilings, looking out to tropical green flora, no neighbors behind... this most desirable floorplan offers spaciousness and privacy. Enter the front door to your personal haven. Open, airy, peaceful vibes. Enjoy nature views while chilling in AC. Deck lanai off dining room for easy grilling and enjoying the outdoors. Primary bedroom, full bath, two vanities on main level, opens to enclosed courtyard. Downstairs, two bedrooms, vinyl sliders, small lanais and luscious green yard space. Brand new water heater, newer windows & sliders throughout, split ACs just serviced, keep you cool and comfortable. Newer kitchen features wood cabinets, stainless steel, island, two pantries w/pull-outs, soft close, under cab lights. Newer washer and dryer, brand new luxury vinyl plank floor/moulding in all bedrooms, downstairs hallways. No carpet. Fenced courtyard in front, deck lanai off living/dining area, two small open lanais and plenty grass downstairs. Close to highways H-3, Likelike, Kaneohe MCBH. Dining, shopping, movies nearby. Community pool. Two parking spots plus guest and street parking for visitors. Turn-key opportunity, low maint fee."
}
["rets_sqft_lanai_open"]=>
array(1) {
[0]=>
string(3) "228"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "1321"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "1549"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-28T15:16:28.123"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2022-06-28"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(8) "Hui Kelu"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(6) "47-718"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(64) "1$21.438212$-157.833334$253.86$13.33$1.00$UNzsRyi1CmLx8vPWO9TRFQ"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(3) "2.5"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "183.00"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "2196.00"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "693900.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(9) "315200.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "378700.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_tax_paid_by_seller_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_tax_year"]=>
array(1) {
[0]=>
string(4) "2022"
}
["rets_thumbnail_url"]=>
array(1) {
[0]=>
string(81) "https://cdn.rets.ci/marcusrealty-images/16657134/ef07902cf07219675dcc908cdbcbb234"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "147"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(2) "97"
}
["rets_tmk_division"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tmk_parcel"]=>
array(1) {
[0]=>
string(2) "27"
}
["rets_tmk_section"]=>
array(1) {
[0]=>
string(1) "7"
}
["rets_tmk_zone"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_tmkplat"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_unit_number"]=>
array(1) {
[0]=>
string(4) "1502"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1974"
}
["rets_year_remodeled"]=>
array(1) {
[0]=>
string(4) "2020"
}
["security"]=>
array(1) {
[0]=>
string(3) "Key"
}
["state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["street_name"]=>
array(1) {
[0]=>
string(8) "Hui Kelu"
}
["street_number"]=>
array(1) {
[0]=>
string(6) "47-718"
}
["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-7-004-027-0097"
}
["unit"]=>
array(1) {
[0]=>
string(75) "ADA Accessible,Bedroom on 1st Level,Full Bath on 1st Floor,Multi Level,Yard"
}
["unit_number"]=>
array(1) {
[0]=>
string(4) "1502"
}
["view"]=>
array(1) {
[0]=>
string(6) "Garden"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16657134"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202209668"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1656465427"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1974"
}
["year_remodeled_"]=>
array(1) {
[0]=>
string(4) "2020"
}
["zoning"]=>
array(1) {
[0]=>
string(29) "05 - R-5 Residential District"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(3111) "a:189:{i:0;i:22273963;i:1;i:22273964;i:2;i:22273965;i:3;i:22273966;i:4;i:22273967;i:5;i:22273968;i:6;i:22273969;i:7;i:22273970;i:8;i:22273971;i:9;i:22273972;i:10;i:22273973;i:11;i:22273974;i:12;i:22273975;i:13;i:22273976;i:14;i:22273977;i:15;i:22273978;i:16;i:22273979;i:17;i:22273980;i:18;i:22273981;i:19;i:22273982;i:20;i:22273983;i:21;i:22274145;i:22;i:22274146;i:23;i:22274147;i:24;i:22274148;i:25;i:22274149;i:26;i:22274150;i:27;i:22274151;i:28;i:22274152;i:29;i:22274153;i:30;i:22274154;i:31;i:22274155;i:32;i:22274156;i:33;i:22274157;i:34;i:22274158;i:35;i:22274159;i:36;i:22274160;i:37;i:22274161;i:38;i:22274162;i:39;i:22274163;i:40;i:22274164;i:41;i:22274165;i:42;i:22274267;i:43;i:22274268;i:44;i:22274269;i:45;i:22274270;i:46;i:22274271;i:47;i:22274272;i:48;i:22274273;i:49;i:22274274;i:50;i:22274275;i:51;i:22274276;i:52;i:22274277;i:53;i:22274278;i:54;i:22274279;i:55;i:22274280;i:56;i:22274281;i:57;i:22274282;i:58;i:22274283;i:59;i:22274284;i:60;i:22274285;i:61;i:22274286;i:62;i:22274287;i:63;i:22280899;i:64;i:22280900;i:65;i:22280901;i:66;i:22280902;i:67;i:22280903;i:68;i:22280904;i:69;i:22280905;i:70;i:22280906;i:71;i:22280907;i:72;i:22280908;i:73;i:22280909;i:74;i:22280910;i:75;i:22280911;i:76;i:22280912;i:77;i:22280913;i:78;i:22280914;i:79;i:22280915;i:80;i:22280916;i:81;i:22280917;i:82;i:22280918;i:83;i:22280919;i:84;i:22289122;i:85;i:22289123;i:86;i:22289124;i:87;i:22289125;i:88;i:22289126;i:89;i:22289127;i:90;i:22289128;i:91;i:22289129;i:92;i:22289130;i:93;i:22289131;i:94;i:22289132;i:95;i:22289133;i:96;i:22289134;i:97;i:22289135;i:98;i:22289136;i:99;i:22289137;i:100;i:22289138;i:101;i:22289139;i:102;i:22289140;i:103;i:22289141;i:104;i:22289142;i:105;i:22293177;i:106;i:22293178;i:107;i:22293179;i:108;i:22293180;i:109;i:22293181;i:110;i:22293182;i:111;i:22293183;i:112;i:22293184;i:113;i:22293185;i:114;i:22293186;i:115;i:22293187;i:116;i:22293188;i:117;i:22293189;i:118;i:22293190;i:119;i:22293191;i:120;i:22293192;i:121;i:22293193;i:122;i:22293194;i:123;i:22293195;i:124;i:22293196;i:125;i:22293197;i:126;i:22308359;i:127;i:22308360;i:128;i:22308361;i:129;i:22308362;i:130;i:22308363;i:131;i:22308364;i:132;i:22308365;i:133;i:22308366;i:134;i:22308367;i:135;i:22308368;i:136;i:22308369;i:137;i:22308370;i:138;i:22308371;i:139;i:22308372;i:140;i:22308373;i:141;i:22308374;i:142;i:22308375;i:143;i:22308376;i:144;i:22308377;i:145;i:22308378;i:146;i:22308379;i:147;i:22308380;i:148;i:22308381;i:149;i:22308382;i:150;i:22308383;i:151;i:22308384;i:152;i:22308385;i:153;i:22308386;i:154;i:22308387;i:155;i:22308388;i:156;i:22308389;i:157;i:22308390;i:158;i:22308391;i:159;i:22308392;i:160;i:22308393;i:161;i:22308394;i:162;i:22308395;i:163;i:22308396;i:164;i:22308397;i:165;i:22308398;i:166;i:22308399;i:167;i:22308400;i:168;i:22569438;i:169;i:22569439;i:170;i:22569440;i:171;i:22569441;i:172;i:22569442;i:173;i:22569443;i:174;i:22569444;i:175;i:22569445;i:176;i:22569446;i:177;i:22569447;i:178;i:22569448;i:179;i:22569449;i:180;i:22569450;i:181;i:22569451;i:182;i:22569452;i:183;i:22569453;i:184;i:22569454;i:185;i:22569455;i:186;i:22569456;i:187;i:22569457;i:188;i:22569458;}"
}
["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-05-24T16:21:52.633"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2022-05-26"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2022-06-28"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(9) "820000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2023-05-20"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2022-06-28"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 261-1800"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(23) "WendyT@BetterHawaii.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(12) "Wendy N Tenn"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "26110"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(7) "3475831"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(6) "ADVG02"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(8) "10139093"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 261-1800"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "22569438"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 315200.00
)
[assd_val_land] => Array
(
[0] => 378700.00
)
[assd_val_total] => Array
(
[0] => 693900.00
)
[bedrooms] => Array
(
[0] => 3
)
[building_name] => Array
(
[0] => Club View Gardens 2
)
[building_style] => Array
(
[0] => Townhouse
)
[city] => Array
(
[0] => Kaneohe
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Pets Allowed (Verify),Property Disclosure Stmt
)
[elementary_school] => Array
(
[0] => Ahuimanu
)
[floor_covering] => Array
(
[0] => Ceramic Tile,Other,Vinyl
)
[frontage] => Array
(
[0] => Other
)
[full_baths] => Array
(
[0] => 2
)
[furnished] => Array
(
[0] => Partial
)
[half_baths] => Array
(
[0] => 0
)
[high_school] => Array
(
[0] => Castle
)
[home_exampt] => Array
(
[0] => 0
)
[lanai_sf] => Array
(
[0] => 228
)
[land_area_sf] => Array
(
[0] => 919160.00
)
[land_recorded] => Array
(
[0] => Land Court
)
[land_tenure] => Array
(
[0] => FS - Fee Simple
)
[list_agent_email] => Array
(
[0] => shari.hooks@cbpacific.com
)
[list_agent_name] => Array
(
[0] => Shari M Hooks
)
[list_agent_phone_number] => Array
(
[0] => (808) 261-3314
)
[list_date] => Array
(
[0] => 2022-05-20
)
[list_office_name] => Array
(
[0] => Coldwell Banker Realty
)
[list_price] => Array
(
[0] => 815000.00
)
[living_sf] => Array
(
[0] => 1549
)
[location] => Array
(
[0] => 47-718 Hui Kelu Street Unit 1502, Kaneohe, HI 96744
)
[maintenance_fees] => Array
(
[0] => 632.00
)
[middle_school] => Array
(
[0] => King
)
[mls_] => Array
(
[0] => 202209668
)
[neighborhood] => Array
(
[0] => TEMPLE VALLEY
)
[number_of_parking_spaces] => Array
(
[0] => 2
)
[number_of_stories] => Array
(
[0] => Two
)
[office_mls_id] => Array
(
[0] => CBPP04
)
[parking_features] => Array
(
[0] => Assigned,Open - 2
)
[possession] => Array
(
[0] => 45 Days or Less,Early Occupancy,Negotiable
)
[postal_code] => Array
(
[0] => 96744
)
[property_condition] => Array
(
[0] => Above Average,Excellent
)
[property_type] => Array
(
[0] => condo_townhouse
)
[property_type_label] => Array
(
[0] => Condo Townhouse
)
[region] => Array
(
[0] => Kaneohe
)
[rets_association_fee_total] => Array
(
[0] => 632
)
[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_building_name] => Array
(
[0] => Club View Gardens 2
)
[rets_city] => Array
(
[0] => Kaneohe
)
[rets_condo_parking_unit] => Array
(
[0] => 1,2
)
[rets_current_price] => Array
(
[0] => 820000.00
)
[rets_dom] => Array
(
[0] => 6
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_elementary_school] => Array
(
[0] => Ahuimanu
)
[rets_floor_number] => Array
(
[0] => 1
)
[rets_foreclosure_yn] => Array
(
[0] => 0
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_high_school] => Array
(
[0] => Castle
)
[rets_id] => Array
(
[0] => 16657134
)
[rets_immoviewer_yn] => Array
(
[0] => 0
)
[rets_internet_automated_valuation_dis] => Array
(
[0] => 0
)
[rets_internet_consumer_comment_yn] => Array
(
[0] => 0
)
[rets_list_agent_direct_work_phone] => Array
(
[0] => (808) 261-3314
)
[rets_list_agent_email] => Array
(
[0] => shari.hooks@cbpacific.com
)
[rets_list_agent_full_name] => Array
(
[0] => Shari M Hooks
)
[rets_list_agent_mlsid] => Array
(
[0] => 43870
)
[rets_list_agent_mui] => Array
(
[0] => 3483868
)
[rets_list_office_mlsid] => Array
(
[0] => CBPP04
)
[rets_list_office_mui] => Array
(
[0] => 3484714
)
[rets_list_office_name] => Array
(
[0] => Coldwell Banker Realty
)
[rets_list_office_phone] => Array
(
[0] => (808) 261-3314
)
[rets_list_price] => Array
(
[0] => 815000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2022-05-20
)
[rets_lot_size_area] => Array
(
[0] => 919160.00
)
[rets_maintenance_expense] => Array
(
[0] => 632.00
)
[rets_management_company_name] => Array
(
[0] => Hawaiian Prop
)
[rets_management_company_phone] => Array
(
[0] => 808-539-9777
)
[rets_matrix_modified_dt] => Array
(
[0] => 2022-06-28T15:16:28.123
)
[rets_matrix_unique_id] => Array
(
[0] => 16657134
)
[rets_middle_or_junior_school] => Array
(
[0] => King
)
[rets_mls_number] => Array
(
[0] => 202209668
)
[rets_neighbourhood] => Array
(
[0] => TEMPLE VALLEY
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2022-05-19T20:49:36.500
)
[rets_original_list_price] => Array
(
[0] => 815000.00
)
[rets_owner_occupancy_percentage] => Array
(
[0] => 80
)
[rets_parcel_number] => Array
(
[0] => 1-4-7-004-027-0097
)
[rets_parking_additional] => Array
(
[0] => 3
)
[rets_parking_total] => Array
(
[0] => 2
)
[rets_permit_address_internet_yn] => Array
(
[0] => 1
)
[rets_permit_internet_yn] => Array
(
[0] => 1
)
[rets_photo_count] => Array
(
[0] => 23
)
[rets_photo_modification_timestamp] => Array
(
[0] => 2022-05-21T10:58:59.820
)
[rets_postal_code] => Array
(
[0] => 96744
)
[rets_price_change_timestamp] => Array
(
[0] => 2022-05-21T11:19:15.793
)
[rets_primary_key] => Array
(
[0] => 16657134
)
[rets_private_remarks] => Array
(
[0] => Use Showingtime to schedule. Text Shari to inquire. Sold as-is. 7 day J-1. Include AS-IS and CB Standard. Show verification of funds even if 100% financed. Offers please by Wed 5/25 noon for reply no later than Thursday 7pm. Vacant-easy to see.
)
[rets_public_remarks] => Array
(
[0] => Tucked away, stunningly remodeled throughout, high ceilings, looking out to tropical green flora, no neighbors behind... this most desirable floorplan offers spaciousness and privacy. Enter the front door to your personal haven. Open, airy, peaceful vibes. Enjoy nature views while chilling in AC. Deck lanai off dining room for easy grilling and enjoying the outdoors. Primary bedroom, full bath, two vanities on main level, opens to enclosed courtyard. Downstairs, two bedrooms, vinyl sliders, small lanais and luscious green yard space. Brand new water heater, newer windows & sliders throughout, split ACs just serviced, keep you cool and comfortable. Newer kitchen features wood cabinets, stainless steel, island, two pantries w/pull-outs, soft close, under cab lights. Newer washer and dryer, brand new luxury vinyl plank floor/moulding in all bedrooms, downstairs hallways. No carpet. Fenced courtyard in front, deck lanai off living/dining area, two small open lanais and plenty grass downstairs. Close to highways H-3, Likelike, Kaneohe MCBH. Dining, shopping, movies nearby. Community pool. Two parking spots plus guest and street parking for visitors. Turn-key opportunity, low maint fee.
)
[rets_sqft_lanai_open] => Array
(
[0] => 228
)
[rets_sqft_roofed_living] => Array
(
[0] => 1321
)
[rets_sqft_total] => Array
(
[0] => 1549
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2022-06-28T15:16:28.123
)
[rets_status_contractual_search_date] => Array
(
[0] => 2022-06-28
)
[rets_street_name] => Array
(
[0] => Hui Kelu
)
[rets_street_number] => Array
(
[0] => 47-718
)
[rets_street_view_param] => Array
(
[0] => 1$21.438212$-157.833334$253.86$13.33$1.00$UNzsRyi1CmLx8vPWO9TRFQ
)
[rets_sub_agency_compensation] => Array
(
[0] => 2.5
)
[rets_tax_amount] => Array
(
[0] => 183.00
)
[rets_tax_annual_amount] => Array
(
[0] => 2196.00
)
[rets_tax_assessed_value] => Array
(
[0] => 693900.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 315200.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 378700.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 0
)
[rets_tax_paid_by_seller_yn] => Array
(
[0] => 0
)
[rets_tax_year] => Array
(
[0] => 2022
)
[rets_thumbnail_url] => Array
(
[0] => https://cdn.rets.ci/marcusrealty-images/16657134/ef07902cf07219675dcc908cdbcbb234
)
[rets_tmk_area] => Array
(
[0] => 147
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 97
)
[rets_tmk_division] => Array
(
[0] => 1
)
[rets_tmk_parcel] => Array
(
[0] => 27
)
[rets_tmk_section] => Array
(
[0] => 7
)
[rets_tmk_zone] => Array
(
[0] => 4
)
[rets_tmkplat] => Array
(
[0] => 4
)
[rets_unit_number] => Array
(
[0] => 1502
)
[rets_year_built] => Array
(
[0] => 1974
)
[rets_year_remodeled] => Array
(
[0] => 2020
)
[security] => Array
(
[0] => Key
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Hui Kelu
)
[street_number] => Array
(
[0] => 47-718
)
[street_suffix] => Array
(
[0] => Street
)
[terms_accept] => Array
(
[0] => Cash,Conventional,VA
)
[tmk] => Array
(
[0] => 1-4-7-004-027-0097
)
[unit] => Array
(
[0] => ADA Accessible,Bedroom on 1st Level,Full Bath on 1st Floor,Multi Level,Yard
)
[unit_number] => Array
(
[0] => 1502
)
[view] => Array
(
[0] => Garden
)
[wpp::rets_pk] => Array
(
[0] => 16657134
)
[wpp_gpid] => Array
(
[0] => 202209668
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1656465427
)
[year_built] => Array
(
[0] => 1974
)
[year_remodeled_] => Array
(
[0] => 2020
)
[zoning] => Array
(
[0] => 05 - R-5 Residential District
)
[new_attached_media] => Array
(
[0] => a:189:{i:0;i:22273963;i:1;i:22273964;i:2;i:22273965;i:3;i:22273966;i:4;i:22273967;i:5;i:22273968;i:6;i:22273969;i:7;i:22273970;i:8;i:22273971;i:9;i:22273972;i:10;i:22273973;i:11;i:22273974;i:12;i:22273975;i:13;i:22273976;i:14;i:22273977;i:15;i:22273978;i:16;i:22273979;i:17;i:22273980;i:18;i:22273981;i:19;i:22273982;i:20;i:22273983;i:21;i:22274145;i:22;i:22274146;i:23;i:22274147;i:24;i:22274148;i:25;i:22274149;i:26;i:22274150;i:27;i:22274151;i:28;i:22274152;i:29;i:22274153;i:30;i:22274154;i:31;i:22274155;i:32;i:22274156;i:33;i:22274157;i:34;i:22274158;i:35;i:22274159;i:36;i:22274160;i:37;i:22274161;i:38;i:22274162;i:39;i:22274163;i:40;i:22274164;i:41;i:22274165;i:42;i:22274267;i:43;i:22274268;i:44;i:22274269;i:45;i:22274270;i:46;i:22274271;i:47;i:22274272;i:48;i:22274273;i:49;i:22274274;i:50;i:22274275;i:51;i:22274276;i:52;i:22274277;i:53;i:22274278;i:54;i:22274279;i:55;i:22274280;i:56;i:22274281;i:57;i:22274282;i:58;i:22274283;i:59;i:22274284;i:60;i:22274285;i:61;i:22274286;i:62;i:22274287;i:63;i:22280899;i:64;i:22280900;i:65;i:22280901;i:66;i:22280902;i:67;i:22280903;i:68;i:22280904;i:69;i:22280905;i:70;i:22280906;i:71;i:22280907;i:72;i:22280908;i:73;i:22280909;i:74;i:22280910;i:75;i:22280911;i:76;i:22280912;i:77;i:22280913;i:78;i:22280914;i:79;i:22280915;i:80;i:22280916;i:81;i:22280917;i:82;i:22280918;i:83;i:22280919;i:84;i:22289122;i:85;i:22289123;i:86;i:22289124;i:87;i:22289125;i:88;i:22289126;i:89;i:22289127;i:90;i:22289128;i:91;i:22289129;i:92;i:22289130;i:93;i:22289131;i:94;i:22289132;i:95;i:22289133;i:96;i:22289134;i:97;i:22289135;i:98;i:22289136;i:99;i:22289137;i:100;i:22289138;i:101;i:22289139;i:102;i:22289140;i:103;i:22289141;i:104;i:22289142;i:105;i:22293177;i:106;i:22293178;i:107;i:22293179;i:108;i:22293180;i:109;i:22293181;i:110;i:22293182;i:111;i:22293183;i:112;i:22293184;i:113;i:22293185;i:114;i:22293186;i:115;i:22293187;i:116;i:22293188;i:117;i:22293189;i:118;i:22293190;i:119;i:22293191;i:120;i:22293192;i:121;i:22293193;i:122;i:22293194;i:123;i:22293195;i:124;i:22293196;i:125;i:22293197;i:126;i:22308359;i:127;i:22308360;i:128;i:22308361;i:129;i:22308362;i:130;i:22308363;i:131;i:22308364;i:132;i:22308365;i:133;i:22308366;i:134;i:22308367;i:135;i:22308368;i:136;i:22308369;i:137;i:22308370;i:138;i:22308371;i:139;i:22308372;i:140;i:22308373;i:141;i:22308374;i:142;i:22308375;i:143;i:22308376;i:144;i:22308377;i:145;i:22308378;i:146;i:22308379;i:147;i:22308380;i:148;i:22308381;i:149;i:22308382;i:150;i:22308383;i:151;i:22308384;i:152;i:22308385;i:153;i:22308386;i:154;i:22308387;i:155;i:22308388;i:156;i:22308389;i:157;i:22308390;i:158;i:22308391;i:159;i:22308392;i:160;i:22308393;i:161;i:22308394;i:162;i:22308395;i:163;i:22308396;i:164;i:22308397;i:165;i:22308398;i:166;i:22308399;i:167;i:22308400;i:168;i:22569438;i:169;i:22569439;i:170;i:22569440;i:171;i:22569441;i:172;i:22569442;i:173;i:22569443;i:174;i:22569444;i:175;i:22569445;i:176;i:22569446;i:177;i:22569447;i:178;i:22569448;i:179;i:22569449;i:180;i:22569450;i:181;i:22569451;i:182;i:22569452;i:183;i:22569453;i:184;i:22569454;i:185;i:22569455;i:186;i:22569456;i:187;i:22569457;i:188;i:22569458;}
)
[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-05-24T16:21:52.633
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2022-05-26
)
[rets_close_date] => Array
(
[0] => 2022-06-28
)
[rets_close_price] => Array
(
[0] => 820000.00
)
[rets_expiration_date] => Array
(
[0] => 2023-05-20
)
[rets_off_market_date] => Array
(
[0] => 2022-06-28
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 261-1800
)
[rets_selling_agent_email] => Array
(
[0] => WendyT@BetterHawaii.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Wendy N Tenn
)
[rets_selling_agent_mlsid] => Array
(
[0] => 26110
)
[rets_selling_agent_mui] => Array
(
[0] => 3475831
)
[rets_selling_office_mlsid] => Array
(
[0] => ADVG02
)
[rets_selling_office_mui] => Array
(
[0] => 10139093
)
[rets_selling_office_name] => Array
(
[0] => BHGRE Advantage Realty
)
[rets_selling_office_phone] => Array
(
[0] => (808) 261-1800
)
[_thumbnail_id] => Array
(
[0] => 22569438
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446