404 Waiopouli Place
Honolulu, HI 96825

Take a Virtual Tour

Listing
Overview

Price: $2,250,000
Area: LUNA KAI
Status: Sold

Island Retreat! Absolutely charming three bedroom + built in office loft, two and one half bath residence offers vaulted ceilings, beautiful
hardwood moldings & trim accents, central air conditioning and many custom details and finishes throughout. The striking professional
kitchen offers granite counter tops, a center island with cook top, beautiful custom Mahogany cabinetry and large wrap around counters. An
outdoor covered lanai offers the perfect location for dining and entertaining and overlooks a central grassy courtyard with tropical
landscape, palms and a refreshing tiled pool. The detached recreation room with full bath and covered lanai is ideal for home office use,
personal gym and more! This home is conveniently located to nearby beaches, hiking trails, dining, shopping & more!

Listing by: Coldwell Banker Realty

array(159) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "345600.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "906700.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(10) "1252300.00"
  }
  ["assn_fee_inclusions"]=>
  array(1) {
    [0]=>
    string(2) "39"
  }
  ["association_fees"]=>
  array(1) {
    [0]=>
    string(2) "39"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(20) "Detach Single Family"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(24) "Property Disclosure Stmt"
  }
  ["easements"]=>
  array(1) {
    [0]=>
    string(14) "Drainage,Sewer"
  }
  ["elementary_school"]=>
  array(1) {
    [0]=>
    string(9) "Koko Head"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(38) "Ceramic Tile,Hardwood,Other,W/W Carpet"
  }
  ["frontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["high_school"]=>
  array(1) {
    [0]=>
    string(6) "Kaiser"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(6) "140000"
  }
  ["lanai_sf"]=>
  array(1) {
    [0]=>
    string(3) "483"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(7) "8234.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(19) "tracy@cbpacific.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(11) "Tracy Allen"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 596-0456"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-08-20"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(10) "2250000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(4) "3221"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(39) "404 Waiopouli Place, Honolulu, HI 96825"
  }
  ["middle_school"]=>
  array(1) {
    [0]=>
    string(10) "Niu Valley"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202124346"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(8) "LUNA KAI"
  }
  ["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) "CBPP"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(28) "2 Car,Driveway,Garage,Street"
  }
  ["pool_"]=>
  array(1) {
    [0]=>
    string(14) "In Ground,Tile"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(10) "At Closing"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96825"
  }
  ["property_condition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["property_type"]=>
  array(1) {
    [0]=>
    string(13) "single_family"
  }
  ["property_type_label"]=>
  array(1) {
    [0]=>
    string(13) "single_family"
  }
  ["region"]=>
  array(1) {
    [0]=>
    string(9) "HawaiiKai"
  }
  ["rets_association_fee"]=>
  array(1) {
    [0]=>
    string(2) "39"
  }
  ["rets_association_fee_total"]=>
  array(1) {
    [0]=>
    string(2) "39"
  }
  ["rets_baths_full"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["rets_baths_half"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_baths_total"]=>
  array(1) {
    [0]=>
    string(4) "3.01"
  }
  ["rets_beds_total"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["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) "2250000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(2) "28"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_elementary_school"]=>
  array(1) {
    [0]=>
    string(9) "Koko Head"
  }
  ["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) "Kaiser"
  }
  ["rets_id"]=>
  array(1) {
    [0]=>
    string(8) "16175877"
  }
  ["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) 596-0456"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(19) "tracy@cbpacific.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(11) "Tracy Allen"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "18139"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "8834388"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "CBPP"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3485212"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 596-0456"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(10) "2250000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-08-20"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(7) "8234.00"
  }
  ["rets_management_company_name"]=>
  array(1) {
    [0]=>
    string(19) "Hawaiian Properties"
  }
  ["rets_management_company_phone"]=>
  array(1) {
    [0]=>
    string(12) "808-593-9777"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-21T10:39:33.627"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "16175877"
  }
  ["rets_middle_or_junior_school"]=>
  array(1) {
    [0]=>
    string(10) "Niu Valley"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202124346"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(8) "LUNA KAI"
  }
  ["rets_new_development_construction_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-21T10:38:38.550"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(10) "2250000.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-3-9-006-071-0000"
  }
  ["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-09-21T10:38:38.550"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96825"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "16175877"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(17) "Exempted listing."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(805) "Island Retreat! Absolutely charming three bedroom + built in office loft, two and one half bath residence offers vaulted ceilings, beautiful
hardwood moldings & trim accents, central air conditioning and many custom details and finishes throughout. The striking professional
kitchen offers granite counter tops, a center island with cook top, beautiful custom Mahogany cabinetry and large wrap around counters. An
outdoor covered lanai offers the perfect location for dining and entertaining and overlooks a central grassy courtyard with tropical
landscape, palms and a refreshing tiled pool. The detached recreation room with full bath and covered lanai is ideal for home office use,
personal gym and more! This home is conveniently located to nearby beaches, hiking trails, dining, shopping & more!"
  }
  ["rets_sqft_garage_carport"]=>
  array(1) {
    [0]=>
    string(3) "306"
  }
  ["rets_sqft_lanai_open"]=>
  array(1) {
    [0]=>
    string(3) "483"
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(4) "2652"
  }
  ["rets_sqft_roofed_other"]=>
  array(1) {
    [0]=>
    string(2) "86"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(4) "3221"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-21T10:39:33.627"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-17"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(9) "Waiopouli"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(3) "404"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(64) "1$21.283019$-157.700797$352.55$13.33$1.00$TOPOvZiEqpgv8rK4hO9rJw"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(4) "2.5%"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "324.42"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(10) "1252300.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "345600.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "906700.00"
  }
  ["rets_tax_excemption_owner_occupancy"]=>
  array(1) {
    [0]=>
    string(6) "140000"
  }
  ["rets_tax_paid_by_seller_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_tax_year"]=>
  array(1) {
    [0]=>
    string(4) "2021"
  }
  ["rets_thumbnail_url"]=>
  array(1) {
    [0]=>
    string(81) "https://cdn.rets.ci/marcusrealty-images/16175877/4338b4500472b5000f1acc4f29171e32"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "139"
  }
  ["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) "71"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "9"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["rets_virtual_tour_url_unbranded"]=>
  array(1) {
    [0]=>
    string(53) "https://player.vimeo.com/video/595778985?h=c2119a4d15"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1968"
  }
  ["rets_year_remodeled"]=>
  array(1) {
    [0]=>
    string(4) "2020"
  }
  ["setbacks"]=>
  array(1) {
    [0]=>
    string(13) "C&C,Of Record"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(9) "Waiopouli"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(3) "404"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(5) "Place"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(17) "Cash,Conventional"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-3-9-006-071-0000"
  }
  ["topography"]=>
  array(1) {
    [0]=>
    string(5) "Clear"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(15) "Garden,Mountain"
  }
  ["virtual_tour"]=>
  array(1) {
    [0]=>
    string(53) "https://player.vimeo.com/video/595778985?h=c2119a4d15"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "16175877"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202124346"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1632256859"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1968"
  }
  ["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(637) "a:40:{i:0;i:20787991;i:1;i:20787992;i:2;i:20787993;i:3;i:20787994;i:4;i:20787995;i:5;i:20787996;i:6;i:20787997;i:7;i:20787998;i:8;i:20787999;i:9;i:20788000;i:10;i:20788001;i:11;i:20788002;i:12;i:20788003;i:13;i:20788004;i:14;i:20788005;i:15;i:20788006;i:16;i:20788007;i:17;i:20788008;i:18;i:20788009;i:19;i:20788049;i:20;i:20788050;i:21;i:20788051;i:22;i:20788052;i:23;i:20788053;i:24;i:20788054;i:25;i:20788055;i:26;i:20788056;i:27;i:20788057;i:28;i:20788058;i:29;i:20788059;i:30;i:20788060;i:31;i:20788061;i:32;i:20788062;i:33;i:20788063;i:34;i:20788064;i:35;i:20788065;i:36;i:20788066;i:37;i:20788067;i:38;i:20788068;i:39;i:20788069;}"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-17"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(10) "2250000.00"
  }
  ["rets_expiration_date"]=>
  array(1) {
    [0]=>
    string(10) "2022-08-19"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-17"
  }
  ["rets_pending_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-08-20"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 596-0456"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(19) "tracy@cbpacific.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(11) "Tracy Allen"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "18139"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "8834388"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "CBPP"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3485212"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 596-0456"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20788049"
  }
}
Array
(
    [assd_val_imprv] => Array
        (
            [0] => 345600.00
        )

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

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

    [assn_fee_inclusions] => Array
        (
            [0] => 39
        )

    [association_fees] => Array
        (
            [0] => 39
        )

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

    [building_style] => Array
        (
            [0] => Detach Single Family
        )

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

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

    [disclosures] => Array
        (
            [0] => Property Disclosure Stmt
        )

    [easements] => Array
        (
            [0] => Drainage,Sewer
        )

    [elementary_school] => Array
        (
            [0] => Koko Head
        )

    [floor_covering] => Array
        (
            [0] => Ceramic Tile,Hardwood,Other,W/W Carpet
        )

    [frontage] => Array
        (
            [0] => Other
        )

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

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

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

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

    [lanai_sf] => Array
        (
            [0] => 483
        )

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

    [land_recorded] => Array
        (
            [0] => Regular System
        )

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

    [list_agent_email] => Array
        (
            [0] => tracy@cbpacific.com
        )

    [list_agent_name] => Array
        (
            [0] => Tracy Allen
        )

    [list_agent_phone_number] => Array
        (
            [0] => (808) 596-0456
        )

    [list_date] => Array
        (
            [0] => 2021-08-20
        )

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

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

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

    [location] => Array
        (
            [0] => 404 Waiopouli Place, Honolulu, HI 96825
        )

    [middle_school] => Array
        (
            [0] => Niu Valley
        )

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

    [neighborhood] => Array
        (
            [0] => LUNA KAI
        )

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

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

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

    [parking_features] => Array
        (
            [0] => 2 Car,Driveway,Garage,Street
        )

    [pool_] => Array
        (
            [0] => In Ground,Tile
        )

    [possession] => Array
        (
            [0] => At Closing
        )

    [postal_code] => Array
        (
            [0] => 96825
        )

    [property_condition] => Array
        (
            [0] => Excellent
        )

    [property_type] => Array
        (
            [0] => single_family
        )

    [property_type_label] => Array
        (
            [0] => single_family
        )

    [region] => Array
        (
            [0] => HawaiiKai
        )

    [rets_association_fee] => Array
        (
            [0] => 39
        )

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

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

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

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

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

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

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

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

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

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

    [rets_elementary_school] => Array
        (
            [0] => Koko Head
        )

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

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

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

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

    [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) 596-0456
        )

    [rets_list_agent_email] => Array
        (
            [0] => tracy@cbpacific.com
        )

    [rets_list_agent_full_name] => Array
        (
            [0] => Tracy Allen
        )

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

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

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

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

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

    [rets_list_office_phone] => Array
        (
            [0] => (808) 596-0456
        )

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

    [rets_listing_contract_date] => Array
        (
            [0] => 2021-08-20
        )

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

    [rets_management_company_name] => Array
        (
            [0] => Hawaiian Properties
        )

    [rets_management_company_phone] => Array
        (
            [0] => 808-593-9777
        )

    [rets_matrix_modified_dt] => Array
        (
            [0] => 2021-09-21T10:39:33.627
        )

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

    [rets_middle_or_junior_school] => Array
        (
            [0] => Niu Valley
        )

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

    [rets_neighbourhood] => Array
        (
            [0] => LUNA KAI
        )

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

    [rets_original_entry_timestamp] => Array
        (
            [0] => 2021-09-21T10:38:38.550
        )

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

    [rets_parcel_number] => Array
        (
            [0] => 1-3-9-006-071-0000
        )

    [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-09-21T10:38:38.550
        )

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

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

    [rets_private_remarks] => Array
        (
            [0] => Exempted listing.
        )

    [rets_public_remarks] => Array
        (
            [0] => Island Retreat! Absolutely charming three bedroom + built in office loft, two and one half bath residence offers vaulted ceilings, beautiful
hardwood moldings & trim accents, central air conditioning and many custom details and finishes throughout. The striking professional
kitchen offers granite counter tops, a center island with cook top, beautiful custom Mahogany cabinetry and large wrap around counters. An
outdoor covered lanai offers the perfect location for dining and entertaining and overlooks a central grassy courtyard with tropical
landscape, palms and a refreshing tiled pool. The detached recreation room with full bath and covered lanai is ideal for home office use,
personal gym and more! This home is conveniently located to nearby beaches, hiking trails, dining, shopping & more!
        )

    [rets_sqft_garage_carport] => Array
        (
            [0] => 306
        )

    [rets_sqft_lanai_open] => Array
        (
            [0] => 483
        )

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

    [rets_sqft_roofed_other] => Array
        (
            [0] => 86
        )

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

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

    [rets_status_change_timestamp] => Array
        (
            [0] => 2021-09-21T10:39:33.627
        )

    [rets_status_contractual_search_date] => Array
        (
            [0] => 2021-09-17
        )

    [rets_street_name] => Array
        (
            [0] => Waiopouli
        )

    [rets_street_number] => Array
        (
            [0] => 404
        )

    [rets_street_view_param] => Array
        (
            [0] => 1$21.283019$-157.700797$352.55$13.33$1.00$TOPOvZiEqpgv8rK4hO9rJw
        )

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

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

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

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

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

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

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

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

    [rets_thumbnail_url] => Array
        (
            [0] => https://cdn.rets.ci/marcusrealty-images/16175877/4338b4500472b5000f1acc4f29171e32
        )

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

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

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

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

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

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

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

    [rets_virtual_tour_url_unbranded] => Array
        (
            [0] => https://player.vimeo.com/video/595778985?h=c2119a4d15
        )

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

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

    [setbacks] => Array
        (
            [0] => C&C,Of Record
        )

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

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

    [street_name] => Array
        (
            [0] => Waiopouli
        )

    [street_number] => Array
        (
            [0] => 404
        )

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

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

    [tmk] => Array
        (
            [0] => 1-3-9-006-071-0000
        )

    [topography] => Array
        (
            [0] => Clear
        )

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

    [virtual_tour] => Array
        (
            [0] => https://player.vimeo.com/video/595778985?h=c2119a4d15
        )

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

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

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

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

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

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

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

    [new_attached_media] => Array
        (
            [0] => a:40:{i:0;i:20787991;i:1;i:20787992;i:2;i:20787993;i:3;i:20787994;i:4;i:20787995;i:5;i:20787996;i:6;i:20787997;i:7;i:20787998;i:8;i:20787999;i:9;i:20788000;i:10;i:20788001;i:11;i:20788002;i:12;i:20788003;i:13;i:20788004;i:14;i:20788005;i:15;i:20788006;i:16;i:20788007;i:17;i:20788008;i:18;i:20788009;i:19;i:20788049;i:20;i:20788050;i:21;i:20788051;i:22;i:20788052;i:23;i:20788053;i:24;i:20788054;i:25;i:20788055;i:26;i:20788056;i:27;i:20788057;i:28;i:20788058;i:29;i:20788059;i:30;i:20788060;i:31;i:20788061;i:32;i:20788062;i:33;i:20788063;i:34;i:20788064;i:35;i:20788065;i:36;i:20788066;i:37;i:20788067;i:38;i:20788068;i:39;i:20788069;}
        )

    [rets_close_date] => Array
        (
            [0] => 2021-09-17
        )

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

    [rets_expiration_date] => Array
        (
            [0] => 2022-08-19
        )

    [rets_off_market_date] => Array
        (
            [0] => 2021-09-17
        )

    [rets_pending_date] => Array
        (
            [0] => 2021-08-20
        )

    [rets_selling_agent_direct_work_phone] => Array
        (
            [0] => (808) 596-0456
        )

    [rets_selling_agent_email] => Array
        (
            [0] => tracy@cbpacific.com
        )

    [rets_selling_agent_full_name] => Array
        (
            [0] => Tracy Allen
        )

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

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

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

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

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

    [rets_selling_office_phone] => Array
        (
            [0] => (808) 596-0456
        )

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

)

  • Bedrooms: 3
  • Full Baths: 3
  • Half Baths: 1
  • Land Area (sf): 8,234
  • Living (sf): 3,221
  • Year Built: 1968

  • Property Condition: Excellent
  • Number of Parking Spaces: 2
  • Pool: In Ground,Tile
  • Number of Stories: Two
  • View: Garden,Mountain
  • Listing Office: Coldwell Banker Realty

  • Association Fees: $39
  • Land Tenure: FS - Fee Simple

  • Elementary School: Koko Head
  • Middle School: Niu Valley
  • High School: Kaiser

CONTACT US

Marcus Realty

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