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] => R2470768 [MLSP_ID] => 1 [listing_key] => R2470768-1 [resource] => Property [class] => RA_2 [mls_board_name] => Real Estate Board of Greater Vancouver [agent_code] => V75446 [agent_key] => V75446-1 [agent_name] => Sean Patterson [office_code] => V005055 [office_key] => V005055-1 [office_name] => Keller Williams Realty VanCentral [ListingKey] => [PropertyType] => Residential Attached [PropertyTypeNew] => Apartment/Condo [PropertyStyle] => [ListingStatus] => Active [SubType] => Apartment/Condo [OwnershipType] => Freehold Strata [OwnershipTypeNew] => Freehold Strata [Zoning] => [BathsFull] => 1 [BathsHalf] => 0 [Baths] => 1 [Beds] => 2 [TotalAcreage] => 0 [ListPrice] => 649000 [ListMarketPercentage] => 0 [ListMarketPercentageCity] => 0 [OriginalListPrice] => 649000 [SQFT] => 0 [FloorArea] => 741 [YearBuilt] => 2020 [TotalPhotos] => 24 [Main_Photo] => 1 [Description] => Built by Bosa, this sub-penthouse corner unit has a 180 degree panoramic south east view with a 220 sq ft covered balcony. The open concept floor plan is fantastic for entertaining and the over height 10 ft ceilings only enhance the natural light and livability. Finished to a higher quality standard then you'll find at this price point this home is perfect for owner occupiers and investors. Offering ONE OF A KIND AMENITIES with a 24,000 sq ft private amenity space similar to a YMCA: with concierge, gymnasium, workout centre, outdoor pool and patio, theatre room, piano rooms, party rooms, sauna/steam, business centre, and more.. You will have plenty of space to reconnect, recharge, or relax in this complete community that provides amazing lifestyle in an urban centre close to sky train. [Description2] => [Stories] => 1 [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 343.14 [Tax] => 1640.00 [TaxYear] => 2020 [Region] => [ListingDate] => 2020-06-30 [LastUpdateDate] => 2020-06-30T20:03:31 [LastPhotoDate] => [Pic_Download_Flag] => N [Pic_Updated_Date] => [Pic_Download_Try_Date] => [DisplayAddress] => Yes [PublishOnInternet] => Yes [business_type_major] => [business_type_minor] => [dom] => 6 [tag] => [is_openhouse] => No [vw_is_show_only_processed] => Yes [is_mark_for_deletion] => N [Listing_Created_Date] => 2020-06-30 13:20:05 [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] => 262492395 [display_on_website] => Yes [display_on_website_datetime] => 1593550327 [created_datetime] => 2020-06-30 13:20:05 [updated_datetime] => 2020-06-30 13:20:05 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2020-06-30 13:51:47 [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] => R2470768-1 [Area] => Coquitlam [StreetName] => FOSTER [StreetNumber] => 525 [StreetType] => AVENUE [UnitNo] => 2808 [StreetDirection] => [ZipCode] => V3J 0B3 [CityName] => Coquitlam [County] => [State] => BC [Subdivision] => Coquitlam West [Latitude] => 49.256951100000000 [Longitude] => -122.890496500000000 [DayOnMarket] => 6 [Pic_Path] => https://static.estateblock.com/pictures/property/R2470768-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] => Sean Patterson [LA1_Email] => info@seanpatterson.ca [LA1_LoginName] => V75446 [LA1_PhoneNumber1] => 604-218-2528 [LA1_WebPage] => http://www.seanandlaura.ca [LFD_Amenities_56] => Club House,Exercise Centre,Guest Suite,Pool; Outdoor,Sauna/Steam Room,Concierge [LFD_BasementArea_37] => None [LFD_BylawRestrictions_58] => Pets Allowed,Rentals Allowed [LFD_Construction_41] => Concrete,Frame - Metal [LFD_DirectionalExpFaces_59] => Southeast [LFD_DirectionalExpRearYard_40] => Southeast [LFD_ExteriorFinish_42] => Concrete,Glass,Metal [LFD_FeaturesIncluded_55] => ClthWsh/Dryr/Frdg/Stve/DW,Drapes/Window Coverings,Garage Door Opener,Heat Recov. Vent.,Hot Tub Spa/Swirlpool,Range Top,Sprinkler - Fire,Vaulted Ceiling,Windows - Thermo [LFD_FloorFinish_50] => Laminate,Tile [LFD_FuelHeating_48] => Electric [LFD_MaintFeeIncludes_57] => Caretaker,Garbage Pickup,Gardening,Gas,Management,Recreation Facility,Snow removal [LFD_OutdoorArea_47] => Balcony(s) [LFD_ParkingAccess_45] => Side [LFD_Parking_44] => Garage; Underground [LFD_Roof_43] => Tar & Gravel [LFD_ServicesConnected_38] => Electricity,Natural Gas,Sanitary Sewer,Storm Sewer,Water [LFD_SiteInfluences_46] => Central Location,Recreation Nearby,Shopping Nearby [LFD_StyleofHome_32] => Corner Unit,Upper Unit [LFD_Suite_36] => None [LFD_WaterSupply_39] => City/Municipal [LM_char100_1] => 031-008-721 [LM_char100_3] => Southeast [LM_Char10_10] => Attached [LM_Char10_11] => Apartment/Condo [LM_Char10_12] => Freehold Strata [LM_Char10_13] => Yes [LM_Char10_15] => No [LM_Char10_17] => RM6 [LM_Char10_18] => Concrete Perimeter [LM_Char10_23] => Yes [LM_Char10_25] => Master Bedroom [LM_Char10_4] => Greater Vancouver [LM_Char10_5] => Coquitlam West [LM_Char10_6] => Real Estate Board of Greater Vancouver [LM_char10_75] => City/Municipal [LM_Char1_1] => No [LM_Char1_10] => No [LM_Char1_13] => Yes [LM_char1_36] => Residential Attached [LM_char1_60] => No [LM_Char1_9] => No [LM_char255_1] => 3.22% ON THE FIRST $100K AND 1.15% ON THE REMAINING BALANCE. [LM_Char25_16] => Main [LM_Char25_27] => 604-685-3227 [LM_char30_2] => AWM Alliance [LM_Char50_5] => Lougheed Heights II [LM_char5_10] => Main [LM_char5_11] => Bedroom [LM_char5_12] => 10'0 [LM_char5_13] => 9'5 [LM_char5_14] => Main [LM_char5_15] => Dining Room [LM_char5_16] => 14'0 [LM_char5_17] => 7'5 [LM_char5_18] => Main [LM_char5_19] => Living Room [LM_char5_20] => 10'7 [LM_char5_21] => 11'5 [LM_char5_22] => Main [LM_char5_23] => Kitchen [LM_char5_24] => 8'11 [LM_char5_25] => 7'5 [LM_char5_26] => Main [LM_char5_27] => Foyer [LM_char5_28] => 12'1 [LM_char5_29] => 5'5 [LM_char5_6] => Feet [LM_char5_7] => Main [LM_char5_8] => 10'2 [LM_char5_9] => 9'7 [LM_Dec_1] => 741 [LM_Dec_11] => 0.00 [LM_Dec_12] => 0.00 [LM_Dec_13] => 0.00 [LM_Dec_14] => 0.00 [LM_Dec_16] => 1640.00 [LM_Dec_22] => 343.14 [LM_Dec_5] => 741 [LM_Dec_7] => 741 [LM_Int1_1] => 1 [LM_Int1_18] => 1 [LM_Int1_19] => 1 [LM_Int1_4] => 2 [LM_Int1_6] => 2 [LM_Int1_7] => 6 [LM_Int1_8] => 1 [LM_Int1_9] => 4 [LM_Int2_2] => 2020 [LM_Int2_5] => 2020 [LM_Int2_6] => 1 [LM_Int2_7] => 1 [LM_Int4_1] => 336 [LO1_OrganizationName] => Keller Williams Realty VanCentral [LO1_PhoneNumber1] => 604-262-1581 [LO1_ShortName] => V005055 [LO1_WebPage] => http://www.kwrealtyvancentral.com [LR_remarks22] => Built by Bosa, this sub-penthouse corner unit has a 180 degree panoramic south east view with a 220 sq ft covered balcony. The open concept floor plan is fantastic for entertaining and the over height 10 ft ceilings only enhance the natural light and livability. Finished to a higher quality standard then you'll find at this price point this home is perfect for owner occupiers and investors. Offering ONE OF A KIND AMENITIES with a 24,000 sq ft private amenity space similar to a YMCA: with concierge, gymnasium, workout centre, outdoor pool and patio, theatre room, piano rooms, party rooms, sauna/steam, business centre, and more.. You will have plenty of space to reconnect, recharge, or relax in this complete community that provides amazing lifestyle in an urban centre close to sky train. [LV_vow_address] => Yes [LV_vow_include] => Yes [L_Address] => 2808 525 FOSTER AVENUE [L_AddressNumber] => 525 [L_AddressStreet] => FOSTER [L_AddressUnit] => 2808 [L_Area] => Coquitlam [L_AskingPrice] => 649000 [L_CDOM] => 49 [L_City] => Coquitlam [L_DisplayId] => R2470768 [L_ExpirationDate] => 2020-09-10 [L_IdxInclude] => Yes [L_InputDate] => 2020-06-30T20:01:06 [L_Last_Photo_updt] => 2020-06-30T20:01:08 [L_ListAgent1] => 46983 [L_ListingDate] => 2020-06-30 [L_ListingID] => 262492395 [L_ListOffice1] => 4175 [L_OriginalPrice] => 649000 [L_PictureCount] => 24 [L_PricePerSQFT] => 875.84 [L_Remarks] => STRATA LOT 259 DISTRICT LOT 7 GROUP 1 NEW WESTMINSTER DISTRICT STRATA PLAN EPS4094 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_] => Apartment/Condo [L_UpdateDate] => 2020-06-30T20:03:31 [L_Zip] => V3J 0B3 [Section] => mls ) ) ) ) [previous:Exception:private] => )