Enjoy this wonderful 3/2 spacious and airy end unit. This townhome boasts vaulted ceilings, two large lanais: one that is enclosed off the primary bedroom; great for a garden or for pets, and another lanai off the living room that has spectacular views of the Ko’olau mountains, and two assigned parking nearby. Main level has primary bedroom, bathroom, living room, dining room, and kitchen. Downstairs has two bedrooms, bathroom, and an unfinished basement for extra space potential. Amenities include pool, clubhouse and site manager. The community is close to grocery store, restaurants, shopping, and H3 freeway. First Open House Sunday October 3rd 2-5 pm
Listing by: Engel & Volkers-Honolulu
array(158) {
["assd_val_imprv"]=>
array(1) {
[0]=>
string(8) "29100.00"
}
["assd_val_land"]=>
array(1) {
[0]=>
string(9) "546100.00"
}
["assd_val_total"]=>
array(1) {
[0]=>
string(9) "575200.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(32) "No Unit Above or Below,Townhouse"
}
["city"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["county"]=>
array(1) {
[0]=>
string(4) "Oahu"
}
["disclosures"]=>
array(1) {
[0]=>
string(24) "Property Disclosure Stmt"
}
["floor_covering"]=>
array(1) {
[0]=>
string(21) "Ceramic Tile,Hardwood"
}
["full_baths"]=>
array(1) {
[0]=>
string(1) "2"
}
["half_baths"]=>
array(1) {
[0]=>
string(1) "0"
}
["home_exampt"]=>
array(1) {
[0]=>
string(1) "0"
}
["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(31) "joeyann.staggs@evrealestate.com"
}
["list_agent_name"]=>
array(1) {
[0]=>
string(15) "Joey Ann Staggs"
}
["list_agent_phone_number"]=>
array(1) {
[0]=>
string(14) "(808) 369-8880"
}
["list_date"]=>
array(1) {
[0]=>
string(10) "2021-09-28"
}
["list_office_name"]=>
array(1) {
[0]=>
string(24) "Engel & Volkers-Honolulu"
}
["list_price"]=>
array(1) {
[0]=>
string(9) "705000.00"
}
["living_sf"]=>
array(1) {
[0]=>
string(4) "1321"
}
["location"]=>
array(1) {
[0]=>
string(48) "47-736 Hui Kelu Street Unit 1, Kaneohe, HI 96744"
}
["maintenance_fees"]=>
array(1) {
[0]=>
string(6) "579.19"
}
["mls_"]=>
array(1) {
[0]=>
string(9) "202124638"
}
["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) "PPRO03"
}
["parking_features"]=>
array(1) {
[0]=>
string(21) "Assigned,Guest,Street"
}
["possession"]=>
array(1) {
[0]=>
string(10) "At Closing"
}
["postal_code"]=>
array(1) {
[0]=>
string(5) "96744"
}
["property_condition"]=>
array(1) {
[0]=>
string(21) "Above Average,Average"
}
["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_2"]=>
array(1) {
[0]=>
string(2) "42"
}
["rets_association_fee_total"]=>
array(1) {
[0]=>
string(3) "621"
}
["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(6) "63, 64"
}
["rets_current_price"]=>
array(1) {
[0]=>
string(9) "730000.00"
}
["rets_dom"]=>
array(1) {
[0]=>
string(1) "8"
}
["rets_dual_variable_compensation_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_floor_number"]=>
array(1) {
[0]=>
string(1) "2"
}
["rets_fractional_ownership_yn"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_id"]=>
array(1) {
[0]=>
string(8) "16183825"
}
["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) 369-8880"
}
["rets_list_agent_email"]=>
array(1) {
[0]=>
string(31) "joeyann.staggs@evrealestate.com"
}
["rets_list_agent_full_name"]=>
array(1) {
[0]=>
string(15) "Joey Ann Staggs"
}
["rets_list_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "42420"
}
["rets_list_agent_mui"]=>
array(1) {
[0]=>
string(7) "3482959"
}
["rets_list_office_mlsid"]=>
array(1) {
[0]=>
string(6) "PPRO03"
}
["rets_list_office_mui"]=>
array(1) {
[0]=>
string(8) "15514808"
}
["rets_list_office_name"]=>
array(1) {
[0]=>
string(24) "Engel & Volkers-Honolulu"
}
["rets_list_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 369-8880"
}
["rets_list_price"]=>
array(1) {
[0]=>
string(9) "705000.00"
}
["rets_listing_contract_date"]=>
array(1) {
[0]=>
string(10) "2021-09-28"
}
["rets_lock_box_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_lot_size_area"]=>
array(1) {
[0]=>
string(9) "919160.00"
}
["rets_maintenance_expense"]=>
array(1) {
[0]=>
string(6) "579.19"
}
["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) "2021-10-29T10:17:11.433"
}
["rets_matrix_unique_id"]=>
array(1) {
[0]=>
string(8) "16183825"
}
["rets_mls_number"]=>
array(1) {
[0]=>
string(9) "202124638"
}
["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) "2021-09-28T07:04:08.800"
}
["rets_original_list_price"]=>
array(1) {
[0]=>
string(9) "705000.00"
}
["rets_owner_occupancy_percentage"]=>
array(1) {
[0]=>
string(2) "74"
}
["rets_parcel_number"]=>
array(1) {
[0]=>
string(18) "1-4-7-004-027-0001"
}
["rets_parking_additional"]=>
array(1) {
[0]=>
string(1) "0"
}
["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) "2021-09-28T07:04:08.800"
}
["rets_postal_code"]=>
array(1) {
[0]=>
string(5) "96744"
}
["rets_price_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2021-09-28T07:04:08.800"
}
["rets_primary_key"]=>
array(1) {
[0]=>
string(8) "16183825"
}
["rets_private_remarks"]=>
array(1) {
[0]=>
string(326) "EZ to show. Use Showing Time. Broker's Open Thursday Sept 30 10:30-12:30 pm. Deadline for offers: Tuesday Oct 5th 12pm. Please see supplements for As Is Add and LBP Add. Maintenance fee is $579.19 and there is a $254.74 bi annual association fee for pool & clubhouse area. Please call agent for Seller's preferences for offer."
}
["rets_public_remarks"]=>
array(1) {
[0]=>
string(660) "Enjoy this wonderful 3/2 spacious and airy end unit. This townhome boasts vaulted ceilings, two large lanais: one that is enclosed off the primary bedroom; great for a garden or for pets, and another lanai off the living room that has spectacular views of the Ko'olau mountains, and two assigned parking nearby. Main level has primary bedroom, bathroom, living room, dining room, and kitchen. Downstairs has two bedrooms, bathroom, and an unfinished basement for extra space potential. Amenities include pool, clubhouse and site manager. The community is close to grocery store, restaurants, shopping, and H3 freeway. First Open House Sunday October 3rd 2-5 pm"
}
["rets_public_report_number"]=>
array(1) {
[0]=>
string(3) "425"
}
["rets_sqft_roofed_living"]=>
array(1) {
[0]=>
string(4) "1321"
}
["rets_sqft_total"]=>
array(1) {
[0]=>
string(4) "1321"
}
["rets_state_or_province"]=>
array(1) {
[0]=>
string(2) "HI"
}
["rets_status_change_timestamp"]=>
array(1) {
[0]=>
string(23) "2021-10-29T10:17:11.433"
}
["rets_status_contractual_search_date"]=>
array(1) {
[0]=>
string(10) "2021-10-29"
}
["rets_street_name"]=>
array(1) {
[0]=>
string(8) "Hui Kelu"
}
["rets_street_number"]=>
array(1) {
[0]=>
string(6) "47-736"
}
["rets_street_view_param"]=>
array(1) {
[0]=>
string(64) "1$21.438505$-157.832836$268.28$13.33$1.00$vJ4Xbsm9ZdH3AEbrmf2hBQ"
}
["rets_sub_agency_compensation"]=>
array(1) {
[0]=>
string(2) "2%"
}
["rets_supplement_count"]=>
array(1) {
[0]=>
string(1) "4"
}
["rets_supplement_modification_timestam"]=>
array(1) {
[0]=>
string(23) "2021-09-28T15:17:13.490"
}
["rets_tax_amount"]=>
array(1) {
[0]=>
string(6) "167.77"
}
["rets_tax_assessed_value"]=>
array(1) {
[0]=>
string(9) "575200.00"
}
["rets_tax_assessed_value_improvements"]=>
array(1) {
[0]=>
string(8) "29100.00"
}
["rets_tax_assessed_value_land"]=>
array(1) {
[0]=>
string(9) "546100.00"
}
["rets_tax_excemption_owner_occupancy"]=>
array(1) {
[0]=>
string(1) "0"
}
["rets_tax_paid_by_seller_yn"]=>
array(1) {
[0]=>
string(1) "1"
}
["rets_tax_year"]=>
array(1) {
[0]=>
string(4) "2021"
}
["rets_thumbnail_url"]=>
array(1) {
[0]=>
string(81) "https://cdn.rets.ci/marcusrealty-images/16183825/098aaf3dda1a415f4cea2c7ff33b0697"
}
["rets_tmk_area"]=>
array(1) {
[0]=>
string(3) "147"
}
["rets_tmk_condo_property_regime_number"]=>
array(1) {
[0]=>
string(1) "1"
}
["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(1) "1"
}
["rets_year_built"]=>
array(1) {
[0]=>
string(4) "1974"
}
["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-736"
}
["street_suffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["terms_accept"]=>
array(1) {
[0]=>
string(35) "Cash,Conventional,USDA Financing,VA"
}
["tmk"]=>
array(1) {
[0]=>
string(18) "1-4-7-004-027-0001"
}
["unit"]=>
array(1) {
[0]=>
string(59) "Bedroom on 1st Level,Corner/End,Full Bath on 1st Floor,Yard"
}
["unit_number"]=>
array(1) {
[0]=>
string(1) "1"
}
["view"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["wpp::rets_pk"]=>
array(1) {
[0]=>
string(8) "16183825"
}
["wpp_gpid"]=>
array(1) {
[0]=>
string(9) "202124638"
}
["wpp_import_schedule_id"]=>
array(1) {
[0]=>
string(10) "1463343682"
}
["wpp_import_time"]=>
array(1) {
[0]=>
string(10) "1635538680"
}
["year_built"]=>
array(1) {
[0]=>
string(4) "1974"
}
["zoning"]=>
array(1) {
[0]=>
string(29) "05 - R-5 Residential District"
}
["new_attached_media"]=>
array(1) {
[0]=>
string(2363) "a:145:{i:0;i:20850529;i:1;i:20850530;i:2;i:20850531;i:3;i:20850532;i:4;i:20850533;i:5;i:20850534;i:6;i:20850535;i:7;i:20850536;i:8;i:20850537;i:9;i:20850538;i:10;i:20850539;i:11;i:20850540;i:12;i:20850541;i:13;i:20850542;i:14;i:20850543;i:15;i:20850544;i:16;i:20850545;i:17;i:20850546;i:18;i:20850547;i:19;i:20854080;i:20;i:20854081;i:21;i:20854082;i:22;i:20854083;i:23;i:20854084;i:24;i:20854085;i:25;i:20854086;i:26;i:20854087;i:27;i:20854088;i:28;i:20854089;i:29;i:20854090;i:30;i:20854091;i:31;i:20854092;i:32;i:20854093;i:33;i:20854094;i:34;i:20854095;i:35;i:20854096;i:36;i:20854097;i:37;i:20854098;i:38;i:20854099;i:39;i:20854100;i:40;i:20854155;i:41;i:20854156;i:42;i:20854157;i:43;i:20854158;i:44;i:20854159;i:45;i:20854160;i:46;i:20854161;i:47;i:20854162;i:48;i:20854163;i:49;i:20854164;i:50;i:20854165;i:51;i:20854166;i:52;i:20854167;i:53;i:20854168;i:54;i:20854169;i:55;i:20854170;i:56;i:20854171;i:57;i:20854172;i:58;i:20854173;i:59;i:20854174;i:60;i:20854175;i:61;i:20855663;i:62;i:20855664;i:63;i:20855665;i:64;i:20855666;i:65;i:20855667;i:66;i:20855668;i:67;i:20855669;i:68;i:20855670;i:69;i:20855671;i:70;i:20855672;i:71;i:20855673;i:72;i:20855674;i:73;i:20855675;i:74;i:20855676;i:75;i:20855677;i:76;i:20855678;i:77;i:20855679;i:78;i:20855680;i:79;i:20855681;i:80;i:20855682;i:81;i:20855683;i:82;i:20856247;i:83;i:20856248;i:84;i:20856249;i:85;i:20856250;i:86;i:20856251;i:87;i:20856252;i:88;i:20856253;i:89;i:20856254;i:90;i:20856255;i:91;i:20856256;i:92;i:20856257;i:93;i:20856258;i:94;i:20856259;i:95;i:20856260;i:96;i:20856261;i:97;i:20856262;i:98;i:20856263;i:99;i:20856264;i:100;i:20856265;i:101;i:20856266;i:102;i:20856267;i:103;i:20913572;i:104;i:20913573;i:105;i:20913574;i:106;i:20913575;i:107;i:20913576;i:108;i:20913577;i:109;i:20913578;i:110;i:20913579;i:111;i:20913580;i:112;i:20913581;i:113;i:20913582;i:114;i:20913583;i:115;i:20913584;i:116;i:20913585;i:117;i:20913586;i:118;i:20913587;i:119;i:20913588;i:120;i:20913589;i:121;i:20913590;i:122;i:20913591;i:123;i:20913592;i:124;i:21057831;i:125;i:21057832;i:126;i:21057833;i:127;i:21057834;i:128;i:21057835;i:129;i:21057836;i:130;i:21057837;i:131;i:21057838;i:132;i:21057839;i:133;i:21057840;i:134;i:21057841;i:135;i:21057842;i:136;i:21057843;i:137;i:21057844;i:138;i:21057845;i:139;i:21057846;i:140;i:21057847;i:141;i:21057848;i:142;i:21057849;i:143;i:21057850;i:144;i:21057851;}"
}
["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_virtual_tour_url_unbranded"]=>
array(1) {
[0]=>
string(40) "https://player.vimeo.com/video/617526080"
}
["virtual_tour"]=>
array(1) {
[0]=>
string(40) "https://player.vimeo.com/video/617526080"
}
["rets_active_continue_to_show_date"]=>
array(1) {
[0]=>
string(10) "2021-10-05"
}
["rets_close_date"]=>
array(1) {
[0]=>
string(10) "2021-10-29"
}
["rets_close_price"]=>
array(1) {
[0]=>
string(9) "730000.00"
}
["rets_expiration_date"]=>
array(1) {
[0]=>
string(10) "2022-09-27"
}
["rets_off_market_date"]=>
array(1) {
[0]=>
string(10) "2021-10-29"
}
["rets_selling_agent_direct_work_phone"]=>
array(1) {
[0]=>
string(14) "(808) 371-3509"
}
["rets_selling_agent_email"]=>
array(1) {
[0]=>
string(21) "mateodubs@hotmail.com"
}
["rets_selling_agent_full_name"]=>
array(1) {
[0]=>
string(15) "Matthew DuBrule"
}
["rets_selling_agent_mlsid"]=>
array(1) {
[0]=>
string(5) "25279"
}
["rets_selling_agent_mui"]=>
array(1) {
[0]=>
string(8) "10538530"
}
["rets_selling_office_mlsid"]=>
array(1) {
[0]=>
string(4) "HRCT"
}
["rets_selling_office_mui"]=>
array(1) {
[0]=>
string(8) "12644575"
}
["rets_selling_office_name"]=>
array(1) {
[0]=>
string(28) "Harcourts Island Real Estate"
}
["rets_selling_office_phone"]=>
array(1) {
[0]=>
string(14) "(808) 371-3509"
}
["rets_tax_annual_amount"]=>
array(1) {
[0]=>
string(7) "2013.24"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "21057831"
}
}
Array
(
[assd_val_imprv] => Array
(
[0] => 29100.00
)
[assd_val_land] => Array
(
[0] => 546100.00
)
[assd_val_total] => Array
(
[0] => 575200.00
)
[bedrooms] => Array
(
[0] => 3
)
[building_name] => Array
(
[0] => Club View Gardens 2
)
[building_style] => Array
(
[0] => No Unit Above or Below,Townhouse
)
[city] => Array
(
[0] => Kaneohe
)
[county] => Array
(
[0] => Oahu
)
[disclosures] => Array
(
[0] => Property Disclosure Stmt
)
[floor_covering] => Array
(
[0] => Ceramic Tile,Hardwood
)
[full_baths] => Array
(
[0] => 2
)
[half_baths] => Array
(
[0] => 0
)
[home_exampt] => Array
(
[0] => 0
)
[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] => joeyann.staggs@evrealestate.com
)
[list_agent_name] => Array
(
[0] => Joey Ann Staggs
)
[list_agent_phone_number] => Array
(
[0] => (808) 369-8880
)
[list_date] => Array
(
[0] => 2021-09-28
)
[list_office_name] => Array
(
[0] => Engel & Volkers-Honolulu
)
[list_price] => Array
(
[0] => 705000.00
)
[living_sf] => Array
(
[0] => 1321
)
[location] => Array
(
[0] => 47-736 Hui Kelu Street Unit 1, Kaneohe, HI 96744
)
[maintenance_fees] => Array
(
[0] => 579.19
)
[mls_] => Array
(
[0] => 202124638
)
[neighborhood] => Array
(
[0] => TEMPLE VALLEY
)
[number_of_parking_spaces] => Array
(
[0] => 2
)
[number_of_stories] => Array
(
[0] => Two
)
[office_mls_id] => Array
(
[0] => PPRO03
)
[parking_features] => Array
(
[0] => Assigned,Guest,Street
)
[possession] => Array
(
[0] => At Closing
)
[postal_code] => Array
(
[0] => 96744
)
[property_condition] => Array
(
[0] => Above Average,Average
)
[property_type] => Array
(
[0] => condo_townhouse
)
[property_type_label] => Array
(
[0] => Condo Townhouse
)
[region] => Array
(
[0] => Kaneohe
)
[rets_association_fee_2] => Array
(
[0] => 42
)
[rets_association_fee_total] => Array
(
[0] => 621
)
[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] => 63, 64
)
[rets_current_price] => Array
(
[0] => 730000.00
)
[rets_dom] => Array
(
[0] => 8
)
[rets_dual_variable_compensation_yn] => Array
(
[0] => 0
)
[rets_floor_number] => Array
(
[0] => 2
)
[rets_fractional_ownership_yn] => Array
(
[0] => 0
)
[rets_id] => Array
(
[0] => 16183825
)
[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) 369-8880
)
[rets_list_agent_email] => Array
(
[0] => joeyann.staggs@evrealestate.com
)
[rets_list_agent_full_name] => Array
(
[0] => Joey Ann Staggs
)
[rets_list_agent_mlsid] => Array
(
[0] => 42420
)
[rets_list_agent_mui] => Array
(
[0] => 3482959
)
[rets_list_office_mlsid] => Array
(
[0] => PPRO03
)
[rets_list_office_mui] => Array
(
[0] => 15514808
)
[rets_list_office_name] => Array
(
[0] => Engel & Volkers-Honolulu
)
[rets_list_office_phone] => Array
(
[0] => (808) 369-8880
)
[rets_list_price] => Array
(
[0] => 705000.00
)
[rets_listing_contract_date] => Array
(
[0] => 2021-09-28
)
[rets_lock_box_yn] => Array
(
[0] => 1
)
[rets_lot_size_area] => Array
(
[0] => 919160.00
)
[rets_maintenance_expense] => Array
(
[0] => 579.19
)
[rets_management_company_name] => Array
(
[0] => Hawaiian Prop
)
[rets_management_company_phone] => Array
(
[0] => 808-539-9777
)
[rets_matrix_modified_dt] => Array
(
[0] => 2021-10-29T10:17:11.433
)
[rets_matrix_unique_id] => Array
(
[0] => 16183825
)
[rets_mls_number] => Array
(
[0] => 202124638
)
[rets_neighbourhood] => Array
(
[0] => TEMPLE VALLEY
)
[rets_new_development_construction_yn] => Array
(
[0] => 0
)
[rets_original_entry_timestamp] => Array
(
[0] => 2021-09-28T07:04:08.800
)
[rets_original_list_price] => Array
(
[0] => 705000.00
)
[rets_owner_occupancy_percentage] => Array
(
[0] => 74
)
[rets_parcel_number] => Array
(
[0] => 1-4-7-004-027-0001
)
[rets_parking_additional] => Array
(
[0] => 0
)
[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] => 2021-09-28T07:04:08.800
)
[rets_postal_code] => Array
(
[0] => 96744
)
[rets_price_change_timestamp] => Array
(
[0] => 2021-09-28T07:04:08.800
)
[rets_primary_key] => Array
(
[0] => 16183825
)
[rets_private_remarks] => Array
(
[0] => EZ to show. Use Showing Time. Broker's Open Thursday Sept 30 10:30-12:30 pm. Deadline for offers: Tuesday Oct 5th 12pm. Please see supplements for As Is Add and LBP Add. Maintenance fee is $579.19 and there is a $254.74 bi annual association fee for pool & clubhouse area. Please call agent for Seller's preferences for offer.
)
[rets_public_remarks] => Array
(
[0] => Enjoy this wonderful 3/2 spacious and airy end unit. This townhome boasts vaulted ceilings, two large lanais: one that is enclosed off the primary bedroom; great for a garden or for pets, and another lanai off the living room that has spectacular views of the Ko'olau mountains, and two assigned parking nearby. Main level has primary bedroom, bathroom, living room, dining room, and kitchen. Downstairs has two bedrooms, bathroom, and an unfinished basement for extra space potential. Amenities include pool, clubhouse and site manager. The community is close to grocery store, restaurants, shopping, and H3 freeway. First Open House Sunday October 3rd 2-5 pm
)
[rets_public_report_number] => Array
(
[0] => 425
)
[rets_sqft_roofed_living] => Array
(
[0] => 1321
)
[rets_sqft_total] => Array
(
[0] => 1321
)
[rets_state_or_province] => Array
(
[0] => HI
)
[rets_status_change_timestamp] => Array
(
[0] => 2021-10-29T10:17:11.433
)
[rets_status_contractual_search_date] => Array
(
[0] => 2021-10-29
)
[rets_street_name] => Array
(
[0] => Hui Kelu
)
[rets_street_number] => Array
(
[0] => 47-736
)
[rets_street_view_param] => Array
(
[0] => 1$21.438505$-157.832836$268.28$13.33$1.00$vJ4Xbsm9ZdH3AEbrmf2hBQ
)
[rets_sub_agency_compensation] => Array
(
[0] => 2%
)
[rets_supplement_count] => Array
(
[0] => 4
)
[rets_supplement_modification_timestam] => Array
(
[0] => 2021-09-28T15:17:13.490
)
[rets_tax_amount] => Array
(
[0] => 167.77
)
[rets_tax_assessed_value] => Array
(
[0] => 575200.00
)
[rets_tax_assessed_value_improvements] => Array
(
[0] => 29100.00
)
[rets_tax_assessed_value_land] => Array
(
[0] => 546100.00
)
[rets_tax_excemption_owner_occupancy] => Array
(
[0] => 0
)
[rets_tax_paid_by_seller_yn] => Array
(
[0] => 1
)
[rets_tax_year] => Array
(
[0] => 2021
)
[rets_thumbnail_url] => Array
(
[0] => https://cdn.rets.ci/marcusrealty-images/16183825/098aaf3dda1a415f4cea2c7ff33b0697
)
[rets_tmk_area] => Array
(
[0] => 147
)
[rets_tmk_condo_property_regime_number] => Array
(
[0] => 1
)
[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] => 1
)
[rets_year_built] => Array
(
[0] => 1974
)
[state_or_province] => Array
(
[0] => HI
)
[status] => Array
(
[0] => Sold
)
[street_name] => Array
(
[0] => Hui Kelu
)
[street_number] => Array
(
[0] => 47-736
)
[street_suffix] => Array
(
[0] => Street
)
[terms_accept] => Array
(
[0] => Cash,Conventional,USDA Financing,VA
)
[tmk] => Array
(
[0] => 1-4-7-004-027-0001
)
[unit] => Array
(
[0] => Bedroom on 1st Level,Corner/End,Full Bath on 1st Floor,Yard
)
[unit_number] => Array
(
[0] => 1
)
[view] => Array
(
[0] => Mountain
)
[wpp::rets_pk] => Array
(
[0] => 16183825
)
[wpp_gpid] => Array
(
[0] => 202124638
)
[wpp_import_schedule_id] => Array
(
[0] => 1463343682
)
[wpp_import_time] => Array
(
[0] => 1635538680
)
[year_built] => Array
(
[0] => 1974
)
[zoning] => Array
(
[0] => 05 - R-5 Residential District
)
[new_attached_media] => Array
(
[0] => a:145:{i:0;i:20850529;i:1;i:20850530;i:2;i:20850531;i:3;i:20850532;i:4;i:20850533;i:5;i:20850534;i:6;i:20850535;i:7;i:20850536;i:8;i:20850537;i:9;i:20850538;i:10;i:20850539;i:11;i:20850540;i:12;i:20850541;i:13;i:20850542;i:14;i:20850543;i:15;i:20850544;i:16;i:20850545;i:17;i:20850546;i:18;i:20850547;i:19;i:20854080;i:20;i:20854081;i:21;i:20854082;i:22;i:20854083;i:23;i:20854084;i:24;i:20854085;i:25;i:20854086;i:26;i:20854087;i:27;i:20854088;i:28;i:20854089;i:29;i:20854090;i:30;i:20854091;i:31;i:20854092;i:32;i:20854093;i:33;i:20854094;i:34;i:20854095;i:35;i:20854096;i:36;i:20854097;i:37;i:20854098;i:38;i:20854099;i:39;i:20854100;i:40;i:20854155;i:41;i:20854156;i:42;i:20854157;i:43;i:20854158;i:44;i:20854159;i:45;i:20854160;i:46;i:20854161;i:47;i:20854162;i:48;i:20854163;i:49;i:20854164;i:50;i:20854165;i:51;i:20854166;i:52;i:20854167;i:53;i:20854168;i:54;i:20854169;i:55;i:20854170;i:56;i:20854171;i:57;i:20854172;i:58;i:20854173;i:59;i:20854174;i:60;i:20854175;i:61;i:20855663;i:62;i:20855664;i:63;i:20855665;i:64;i:20855666;i:65;i:20855667;i:66;i:20855668;i:67;i:20855669;i:68;i:20855670;i:69;i:20855671;i:70;i:20855672;i:71;i:20855673;i:72;i:20855674;i:73;i:20855675;i:74;i:20855676;i:75;i:20855677;i:76;i:20855678;i:77;i:20855679;i:78;i:20855680;i:79;i:20855681;i:80;i:20855682;i:81;i:20855683;i:82;i:20856247;i:83;i:20856248;i:84;i:20856249;i:85;i:20856250;i:86;i:20856251;i:87;i:20856252;i:88;i:20856253;i:89;i:20856254;i:90;i:20856255;i:91;i:20856256;i:92;i:20856257;i:93;i:20856258;i:94;i:20856259;i:95;i:20856260;i:96;i:20856261;i:97;i:20856262;i:98;i:20856263;i:99;i:20856264;i:100;i:20856265;i:101;i:20856266;i:102;i:20856267;i:103;i:20913572;i:104;i:20913573;i:105;i:20913574;i:106;i:20913575;i:107;i:20913576;i:108;i:20913577;i:109;i:20913578;i:110;i:20913579;i:111;i:20913580;i:112;i:20913581;i:113;i:20913582;i:114;i:20913583;i:115;i:20913584;i:116;i:20913585;i:117;i:20913586;i:118;i:20913587;i:119;i:20913588;i:120;i:20913589;i:121;i:20913590;i:122;i:20913591;i:123;i:20913592;i:124;i:21057831;i:125;i:21057832;i:126;i:21057833;i:127;i:21057834;i:128;i:21057835;i:129;i:21057836;i:130;i:21057837;i:131;i:21057838;i:132;i:21057839;i:133;i:21057840;i:134;i:21057841;i:135;i:21057842;i:136;i:21057843;i:137;i:21057844;i:138;i:21057845;i:139;i:21057846;i:140;i:21057847;i:141;i:21057848;i:142;i:21057849;i:143;i:21057850;i:144;i:21057851;}
)
[rets_open_house_count] => Array
(
[0] => 2
)
[rets_active_open_house_count] => Array
(
[0] => 0
)
[rets_open_house_upcoming] => Array
(
[0] =>
)
[rets_virtual_tour_url_unbranded] => Array
(
[0] => https://player.vimeo.com/video/617526080
)
[virtual_tour] => Array
(
[0] => https://player.vimeo.com/video/617526080
)
[rets_active_continue_to_show_date] => Array
(
[0] => 2021-10-05
)
[rets_close_date] => Array
(
[0] => 2021-10-29
)
[rets_close_price] => Array
(
[0] => 730000.00
)
[rets_expiration_date] => Array
(
[0] => 2022-09-27
)
[rets_off_market_date] => Array
(
[0] => 2021-10-29
)
[rets_selling_agent_direct_work_phone] => Array
(
[0] => (808) 371-3509
)
[rets_selling_agent_email] => Array
(
[0] => mateodubs@hotmail.com
)
[rets_selling_agent_full_name] => Array
(
[0] => Matthew DuBrule
)
[rets_selling_agent_mlsid] => Array
(
[0] => 25279
)
[rets_selling_agent_mui] => Array
(
[0] => 10538530
)
[rets_selling_office_mlsid] => Array
(
[0] => HRCT
)
[rets_selling_office_mui] => Array
(
[0] => 12644575
)
[rets_selling_office_name] => Array
(
[0] => Harcourts Island Real Estate
)
[rets_selling_office_phone] => Array
(
[0] => (808) 371-3509
)
[rets_tax_annual_amount] => Array
(
[0] => 2013.24
)
[_thumbnail_id] => Array
(
[0] => 21057831
)
)
CONTACT US
#RB-7120
info@marcushawaii.com
(808)839-7446