Exception Object ( [message:protected] => Database error: Invalid SQL: (SELECT NHD.master_name AS neighborhood, NHD.master_area AS area_name, distance, ROUND((with_univ_certificate_degree * 100), 1) AS main_field, (CASE WHEN CAST(with_univ_certificate_degree AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(with_univ_certificate_degree AS DECIMAL) > Step1 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step2 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step3 THEN 'green' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step3 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step4 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step5 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step6 THEN 'red' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step6 THEN 'red' END) AS main_field_color FROM map_demographic_neighborhood1 AS NH LEFT JOIN map_demographic_details1 AS NHD ON NHD.cartodb_id = NH.neighbour_id LEFT JOIN map_demographic_data AS M ON M.Category = 'Education' AND M.DB_FieldName = 'with_univ_certificate_degree' WHERE master_id = '454')UNION (SELECT NHD.master_name AS neighborhood, NHD.master_area AS area_name, '0', ROUND((with_univ_certificate_degree * 100), 1) AS main_field, (CASE WHEN CAST(with_univ_certificate_degree AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(with_univ_certificate_degree AS DECIMAL) > Step1 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step2 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step3 THEN 'green' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step3 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step4 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step5 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step6 THEN 'red' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step6 THEN 'red' END) AS main_field_color FROM map_demographic_details1 AS NHD LEFT JOIN map_demographic_data AS M ON M.Category = 'Education' AND M.DB_FieldName = 'with_univ_certificate_degree' WHERE cartodb_id = '454') ORDER BY distance ASC LIMIT 1
MySQL Error: 1021 (Disk full (/home/tmp/#sql_14bf_16.MAI); waiting for someone to free some space... (errno: 28 "No space left on device"))
[string:Exception:private] => [code:protected] => 0 [file:protected] => /home/estatebl/public_html/libs/mysql5i.php [line:protected] => 665 [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.master_name AS neighborhood, NHD.master_area AS area_name, distance, ROUND((with_univ_certificate_degree * 100), 1) AS main_field, (CASE WHEN CAST(with_univ_certificate_degree AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(with_univ_certificate_degree AS DECIMAL) > Step1 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step2 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step3 THEN 'green' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step3 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step4 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step5 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step6 THEN 'red' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step6 THEN 'red' END) AS main_field_color FROM map_demographic_neighborhood1 AS NH LEFT JOIN map_demographic_details1 AS NHD ON NHD.cartodb_id = NH.neighbour_id LEFT JOIN map_demographic_data AS M ON M.Category = 'Education' AND M.DB_FieldName = 'with_univ_certificate_degree' WHERE master_id = '454')UNION (SELECT NHD.master_name AS neighborhood, NHD.master_area AS area_name, '0', ROUND((with_univ_certificate_degree * 100), 1) AS main_field, (CASE WHEN CAST(with_univ_certificate_degree AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(with_univ_certificate_degree AS DECIMAL) > Step1 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step2 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step3 THEN 'green' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step3 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step4 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step5 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step6 THEN 'red' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step6 THEN 'red' END) AS main_field_color FROM map_demographic_details1 AS NHD LEFT JOIN map_demographic_data AS M ON M.Category = 'Education' AND M.DB_FieldName = 'with_univ_certificate_degree' WHERE cartodb_id = '454') ORDER BY distance ASC LIMIT 1 ) ) [1] => Array ( [file] => /home/estatebl/public_html/db_access/Demographic.php [line] => 509 [function] => query [class] => DB_Sql [type] => -> [args] => Array ( [0] => (SELECT NHD.master_name AS neighborhood, NHD.master_area AS area_name, distance, ROUND((with_univ_certificate_degree * 100), 1) AS main_field, (CASE WHEN CAST(with_univ_certificate_degree AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(with_univ_certificate_degree AS DECIMAL) > Step1 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step2 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step3 THEN 'green' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step3 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step4 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step5 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step6 THEN 'red' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step6 THEN 'red' END) AS main_field_color FROM map_demographic_neighborhood1 AS NH LEFT JOIN map_demographic_details1 AS NHD ON NHD.cartodb_id = NH.neighbour_id LEFT JOIN map_demographic_data AS M ON M.Category = 'Education' AND M.DB_FieldName = 'with_univ_certificate_degree' WHERE master_id = '454')UNION (SELECT NHD.master_name AS neighborhood, NHD.master_area AS area_name, '0', ROUND((with_univ_certificate_degree * 100), 1) AS main_field, (CASE WHEN CAST(with_univ_certificate_degree AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(with_univ_certificate_degree AS DECIMAL) > Step1 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step2 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step3 THEN 'green' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step3 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step4 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step5 AND CAST(with_univ_certificate_degree AS DECIMAL) < Step6 THEN 'red' WHEN CAST(with_univ_certificate_degree AS DECIMAL) >= Step6 THEN 'red' END) AS main_field_color FROM map_demographic_details1 AS NHD LEFT JOIN map_demographic_data AS M ON M.Category = 'Education' AND M.DB_FieldName = 'with_univ_certificate_degree' WHERE cartodb_id = '454') ORDER BY distance ASC LIMIT 1 ) ) [2] => Array ( [file] => /home/estatebl/public_html/component/IDXListingComponent.php [line] => 816 [function] => getNeighborhoodUniData [class] => Demographic [type] => -> [args] => Array ( [0] => Array ( [main_category] => Education [sub_category] => % with univ. certificate/degree [rel_field_name] => with_univ_certificate_degree [cartodb_id] => 454 ) ) ) [3] => Array ( [file] => /home/estatebl/public_html/listing.php [line] => 531 [function] => buildUniqueTextData [class] => IDXListingComponent [type] => -> [args] => Array ( [0] => Array ( [MLS_NUM] => R2471056 [MLSP_ID] => 1 [listing_key] => R2471056-1 [resource] => Property [class] => RA_2 [mls_board_name] => Real Estate Board of Greater Vancouver [agent_code] => V82462 [agent_key] => V82462-1 [agent_name] => Mohsen Rahmanian [office_code] => V000913 [office_key] => V000913-1 [office_name] => Sutton Group-West Coast Realty [ListingKey] => [PropertyType] => Residential Attached [PropertyTypeNew] => Apartment/Condo [PropertyStyle] => [ListingStatus] => Active [SubType] => Apartment/Condo [OwnershipType] => Freehold Strata [OwnershipTypeNew] => Freehold Strata [Zoning] => [BathsFull] => 2 [BathsHalf] => 0 [Baths] => 2 [Beds] => 2 [TotalAcreage] => 0 [ListPrice] => 998000 [ListMarketPercentage] => 0 [ListMarketPercentageCity] => 0 [OriginalListPrice] => 998000 [SQFT] => 0 [FloorArea] => 977 [YearBuilt] => 2019 [TotalPhotos] => 21 [Main_Photo] => 1 [Description] => Centrally located in the Brentwood neighbourhood this beautiful 977sqft 2 bed 2 bath sits high up on the 39th floor W/ CITY & WATER VIEWs. Just steps away from the Gilmore Skytrain station, you can enjoy all the luxuries this building has to offer. It features an expansive open-concept kitchen, dining & living room. Homes includes a full sized Stainless Steel appliance package (GAS STOVE), house sized front loading washer/dryer, AIR CONDITIONING, blackout blinds in the bedrooms, expansive windows & a spacious balcony with 180 Degree VIEWS. Escala features 15,000 SF of amenity space including a full time concierge, fitness centre, lounge, kitchen area, billiards table, indoor pool, sauna/steam room, hot tub, theatre room & Rental suite for out of town visitors. EV PARKING SPOTS AVAILABLE [Description2] => Centrally located in the Brentwood neighbourhood this beautiful 977sqft 2 bed 2 bath sits high up on the 39th floor W/ CITY & WATER VIEWs. Just steps away from the Gilmore Skytrain station, you can enjoy all the luxuries this building has to offer. It features an expansive open-concept kitchen, dining & living room. Homes includes a full sized Stainless Steel appliance package (GAS STOVE), house sized front loading washer/dryer, AIR CONDITIONING, blackout blinds in the bedrooms, expansive windows & a spacious balcony with 180 Degree VIEWS. Escala features 15,000 SF of amenity space including a full time concierge, fitness centre, lounge, kitchen area, billiards table, indoor pool, sauna/steam room, hot tub, theatre room & Rental suite for out of town visitors. EV PARKING SPOTS AVAILABLE [Stories] => 1 [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 388.19 [Tax] => 2605.81 [TaxYear] => 2020 [Region] => [ListingDate] => 2020-06-30 [LastUpdateDate] => 2020-07-01T02:17:06 [LastPhotoDate] => [Pic_Download_Flag] => N [Pic_Updated_Date] => [Pic_Download_Try_Date] => [DisplayAddress] => Yes [PublishOnInternet] => Yes [business_type_major] => [business_type_minor] => [dom] => 3 [tag] => [is_openhouse] => No [vw_is_show_only_processed] => Yes [is_mark_for_deletion] => N [Listing_Created_Date] => 2020-06-30 19:40:02 [is_price_reduced] => N [price_reduced_date] => [cartodb_id_ele_sch] => 318 [cartodb_id_ele_sch_process] => Yes [cartodb_id_mid_sch] => 0 [cartodb_id_mid_sch_process] => Yes [cartodb_id_sec_sch] => 60 [cartodb_id_sec_sch_process] => Yes [cartodb_id_crime] => 4 [cartodb_id_crime_process] => Yes [cartodb_id_demographic1] => 454 [cartodb_id_demographic1_process] => Yes [cartodb_id_demographic2] => 275 [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] => 41 [cartodb_id_city_process] => Yes [cartodb_id_area] => 18 [cartodb_id_area_process] => Yes [cartodb_id_subdivision] => 1806 [cartodb_id_subdivision_process] => Yes [DeletedDate] => 0000-00-00 00:00:00 [rets_system_key] => 262492683 [display_on_website] => Yes [display_on_website_datetime] => 1593571686 [created_datetime] => 2020-06-30 19:40:02 [updated_datetime] => 2020-06-30 19:40:02 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2020-06-30 19:42:26 [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] => R2471056-1 [Area] => Burnaby North [StreetName] => GILMORE [StreetNumber] => 1788 [StreetType] => AVENUE [UnitNo] => 3905 [StreetDirection] => [ZipCode] => V5C 0L5 [CityName] => Burnaby [County] => [State] => BC [Subdivision] => Brentwood Park [Latitude] => 49.268308600000000 [Longitude] => -123.013669700000000 [DayOnMarket] => 4 [Pic_Path] => https://static.estateblock.com/pictures/property/R2471056-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 ) [LA1_Char100_1] => Mohsen Rahmanian [LA1_Email] => Mohsensrahmanian@gmail.com [LA1_LoginName] => V82462 [LA1_PhoneNumber1] => 778-389-6777 [LFD_Amenities_56] => Air Cond./Central,Exercise Centre,Pool; Indoor,Sauna/Steam Room,Swirlpool/Hot Tub,Concierge [LFD_BasementArea_37] => None [LFD_BylawRestrictions_58] => No Restrictions [LFD_Construction_41] => Concrete [LFD_ExteriorFinish_42] => Glass [LFD_FuelHeating_48] => Forced Air [LFD_MaintFeeIncludes_57] => Garbage Pickup,Gas,Hot Water,Management,Recreation Facility,Snow removal [LFD_OutdoorArea_47] => Balcony(s) [LFD_Parking_44] => Garage Underbuilding [LFD_Roof_43] => Other [LFD_ServicesConnected_38] => Community,Electricity,Natural Gas,Sanitary Sewer,Storm Sewer,Water [LFD_StyleofHome_32] => 1 Storey [LFD_WaterSupply_39] => City/Municipal [LM_char100_1] => 030-833-400 [LM_char100_3] => CITY MOUNTAINS WATER [LM_Char10_10] => Attached [LM_Char10_11] => Apartment/Condo [LM_Char10_12] => Freehold Strata [LM_Char10_13] => No [LM_Char10_17] => CONDO [LM_Char10_18] => Concrete Block [LM_Char10_23] => Yes [LM_Char10_25] => Living Room [LM_Char10_4] => Greater Vancouver [LM_Char10_5] => Brentwood Park [LM_Char10_6] => Real Estate Board of Greater Vancouver [LM_Char1_1] => Yes [LM_Char1_13] => Yes [LM_Char1_2] => No [LM_char1_36] => Residential Attached [LM_char255_1] => 3.22% ON 1ST $100,000 & 1.15% ON REMAINDER [LM_Char25_16] => Main [LM_Char25_17] => Main [LM_Char25_27] => 604-683-8900 [LM_char30_2] => First Service [LM_Char50_4] => Never Lived In [LM_Char50_5] => ESCALA [LM_char5_10] => Main [LM_char5_11] => Dining Room [LM_char5_12] => 12'0 [LM_char5_13] => 6'6 [LM_char5_14] => Main [LM_char5_15] => Kitchen [LM_char5_16] => 12'2 [LM_char5_17] => 8'3 [LM_char5_18] => Main [LM_char5_19] => Master Bedroom [LM_char5_20] => 12'8 [LM_char5_21] => 10'3 [LM_char5_22] => Main [LM_char5_23] => Walk-In Closet [LM_char5_24] => 4'9 [LM_char5_25] => 5'0 [LM_char5_26] => Main [LM_char5_27] => Bedroom [LM_char5_28] => 12'4 [LM_char5_29] => 9'9 [LM_char5_30] => Main [LM_char5_31] => Foyer [LM_char5_32] => 10'10 [LM_char5_33] => 3'10 [LM_char5_34] => Main [LM_char5_35] => Patio [LM_char5_36] => 11'6 [LM_char5_37] => 9'3 [LM_char5_7] => Main [LM_char5_8] => 11'5 [LM_char5_9] => 11'10 [LM_Dec_1] => 977 [LM_Dec_11] => 0.00 [LM_Dec_12] => 0.00 [LM_Dec_13] => 0.00 [LM_Dec_14] => 0.00 [LM_Dec_16] => 2605.81 [LM_Dec_22] => 388.19 [LM_Dec_5] => 977 [LM_Dec_7] => 977 [LM_Int1_1] => 1 [LM_Int1_10] => 4 [LM_Int1_18] => 2 [LM_Int1_19] => 2 [LM_Int1_20] => 4 [LM_Int1_4] => 2 [LM_Int1_6] => 2 [LM_Int1_7] => 8 [LM_Int1_8] => 1 [LM_Int1_9] => 4 [LM_Int2_2] => 2019 [LM_Int2_3] => 1 [LM_Int2_5] => 2020 [LM_Int2_6] => 1 [LM_Int2_7] => 1 [LM_Int2_8] => 42 [LM_Int4_1] => 520 [LO1_OrganizationName] => Sutton Group-West Coast Realty [LO1_PhoneNumber1] => 604-986-9321 [LO1_ShortName] => V000913 [LR_remarks22] => Centrally located in the Brentwood neighbourhood this beautiful 977sqft 2 bed 2 bath sits high up on the 39th floor W/ CITY & WATER VIEWs. Just steps away from the Gilmore Skytrain station, you can enjoy all the luxuries this building has to offer. It features an expansive open-concept kitchen, dining & living room. Homes includes a full sized Stainless Steel appliance package (GAS STOVE), house sized front loading washer/dryer, AIR CONDITIONING, blackout blinds in the bedrooms, expansive windows & a spacious balcony with 180 Degree VIEWS. Escala features 15,000 SF of amenity space including a full time concierge, fitness centre, lounge, kitchen area, billiards table, indoor pool, sauna/steam room, hot tub, theatre room & Rental suite for out of town visitors. EV PARKING SPOTS AVAILABLE [LR_remarks33] => Centrally located in the Brentwood neighbourhood this beautiful 977sqft 2 bed 2 bath sits high up on the 39th floor W/ CITY & WATER VIEWs. Just steps away from the Gilmore Skytrain station, you can enjoy all the luxuries this building has to offer. It features an expansive open-concept kitchen, dining & living room. Homes includes a full sized Stainless Steel appliance package (GAS STOVE), house sized front loading washer/dryer, AIR CONDITIONING, blackout blinds in the bedrooms, expansive windows & a spacious balcony with 180 Degree VIEWS. Escala features 15,000 SF of amenity space including a full time concierge, fitness centre, lounge, kitchen area, billiards table, indoor pool, sauna/steam room, hot tub, theatre room & Rental suite for out of town visitors. EV PARKING SPOTS AVAILABLE [LV_vow_address] => Yes [LV_vow_include] => Yes [L_Address] => 3905 1788 GILMORE AVENUE [L_AddressNumber] => 1788 [L_AddressStreet] => GILMORE [L_AddressUnit] => 3905 [L_Area] => Burnaby North [L_AskingPrice] => 998000 [L_City] => Burnaby [L_DisplayId] => R2471056 [L_ExpirationDate] => 2020-12-31 [L_IdxInclude] => Yes [L_InputDate] => 2020-07-01T02:07:38 [L_Last_Photo_updt] => 2020-07-01T02:13:34 [L_ListAgent1] => 59087 [L_ListingDate] => 2020-06-30 [L_ListingID] => 262492683 [L_ListOffice1] => 2935 [L_OriginalPrice] => 998000 [L_PictureCount] => 21 [L_PricePerSQFT] => 1021.49 [L_Remarks] => STRATA LOT 492, PLAN EPS5846, DISTRICT LOT 120, GROUP 1, NEW WESTMINSTER LAND DISTRICT, TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE [L_State] => BC [L_Status] => Active [L_StreetDesignationId] => AVENUE [L_Type_] => Apartment/Condo [L_UpdateDate] => 2020-07-01T02:17:06 [L_Zip] => V5C 0L5 [Section] => mls ) ) ) ) [previous:Exception:private] => )