47-677 Hui Kelu Street Unit 7001
Kaneohe, HI 96744

Listing
Overview

Price: $738,000
Area: TEMPLE VALLEY
Status: Sold

Rarely available 2014-2015 remodeled large living area 4 bedroom townhome. Enjoy the nice views of the Koolau mountains. Remodeled kitchen with newer large S/S bottom freezer fridge with ice maker, clean top range, cabinets, sink, fixtures, both bathrooms remodeled with newer shower (see pics), cabinet, flooring, paint and fixtures. Master bedroom and full bath located on 1st floor. Lots of closet space upstairs and down to store things. 3 bedrooms located upstairs with 2 balconies and another full remodeled bathroom. Corner end unit with large private lanai and storage closet. Comes with 2 open side by side parking stalls near the unit. Just minutes away from shopping, restaurants, movie theater and more. Don’t snooze on this one!

array(160) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "219800.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "453500.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "673300.00"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["building_name"]=>
  array(1) {
    [0]=>
    string(19) "Club View Gardens 3"
  }
  ["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(45) "Property Disclosure Stmt,Relative of Licensee"
  }
  ["elementary_school"]=>
  array(1) {
    [0]=>
    string(8) "Ahuimanu"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(38) "Ceramic Tile,Laminate,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(6) "Castle"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(6) "100000"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(9) "328094.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(27) "RealEstateDan@hawaii.rr.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(12) "Dan Murakami"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 383-7659"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-06-10"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(15) "Nalu Realty LLC"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "738000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(4) "1555"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(51) "47-677 Hui Kelu Street Unit 7001, Kaneohe, HI 96744"
  }
  ["maintenance_fees"]=>
  array(1) {
    [0]=>
    string(6) "663.00"
  }
  ["middle_school"]=>
  array(1) {
    [0]=>
    string(4) "King"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202115348"
  }
  ["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(4) "WAVE"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(30) "Assigned,Guest,Open - 2,Street"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(26) "45 Days or Less,At Closing"
  }
  ["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_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-06-25"
  }
  ["rets_association_fee_2"]=>
  array(1) {
    [0]=>
    string(3) "142"
  }
  ["rets_association_fee_total"]=>
  array(1) {
    [0]=>
    string(3) "805"
  }
  ["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_building_name"]=>
  array(1) {
    [0]=>
    string(19) "Club View Gardens 3"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["rets_condo_parking_unit"]=>
  array(1) {
    [0]=>
    string(3) "TBD"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(9) "740000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(2) "15"
  }
  ["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) "2"
  }
  ["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) "15974076"
  }
  ["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) 383-7659"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(27) "RealEstateDan@hawaii.rr.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(12) "Dan Murakami"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "26744"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3476391"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "WAVE"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3487452"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(15) "Nalu Realty LLC"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 383-7659"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(9) "738000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-06-10"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(9) "328094.00"
  }
  ["rets_maintenance_expense"]=>
  array(1) {
    [0]=>
    string(6) "663.00"
  }
  ["rets_management_company_name"]=>
  array(1) {
    [0]=>
    string(7) "Associa"
  }
  ["rets_management_company_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 836-0911"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-07-27T12:31:28.843"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "15974076"
  }
  ["rets_middle_or_junior_school"]=>
  array(1) {
    [0]=>
    string(4) "King"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202115348"
  }
  ["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-06-10T23:31:20.217"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(9) "738000.00"
  }
  ["rets_owner_occupancy_percentage"]=>
  array(1) {
    [0]=>
    string(2) "78"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-4-7-004-034-0037"
  }
  ["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) "25"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-06-10T23:31:20.217"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96744"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-06-10T23:31:20.217"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "15974076"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(270) "Easy to view on lock box.  Please attach AS IS Addendum and Pre-Approval letter with all offers.  Offers will be presented to the owner on Friday June 25, 2021.  Please submit all offers no later than midnight Thursday June 24, 2021.  Please use TG escrow Jill Kirihara."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(747) "Rarely available 2014-2015 remodeled large living area 4 bedroom townhome.  Enjoy the nice views of the Koolau mountains.  Remodeled kitchen with newer large S/S bottom freezer fridge with ice maker, clean top range, cabinets, sink, fixtures, both bathrooms remodeled with newer shower (see pics), cabinet, flooring, paint and fixtures. Master bedroom and full bath located on 1st floor.  Lots of closet space upstairs and down to store things.  3 bedrooms located upstairs with 2 balconies and another full remodeled bathroom. Corner end unit with large private lanai and storage closet.  Comes with 2 open side by side parking stalls near the unit.  Just minutes away from shopping, restaurants, movie theater and more. Don't snooze on this one!"
  }
  ["rets_room_count"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(4) "1555"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(4) "1555"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-07-27T12:31:28.843"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-07-27"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(8) "Hui Kelu"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(6) "47-677"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(64) "1$21.432479$-157.837233$234.23$13.33$1.00$peswuEjacL1hoDxeGS83Vg"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(3) "2.5"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "167.21"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "673300.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "219800.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "453500.00"
  }
  ["rets_tax_excemption_owner_occupancy"]=>
  array(1) {
    [0]=>
    string(6) "100000"
  }
  ["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/15974076/a255ec742ae044b88b7d6c9fb7c1ba45"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "147"
  }
  ["rets_tmk_condo_property_regime_number"]=>
  array(1) {
    [0]=>
    string(2) "37"
  }
  ["rets_tmk_division"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tmk_parcel"]=>
  array(1) {
    [0]=>
    string(2) "34"
  }
  ["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) "7001"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1976"
  }
  ["rets_year_remodeled"]=>
  array(1) {
    [0]=>
    string(4) "2015"
  }
  ["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-677"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(17) "Cash,Conventional"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-4-7-004-034-0037"
  }
  ["unit"]=>
  array(1) {
    [0]=>
    string(62) "Bedroom on 1st Level,Corner/End,Full Bath on 1st Floor,Storage"
  }
  ["unit_number"]=>
  array(1) {
    [0]=>
    string(4) "7001"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(8) "Mountain"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "15974076"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202115348"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1628892428"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1976"
  }
  ["year_remodeled_"]=>
  array(1) {
    [0]=>
    string(4) "2015"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(29) "05 - R-5 Residential District"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(1005) "a:63:{i:0;i:20008636;i:1;i:20008637;i:2;i:20008638;i:3;i:20008639;i:4;i:20008640;i:5;i:20008641;i:6;i:20008642;i:7;i:20008643;i:8;i:20008644;i:9;i:20008645;i:10;i:20008646;i:11;i:20008647;i:12;i:20008648;i:13;i:20008649;i:14;i:20008650;i:15;i:20008651;i:16;i:20008652;i:17;i:20008653;i:18;i:20008654;i:19;i:20008655;i:20;i:20008656;i:21;i:20194215;i:22;i:20194216;i:23;i:20194217;i:24;i:20194218;i:25;i:20194219;i:26;i:20194220;i:27;i:20194221;i:28;i:20194222;i:29;i:20194223;i:30;i:20194224;i:31;i:20194225;i:32;i:20194226;i:33;i:20194227;i:34;i:20194228;i:35;i:20194229;i:36;i:20194230;i:37;i:20194231;i:38;i:20194232;i:39;i:20194233;i:40;i:20194234;i:41;i:20194235;i:42;i:20256727;i:43;i:20256728;i:44;i:20256729;i:45;i:20256730;i:46;i:20256731;i:47;i:20256732;i:48;i:20256733;i:49;i:20256734;i:50;i:20256735;i:51;i:20256736;i:52;i:20256737;i:53;i:20256738;i:54;i:20256739;i:55;i:20256740;i:56;i:20256741;i:57;i:20256742;i:58;i:20256743;i:59;i:20256744;i:60;i:20256745;i:61;i:20256746;i:62;i:20256747;}"
  }
  ["fee_purchase"]=>
  array(1) {
    [0]=>
    string(6) "740000"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-07-27"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(9) "740000.00"
  }
  ["rets_fee_purchase"]=>
  array(1) {
    [0]=>
    string(6) "740000"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-07-27"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 488-1991"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(18) "dmkapiko@gmail.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(16) "Donavan M Kapiko"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "46322"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(8) "10170068"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(6) "CBPP05"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3484715"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 488-1991"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20256727"
  }
}
Array
(
    [assd_val_imprv] => Array
        (
            [0] => 219800.00
        )

    [assd_val_land] => Array
        (
            [0] => 453500.00
        )

    [assd_val_total] => Array
        (
            [0] => 673300.00
        )

    [bedrooms] => Array
        (
            [0] => 4
        )

    [building_name] => Array
        (
            [0] => Club View Gardens 3
        )

    [building_style] => Array
        (
            [0] => Townhouse
        )

    [city] => Array
        (
            [0] => Kaneohe
        )

    [county] => Array
        (
            [0] => Oahu
        )

    [disclosures] => Array
        (
            [0] => Property Disclosure Stmt,Relative of Licensee
        )

    [elementary_school] => Array
        (
            [0] => Ahuimanu
        )

    [floor_covering] => Array
        (
            [0] => Ceramic Tile,Laminate,Vinyl,W/W Carpet
        )

    [full_baths] => Array
        (
            [0] => 2
        )

    [furnished] => Array
        (
            [0] => None
        )

    [half_baths] => Array
        (
            [0] => 0
        )

    [high_school] => Array
        (
            [0] => Castle
        )

    [home_exampt] => Array
        (
            [0] => 100000
        )

    [land_area_sf] => Array
        (
            [0] => 328094.00
        )

    [land_recorded] => Array
        (
            [0] => Land Court
        )

    [land_tenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [list_agent_email] => Array
        (
            [0] => RealEstateDan@hawaii.rr.com
        )

    [list_agent_name] => Array
        (
            [0] => Dan Murakami
        )

    [list_agent_phone_number] => Array
        (
            [0] => (808) 383-7659
        )

    [list_date] => Array
        (
            [0] => 2021-06-10
        )

    [list_office_name] => Array
        (
            [0] => Nalu Realty LLC
        )

    [list_price] => Array
        (
            [0] => 738000.00
        )

    [living_sf] => Array
        (
            [0] => 1555
        )

    [location] => Array
        (
            [0] => 47-677 Hui Kelu Street Unit 7001, Kaneohe, HI 96744
        )

    [maintenance_fees] => Array
        (
            [0] => 663.00
        )

    [middle_school] => Array
        (
            [0] => King
        )

    [mls_] => Array
        (
            [0] => 202115348
        )

    [neighborhood] => Array
        (
            [0] => TEMPLE VALLEY
        )

    [number_of_parking_spaces] => Array
        (
            [0] => 2
        )

    [number_of_stories] => Array
        (
            [0] => Two
        )

    [office_mls_id] => Array
        (
            [0] => WAVE
        )

    [parking_features] => Array
        (
            [0] => Assigned,Guest,Open - 2,Street
        )

    [possession] => Array
        (
            [0] => 45 Days or Less,At Closing
        )

    [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_active_continue_to_show_date] => Array
        (
            [0] => 2021-06-25
        )

    [rets_association_fee_2] => Array
        (
            [0] => 142
        )

    [rets_association_fee_total] => Array
        (
            [0] => 805
        )

    [rets_baths_full] => Array
        (
            [0] => 2
        )

    [rets_baths_half] => Array
        (
            [0] => 0
        )

    [rets_baths_total] => Array
        (
            [0] => 2.00
        )

    [rets_beds_total] => Array
        (
            [0] => 4
        )

    [rets_building_name] => Array
        (
            [0] => Club View Gardens 3
        )

    [rets_city] => Array
        (
            [0] => Kaneohe
        )

    [rets_condo_parking_unit] => Array
        (
            [0] => TBD
        )

    [rets_current_price] => Array
        (
            [0] => 740000.00
        )

    [rets_dom] => Array
        (
            [0] => 15
        )

    [rets_dual_variable_compensation_yn] => Array
        (
            [0] => 0
        )

    [rets_elementary_school] => Array
        (
            [0] => Ahuimanu
        )

    [rets_floor_number] => Array
        (
            [0] => 2
        )

    [rets_foreclosure_yn] => Array
        (
            [0] => 0
        )

    [rets_fractional_ownership_yn] => Array
        (
            [0] => 0
        )

    [rets_high_school] => Array
        (
            [0] => Castle
        )

    [rets_id] => Array
        (
            [0] => 15974076
        )

    [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) 383-7659
        )

    [rets_list_agent_email] => Array
        (
            [0] => RealEstateDan@hawaii.rr.com
        )

    [rets_list_agent_full_name] => Array
        (
            [0] => Dan Murakami
        )

    [rets_list_agent_mlsid] => Array
        (
            [0] => 26744
        )

    [rets_list_agent_mui] => Array
        (
            [0] => 3476391
        )

    [rets_list_office_mlsid] => Array
        (
            [0] => WAVE
        )

    [rets_list_office_mui] => Array
        (
            [0] => 3487452
        )

    [rets_list_office_name] => Array
        (
            [0] => Nalu Realty LLC
        )

    [rets_list_office_phone] => Array
        (
            [0] => (808) 383-7659
        )

    [rets_list_price] => Array
        (
            [0] => 738000.00
        )

    [rets_listing_contract_date] => Array
        (
            [0] => 2021-06-10
        )

    [rets_lot_size_area] => Array
        (
            [0] => 328094.00
        )

    [rets_maintenance_expense] => Array
        (
            [0] => 663.00
        )

    [rets_management_company_name] => Array
        (
            [0] => Associa
        )

    [rets_management_company_phone] => Array
        (
            [0] => (808) 836-0911
        )

    [rets_matrix_modified_dt] => Array
        (
            [0] => 2021-07-27T12:31:28.843
        )

    [rets_matrix_unique_id] => Array
        (
            [0] => 15974076
        )

    [rets_middle_or_junior_school] => Array
        (
            [0] => King
        )

    [rets_mls_number] => Array
        (
            [0] => 202115348
        )

    [rets_neighbourhood] => Array
        (
            [0] => TEMPLE VALLEY
        )

    [rets_new_development_construction_yn] => Array
        (
            [0] => 0
        )

    [rets_original_entry_timestamp] => Array
        (
            [0] => 2021-06-10T23:31:20.217
        )

    [rets_original_list_price] => Array
        (
            [0] => 738000.00
        )

    [rets_owner_occupancy_percentage] => Array
        (
            [0] => 78
        )

    [rets_parcel_number] => Array
        (
            [0] => 1-4-7-004-034-0037
        )

    [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] => 25
        )

    [rets_photo_modification_timestamp] => Array
        (
            [0] => 2021-06-10T23:31:20.217
        )

    [rets_postal_code] => Array
        (
            [0] => 96744
        )

    [rets_price_change_timestamp] => Array
        (
            [0] => 2021-06-10T23:31:20.217
        )

    [rets_primary_key] => Array
        (
            [0] => 15974076
        )

    [rets_private_remarks] => Array
        (
            [0] => Easy to view on lock box.  Please attach AS IS Addendum and Pre-Approval letter with all offers.  Offers will be presented to the owner on Friday June 25, 2021.  Please submit all offers no later than midnight Thursday June 24, 2021.  Please use TG escrow Jill Kirihara.
        )

    [rets_public_remarks] => Array
        (
            [0] => Rarely available 2014-2015 remodeled large living area 4 bedroom townhome.  Enjoy the nice views of the Koolau mountains.  Remodeled kitchen with newer large S/S bottom freezer fridge with ice maker, clean top range, cabinets, sink, fixtures, both bathrooms remodeled with newer shower (see pics), cabinet, flooring, paint and fixtures. Master bedroom and full bath located on 1st floor.  Lots of closet space upstairs and down to store things.  3 bedrooms located upstairs with 2 balconies and another full remodeled bathroom. Corner end unit with large private lanai and storage closet.  Comes with 2 open side by side parking stalls near the unit.  Just minutes away from shopping, restaurants, movie theater and more. Don't snooze on this one!
        )

    [rets_room_count] => Array
        (
            [0] => 0
        )

    [rets_sqft_roofed_living] => Array
        (
            [0] => 1555
        )

    [rets_sqft_total] => Array
        (
            [0] => 1555
        )

    [rets_state_or_province] => Array
        (
            [0] => HI
        )

    [rets_status_change_timestamp] => Array
        (
            [0] => 2021-07-27T12:31:28.843
        )

    [rets_status_contractual_search_date] => Array
        (
            [0] => 2021-07-27
        )

    [rets_street_name] => Array
        (
            [0] => Hui Kelu
        )

    [rets_street_number] => Array
        (
            [0] => 47-677
        )

    [rets_street_view_param] => Array
        (
            [0] => 1$21.432479$-157.837233$234.23$13.33$1.00$peswuEjacL1hoDxeGS83Vg
        )

    [rets_sub_agency_compensation] => Array
        (
            [0] => 2.5
        )

    [rets_tax_amount] => Array
        (
            [0] => 167.21
        )

    [rets_tax_assessed_value] => Array
        (
            [0] => 673300.00
        )

    [rets_tax_assessed_value_improvements] => Array
        (
            [0] => 219800.00
        )

    [rets_tax_assessed_value_land] => Array
        (
            [0] => 453500.00
        )

    [rets_tax_excemption_owner_occupancy] => Array
        (
            [0] => 100000
        )

    [rets_tax_paid_by_seller_yn] => Array
        (
            [0] => 0
        )

    [rets_tax_year] => Array
        (
            [0] => 2020
        )

    [rets_thumbnail_url] => Array
        (
            [0] => https://cdn.rets.ci/marcusrealty-images/15974076/a255ec742ae044b88b7d6c9fb7c1ba45
        )

    [rets_tmk_area] => Array
        (
            [0] => 147
        )

    [rets_tmk_condo_property_regime_number] => Array
        (
            [0] => 37
        )

    [rets_tmk_division] => Array
        (
            [0] => 1
        )

    [rets_tmk_parcel] => Array
        (
            [0] => 34
        )

    [rets_tmk_section] => Array
        (
            [0] => 7
        )

    [rets_tmk_zone] => Array
        (
            [0] => 4
        )

    [rets_tmkplat] => Array
        (
            [0] => 4
        )

    [rets_unit_number] => Array
        (
            [0] => 7001
        )

    [rets_year_built] => Array
        (
            [0] => 1976
        )

    [rets_year_remodeled] => Array
        (
            [0] => 2015
        )

    [state_or_province] => Array
        (
            [0] => HI
        )

    [status] => Array
        (
            [0] => Sold
        )

    [street_name] => Array
        (
            [0] => Hui Kelu
        )

    [street_number] => Array
        (
            [0] => 47-677
        )

    [street_suffix] => Array
        (
            [0] => Street
        )

    [terms_accept] => Array
        (
            [0] => Cash,Conventional
        )

    [tmk] => Array
        (
            [0] => 1-4-7-004-034-0037
        )

    [unit] => Array
        (
            [0] => Bedroom on 1st Level,Corner/End,Full Bath on 1st Floor,Storage
        )

    [unit_number] => Array
        (
            [0] => 7001
        )

    [view] => Array
        (
            [0] => Mountain
        )

    [wpp::rets_pk] => Array
        (
            [0] => 15974076
        )

    [wpp_gpid] => Array
        (
            [0] => 202115348
        )

    [wpp_import_schedule_id] => Array
        (
            [0] => 1463343682
        )

    [wpp_import_time] => Array
        (
            [0] => 1628892428
        )

    [year_built] => Array
        (
            [0] => 1976
        )

    [year_remodeled_] => Array
        (
            [0] => 2015
        )

    [zoning] => Array
        (
            [0] => 05 - R-5 Residential District
        )

    [new_attached_media] => Array
        (
            [0] => a:63:{i:0;i:20008636;i:1;i:20008637;i:2;i:20008638;i:3;i:20008639;i:4;i:20008640;i:5;i:20008641;i:6;i:20008642;i:7;i:20008643;i:8;i:20008644;i:9;i:20008645;i:10;i:20008646;i:11;i:20008647;i:12;i:20008648;i:13;i:20008649;i:14;i:20008650;i:15;i:20008651;i:16;i:20008652;i:17;i:20008653;i:18;i:20008654;i:19;i:20008655;i:20;i:20008656;i:21;i:20194215;i:22;i:20194216;i:23;i:20194217;i:24;i:20194218;i:25;i:20194219;i:26;i:20194220;i:27;i:20194221;i:28;i:20194222;i:29;i:20194223;i:30;i:20194224;i:31;i:20194225;i:32;i:20194226;i:33;i:20194227;i:34;i:20194228;i:35;i:20194229;i:36;i:20194230;i:37;i:20194231;i:38;i:20194232;i:39;i:20194233;i:40;i:20194234;i:41;i:20194235;i:42;i:20256727;i:43;i:20256728;i:44;i:20256729;i:45;i:20256730;i:46;i:20256731;i:47;i:20256732;i:48;i:20256733;i:49;i:20256734;i:50;i:20256735;i:51;i:20256736;i:52;i:20256737;i:53;i:20256738;i:54;i:20256739;i:55;i:20256740;i:56;i:20256741;i:57;i:20256742;i:58;i:20256743;i:59;i:20256744;i:60;i:20256745;i:61;i:20256746;i:62;i:20256747;}
        )

    [fee_purchase] => Array
        (
            [0] => 740000
        )

    [rets_close_date] => Array
        (
            [0] => 2021-07-27
        )

    [rets_close_price] => Array
        (
            [0] => 740000.00
        )

    [rets_fee_purchase] => Array
        (
            [0] => 740000
        )

    [rets_off_market_date] => Array
        (
            [0] => 2021-07-27
        )

    [rets_selling_agent_direct_work_phone] => Array
        (
            [0] => (808) 488-1991
        )

    [rets_selling_agent_email] => Array
        (
            [0] => dmkapiko@gmail.com
        )

    [rets_selling_agent_full_name] => Array
        (
            [0] => Donavan M Kapiko
        )

    [rets_selling_agent_mlsid] => Array
        (
            [0] => 46322
        )

    [rets_selling_agent_mui] => Array
        (
            [0] => 10170068
        )

    [rets_selling_office_mlsid] => Array
        (
            [0] => CBPP05
        )

    [rets_selling_office_mui] => Array
        (
            [0] => 3484715
        )

    [rets_selling_office_name] => Array
        (
            [0] => Coldwell Banker Realty
        )

    [rets_selling_office_phone] => Array
        (
            [0] => (808) 488-1991
        )

    [_thumbnail_id] => Array
        (
            [0] => 20256727
        )

)

  • Bedrooms: 4
  • Full Baths: 2
  • Land Area (sf): 328,094
  • Living (sf): 1,555
  • Year Built: 1976
  • Building Name: Club View Gardens 3

  • Property Condition: Above Average,Excellent
  • Number of Parking Spaces: 2
  • Number of Stories: Two
  • View: Mountain
  • Listing Office: Nalu Realty LLC

  • Maintenance Fees: $663
  • Land Tenure: FS - Fee Simple

  • Elementary School: Ahuimanu
  • Middle School: King
  • High School: Castle

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446