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 = '471')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 = '471') ORDER BY distance ASC LIMIT 1
MySQL Error: 1021 (Disk full (/home/tmp/#sql_14bc_35.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 = '471')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 = '471') 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 = '471')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 = '471') 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] => 471 ) ) ) [3] => Array ( [file] => /home/estatebl/public_html/listing.php [line] => 531 [function] => buildUniqueTextData [class] => IDXListingComponent [type] => -> [args] => Array ( [0] => Array ( [MLS_NUM] => R2470452 [MLSP_ID] => 1 [listing_key] => R2470452-1 [resource] => Property [class] => RD_1 [mls_board_name] => Real Estate Board of Greater Vancouver [agent_code] => V18797 [agent_key] => V18797-1 [agent_name] => Herb Johnstone PREC* [office_code] => V002503 [office_key] => V002503-1 [office_name] => Sutton Group-West Coast Realty [ListingKey] => [PropertyType] => Residential Detached [PropertyTypeNew] => House [PropertyStyle] => 2 Storey w/Bsmt. [ListingStatus] => Active [SubType] => House/Single Family [OwnershipType] => Freehold NonStrata [OwnershipTypeNew] => Freehold [Zoning] => [BathsFull] => 2 [BathsHalf] => 1 [Baths] => 3 [Beds] => 4 [TotalAcreage] => 0.21 [ListPrice] => 1398000 [ListMarketPercentage] => 0 [ListMarketPercentageCity] => 0 [OriginalListPrice] => 1398000 [SQFT] => 9072 [FloorArea] => 4002 [YearBuilt] => 1985 [TotalPhotos] => 32 [Main_Photo] => 1 [Description] => This SPACIOUS & CLEAN Tudor Style Home sits on the high side of the street, in a cul-de-sac location, on a HUGE, private 9,072 s.f. lot. This 3 level, 4000 s.f. aprox. home has 4 bedrooms plus games room up, the M. bedroom has 2 w/i closets and a full ensuite. The main floor has generous rooms, plus screened french doors off the kitchen that open to a sunny patio (28'x17'). Downstairs, there is a home theatre and unfinished area with a separate entrance. Other features inc newer roof and windows w/screens (2012), hardwood floors, skylights, natural gas BBQ h/u, irrigation system and built in vacuum. Close to Schools, Transit, Shopping, Mundy Park, Hwy & Freeway. Private Showings Sunday July 5 (2-4 pm) Please call to book your appointment. [Description2] => [Stories] => 3 [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 0.00 [Tax] => 5109.45 [TaxYear] => 2019 [Region] => [ListingDate] => 2020-06-29 [LastUpdateDate] => 2020-07-06T17:13:53 [LastPhotoDate] => [Pic_Download_Flag] => N [Pic_Updated_Date] => [Pic_Download_Try_Date] => [DisplayAddress] => Yes [PublishOnInternet] => Yes [business_type_major] => [business_type_minor] => [dom] => 7 [tag] => [is_openhouse] => No [vw_is_show_only_processed] => Yes [is_mark_for_deletion] => N [Listing_Created_Date] => 2020-06-29 16:20:06 [is_price_reduced] => N [price_reduced_date] => [cartodb_id_ele_sch] => 460 [cartodb_id_ele_sch_process] => Yes [cartodb_id_mid_sch] => 23 [cartodb_id_mid_sch_process] => Yes [cartodb_id_sec_sch] => 109 [cartodb_id_sec_sch_process] => Yes [cartodb_id_crime] => 24 [cartodb_id_crime_process] => Yes [cartodb_id_demographic1] => 471 [cartodb_id_demographic1_process] => Yes [cartodb_id_demographic2] => 42 [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] => 20 [cartodb_id_city_process] => Yes [cartodb_id_area] => 20 [cartodb_id_area_process] => Yes [cartodb_id_subdivision] => 2007 [cartodb_id_subdivision_process] => Yes [DeletedDate] => 0000-00-00 00:00:00 [rets_system_key] => 262492079 [display_on_website] => Yes [display_on_website_datetime] => 1593476166 [created_datetime] => 2020-06-29 16:20:06 [updated_datetime] => 2020-07-06 10:20:05 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2020-07-06 10:35:32 [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] => R2470452-1 [Area] => Coquitlam [StreetName] => ASHURST [StreetNumber] => 2509 [StreetType] => AVENUE [UnitNo] => [StreetDirection] => [ZipCode] => V3K 5T5 [CityName] => Coquitlam [County] => [State] => BC [Subdivision] => Coquitlam East [Latitude] => 49.242958200000000 [Longitude] => -122.825113100000000 [DayOnMarket] => 7 [Pic_Path] => https://static.estateblock.com/pictures/property/R2470452-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] => Herb Johnstone PREC* [LA1_Email] => herbj@telus.net [LA1_LoginName] => V18797 [LA1_PhoneNumber1] => 604-415-9800 [LA1_WebPage] => http://www.herbjohnstone.com [LFD_BasementArea_6] => Full [LFD_Construction_10] => Frame - Wood [LFD_DirectionalExpRearYard_9] => Northwest [LFD_ExteriorFinish_11] => Brick,Stucco,Wood [LFD_FeaturesIncluded_24] => ClthWsh/Dryr/Frdg/Stve/DW,Garage Door Opener,Vacuum - Built In [LFD_FireplaceFueledby_18] => Natural Gas [LFD_FloorFinish_19] => Hardwood,Wall/Wall/Mixed [LFD_FuelHeating_17] => Forced Air [LFD_OutdoorArea_16] => Patio(s) [LFD_ParkingAccess_14] => Front [LFD_Parking_13] => Garage; Double [LFD_Renovations_4] => Partly [LFD_Roof_12] => Fibreglass [LFD_ServicesConnected_7] => Natural Gas,Sanitary Sewer,Water [LFD_SiteInfluences_15] => Cul-de-Sac,Private Setting,Private Yard,Recreation Nearby,Shopping Nearby,Treed [LFD_StyleofHome_1] => 2 Storey w/Bsmt. [LFD_Suite_5] => None [LFD_WaterSupply_8] => City/Municipal [LM_char100_1] => 000-871-591 [LM_Char10_10] => Detached [LM_Char10_11] => House/Single Family [LM_Char10_12] => Freehold NonStrata [LM_Char10_13] => Yes [LM_Char10_15] => No [LM_Char10_16] => No [LM_Char10_17] => SFD [LM_Char10_18] => Concrete Perimeter [LM_Char10_20] => Concrete [LM_Char10_25] => Living Room [LM_Char10_26] => 18'9 [LM_Char10_27] => Bsmt [LM_Char10_28] => Other [LM_Char10_29] => 19' [LM_Char10_30] => 12'9 [LM_Char10_4] => Greater Vancouver [LM_Char10_5] => Coquitlam East [LM_Char10_6] => Real Estate Board of Greater Vancouver [LM_char10_75] => City/Municipal [LM_Char1_1] => No [LM_Char1_10] => No [LM_Char1_2] => No [LM_Char1_3] => Yes [LM_char1_36] => Residential Detached [LM_char255_1] => 3% ON THE FIRST $100,000 ; 1.1625% ON THE BALANCE [LM_Char25_16] => Main [LM_Char25_17] => Above [LM_Char25_18] => Above [LM_char30_28] => 162 [LM_char50_11] => 3 blocks [LM_char50_12] => 2 blocks [LM_char5_10] => Main [LM_char5_11] => Dining Room [LM_char5_12] => 14' [LM_char5_13] => 10' [LM_char5_14] => Main [LM_char5_15] => Kitchen [LM_char5_16] => 18' [LM_char5_17] => 10' [LM_char5_18] => Main [LM_char5_19] => Eating Area [LM_char5_20] => 13' [LM_char5_21] => 6' [LM_char5_22] => Main [LM_char5_23] => Family Room [LM_char5_24] => 15'5 [LM_char5_25] => 12' [LM_char5_26] => Main [LM_char5_27] => Den [LM_char5_28] => 14' [LM_char5_29] => 10' [LM_char5_30] => Main [LM_char5_31] => Laundry [LM_char5_32] => 10'6 [LM_char5_33] => 6'9 [LM_char5_34] => Above [LM_char5_35] => Master Bedroom [LM_char5_36] => 15'2 [LM_char5_37] => 14'3 [LM_char5_38] => Above [LM_char5_39] => Bedroom [LM_char5_40] => 12'2 [LM_char5_41] => 10'4 [LM_char5_42] => Above [LM_char5_43] => Bedroom [LM_char5_44] => 11'3 [LM_char5_45] => 10'6 [LM_char5_46] => Above [LM_char5_47] => Bedroom [LM_char5_48] => 10'9 [LM_char5_49] => 8'6 [LM_char5_50] => Above [LM_char5_51] => Games Room [LM_char5_52] => 18' [LM_char5_53] => 17' [LM_char5_54] => Bsmt [LM_char5_55] => Media Room [LM_char5_56] => 19'6 [LM_char5_57] => 13'6 [LM_char5_58] => Bsmt [LM_char5_59] => Other [LM_char5_6] => Feet [LM_char5_60] => 31' [LM_char5_7] => Main [LM_char5_8] => 18'9 [LM_char5_9] => 14' [LM_Dec_1] => 1334 [LM_Dec_11] => 9072.00 [LM_Dec_12] => 0.21 [LM_Dec_13] => 842.82 [LM_Dec_14] => 0.08 [LM_Dec_16] => 5109.45 [LM_Dec_2] => 1424 [LM_Dec_4] => 348 [LM_Dec_5] => 3106 [LM_Dec_6] => 896 [LM_Dec_7] => 4002 [LM_Dec_8] => 56.00 [LM_Dec_9] => 17.07 [LM_Int1_1] => 3 [LM_Int1_10] => 4 [LM_Int1_11] => 4 [LM_Int1_17] => 1 [LM_Int1_18] => 2 [LM_Int1_19] => 3 [LM_Int1_2] => 2 [LM_Int1_20] => 4 [LM_Int1_4] => 4 [LM_Int1_6] => 4 [LM_Int1_7] => 15 [LM_Int1_8] => 1 [LM_Int1_9] => 2 [LM_Int2_2] => 1985 [LM_Int2_3] => 35 [LM_Int2_5] => 2019 [LM_Int2_6] => 2 [LM_Int2_7] => 4 [LO1_OrganizationName] => Sutton Group-West Coast Realty [LO1_PhoneNumber1] => 604-415-9800 [LO1_ShortName] => V002503 [LO1_WebPage] => http://www.suttonwestcoast.com [LR_remarks22] => This SPACIOUS & CLEAN Tudor Style Home sits on the high side of the street, in a cul-de-sac location, on a HUGE, private 9,072 s.f. lot. This 3 level, 4000 s.f. aprox. home has 4 bedrooms plus games room up, the M. bedroom has 2 w/i closets and a full ensuite. The main floor has generous rooms, plus screened french doors off the kitchen that open to a sunny patio (28'x17'). Downstairs, there is a home theatre and unfinished area with a separate entrance. Other features inc newer roof and windows w/screens (2012), hardwood floors, skylights, natural gas BBQ h/u, irrigation system and built in vacuum. Close to Schools, Transit, Shopping, Mundy Park, Hwy & Freeway. Private Showings Sunday July 5 (2-4 pm) Please call to book your appointment. [LV_vow_address] => Yes [LV_vow_include] => Yes [L_Address] => 2509 ASHURST AVENUE [L_AddressNumber] => 2509 [L_AddressStreet] => ASHURST [L_Area] => Coquitlam [L_AskingPrice] => 1398000 [L_CDOM] => 7 [L_City] => Coquitlam [L_DisplayId] => R2470452 [L_DOM] => 7 [L_ExpirationDate] => 2020-09-29 [L_IdxInclude] => Yes [L_InputDate] => 2020-06-29T23:08:10 [L_Last_Photo_updt] => 2020-07-06T17:13:54 [L_ListAgent1] => 22875 [L_ListingDate] => 2020-06-29 [L_ListingID] => 262492079 [L_ListOffice1] => 2924 [L_OriginalPrice] => 1398000 [L_PictureCount] => 32 [L_PricePerSQFT] => 349.33 [L_Remarks] => LOT 347, PLAN NWP68433, DISTRICT LOT 112, NEW WESTMINSTER LAND DISTRICT [L_State] => BC [L_Status] => Active [L_StreetDesignationId] => AVENUE [L_Type_] => House/Single Family [L_UpdateDate] => 2020-07-06T17:13:53 [L_Zip] => V3K 5T5 [VT_VTourURL] => https://www.pixilink.com/151508 [Section] => mls ) ) ) ) [previous:Exception:private] => )