Exception Object ( [message:protected] => Database error: Invalid SQL: (SELECT step1,step2,step3,step4,step5,step6, NHD.master_name AS neighborhood, NHD.master_area AS area_name, distance, median_age_of_the_population AS main_field, (CASE WHEN CAST(median_age_of_the_population AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(median_age_of_the_population AS DECIMAL) > Step1 AND CAST(median_age_of_the_population AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step2 AND CAST(median_age_of_the_population AS DECIMAL) < Step3 THEN 'green' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step3 AND CAST(median_age_of_the_population AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step4 AND CAST(median_age_of_the_population AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step5 AND CAST(median_age_of_the_population AS DECIMAL) < Step6 THEN 'red' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step6 THEN 'red' END) AS main_field_color FROM map_demographic_neighborhood2 AS NH LEFT JOIN map_demographic_details2 AS NHD ON NHD.cartodb_id = NH.neighbour_id LEFT JOIN map_demographic_data AS M ON M.Category = 'General' AND M.DB_FieldName = 'median_age_of_the_population' WHERE master_id = '269')UNION(SELECT step1,step2,step3,step4,step5,step6,NHD.master_name AS neighborhood, NHD.master_area AS area_name, '0', median_age_of_the_population AS main_field, (CASE WHEN CAST(median_age_of_the_population AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(median_age_of_the_population AS DECIMAL) > Step1 AND CAST(median_age_of_the_population AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step2 AND CAST(median_age_of_the_population AS DECIMAL) < Step3 THEN 'green' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step3 AND CAST(median_age_of_the_population AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step4 AND CAST(median_age_of_the_population AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step5 AND CAST(median_age_of_the_population AS DECIMAL) < Step6 THEN 'red' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step6 THEN 'red' END) AS main_field_color FROM map_demographic_details2 AS NHD LEFT JOIN map_demographic_data AS M ON M.Category = 'General' AND M.DB_FieldName = 'median_age_of_the_population' WHERE cartodb_id = '269') ORDER BY distance ASC
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 step1,step2,step3,step4,step5,step6, NHD.master_name AS neighborhood, NHD.master_area AS area_name, distance, median_age_of_the_population AS main_field, (CASE WHEN CAST(median_age_of_the_population AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(median_age_of_the_population AS DECIMAL) > Step1 AND CAST(median_age_of_the_population AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step2 AND CAST(median_age_of_the_population AS DECIMAL) < Step3 THEN 'green' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step3 AND CAST(median_age_of_the_population AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step4 AND CAST(median_age_of_the_population AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step5 AND CAST(median_age_of_the_population AS DECIMAL) < Step6 THEN 'red' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step6 THEN 'red' END) AS main_field_color FROM map_demographic_neighborhood2 AS NH LEFT JOIN map_demographic_details2 AS NHD ON NHD.cartodb_id = NH.neighbour_id LEFT JOIN map_demographic_data AS M ON M.Category = 'General' AND M.DB_FieldName = 'median_age_of_the_population' WHERE master_id = '269')UNION(SELECT step1,step2,step3,step4,step5,step6,NHD.master_name AS neighborhood, NHD.master_area AS area_name, '0', median_age_of_the_population AS main_field, (CASE WHEN CAST(median_age_of_the_population AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(median_age_of_the_population AS DECIMAL) > Step1 AND CAST(median_age_of_the_population AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step2 AND CAST(median_age_of_the_population AS DECIMAL) < Step3 THEN 'green' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step3 AND CAST(median_age_of_the_population AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step4 AND CAST(median_age_of_the_population AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step5 AND CAST(median_age_of_the_population AS DECIMAL) < Step6 THEN 'red' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step6 THEN 'red' END) AS main_field_color FROM map_demographic_details2 AS NHD LEFT JOIN map_demographic_data AS M ON M.Category = 'General' AND M.DB_FieldName = 'median_age_of_the_population' WHERE cartodb_id = '269') ORDER BY distance ASC ) ) [1] => Array ( [file] => /home/estatebl/public_html/db_access/Demographic.php [line] => 509 [function] => query [class] => DB_Sql [type] => -> [args] => Array ( [0] => (SELECT step1,step2,step3,step4,step5,step6, NHD.master_name AS neighborhood, NHD.master_area AS area_name, distance, median_age_of_the_population AS main_field, (CASE WHEN CAST(median_age_of_the_population AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(median_age_of_the_population AS DECIMAL) > Step1 AND CAST(median_age_of_the_population AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step2 AND CAST(median_age_of_the_population AS DECIMAL) < Step3 THEN 'green' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step3 AND CAST(median_age_of_the_population AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step4 AND CAST(median_age_of_the_population AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step5 AND CAST(median_age_of_the_population AS DECIMAL) < Step6 THEN 'red' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step6 THEN 'red' END) AS main_field_color FROM map_demographic_neighborhood2 AS NH LEFT JOIN map_demographic_details2 AS NHD ON NHD.cartodb_id = NH.neighbour_id LEFT JOIN map_demographic_data AS M ON M.Category = 'General' AND M.DB_FieldName = 'median_age_of_the_population' WHERE master_id = '269')UNION(SELECT step1,step2,step3,step4,step5,step6,NHD.master_name AS neighborhood, NHD.master_area AS area_name, '0', median_age_of_the_population AS main_field, (CASE WHEN CAST(median_age_of_the_population AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(median_age_of_the_population AS DECIMAL) > Step1 AND CAST(median_age_of_the_population AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step2 AND CAST(median_age_of_the_population AS DECIMAL) < Step3 THEN 'green' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step3 AND CAST(median_age_of_the_population AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step4 AND CAST(median_age_of_the_population AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step5 AND CAST(median_age_of_the_population AS DECIMAL) < Step6 THEN 'red' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step6 THEN 'red' END) AS main_field_color FROM map_demographic_details2 AS NHD LEFT JOIN map_demographic_data AS M ON M.Category = 'General' AND M.DB_FieldName = 'median_age_of_the_population' WHERE cartodb_id = '269') ORDER BY distance ASC ) ) [2] => Array ( [file] => /home/estatebl/public_html/component/IDXListingComponent.php [line] => 914 [function] => getNeighborhoodUniData [class] => Demographic [type] => -> [args] => Array ( [0] => Array ( [main_category] => General [sub_category] => Median Age [rel_field_name] => median_age_of_the_population [cartodb_id] => 269 ) ) ) [3] => Array ( [file] => /home/estatebl/public_html/listing.php [line] => 521 [function] => buildUniqueTextData [class] => IDXListingComponent [type] => -> [args] => Array ( [0] => Array ( [MLS_NUM] => R2349020 [MLSP_ID] => 1 [listing_key] => R2349020-1 [resource] => Property [class] => RA_2 [mls_board_name] => Real Estate Board of Greater Vancouver [agent_code] => V46780 [agent_key] => V46780-1 [agent_name] => Cindy Chen PREC* [office_code] => V005157 [office_key] => V005157-1 [office_name] => Saba Realty Ltd. [ListingKey] => 0 [PropertyType] => Residential Attached [PropertyTypeNew] => Apartment/Condo [PropertyStyle] => [ListingStatus] => Active [SubType] => Apartment/Condo [OwnershipType] => Freehold Strata [OwnershipTypeNew] => Freehold Strata [Zoning] => [BathsFull] => 1 [BathsHalf] => 0 [Baths] => 1 [Beds] => 1 [TotalAcreage] => 0 [ListPrice] => 659000 [ListMarketPercentage] => 7.59 [ListMarketPercentageCity] => 1.37 [OriginalListPrice] => 0 [SQFT] => 0 [FloorArea] => 560 [YearBuilt] => 2011 [TotalPhotos] => 17 [Main_Photo] => 1 [Description] => Welcome to "Richards Living" located conveniently in the heart of Yaletown, North America's most vibrant community. This one bedroom and den offers functional layout with no wasted space featuring contemporary kitchen with granite counter tops and European style cabinetry with soft drawers, hardwood floor, 11' x 4 ' balcony. Amenities include fully equipped fitness centre, roof top garden with play area, bike room. Perfect location with front door access to Yaletown's top restaurants, shopping, entertainment, Canada Line Station, seawall and Parks. Great opportunity for professionals, first time buyers and investors. [Description2] => Welcome to "Richards Living" located conveniently in the heart of Yaletown, North America's most vibrant community. This one bedroom and den offers functional layout with no wasted space featuring contemporary kitchen with granite counter tops and European style cabinetry with soft drawers, hardwood floor, 11' x 4 ' balcony. Amenities include fully equipped fitness centre, roof top garden with play area, bike room. Perfect location with front door access to Yaletown's top restaurants, shopping, entertainment, Canada Line Station, seawall and Parks. Great opportunity for professionals first time buyers and investors. [Stories] => 1 [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 209.16 [Tax] => 1520.45 [TaxYear] => 2018 [Region] => [ListingDate] => 2019-03-14 [LastUpdateDate] => 2019-04-27T19:28:00 [LastPhotoDate] => [Pic_Download_Flag] => N [Pic_Updated_Date] => [Pic_Download_Try_Date] => [DisplayAddress] => Yes [PublishOnInternet] => Yes [business_type_major] => [business_type_minor] => [dom] => 65 [tag] => [is_openhouse] => No [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] => 53 [cartodb_id_ele_sch_process] => Yes [cartodb_id_mid_sch] => 0 [cartodb_id_mid_sch_process] => Yes [cartodb_id_sec_sch] => 44 [cartodb_id_sec_sch_process] => Yes [cartodb_id_crime] => 9 [cartodb_id_crime_process] => Yes [cartodb_id_demographic1] => 228 [cartodb_id_demographic1_process] => Yes [cartodb_id_demographic2] => 269 [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] => 36 [cartodb_id_subdivision_process] => Yes [DeletedDate] => 0000-00-00 00:00:00 [rets_system_key] => 262370647 [display_on_website] => Yes [display_on_website_datetime] => 1552656001 [created_datetime] => 2019-03-14 18:40:05 [updated_datetime] => 2019-04-30 11:01:38 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2019-05-02 03:27:42 [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] => R2349020-1 [Area] => Vancouver West [StreetName] => RICHARDS [StreetNumber] => 1088 [StreetType] => STREET [UnitNo] => 710 [StreetDirection] => [ZipCode] => V6B 0J8 [CityName] => Vancouver [County] => [State] => BC [Subdivision] => Yaletown [Latitude] => 49.277338900000000 [Longitude] => -123.121624600000000 [DayOnMarket] => 66 [Pic_Path] => https://static.estateblock.com/pictures/property/R2349020-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] => 17 [LM_Int1_4] => 1 [LFD_SiteInfluences_46] => Central Location,Marina Nearby,Recreation Nearby,Shopping Nearby [LFD_FeaturesIncluded_55] => ClthWsh/Dryr/Frdg/Stve/DW,Disposal - Waste,Drapes/Window Coverings [L_Zip] => V6B 0J8 [L_UpdateDate] => 2019-04-27T19:28:00 [L_StreetDesignationId] => STREET [L_Status] => Active [L_State] => BC [L_ListingID] => 262370647 [L_ListingDate] => 2019-03-14 [L_ListOffice1] => 4254 [L_ListAgent1] => 38433 [L_DisplayId] => R2349020 [L_City] => Vancouver [L_AskingPrice] => 659000 [L_Area] => Vancouver West [L_AddressUnit] => 710 [L_AddressStreet] => RICHARDS [L_AddressNumber] => 1088 [L_Address] => 710 1088 RICHARDS STREET [LV_vow_include] => Yes [LV_vow_address] => Yes [L_Last_Photo_updt] => 2019-04-24T01:18:42 [LR_remarks33] => Welcome to "Richards Living" located conveniently in the heart of Yaletown, North America's most vibrant community. This one bedroom and den offers functional layout with no wasted space featuring contemporary kitchen with granite counter tops and European style cabinetry with soft drawers, hardwood floor, 11' x 4 ' balcony. Amenities include fully equipped fitness centre, roof top garden with play area, bike room. Perfect location with front door access to Yaletown's top restaurants, shopping, entertainment, Canada Line Station, seawall and Parks. Great opportunity for professionals first time buyers and investors. [LR_remarks22] => Welcome to "Richards Living" located conveniently in the heart of Yaletown, North America's most vibrant community. This one bedroom and den offers functional layout with no wasted space featuring contemporary kitchen with granite counter tops and European style cabinetry with soft drawers, hardwood floor, 11' x 4 ' balcony. Amenities include fully equipped fitness centre, roof top garden with play area, bike room. Perfect location with front door access to Yaletown's top restaurants, shopping, entertainment, Canada Line Station, seawall and Parks. Great opportunity for professionals, first time buyers and investors. [LO1_ShortName] => V005157 [LO1_PhoneNumber1] => 604-370-0877 [LO1_OrganizationName] => Saba Realty Ltd. [LM_char1_36] => Residential Attached [LM_Int2_5] => 2018 [LM_Int2_3] => 8 [LM_Int2_2] => 2011 [LM_Int1_19] => 1 [LM_Int1_18] => 1 [LM_Int1_1] => 1 [LM_Dec_7] => 560 [LM_Dec_22] => 209.16 [LM_Dec_16] => 1520.45 [LM_Dec_1] => 560 [LM_Char10_6] => Real Estate Board of Greater Vancouver [LM_Char10_5] => Yaletown [LM_Char10_11] => Apartment/Condo [LFD_StyleofHome_32] => Inside Unit [LFD_Amenities_56] => Bike Room,Elevator,Exercise Centre,Garden,In Suite Laundry,Playground [LA1_WebPage] => http://www.cindychenhomes.com [LA1_LoginName] => V46780 [LA1_PhoneNumber1] => 604-218-7183 [LA1_Char100_1] => Cindy Chen PREC* [LM_Char10_12] => Freehold Strata [Section] => mls ) ) ) ) [previous:Exception:private] => )