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 = '475')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 = '475') 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 = '475')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 = '475') 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 = '475')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 = '475') 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] => 475 ) ) ) [3] => Array ( [file] => /home/estatebl/public_html/listing.php [line] => 531 [function] => buildUniqueTextData [class] => IDXListingComponent [type] => -> [args] => Array ( [0] => Array ( [MLS_NUM] => R2470369 [MLSP_ID] => 1 [listing_key] => R2470369-1 [resource] => Property [class] => RA_2 [mls_board_name] => Real Estate Board of Greater Vancouver [agent_code] => V66022 [agent_key] => V66022-1 [agent_name] => Johnson Hsu [office_code] => V002221 [office_key] => V002221-1 [office_name] => Royal Pacific Realty Corp. [ListingKey] => [PropertyType] => Residential Attached [PropertyTypeNew] => Townhouse [PropertyStyle] => [ListingStatus] => Active [SubType] => Townhouse [OwnershipType] => Freehold Strata [OwnershipTypeNew] => Freehold Strata [Zoning] => [BathsFull] => 2 [BathsHalf] => 1 [Baths] => 3 [Beds] => 3 [TotalAcreage] => 0 [ListPrice] => 899000 [ListMarketPercentage] => 0 [ListMarketPercentageCity] => 0 [OriginalListPrice] => 0 [SQFT] => 0 [FloorArea] => 1405 [YearBuilt] => 2015 [TotalPhotos] => 20 [Main_Photo] => 1 [Description] => https://youtu.be/rhAC9-ilZik Stunning townhouse located in emerging Buriquitlam-Lougheed Neighborhood plan community. Abundance of exceptional amenity is in walking distance: Buriquitlam Station, future YMCA community centre, Lougheed Station and shopping malls, Cottonwood Water Park, The Vancouver Golf Club Toppest ranking elementary schl in Cqt, Rob Stibbs elementary, is just 5-min walk. The over 1400 sf 3-bed/ 3 bath family orientated unit with over 9'- feet ceiling on GF and 2nd floor. The unit comes with $30k upgrades: huge office/ storage, laminated wood floor thru, full height wall mirror and designer lighting at dining room, custom wall cabinet pantry at kitchen, and boutique powder rm for quest. Come share your future family dream with our contemporary furnished townhouse. [Description2] => [Stories] => 3 [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 198.62 [Tax] => 3053.37 [TaxYear] => 2019 [Region] => [ListingDate] => 2020-06-29 [LastUpdateDate] => 2020-07-02T04:37:24 [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 15:20:04 [is_price_reduced] => N [price_reduced_date] => [cartodb_id_ele_sch] => 461 [cartodb_id_ele_sch_process] => Yes [cartodb_id_mid_sch] => 21 [cartodb_id_mid_sch_process] => Yes [cartodb_id_sec_sch] => 107 [cartodb_id_sec_sch_process] => Yes [cartodb_id_crime] => 24 [cartodb_id_crime_process] => Yes [cartodb_id_demographic1] => 475 [cartodb_id_demographic1_process] => Yes [cartodb_id_demographic2] => 264 [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] => 2001 [cartodb_id_subdivision_process] => Yes [DeletedDate] => 0000-00-00 00:00:00 [rets_system_key] => 262491996 [display_on_website] => Yes [display_on_website_datetime] => 1593471427 [created_datetime] => 2020-06-29 15:20:04 [updated_datetime] => 2020-07-01 22:00:03 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2020-07-01 22:01:33 [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] => R2470369-1 [Area] => Coquitlam [StreetName] => FOSTER [StreetNumber] => 548 [StreetType] => AVENUE [UnitNo] => 143 [StreetDirection] => [ZipCode] => V3J 0E2 [CityName] => Coquitlam [County] => [State] => BC [Subdivision] => Coquitlam West [Latitude] => 49.256569600000000 [Longitude] => -122.887821300000000 [DayOnMarket] => 7 [Pic_Path] => https://static.estateblock.com/pictures/property/R2470369-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] => Johnson Hsu [LA1_Email] => goldmaples@hotmail.com [LA1_LoginName] => V66022 [LA1_PhoneNumber1] => 604-836-9932 [LFD_Amenities_56] => Bike Room,Club House,Exercise Centre,In Suite Laundry [LFD_BasementArea_37] => None [LFD_BylawRestrictions_58] => No Restrictions [LFD_Construction_41] => Frame - Wood [LFD_ExteriorFinish_42] => Brick,Mixed [LFD_FeaturesIncluded_55] => ClthWsh/Dryr/Frdg/Stve/DW [LFD_FloorFinish_50] => Laminate,Mixed,Tile [LFD_FuelHeating_48] => Baseboard [LFD_MaintFeeIncludes_57] => Garbage Pickup,Gardening,Management,Recreation Facility,Sewer,Snow removal [LFD_OutdoorArea_47] => Balcony(s) [LFD_ParkingAccess_45] => Rear [LFD_Parking_44] => Garage; Single,Visitor Parking [LFD_Roof_43] => Asphalt [LFD_ServicesConnected_38] => Electricity [LFD_SiteInfluences_46] => Central Location,Golf Course Nearby,Recreation Nearby,Shopping Nearby [LFD_StyleofHome_32] => 3 Storey [LFD_Suite_36] => None [LFD_WaterSupply_39] => City/Municipal [LM_char100_1] => 029-686-628 [LM_Char10_10] => Attached [LM_Char10_11] => Townhouse [LM_Char10_12] => Freehold Strata [LM_Char10_13] => Yes [LM_Char10_15] => No [LM_Char10_16] => Yes [LM_Char10_17] => RM2 [LM_Char10_18] => Concrete Perimeter [LM_Char10_23] => No [LM_Char10_25] => Kitchen [LM_Char10_4] => Greater Vancouver [LM_Char10_5] => Coquitlam West [LM_Char10_6] => Real Estate Board of Greater Vancouver [LM_char10_75] => Community [LM_Char1_1] => No [LM_Char1_10] => No [LM_Char1_2] => Yes [LM_Char1_3] => No [LM_char1_36] => Residential Attached [LM_Char1_9] => No [LM_char255_1] => 3200 FIRST 100K, + 1.16% ON BAL + 3000 BONUS [LM_Char25_16] => Main [LM_Char25_17] => Above [LM_Char25_18] => Above [LM_Char25_27] => 604-821-2999 [LM_char30_2] => DWELL PROPERTY MANAGEMENT [LM_char50_11] => CLOSE [LM_char50_12] => CLOSE [LM_Char50_5] => BLACK AND WHITE [LM_char5_10] => Main [LM_char5_11] => Eating Area [LM_char5_12] => 11'25 [LM_char5_13] => 10'13 [LM_char5_14] => Main [LM_char5_15] => Laundry [LM_char5_16] => 12' [LM_char5_17] => 12'75 [LM_char5_18] => Above [LM_char5_19] => Master Bedroom [LM_char5_20] => 9' [LM_char5_21] => 11'62 [LM_char5_22] => Above [LM_char5_23] => Bedroom [LM_char5_24] => 8'25 [LM_char5_25] => 7'88 [LM_char5_26] => Above [LM_char5_27] => Bedroom [LM_char5_28] => 7'5 [LM_char5_29] => 7'13 [LM_char5_30] => Below [LM_char5_31] => Office [LM_char5_32] => 15' [LM_char5_33] => 9' [LM_char5_6] => Feet [LM_char5_7] => Main [LM_char5_8] => 13'5 [LM_char5_9] => 9'75 [LM_Dec_1] => 630 [LM_Dec_11] => 0.00 [LM_Dec_12] => 0.00 [LM_Dec_13] => 0.00 [LM_Dec_14] => 0.00 [LM_Dec_16] => 3053.37 [LM_Dec_2] => 675 [LM_Dec_22] => 198.62 [LM_Dec_3] => 100 [LM_Dec_5] => 1405 [LM_Dec_7] => 1405 [LM_Int1_1] => 3 [LM_Int1_10] => 3 [LM_Int1_11] => 3 [LM_Int1_17] => 1 [LM_Int1_18] => 2 [LM_Int1_19] => 3 [LM_Int1_20] => 3 [LM_Int1_4] => 3 [LM_Int1_6] => 3 [LM_Int1_7] => 7 [LM_Int1_8] => 1 [LM_Int1_9] => 2 [LM_Int2_2] => 2015 [LM_Int2_3] => 5 [LM_Int2_5] => 2019 [LM_Int2_6] => 1 [LM_Int2_7] => 2 [LO1_OrganizationName] => Royal Pacific Realty Corp. [LO1_PhoneNumber1] => 604-266-8989 [LO1_ShortName] => V002221 [LO1_WebPage] => http://www.royalpacific.com [LR_remarks22] => https://youtu.be/rhAC9-ilZik Stunning townhouse located in emerging Buriquitlam-Lougheed Neighborhood plan community. Abundance of exceptional amenity is in walking distance: Buriquitlam Station, future YMCA community centre, Lougheed Station and shopping malls, Cottonwood Water Park, The Vancouver Golf Club Toppest ranking elementary schl in Cqt, Rob Stibbs elementary, is just 5-min walk. The over 1400 sf 3-bed/ 3 bath family orientated unit with over 9'- feet ceiling on GF and 2nd floor. The unit comes with $30k upgrades: huge office/ storage, laminated wood floor thru, full height wall mirror and designer lighting at dining room, custom wall cabinet pantry at kitchen, and boutique powder rm for quest. Come share your future family dream with our contemporary furnished townhouse. [LV_vow_address] => Yes [LV_vow_include] => Yes [L_Address] => 143 548 FOSTER AVENUE [L_AddressNumber] => 548 [L_AddressStreet] => FOSTER [L_AddressUnit] => 143 [L_Area] => Coquitlam [L_AskingPrice] => 899000 [L_CDOM] => 2 [L_City] => Coquitlam [L_DisplayId] => R2470369 [L_DOM] => 2 [L_ExpirationDate] => 2020-09-30 [L_IdxInclude] => Yes [L_InputDate] => 2020-06-29T22:00:15 [L_Last_Photo_updt] => 2020-06-30T19:18:57 [L_ListAgent1] => 53481 [L_ListingDate] => 2020-06-29 [L_ListingID] => 262491996 [L_ListOffice1] => 3336 [L_OriginalPrice] => 899000 [L_PictureCount] => 20 [L_PricePerSQFT] => 639.86 [L_Remarks] => STRATA LOT 52, PLAN EPS1909, DISTRICT LOT 7, 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] => AVENUE [L_Type_] => Townhouse [L_UpdateDate] => 2020-07-02T04:37:24 [L_Zip] => V3J 0E2 [VT_VTourURL] => https://www.youtube.com/watch?v=rhAC9-ilZik&feature=youtu.be [Section] => mls ) ) ) ) [previous:Exception:private] => )