Exception Object ( [message:protected] => Database error: Invalid SQL: (SELECT NHD.area_name, distance, DrugsCrimeRateIncidents, DrugsCrimeRate,DrugsCrimeRateRating,PropertyCrimeRateIncidents, PropertyCrimeRate ,PropertyCrimeRateRating,ViolentCrimeRateIncidents,ViolentCrimeRate,ViolentCrimeRateRating,TotalCrimeRateIncidents,TotalCrimeRate,TotalCrimeRateRating FROM map_demographic_crime_neighborhood AS NH LEFT JOIN map_demographic_crime_details AS NHD ON NHD.Cartodbid = NH.neighbour_id WHERE master_id = '15') UNION (SELECT NHD.area_name, '0', DrugsCrimeRateIncidents, DrugsCrimeRate,DrugsCrimeRateRating,PropertyCrimeRateIncidents, PropertyCrimeRate ,PropertyCrimeRateRating,ViolentCrimeRateIncidents,ViolentCrimeRate,ViolentCrimeRateRating,TotalCrimeRateIncidents,TotalCrimeRate,TotalCrimeRateRating FROM map_demographic_crime_details AS NHD WHERE Cartodbid = '15') ORDER BY distance ASC LIMIT 1
MySQL Error: 1030 (Got error 28 from storage engine)
[string:Exception:private] => [code:protected] => 0 [file:protected] => /home/estatebl/public_html/libs/mysql5i.php [line:protected] => 670 [trace:Exception:private] => Array ( [0] => Array ( [file] => /home/estatebl/public_html/libs/mysql5i.php [line] => 514 [function] => halt [class] => DB_Sql [type] => -> [args] => Array ( [0] => Invalid SQL: (SELECT NHD.area_name, distance, DrugsCrimeRateIncidents, DrugsCrimeRate,DrugsCrimeRateRating,PropertyCrimeRateIncidents, PropertyCrimeRate ,PropertyCrimeRateRating,ViolentCrimeRateIncidents,ViolentCrimeRate,ViolentCrimeRateRating,TotalCrimeRateIncidents,TotalCrimeRate,TotalCrimeRateRating FROM map_demographic_crime_neighborhood AS NH LEFT JOIN map_demographic_crime_details AS NHD ON NHD.Cartodbid = NH.neighbour_id WHERE master_id = '15') UNION (SELECT NHD.area_name, '0', DrugsCrimeRateIncidents, DrugsCrimeRate,DrugsCrimeRateRating,PropertyCrimeRateIncidents, PropertyCrimeRate ,PropertyCrimeRateRating,ViolentCrimeRateIncidents,ViolentCrimeRate,ViolentCrimeRateRating,TotalCrimeRateIncidents,TotalCrimeRate,TotalCrimeRateRating FROM map_demographic_crime_details AS NHD WHERE Cartodbid = '15') ORDER BY distance ASC LIMIT 1 ) ) [1] => Array ( [file] => /home/estatebl/public_html/db_access/DemographicCrime.php [line] => 212 [function] => query [class] => DB_Sql [type] => -> [args] => Array ( [0] => (SELECT NHD.area_name, distance, DrugsCrimeRateIncidents, DrugsCrimeRate,DrugsCrimeRateRating,PropertyCrimeRateIncidents, PropertyCrimeRate ,PropertyCrimeRateRating,ViolentCrimeRateIncidents,ViolentCrimeRate,ViolentCrimeRateRating,TotalCrimeRateIncidents,TotalCrimeRate,TotalCrimeRateRating FROM map_demographic_crime_neighborhood AS NH LEFT JOIN map_demographic_crime_details AS NHD ON NHD.Cartodbid = NH.neighbour_id WHERE master_id = '15') UNION (SELECT NHD.area_name, '0', DrugsCrimeRateIncidents, DrugsCrimeRate,DrugsCrimeRateRating,PropertyCrimeRateIncidents, PropertyCrimeRate ,PropertyCrimeRateRating,ViolentCrimeRateIncidents,ViolentCrimeRate,ViolentCrimeRateRating,TotalCrimeRateIncidents,TotalCrimeRate,TotalCrimeRateRating FROM map_demographic_crime_details AS NHD WHERE Cartodbid = '15') ORDER BY distance ASC LIMIT 1 ) ) [2] => Array ( [file] => /home/estatebl/public_html/component/IDXListingComponent.php [line] => 471 [function] => getNeighborhoodCrimeData [class] => DemographicCrime [type] => -> [args] => Array ( [0] => Array ( [main_category] => Violent Crime Rate [cartodb_id] => 15 ) ) ) [3] => Array ( [file] => /home/estatebl/public_html/listing.php [line] => 521 [function] => buildUniqueTextData [class] => IDXListingComponent [type] => -> [args] => Array ( [0] => Array ( [MLS_NUM] => R2349282 [MLSP_ID] => 1 [listing_key] => R2349282-1 [resource] => Property [class] => RA_2 [mls_board_name] => Real Estate Board of Greater Vancouver [agent_code] => V32546 [agent_key] => V32546-1 [agent_name] => Victor Mironyuk PREC* [office_code] => V003561 [office_key] => V003561-1 [office_name] => TRG Residential Downtown Rlty [ListingKey] => 0 [PropertyType] => Residential Attached [PropertyTypeNew] => Apartment/Condo [PropertyStyle] => [ListingStatus] => Active [SubType] => Apartment/Condo [OwnershipType] => Leasehold prepaid-Strata [OwnershipTypeNew] => Leasehold [Zoning] => [BathsFull] => 2 [BathsHalf] => 0 [Baths] => 2 [Beds] => 2 [TotalAcreage] => 0 [ListPrice] => 1098000 [ListMarketPercentage] => -5.37 [ListMarketPercentageCity] => -5.37 [OriginalListPrice] => 0 [SQFT] => 0 [FloorArea] => 988 [YearBuilt] => 2013 [TotalPhotos] => 15 [Main_Photo] => 1 [Description] => Luxury Living at UBC! Magnificent WATER VIEW large 2 bedroom 2 baths with 9 foot ceilings condo in a concrete quality built high-rise by Polygon. High End finishes throughout, stay in comfort during the long summer days with air cooling A/C system, enjoy cooking in contemporary kitchen with custom panel appliances, white stone countertops, high end appliances with Liebherr counter depth fridge, luxurious bathrooms covered in marble, Kohler designer fixtures. You will enjoy nature scenery an outdoor activity lifestyle with myriad of hiking/biking trails. Westbrook Village community has great amenities all within close proximity to shopping and transit. “Academy” offers live-in caretaker and welcomes pets and rentals. Included 1 locker and 4 parking stalls! OPEN HOUSE: MAY 19, Sun 2-4PM [Description2] => [Stories] => 1 [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 339.81 [Tax] => 2260.62 [TaxYear] => 2018 [Region] => [ListingDate] => 2019-03-13 [LastUpdateDate] => 2019-05-16T22:06:23.3 [LastPhotoDate] => [Pic_Download_Flag] => N [Pic_Updated_Date] => [Pic_Download_Try_Date] => [DisplayAddress] => Yes [PublishOnInternet] => Yes [business_type_major] => [business_type_minor] => [dom] => 66 [tag] => open_house [is_openhouse] => Yes [vw_is_show_only_processed] => Yes [is_mark_for_deletion] => N [Listing_Created_Date] => 0000-00-00 00:00:00 [is_price_reduced] => N [price_reduced_date] => [cartodb_id_ele_sch] => 277 [cartodb_id_ele_sch_process] => Yes [cartodb_id_mid_sch] => 0 [cartodb_id_mid_sch_process] => Yes [cartodb_id_sec_sch] => 50 [cartodb_id_sec_sch_process] => Yes [cartodb_id_crime] => 15 [cartodb_id_crime_process] => Yes [cartodb_id_demographic1] => 241 [cartodb_id_demographic1_process] => Yes [cartodb_id_demographic2] => 212 [cartodb_id_demographic2_process] => Yes [cartodb_id_flood] => 0 [cartodb_id_flood_process] => Yes [cartodb_id_roads2_bound] => No [cartodb_id_roads2_process] => Yes [cartodb_id_rail_skytrain_bound] => No [cartodb_id_rail_skytrain_process] => Yes [cartodb_id_airports_ports_bound] => No [cartodb_id_airports_ports_process] => Yes [cartodb_id_power_bound] => No [cartodb_id_power_process] => Yes [cartodb_id_alr] => 0 [cartodb_id_alr_process] => Yes [cartodb_id_cemeteries] => 0 [cartodb_id_cemeteries_process] => Yes [cartodb_id_city] => 1 [cartodb_id_city_process] => Yes [cartodb_id_area] => 77 [cartodb_id_area_process] => Yes [cartodb_id_subdivision] => 1 [cartodb_id_subdivision_process] => Yes [DeletedDate] => 0000-00-00 00:00:00 [rets_system_key] => 262370909 [display_on_website] => Yes [display_on_website_datetime] => 1552693441 [created_datetime] => 2019-03-15 16:00:05 [updated_datetime] => 2019-05-16 15:40:08 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2019-05-16 15:44:36 [is_hotdeal] => No [hotdeal_tag] => [hotdeal_description] => null [BasementArea] => [Features] => [Amenities] => [SiteInfluences] => [View] => [Frontage] => [mls_market_sef_url] => lower-mainland [mls_is_pic_url_supported] => No [ListingID_MLS] => R2349282-1 [Area] => Vancouver West [StreetName] => BERTON [StreetNumber] => 5728 [StreetType] => AVENUE [UnitNo] => 1702 [StreetDirection] => [ZipCode] => V6S 0E5 [CityName] => Vancouver [County] => [State] => BC [Subdivision] => University VW [Latitude] => 49.256122400000000 [Longitude] => -123.232006700000000 [DayOnMarket] => 67 [Pic_Path] => https://static.estateblock.com/pictures/property/R2349282-1/0 [mls_disclaimer_big] => The data relating to real estate on this website comes in part from the MLS® Reciprocity program of either the Real Estate Board of Greater Vancouver (REBGV), the Fraser Valley Real Estate Board (FVREB) or the Chilliwack and District Real Estate Board (CADREB). Real estate listings held by participating real estate firms are marked with the MLS® logo and detailed information about the listing includes the name of the listing agent. This representation is based in whole or part on data generated by either the REBGV, the FVREB or the CADREB which assumes no responsibility for its accuracy. The materials contained on this page may not be reproduced without the express written consent of either the REBGV, the FVREB or the CADREB. [PictureArr] => Array ( [0] => https://static.estateblock.com/pictures/property/default/0 ) [L_PictureCount] => 15 [L_Last_Photo_updt] => 2019-04-18T20:20:54.2 [LM_char100_3] => Water [LR_remarks22] => Luxury Living at UBC! Magnificent WATER VIEW large 2 bedroom 2 baths with 9 foot ceilings condo in a concrete quality built high-rise by Polygon. High End finishes throughout, stay in comfort during the long summer days with air cooling A/C system, enjoy cooking in contemporary kitchen with custom panel appliances, white stone countertops, high end appliances with Liebherr counter depth fridge, luxurious bathrooms covered in marble, Kohler designer fixtures. You will enjoy nature scenery an outdoor activity lifestyle with myriad of hiking/biking trails. Westbrook Village community has great amenities all within close proximity to shopping and transit. “Academy” offers live-in caretaker and welcomes pets and rentals. Included 1 locker and 4 parking stalls! OPEN HOUSE: MAY 19, Sun 2-4PM [L_Zip] => V6S 0E5 [L_UpdateDate] => 2019-05-16T22:06:23.3 [L_StreetDesignationId] => AVENUE [L_Status] => Active [L_State] => BC [L_ListingID] => 262370909 [L_ListingDate] => 2019-03-13 [L_ListOffice1] => 2758 [L_ListAgent1] => 33287 [L_DisplayId] => R2349282 [L_City] => Vancouver [L_AskingPrice] => 1098000 [L_AddressUnit] => 1702 [L_Area] => Vancouver West [L_AddressStreet] => BERTON [L_AddressNumber] => 5728 [L_Address] => 1702 5728 BERTON AVENUE [LV_vow_include] => Yes [LV_vow_address] => Yes [LO1_ShortName] => V003561 [LO1_PhoneNumber1] => 604-453-6666 [LO1_OrganizationName] => TRG Residential Downtown Rlty [LM_char1_36] => Residential Attached [LM_Int2_5] => 2018 [LM_Int2_3] => 6 [LM_Int2_2] => 2013 [LM_Int1_4] => 2 [LM_Int1_19] => 2 [LM_Int1_18] => 2 [LM_Int1_1] => 1 [LM_Dec_7] => 988 [LM_Dec_22] => 339.81 [LM_Dec_16] => 2260.62 [LM_Dec_1] => 988 [LM_Char10_6] => Real Estate Board of Greater Vancouver [LM_Char10_5] => University VW [LM_Char10_23] => Yes [LM_Char10_11] => Apartment/Condo [LFD_StyleofHome_32] => Corner Unit,Upper Unit [LFD_SiteInfluences_46] => Central Location,Golf Course Nearby,Recreation Nearby,Shopping Nearby,Treed [LFD_FeaturesIncluded_55] => Air Conditioning [LFD_Amenities_56] => Air Cond./Central,Elevator,In Suite Laundry,Playground,Storage [LA1_WebPage] => www.vancouverjustlisted.ca [LA1_PhoneNumber1] => 604-727-1097 [LA1_LoginName] => V32546 [LA1_Char100_1] => Victor Mironyuk PREC* [LM_Char10_12] => Leasehold prepaid-Strata [Section] => mls ) ) ) ) [previous:Exception:private] => )