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 = '483')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 = '483') 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 = '483')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 = '483') 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 = '483')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 = '483') 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] => 483 ) ) ) [3] => Array ( [file] => /home/estatebl/public_html/listing.php [line] => 531 [function] => buildUniqueTextData [class] => IDXListingComponent [type] => -> [args] => Array ( [0] => Array ( [MLS_NUM] => R2470989 [MLSP_ID] => 1 [listing_key] => R2470989-1 [resource] => Property [class] => RA_2 [mls_board_name] => Real Estate Board of Greater Vancouver [agent_code] => V74790 [agent_key] => V74790-1 [agent_name] => Peter Chen [office_code] => V004340 [office_key] => V004340-1 [office_name] => Top Vision Realty Inc. [ListingKey] => [PropertyType] => Residential Attached [PropertyTypeNew] => Townhouse [PropertyStyle] => [ListingStatus] => Active [SubType] => Townhouse [OwnershipType] => Freehold Strata [OwnershipTypeNew] => Freehold Strata [Zoning] => [BathsFull] => 3 [BathsHalf] => 0 [Baths] => 3 [Beds] => 3 [TotalAcreage] => 0 [ListPrice] => 829000 [ListMarketPercentage] => 0 [ListMarketPercentageCity] => 0 [OriginalListPrice] => 0 [SQFT] => 0 [FloorArea] => 1456 [YearBuilt] => 2013 [TotalPhotos] => 24 [Main_Photo] => 1 [Description] => The best Burke Mountain has to offer! Bright, south-facing 3 bedrooms / 3 FULL bathrooms plus den. 9' ceiling on the main floor with large windows featuring unobstructed view of Fraser Valley and an oversized sundeck off the kitchen. Chef's kitchen offers high end stainless steel appliances and ample storage space. 3rd bedroom on the ground floor with full bath provides perfect rental opportunity. Newly installed EV charging station in the garage. Master ensuite with heated floor. 5 min walk to elementary school / shopping / transit. Minutes from future commercial and social hub - Burke Mountain Village. Surrounded by plentiful trails and parks, with Galloway Park at doorstep. Unwind in this relaxing and tranquil neighborhood for a vacation-like lifestyle. [Description2] => [Stories] => 3 [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 259.79 [Tax] => 2934.60 [TaxYear] => 2019 [Region] => [ListingDate] => 2020-06-29 [LastUpdateDate] => 2020-07-02T19:59:45 [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-30 16:40:03 [is_price_reduced] => N [price_reduced_date] => [cartodb_id_ele_sch] => 480 [cartodb_id_ele_sch_process] => Yes [cartodb_id_mid_sch] => 31 [cartodb_id_mid_sch_process] => Yes [cartodb_id_sec_sch] => 111 [cartodb_id_sec_sch_process] => Yes [cartodb_id_crime] => 24 [cartodb_id_crime_process] => Yes [cartodb_id_demographic1] => 483 [cartodb_id_demographic1_process] => Yes [cartodb_id_demographic2] => 562 [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] => 2023 [cartodb_id_subdivision_process] => Yes [DeletedDate] => 0000-00-00 00:00:00 [rets_system_key] => 262492616 [display_on_website] => Yes [display_on_website_datetime] => 1593563646 [created_datetime] => 2020-06-30 16:40:03 [updated_datetime] => 2020-07-02 13:20:02 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2020-07-02 13:42:55 [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] => R2470989-1 [Area] => Coquitlam [StreetName] => HAMES [StreetNumber] => 1349 [StreetType] => CRESCENT [UnitNo] => 7 [StreetDirection] => [ZipCode] => V3E 0G7 [CityName] => Coquitlam [County] => [State] => BC [Subdivision] => Burke Mountain [Latitude] => 49.295114300000000 [Longitude] => -122.754216500000000 [DayOnMarket] => 7 [Pic_Path] => https://static.estateblock.com/pictures/property/R2470989-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] => Peter Chen [LA1_Email] => xuenong@gmail.com [LA1_LoginName] => V74790 [LA1_PhoneNumber1] => 604-679-3788 [LA1_WebPage] => http://www.peterealty.com [LA2_Char100_1] => Sharon Hwang PREC* [LA2_Email] => 168sharonhwang@gmail.com [LA2_LoginName] => V91115 [LA2_PhoneNumber1] => 604-812-8808 [LFD_Amenities_56] => In Suite Laundry,Playground [LFD_BasementArea_37] => Part [LFD_BylawRestrictions_58] => Pets Allowed,Rentals Allowed [LFD_Construction_41] => Frame - Wood [LFD_ExteriorFinish_42] => Fibre Cement Board,Stone,Wood [LFD_FeaturesIncluded_55] => ClthWsh/Dryr/Frdg/Stve/DW [LFD_FireplaceFueledby_49] => Electric [LFD_FloorFinish_50] => Laminate,Mixed,Wall/Wall/Mixed [LFD_FuelHeating_48] => Baseboard,Electric [LFD_MaintFeeIncludes_57] => Garbage Pickup,Gardening,Management [LFD_OutdoorArea_47] => Balcony(s) [LFD_ParkingAccess_45] => Rear [LFD_Parking_44] => Garage; Single [LFD_Roof_43] => Asphalt [LFD_ServicesConnected_38] => Electricity,Natural Gas,Water [LFD_SiteInfluences_46] => Central Location,Lane Access,Recreation Nearby,Shopping Nearby [LFD_StyleofHome_32] => 2 Storey w/Bsmt. [LFD_Suite_36] => None [LFD_WaterSupply_39] => City/Municipal [LM_char100_1] => 028-991-681 [LM_char100_3] => FRASER VALLEY-PORTMANN BRIDGE [LM_Char10_10] => Attached [LM_Char10_11] => Townhouse [LM_Char10_12] => Freehold Strata [LM_Char10_13] => Yes [LM_Char10_15] => No [LM_Char10_17] => RTM-1 [LM_Char10_18] => Concrete Slab [LM_Char10_23] => Yes [LM_Char10_25] => Master Bedroom [LM_Char10_4] => Greater Vancouver [LM_Char10_5] => Burke Mountain [LM_Char10_6] => Real Estate Board of Greater Vancouver [LM_char10_75] => City/Municipal [LM_Char1_1] => Yes [LM_Char1_10] => No [LM_Char1_2] => No [LM_Char1_3] => No [LM_char1_36] => Residential Attached [LM_Char1_9] => No [LM_char255_1] => 3.255% ON 1ST $100,000 / 1.1625% ON THE BALANCE [LM_Char25_16] => Above [LM_Char25_17] => Above [LM_Char25_18] => Below [LM_Char25_27] => 604-248-0758 [LM_char30_2] => DWELL PROPERTY [LM_Char50_5] => NORTHBROOK [LM_char5_10] => Above [LM_char5_11] => Bedroom [LM_char5_12] => 12' [LM_char5_13] => 10' [LM_char5_14] => Above [LM_char5_15] => Study [LM_char5_16] => 7' [LM_char5_17] => 6' [LM_char5_18] => Main [LM_char5_19] => Living Room [LM_char5_20] => 15' [LM_char5_21] => 12' [LM_char5_22] => Main [LM_char5_23] => Dining Room [LM_char5_24] => 11' [LM_char5_25] => 9' [LM_char5_26] => Main [LM_char5_27] => Kitchen [LM_char5_28] => 10' [LM_char5_29] => 8' [LM_char5_30] => Main [LM_char5_31] => Family Room [LM_char5_32] => 9' [LM_char5_33] => 7' [LM_char5_34] => Below [LM_char5_35] => Bedroom [LM_char5_36] => 11' [LM_char5_37] => 8' [LM_char5_6] => Feet [LM_char5_7] => Above [LM_char5_8] => 13' [LM_char5_9] => 11' [LM_Dec_1] => 598 [LM_Dec_11] => 0.00 [LM_Dec_12] => 0.00 [LM_Dec_13] => 0.00 [LM_Dec_14] => 0.00 [LM_Dec_16] => 2934.60 [LM_Dec_2] => 603 [LM_Dec_22] => 259.79 [LM_Dec_3] => 255 [LM_Dec_5] => 1456 [LM_Dec_7] => 1456 [LM_Int1_1] => 3 [LM_Int1_10] => 4 [LM_Int1_11] => 4 [LM_Int1_18] => 3 [LM_Int1_19] => 3 [LM_Int1_2] => 1 [LM_Int1_20] => 4 [LM_Int1_4] => 3 [LM_Int1_6] => 3 [LM_Int1_7] => 8 [LM_Int1_8] => 1 [LM_Int1_9] => 4 [LM_Int2_2] => 2013 [LM_Int2_3] => 7 [LM_Int2_5] => 2019 [LM_Int2_6] => 1 [LM_Int2_7] => 2 [LM_Int4_1] => 16 [LM_Int4_2] => 16 [LO1_OrganizationName] => Top Vision Realty Inc. [LO1_PhoneNumber1] => 604-284-5268 [LO1_ShortName] => V004340 [LO2_OrganizationName] => Top Vision Realty Inc. [LO2_PhoneNumber1] => 604-498-0070 [LO2_ShortName] => V005216 [LR_remarks22] => The best Burke Mountain has to offer! Bright, south-facing 3 bedrooms / 3 FULL bathrooms plus den. 9' ceiling on the main floor with large windows featuring unobstructed view of Fraser Valley and an oversized sundeck off the kitchen. Chef's kitchen offers high end stainless steel appliances and ample storage space. 3rd bedroom on the ground floor with full bath provides perfect rental opportunity. Newly installed EV charging station in the garage. Master ensuite with heated floor. 5 min walk to elementary school / shopping / transit. Minutes from future commercial and social hub - Burke Mountain Village. Surrounded by plentiful trails and parks, with Galloway Park at doorstep. Unwind in this relaxing and tranquil neighborhood for a vacation-like lifestyle. [LV_vow_address] => Yes [LV_vow_include] => Yes [L_Address] => 7 1349 HAMES CRESCENT [L_AddressNumber] => 1349 [L_AddressStreet] => HAMES [L_AddressUnit] => 7 [L_Area] => Coquitlam [L_AskingPrice] => 829000 [L_CDOM] => 3 [L_City] => Coquitlam [L_DisplayId] => R2470989 [L_DOM] => 3 [L_ExpirationDate] => 2020-10-31 [L_IdxInclude] => Yes [L_InputDate] => 2020-06-30T23:17:54 [L_Last_Photo_updt] => 2020-07-01T08:57:04 [L_ListAgent1] => 47297 [L_ListAgent2] => 66196 [L_ListingDate] => 2020-06-29 [L_ListingID] => 262492616 [L_ListOffice1] => 2494 [L_ListOffice2] => 4294 [L_OriginalPrice] => 829000 [L_PictureCount] => 24 [L_PricePerSQFT] => 569.37 [L_Remarks] => STRATA LOT 10, PLAN EPS1164, SECTION 18, TOWNSHIP 40, 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 V [L_State] => BC [L_Status] => Active [L_StreetDesignationId] => CRESCENT [L_Type_] => Townhouse [L_UpdateDate] => 2020-07-02T19:59:45 [L_Zip] => V3E 0G7 [Section] => mls ) ) ) ) [previous:Exception:private] => )