1850 Ala Moana Boulevard Unit 629
Honolulu, HI 96815

Listing
Overview

Price: $190,000
Area: WAIKIKI
Status: Sold

Great location! This boutique condo hotel is conveniently located near Ala Moana Beach, Ala Moana Shopping Center, nearby restaurants, and shuttle bus service (post Covid) in front of building. Unit facing mauka (quiet and cooler side) is the Aston Hotel Pool, showings upon availability. Low maintenance fee includes: cable tv, electricity, hot water, water, sewer, central AC, common areas. Amenities includes: pool, BBQ area, laundry facility, fitness room, security guard and concierge service.

  • Full Baths: 1
  • Living (sf): 265
  • Year Built: 1970

  • Property Condition: Excellent
  • Number of Stories: 8-14
  • View: City
  • Listing Office: Coldwell Banker Realty

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

CONTACT US

Marcus Realty

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

array(152) {
  ["address_is_formatted"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "168100.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(8) "55300.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "223400.00"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["building_name"]=>
  array(1) {
    [0]=>
    string(16) "Palms At Waikiki"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(8) "Condotel"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(24) "Property Disclosure Stmt"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(10) "W/W Carpet"
  }
  ["formatted_address"]=>
  array(1) {
    [0]=>
    string(44) "1850 Ala Moana Blvd, Honolulu, HI 96815, USA"
  }
  ["formatted_address_simple"]=>
  array(1) {
    [0]=>
    string(33) "1850 Ala Moana Blvd, Honolulu, HI"
  }
  ["frontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["furnished"]=>
  array(1) {
    [0]=>
    string(4) "Full"
  }
  ["google_place_id"]=>
  array(1) {
    [0]=>
    string(27) "ChIJ6dM4C35tAHwRiIXvtbfO-SE"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["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(17) "ssp@hawaii.rr.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(14) "Sachi Petersen"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 732-1414"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-01-25"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "190000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(3) "265"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(53) "1850 Ala Moana Boulevard Unit 629, Honolulu, HI 96815"
  }
  ["maintenance_fees"]=>
  array(1) {
    [0]=>
    string(6) "584.00"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202101622"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKIKI"
  }
  ["number_of_parking_spaces"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["number_of_stories"]=>
  array(1) {
    [0]=>
    string(4) "8-14"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(6) "CBPP02"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(10) "At Closing"
  }
  ["property_condition"]=>
  array(1) {
    [0]=>
    string(9) "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(5) "Metro"
  }
  ["rets_association_fee_total"]=>
  array(1) {
    [0]=>
    string(3) "584"
  }
  ["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) "0"
  }
  ["rets_building_name"]=>
  array(1) {
    [0]=>
    string(16) "Palms At Waikiki"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["rets_condo_parking_unit"]=>
  array(1) {
    [0]=>
    string(2) "na"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(9) "190000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(2) "42"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_floor_number"]=>
  array(1) {
    [0]=>
    string(1) "8"
  }
  ["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) "15675754"
  }
  ["rets_immoviewer_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 732-1414"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(17) "ssp@hawaii.rr.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(14) "Sachi Petersen"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "17876"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3473436"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(6) "CBPP02"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3485238"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 732-1414"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(9) "190000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-01-25"
  }
  ["rets_lock_box_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_maintenance_expense"]=>
  array(1) {
    [0]=>
    string(6) "584.00"
  }
  ["rets_management_company_name"]=>
  array(1) {
    [0]=>
    string(10) "Aqua Palms"
  }
  ["rets_management_company_phone"]=>
  array(1) {
    [0]=>
    string(8) "947-7256"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-04-15T13:42:52.760"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "15675754"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202101622"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKIKI"
  }
  ["rets_new_development_construction_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-01-25T10:57:47.287"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(9) "190000.00"
  }
  ["rets_owner_occupancy_percentage"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-2-6-012-003-0129"
  }
  ["rets_parking_additional"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_parking_total"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["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) "12"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-01-25T10:57:47.287"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96815"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "15675754"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(64) "Call agent for showing and based upon Aston's room availability."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(498) "Great location! This boutique condo hotel is conveniently located near Ala Moana Beach, Ala Moana Shopping Center, nearby restaurants, and shuttle bus service (post Covid) in front of building. Unit facing mauka (quiet and cooler side) is the Aston Hotel Pool, showings upon availability. Low maintenance fee includes: cable tv, electricity, hot water, water, sewer, central AC, common areas. Amenities includes: pool, BBQ area, laundry facility, fitness room, security guard and concierge service."
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(3) "265"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(3) "265"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-04-15T13:42:52.760"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-04-15"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(9) "Ala Moana"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(4) "1850"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(106) "1$21.285009$-157.836578$324.07$13.33$1.00$CAoSKkFGMVFpcE52WV9MZ1ZVdFE1NWJWQUVuaDVqZlIwM2J2cWNxcURFSm5pdw.."
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "127.00"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "223400.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "168100.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(8) "55300.00"
  }
  ["rets_tax_excemption_owner_occupancy"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_tax_paid_by_seller_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_tax_year"]=>
  array(1) {
    [0]=>
    string(4) "2021"
  }
  ["rets_thumbnail_url"]=>
  array(1) {
    [0]=>
    string(81) "https://cdn.rets.ci/marcusrealty-images/15675754/06405d7214e77ba3af86a001dd9e436b"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "126"
  }
  ["rets_tmk_condo_property_regime_number"]=>
  array(1) {
    [0]=>
    string(3) "129"
  }
  ["rets_tmk_division"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tmk_parcel"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(2) "12"
  }
  ["rets_unit_number"]=>
  array(1) {
    [0]=>
    string(3) "629"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1970"
  }
  ["security"]=>
  array(1) {
    [0]=>
    string(10) "Card,Video"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(4) "Cash"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-2-6-012-003-0129"
  }
  ["unit"]=>
  array(1) {
    [0]=>
    string(23) "Central AC,Single Level"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(4) "City"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "15675754"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202101622"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1628955269"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1970"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(31) "13 - A-3 High Density Apartment"
  }
  ["latitude"]=>
  array(1) {
    [0]=>
    string(10) "21.2848702"
  }
  ["longitude"]=>
  array(1) {
    [0]=>
    string(12) "-157.8366091"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(1533) "a:96:{i:0;i:17426282;i:1;i:17426283;i:2;i:17426284;i:3;i:17426285;i:4;i:17426286;i:5;i:17426287;i:6;i:17426288;i:7;i:17426289;i:8;i:17426290;i:9;i:17426291;i:10;i:17426292;i:11;i:17426293;i:12;i:17511122;i:13;i:17511123;i:14;i:17511124;i:15;i:17511125;i:16;i:17511126;i:17;i:17511127;i:18;i:17511128;i:19;i:17511129;i:20;i:17511130;i:21;i:17511131;i:22;i:17511132;i:23;i:17511133;i:24;i:19319561;i:25;i:19319562;i:26;i:19319563;i:27;i:19319564;i:28;i:19319565;i:29;i:19319566;i:30;i:19319567;i:31;i:19319568;i:32;i:19319569;i:33;i:19319570;i:34;i:19319571;i:35;i:19319572;i:36;i:19505165;i:37;i:19505166;i:38;i:19505167;i:39;i:19505168;i:40;i:19505169;i:41;i:19505170;i:42;i:19505171;i:43;i:19505172;i:44;i:19505173;i:45;i:19505174;i:46;i:19505175;i:47;i:19505176;i:48;i:19519922;i:49;i:19519923;i:50;i:19519924;i:51;i:19519925;i:52;i:19519926;i:53;i:19519927;i:54;i:19519928;i:55;i:19519929;i:56;i:19519930;i:57;i:19519931;i:58;i:19519932;i:59;i:19519933;i:60;i:19807239;i:61;i:19807240;i:62;i:19807241;i:63;i:19807242;i:64;i:19807243;i:65;i:19807244;i:66;i:19807245;i:67;i:19807246;i:68;i:19807247;i:69;i:19807248;i:70;i:19807249;i:71;i:19807250;i:72;i:20095770;i:73;i:20095771;i:74;i:20095772;i:75;i:20095773;i:76;i:20095774;i:77;i:20095775;i:78;i:20095776;i:79;i:20095777;i:80;i:20095778;i:81;i:20095779;i:82;i:20095780;i:83;i:20095781;i:84;i:20342145;i:85;i:20342146;i:86;i:20342147;i:87;i:20342148;i:88;i:20342149;i:89;i:20342150;i:90;i:20342151;i:91;i:20342152;i:92;i:20342153;i:93;i:20342154;i:94;i:20342155;i:95;i:20342156;}"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-03-06"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-04-15"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(9) "190000.00"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-04-15"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 445-9199"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(25) "kate@associatedhawaii.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(9) "Kate Kang"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "48957"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(8) "13062465"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "AREA"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "15110879"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(30) "Associated Real Estate Advisor"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 445-9199"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96815"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(9) "Ala Moana"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(4) "1850"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(9) "Boulevard"
  }
  ["unit_number"]=>
  array(1) {
    [0]=>
    string(3) "629"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "20342145"
  }
}