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 = '480')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 = '480') 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 = '480')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 = '480') 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 = '480')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 = '480') 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] => 480 ) ) ) [3] => Array ( [file] => /home/estatebl/public_html/listing.php [line] => 531 [function] => buildUniqueTextData [class] => IDXListingComponent [type] => -> [args] => Array ( [0] => Array ( [MLS_NUM] => R2470459 [MLSP_ID] => 1 [listing_key] => R2470459-1 [resource] => Property [class] => RA_2 [mls_board_name] => Real Estate Board of Greater Vancouver [agent_code] => V55051 [agent_key] => V55051-1 [agent_name] => Tim Hill PREC* [office_code] => V005384 [office_key] => V005384-1 [office_name] => RE/MAX All Points Realty [ListingKey] => [PropertyType] => Residential Attached [PropertyTypeNew] => Townhouse [PropertyStyle] => [ListingStatus] => Active [SubType] => Townhouse [OwnershipType] => Freehold Strata [OwnershipTypeNew] => Freehold Strata [Zoning] => [BathsFull] => 2 [BathsHalf] => 0 [Baths] => 2 [Beds] => 2 [TotalAcreage] => 0 [ListPrice] => 599800 [ListMarketPercentage] => 0 [ListMarketPercentageCity] => 0 [OriginalListPrice] => 0 [SQFT] => 0 [FloorArea] => 1348 [YearBuilt] => 2011 [TotalPhotos] => 40 [Main_Photo] => 1 [Description] => Welcome home to Westwood by Mosaic! This thoughtfully designed end unit home has the absolute best location in the complex & if you didn’t know any better you would think it is a show home! This is a rare opportunity to own a desirable centre kitchen home with huge island, quartz countertops & new stainless steel appliances plus large living areas, windows on three sides that allow plenty of light & 9’ ceilings. The top floor boasts two large bedrooms with professionally built-in closet organizers, office nook & laundry. Oversized balcony off the main floor & private, fenced yard that backs onto green space. Big garage with lots of storage. Pet & rental friendly. Close to everything! Coquitlam River, Traboulay Trail, West Coast Express, Skytrain, restaurants, shopping & the list goes on. [Description2] => [Stories] => 3 [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 234.47 [Tax] => 2632.64 [TaxYear] => 2019 [Region] => [ListingDate] => 2020-06-29 [LastUpdateDate] => 2020-07-06T00:08:14 [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:40:03 [is_price_reduced] => N [price_reduced_date] => [cartodb_id_ele_sch] => 482 [cartodb_id_ele_sch_process] => Yes [cartodb_id_mid_sch] => 29 [cartodb_id_mid_sch_process] => Yes [cartodb_id_sec_sch] => 110 [cartodb_id_sec_sch_process] => Yes [cartodb_id_crime] => 24 [cartodb_id_crime_process] => Yes [cartodb_id_demographic1] => 480 [cartodb_id_demographic1_process] => Yes [cartodb_id_demographic2] => 73 [cartodb_id_demographic2_process] => Yes [cartodb_id_flood] => 61 [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] => 262492086 [display_on_website] => Yes [display_on_website_datetime] => 1593476766 [created_datetime] => 2020-06-29 16:40:03 [updated_datetime] => 2020-07-05 17:40:03 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2020-07-05 17:41:35 [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] => R2470459-1 [Area] => Coquitlam [StreetName] => RIVERBEND [StreetNumber] => 3010 [StreetType] => DRIVE [UnitNo] => 131 [StreetDirection] => [ZipCode] => V3C 0B8 [CityName] => Coquitlam [County] => [State] => BC [Subdivision] => Coquitlam East [Latitude] => 49.263277700000000 [Longitude] => -122.791496000000000 [DayOnMarket] => 7 [Pic_Path] => https://static.estateblock.com/pictures/property/R2470459-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] => Tim Hill PREC* [LA1_Email] => timhillrealestate@outlook.com [LA1_LoginName] => V55051 [LA1_PhoneNumber1] => 604-319-4700 [LA1_WebPage] => https://www.timhillrealestate.com [LFD_Amenities_56] => Garden,In Suite Laundry,Playground,Storage [LFD_BasementArea_37] => None [LFD_BylawRestrictions_58] => Pets Allowed w/Rest.,Rentals Allowed [LFD_Construction_41] => Frame - Wood [LFD_DirectionalExpFaces_59] => South [LFD_ExteriorFinish_42] => Brick,Vinyl [LFD_FeaturesIncluded_55] => ClthWsh/Dryr/Frdg/Stve/DW,Drapes/Window Coverings,Garage Door Opener,Microwave,Security System [LFD_FloorFinish_50] => Laminate,Tile [LFD_FuelHeating_48] => Baseboard,Electric [LFD_MaintFeeIncludes_57] => Garbage Pickup,Gardening,Management [LFD_OutdoorArea_47] => Balcony(s),Fenced Yard [LFD_ParkingAccess_45] => Front [LFD_Parking_44] => Garage; Double,Visitor Parking [LFD_Renovations_35] => Partly [LFD_Roof_43] => Asphalt [LFD_ServicesConnected_38] => Electricity,Water [LFD_SiteInfluences_46] => Central Location,Greenbelt,Private Setting,Private Yard,Recreation Nearby,Shopping Nearby [LFD_StyleofHome_32] => Corner Unit,End Unit [LFD_WaterSupply_39] => City/Municipal [LM_char100_1] => 028-610-334 [LM_char100_3] => Greenbelt [LM_Char10_10] => Attached [LM_Char10_11] => Townhouse [LM_Char10_12] => Freehold Strata [LM_Char10_13] => No [LM_Char10_15] => No [LM_Char10_17] => STRATA [LM_Char10_18] => Concrete Perimeter [LM_Char10_19] => Full [LM_Char10_23] => Yes [LM_Char10_25] => Kitchen [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_15] => Yes [LM_Char1_16] => Yes [LM_Char1_2] => Yes [LM_char1_36] => Residential Attached [LM_Char1_9] => No [LM_char255_1] => 3.255% ON THE 1ST $100,000 AND 1.1625% ON THE BALANCE [LM_Char25_16] => Above [LM_Char25_17] => Above [LM_Char25_2] => 35'11"x16'7" [LM_Char25_27] => 604-683-8900 [LM_char30_2] => First Service Residential [LM_char50_11] => Close [LM_char50_12] => Close [LM_Char50_4] => In Progress [LM_Char50_5] => Westwood by Mosaic [LM_char5_10] => Main [LM_char5_11] => Living Room [LM_char5_12] => 14'5 [LM_char5_13] => 14'3 [LM_char5_14] => Main [LM_char5_15] => Dining Room [LM_char5_16] => 14'3 [LM_char5_17] => 11' [LM_char5_18] => Main [LM_char5_19] => Patio [LM_char5_20] => 15'2 [LM_char5_21] => 8'1 [LM_char5_22] => Above [LM_char5_23] => Master Bedroom [LM_char5_24] => 14'4 [LM_char5_25] => 13'1 [LM_char5_26] => Above [LM_char5_27] => Bedroom [LM_char5_28] => 14'3 [LM_char5_29] => 11'3 [LM_char5_30] => Above [LM_char5_31] => Laundry [LM_char5_32] => 4' [LM_char5_33] => 3' [LM_char5_34] => Below [LM_char5_35] => Patio [LM_char5_36] => 24'4 [LM_char5_37] => 18'3 [LM_char5_6] => Feet [LM_char5_7] => Main [LM_char5_8] => 13'2 [LM_char5_9] => 12' [LM_Dec_1] => 609 [LM_Dec_11] => 0.00 [LM_Dec_12] => 0.00 [LM_Dec_13] => 0.00 [LM_Dec_14] => 0.00 [LM_Dec_16] => 2632.64 [LM_Dec_2] => 631 [LM_Dec_22] => 234.47 [LM_Dec_3] => 108 [LM_Dec_5] => 1348 [LM_Dec_7] => 1348 [LM_Int1_1] => 3 [LM_Int1_10] => 3 [LM_Int1_18] => 2 [LM_Int1_19] => 2 [LM_Int1_20] => 3 [LM_Int1_4] => 2 [LM_Int1_6] => 2 [LM_Int1_7] => 8 [LM_Int1_8] => 1 [LM_Int1_9] => 4 [LM_Int2_2] => 2011 [LM_Int2_3] => 9 [LM_Int2_4] => 2019 [LM_Int2_5] => 2019 [LM_Int2_6] => 2 [LM_Int2_7] => 2 [LM_Int2_8] => 3 [LM_Int4_1] => 96 [LM_Int4_2] => 96 [LO1_OrganizationName] => RE/MAX All Points Realty [LO1_PhoneNumber1] => 604-526-2888 [LO1_ShortName] => V005384 [LO1_WebPage] => http://www.remax-advantagebc.com [LR_remarks22] => Welcome home to Westwood by Mosaic! This thoughtfully designed end unit home has the absolute best location in the complex & if you didn’t know any better you would think it is a show home! This is a rare opportunity to own a desirable centre kitchen home with huge island, quartz countertops & new stainless steel appliances plus large living areas, windows on three sides that allow plenty of light & 9’ ceilings. The top floor boasts two large bedrooms with professionally built-in closet organizers, office nook & laundry. Oversized balcony off the main floor & private, fenced yard that backs onto green space. Big garage with lots of storage. Pet & rental friendly. Close to everything! Coquitlam River, Traboulay Trail, West Coast Express, Skytrain, restaurants, shopping & the list goes on. [LV_vow_address] => Yes [LV_vow_include] => Yes [L_Address] => 131 3010 RIVERBEND DRIVE [L_AddressNumber] => 3010 [L_AddressStreet] => RIVERBEND [L_AddressUnit] => 131 [L_Area] => Coquitlam [L_AskingPrice] => 599800 [L_CDOM] => 6 [L_City] => Coquitlam [L_DisplayId] => R2470459 [L_DOM] => 6 [L_ExpirationDate] => 2020-10-29 [L_IdxInclude] => Yes [L_InputDate] => 2020-06-29T23:12:50 [L_Last_Photo_updt] => 2020-07-01T16:55:17 [L_ListAgent1] => 43164 [L_ListingDate] => 2020-06-29 [L_ListingID] => 262492086 [L_ListOffice1] => 4476 [L_OriginalPrice] => 599800 [L_PictureCount] => 40 [L_PricePerSQFT] => 444.96 [L_Remarks] => STRATA LOT 13, PLAN BCS4124, DISTRICT LOT 378, 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 V [L_State] => BC [L_Status] => Active [L_StreetDesignationId] => DRIVE [L_Type_] => Townhouse [L_UpdateDate] => 2020-07-06T00:08:14 [L_Zip] => V3C 0B8 [VT_ExtVTourURL2] => http://royalcityrealty.ca/mylistings.html/listing.r2470459-131-3010-riverbend-drive-coquitlam-v3c-0b8.92210013 [VT_ExtVTourURL3] => http://royalcityrealty.ca/mylistings.html/listing.r2470459-131-3010-riverbend-drive-coquitlam-v3c-0b8.92210013 [VT_VTourURL] => https://my.matterport.com/show/?m=GxoYe8ugL1J&mls=1 [Section] => mls ) ) ) ) [previous:Exception:private] => )