4148 Salt Lake Boulevard
Honolulu, HI 96818

Take a Virtual Tour

Listing
Overview

Price: $599,000
Area: ALIAMANU
Status: Active

Amazing opportunity being listed under tax assessed value, this contractor’s special is conveniently located minutes from shopping, schools Aloha Stadium and more. It is in need of some TLC and is priced at the appraised value. Don’t miss your opportunity to rebuild or renovate to make this into your dream home or as an investment. Home is being sold as-is.

Buyer/Buyer’s Representative shall conduct their due diligence with regard to rebuild/renovation requirements. One or more photos have been enhanced

  • Bedrooms: 2
  • Full Baths: 1
  • Land Area (sf): 5,000
  • Living (sf): 724
  • Year Built: 1955

  • Property Condition: Fair
  • Number of Parking Spaces: 2
  • Pool: None
  • Number of Stories: One
  • View: Other
  • Listing Office: Engel & Volkers-Honolulu

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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

array(131) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(8) "24500.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "600000.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "624500.00"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["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(5) "Other"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(22) "Other,Vinyl,W/W Carpet"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(6) "140000"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(7) "5000.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(30) "Kay.Mukaigawa@evrealestate.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(15) "Kay M Mukaigawa"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 550-0818"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-24"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(24) "Engel & Volkers-Honolulu"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "599000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(3) "724"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(44) "4148 Salt Lake Boulevard, Honolulu, HI 96818"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202129628"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(8) "ALIAMANU"
  }
  ["number_of_parking_spaces"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["number_of_stories"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "PPRO"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(5) "2 Car"
  }
  ["pool_"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(26) "45 Days or Less,At Closing"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96818"
  }
  ["property_condition"]=>
  array(1) {
    [0]=>
    string(4) "Fair"
  }
  ["property_type"]=>
  array(1) {
    [0]=>
    string(13) "single_family"
  }
  ["property_type_label"]=>
  array(1) {
    [0]=>
    string(13) "single_family"
  }
  ["region"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["rets_baths_full"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_baths_half"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_baths_total"]=>
  array(1) {
    [0]=>
    string(4) "1.00"
  }
  ["rets_beds_total"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["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(9) "599000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_foreclosure_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_fractional_ownership_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_id"]=>
  array(1) {
    [0]=>
    string(8) "16308237"
  }
  ["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) 550-0818"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(30) "Kay.Mukaigawa@evrealestate.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(15) "Kay M Mukaigawa"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "15060"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "8842860"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "PPRO"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3486494"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(24) "Engel & Volkers-Honolulu"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 550-0818"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(9) "599000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-24"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(7) "5000.00"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-11-24T17:26:24.047"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "16308237"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202129628"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(8) "ALIAMANU"
  }
  ["rets_new_development_construction_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-11-24T17:22:39.410"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(9) "599000.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-1-1-022-024-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) "23"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-11-24T17:22:39.410"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96818"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-11-24T17:22:39.410"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "16308237"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(186) "Call or text Travis Takeuchi (RA) at 808-383-9078 for showing instructions. Buyer/Buyer's Representative shall conduct their due diligence with regard to rebuild/renovation requirements."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(515) "Amazing opportunity being listed under tax assessed value, this contractor’s special is conveniently located minutes from shopping, schools Aloha Stadium and more. It is in need of some TLC and is priced at the appraised value. Don’t miss your opportunity to rebuild or renovate to make this into your dream home or as an investment. Home is being sold as-is.

Buyer/Buyer's Representative shall conduct their due diligence with regard to rebuild/renovation requirements. One or more photos have been enhanced"
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(3) "724"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(3) "724"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-11-24T17:22:39.410"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-24"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(9) "Salt Lake"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(4) "4148"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(64) "1$21.354937$-157.925611$255.22$13.33$1.00$hfmDiRhFPn03cQ1RRniV4A"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(4) "2.5%"
  }
  ["rets_supplement_count"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_supplement_modification_timestam"]=>
  array(1) {
    [0]=>
    string(23) "2021-11-24T17:14:03.003"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "141.00"
  }
  ["rets_tax_annual_amount"]=>
  array(1) {
    [0]=>
    string(7) "1692.00"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "624500.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(8) "24500.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "600000.00"
  }
  ["rets_tax_excemption_owner_occupancy"]=>
  array(1) {
    [0]=>
    string(6) "140000"
  }
  ["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/16308237/a0abeeef3da032f4a208153187f699c3"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "111"
  }
  ["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) "24"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(2) "22"
  }
  ["rets_virtual_tour_url_unbranded"]=>
  array(1) {
    [0]=>
    string(51) "https://my.matterport.com/show/?m=AXi1Dkoyyvp&mls=1"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1955"
  }
  ["security"]=>
  array(1) {
    [0]=>
    string(3) "Key"
  }
  ["setbacks"]=>
  array(1) {
    [0]=>
    string(9) "Of Record"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(9) "Salt Lake"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(4) "4148"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(9) "Boulevard"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(17) "Cash,Conventional"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-1-1-022-024-0000"
  }
  ["topography"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["virtual_tour"]=>
  array(1) {
    [0]=>
    string(51) "https://my.matterport.com/show/?m=AXi1Dkoyyvp&mls=1"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "16308237"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202129628"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1637810812"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1955"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(29) "05 - R-5 Residential District"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(669) "a:42:{i:0;i:21224917;i:1;i:21224918;i:2;i:21224919;i:3;i:21224920;i:4;i:21224921;i:5;i:21224922;i:6;i:21224923;i:7;i:21224924;i:8;i:21224925;i:9;i:21224926;i:10;i:21224927;i:11;i:21224928;i:12;i:21224929;i:13;i:21224930;i:14;i:21224931;i:15;i:21224932;i:16;i:21224933;i:17;i:21224934;i:18;i:21224935;i:19;i:21224936;i:20;i:21224937;i:21;i:21224959;i:22;i:21224960;i:23;i:21224961;i:24;i:21224962;i:25;i:21224963;i:26;i:21224964;i:27;i:21224965;i:28;i:21224966;i:29;i:21224967;i:30;i:21224968;i:31;i:21224969;i:32;i:21224970;i:33;i:21224971;i:34;i:21224972;i:35;i:21224973;i:36;i:21224974;i:37;i:21224975;i:38;i:21224976;i:39;i:21224977;i:40;i:21224978;i:41;i:21224979;}"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "21224959"
  }
}