Exception Object ( [message:protected] => Database error: Invalid SQL: (SELECT NHD.master_name AS neighborhood, NHD.master_area AS area_name, distance, ROUND((of_rented_dwellings * 100), 1) AS main_field, (CASE WHEN CAST(of_rented_dwellings AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(of_rented_dwellings AS DECIMAL) > Step1 AND CAST(of_rented_dwellings AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(of_rented_dwellings AS DECIMAL) >= Step2 AND CAST(of_rented_dwellings AS DECIMAL) < Step3 THEN 'green' WHEN CAST(of_rented_dwellings AS DECIMAL) >= Step3 AND CAST(of_rented_dwellings AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(of_rented_dwellings AS DECIMAL) >= Step4 AND CAST(of_rented_dwellings AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(of_rented_dwellings AS DECIMAL) >= Step5 AND CAST(of_rented_dwellings AS DECIMAL) < Step6 THEN 'red' WHEN CAST(of_rented_dwellings 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 = 'Rent' AND M.DB_FieldName = 'of_rented_dwellings' WHERE master_id = '295')UNION (SELECT NHD.master_name AS neighborhood, NHD.master_area AS area_name, '0', ROUND((of_rented_dwellings * 100), 1) AS main_field, (CASE WHEN CAST(of_rented_dwellings AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(of_rented_dwellings AS DECIMAL) > Step1 AND CAST(of_rented_dwellings AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(of_rented_dwellings AS DECIMAL) >= Step2 AND CAST(of_rented_dwellings AS DECIMAL) < Step3 THEN 'green' WHEN CAST(of_rented_dwellings AS DECIMAL) >= Step3 AND CAST(of_rented_dwellings AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(of_rented_dwellings AS DECIMAL) >= Step4 AND CAST(of_rented_dwellings AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(of_rented_dwellings AS DECIMAL) >= Step5 AND CAST(of_rented_dwellings AS DECIMAL) < Step6 THEN 'red' WHEN CAST(of_rented_dwellings 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 = 'Rent' AND M.DB_FieldName = 'of_rented_dwellings' WHERE cartodb_id = '295') ORDER BY distance ASC LIMIT 1
MySQL Error: 1021 (Disk full (/home/tmp/#sql_14bc_14.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((of_rented_dwellings * 100), 1) AS main_field, (CASE WHEN CAST(of_rented_dwellings AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(of_rented_dwellings AS DECIMAL) > Step1 AND CAST(of_rented_dwellings AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(of_rented_dwellings AS DECIMAL) >= Step2 AND CAST(of_rented_dwellings AS DECIMAL) < Step3 THEN 'green' WHEN CAST(of_rented_dwellings AS DECIMAL) >= Step3 AND CAST(of_rented_dwellings AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(of_rented_dwellings AS DECIMAL) >= Step4 AND CAST(of_rented_dwellings AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(of_rented_dwellings AS DECIMAL) >= Step5 AND CAST(of_rented_dwellings AS DECIMAL) < Step6 THEN 'red' WHEN CAST(of_rented_dwellings 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 = 'Rent' AND M.DB_FieldName = 'of_rented_dwellings' WHERE master_id = '295')UNION (SELECT NHD.master_name AS neighborhood, NHD.master_area AS area_name, '0', ROUND((of_rented_dwellings * 100), 1) AS main_field, (CASE WHEN CAST(of_rented_dwellings AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(of_rented_dwellings AS DECIMAL) > Step1 AND CAST(of_rented_dwellings AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(of_rented_dwellings AS DECIMAL) >= Step2 AND CAST(of_rented_dwellings AS DECIMAL) < Step3 THEN 'green' WHEN CAST(of_rented_dwellings AS DECIMAL) >= Step3 AND CAST(of_rented_dwellings AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(of_rented_dwellings AS DECIMAL) >= Step4 AND CAST(of_rented_dwellings AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(of_rented_dwellings AS DECIMAL) >= Step5 AND CAST(of_rented_dwellings AS DECIMAL) < Step6 THEN 'red' WHEN CAST(of_rented_dwellings 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 = 'Rent' AND M.DB_FieldName = 'of_rented_dwellings' WHERE cartodb_id = '295') 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((of_rented_dwellings * 100), 1) AS main_field, (CASE WHEN CAST(of_rented_dwellings AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(of_rented_dwellings AS DECIMAL) > Step1 AND CAST(of_rented_dwellings AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(of_rented_dwellings AS DECIMAL) >= Step2 AND CAST(of_rented_dwellings AS DECIMAL) < Step3 THEN 'green' WHEN CAST(of_rented_dwellings AS DECIMAL) >= Step3 AND CAST(of_rented_dwellings AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(of_rented_dwellings AS DECIMAL) >= Step4 AND CAST(of_rented_dwellings AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(of_rented_dwellings AS DECIMAL) >= Step5 AND CAST(of_rented_dwellings AS DECIMAL) < Step6 THEN 'red' WHEN CAST(of_rented_dwellings 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 = 'Rent' AND M.DB_FieldName = 'of_rented_dwellings' WHERE master_id = '295')UNION (SELECT NHD.master_name AS neighborhood, NHD.master_area AS area_name, '0', ROUND((of_rented_dwellings * 100), 1) AS main_field, (CASE WHEN CAST(of_rented_dwellings AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(of_rented_dwellings AS DECIMAL) > Step1 AND CAST(of_rented_dwellings AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(of_rented_dwellings AS DECIMAL) >= Step2 AND CAST(of_rented_dwellings AS DECIMAL) < Step3 THEN 'green' WHEN CAST(of_rented_dwellings AS DECIMAL) >= Step3 AND CAST(of_rented_dwellings AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(of_rented_dwellings AS DECIMAL) >= Step4 AND CAST(of_rented_dwellings AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(of_rented_dwellings AS DECIMAL) >= Step5 AND CAST(of_rented_dwellings AS DECIMAL) < Step6 THEN 'red' WHEN CAST(of_rented_dwellings 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 = 'Rent' AND M.DB_FieldName = 'of_rented_dwellings' WHERE cartodb_id = '295') ORDER BY distance ASC LIMIT 1 ) ) [2] => Array ( [file] => /home/estatebl/public_html/component/IDXListingComponent.php [line] => 1257 [function] => getNeighborhoodUniData [class] => Demographic [type] => -> [args] => Array ( [0] => Array ( [main_category] => Rent [sub_category] => % of rented dwellings [rel_field_name] => of_rented_dwellings [cartodb_id] => 295 ) ) ) [3] => Array ( [file] => /home/estatebl/public_html/listing.php [line] => 531 [function] => buildUniqueTextData [class] => IDXListingComponent [type] => -> [args] => Array ( [0] => Array ( [MLS_NUM] => R2470127 [MLSP_ID] => 1 [listing_key] => R2470127-1 [resource] => Property [class] => RA_2 [mls_board_name] => Real Estate Board of Greater Vancouver [agent_code] => V33030 [agent_key] => V33030-1 [agent_name] => Eddy Chen [office_code] => V005406 [office_key] => V005406-1 [office_name] => 365 Real Estate Services Inc. [ListingKey] => [PropertyType] => Residential Attached [PropertyTypeNew] => Apartment/Condo [PropertyStyle] => [ListingStatus] => Active [SubType] => Apartment/Condo [OwnershipType] => Freehold Strata [OwnershipTypeNew] => Freehold Strata [Zoning] => [BathsFull] => 2 [BathsHalf] => 0 [Baths] => 2 [Beds] => 2 [TotalAcreage] => 0 [ListPrice] => 818000 [ListMarketPercentage] => 0 [ListMarketPercentageCity] => 0 [OriginalListPrice] => 0 [SQFT] => 0 [FloorArea] => 1032 [YearBuilt] => 2008 [TotalPhotos] => 17 [Main_Photo] => 1 [Description] => Spacious 2 bedrooms and 2 bathrooms with gorgeous North East corner view to the mountains. This bright 1,032 sq ft corner unit offers a great & open floor plan with a computer nook. Stainless steel appliances with granite countertop. Laminated floor, clothes washer, and dryer installed in 2012. Strata fee includes gas & city utility. Measurements are approximate, buyers to verify. Close to Lansdowne Mall, Skytrain Station, Kwantlen University. Easy to rent for investment or live-in! [Description2] => Spacious 2 bedrooms and 2 bathrooms with gorgeous North East corner view to the mountains. This bright 1,032 sq ft corner unit offers a great & open floor plan with a computer nook. Stainless steel appliances with granite countertop. Laminated floor, clothes washer, and dryer installed in 2012. Strata fee includes gas & city utility. Measurements are approximate, buyers to verify. Close to Lansdowne Mall, Skytrain Station, Kwantlen University. Easy to rent for investment or live-in! [Stories] => 1 [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 653.51 [Tax] => 2411.81 [TaxYear] => 2020 [Region] => [ListingDate] => 2020-06-29 [LastUpdateDate] => 2020-07-01T02:11:40 [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 11:00:05 [is_price_reduced] => N [price_reduced_date] => [cartodb_id_ele_sch] => 81 [cartodb_id_ele_sch_process] => Yes [cartodb_id_mid_sch] => 0 [cartodb_id_mid_sch_process] => Yes [cartodb_id_sec_sch] => 82 [cartodb_id_sec_sch_process] => Yes [cartodb_id_crime] => 28 [cartodb_id_crime_process] => Yes [cartodb_id_demographic1] => 295 [cartodb_id_demographic1_process] => Yes [cartodb_id_demographic2] => 155 [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] => Yes [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] => 2 [cartodb_id_city_process] => Yes [cartodb_id_area] => 2 [cartodb_id_area_process] => Yes [cartodb_id_subdivision] => 107 [cartodb_id_subdivision_process] => Yes [DeletedDate] => 0000-00-00 00:00:00 [rets_system_key] => 262491754 [display_on_website] => Yes [display_on_website_datetime] => 1593455346 [created_datetime] => 2020-06-29 11:00:05 [updated_datetime] => 2020-06-30 19:40:02 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2020-06-30 19:42:26 [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] => R2470127-1 [Area] => Richmond [StreetName] => LANSDOWNE [StreetNumber] => 8288 [StreetType] => ROAD [UnitNo] => 1501 [StreetDirection] => [ZipCode] => V6X 0B3 [CityName] => Richmond [County] => [State] => BC [Subdivision] => Brighouse [Latitude] => 49.173645000000000 [Longitude] => -123.132532200000000 [DayOnMarket] => 7 [Pic_Path] => https://static.estateblock.com/pictures/property/R2470127-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] => Eddy Chen [LA1_Email] => eeddyy888@gmail.com [LA1_LoginName] => V33030 [LA1_PhoneNumber1] => 778-908-0999 [LFD_Amenities_56] => Club House,Elevator,In Suite Laundry [LFD_BasementArea_37] => None [LFD_BylawRestrictions_58] => Pets Allowed w/Rest.,Rentals Allwd w/Restrctns [LFD_Construction_41] => Concrete [LFD_DirectionalExpFaces_59] => Northeast [LFD_ExteriorFinish_42] => Concrete,Glass,Other [LFD_FeaturesIncluded_55] => ClthWsh/Dryr/Frdg/Stve/DW,Disposal - Waste,Garage Door Opener,Microwave [LFD_FloorFinish_50] => Laminate,Tile [LFD_FuelHeating_48] => Baseboard,Electric [LFD_MaintFeeIncludes_57] => Caretaker,Garbage Pickup,Gardening,Gas,Hot Water,Management,Sewer,Water [LFD_OutdoorArea_47] => Balcony(s) [LFD_ParkingAccess_45] => Front [LFD_Parking_44] => Grge/Double Tandem [LFD_Roof_43] => Other [LFD_ServicesConnected_38] => Electricity,Natural Gas,Sanitary Sewer,Water [LFD_StyleofHome_32] => 1 Storey,Corner Unit [LFD_WaterSupply_39] => City/Municipal [LM_char100_1] => 027-610-772 [LM_char100_3] => Garden city & north mountain [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] => CDT1 [LM_Char10_18] => Concrete Perimeter [LM_Char10_23] => Yes [LM_Char10_25] => Living Room [LM_Char10_4] => Greater Vancouver [LM_Char10_5] => Brighouse [LM_Char10_6] => Real Estate Board of Greater Vancouver [LM_char10_75] => City/Municipal [LM_Char1_1] => Yes [LM_Char1_13] => No [LM_Char1_15] => Yes [LM_Char1_16] => Yes [LM_Char1_2] => No [LM_char1_36] => Residential Attached [LM_Char1_9] => No [LM_char255_1] => 3.255% ON THE FIRST 100,000 PLUS 1.11625% ON THE REMAINING BALANCE [LM_Char25_16] => Main [LM_Char25_17] => Main [LM_Char25_27] => 604-261-0285 [LM_char30_2] => The Wynford Group [LM_char30_4] => 2 [LM_Char50_5] => VERSANTE [LM_char5_10] => Main [LM_char5_11] => Kitchen [LM_char5_12] => 8'4 [LM_char5_13] => 7'11 [LM_char5_14] => Main [LM_char5_15] => Master Bedroom [LM_char5_16] => 14'4 [LM_char5_17] => 14'8 [LM_char5_18] => Main [LM_char5_19] => Bedroom [LM_char5_20] => 12'7 [LM_char5_21] => 10'6 [LM_char5_22] => Main [LM_char5_23] => Nook [LM_char5_24] => 5' [LM_char5_25] => 7' [LM_char5_6] => Feet [LM_char5_7] => Main [LM_char5_8] => 11' [LM_char5_9] => 10'6 [LM_Dec_1] => 1032 [LM_Dec_11] => 0.00 [LM_Dec_12] => 0.00 [LM_Dec_13] => 0.00 [LM_Dec_14] => 0.00 [LM_Dec_16] => 2411.81 [LM_Dec_22] => 653.51 [LM_Dec_5] => 1032 [LM_Dec_7] => 1032 [LM_Int1_1] => 1 [LM_Int1_10] => 4 [LM_Int1_18] => 2 [LM_Int1_19] => 2 [LM_Int1_20] => 4 [LM_Int1_4] => 2 [LM_Int1_6] => 2 [LM_Int1_7] => 5 [LM_Int1_8] => 1 [LM_Int1_9] => 4 [LM_Int2_2] => 2008 [LM_Int2_3] => 12 [LM_Int2_5] => 2020 [LM_Int2_6] => 2 [LM_Int2_7] => 2 [LM_Int2_8] => 18 [LO1_OrganizationName] => 365 Real Estate Services Inc. [LO1_PhoneNumber1] => 604-585-2222 [LO1_ShortName] => V005406 [LR_remarks22] => Spacious 2 bedrooms and 2 bathrooms with gorgeous North East corner view to the mountains. This bright 1,032 sq ft corner unit offers a great & open floor plan with a computer nook. Stainless steel appliances with granite countertop. Laminated floor, clothes washer, and dryer installed in 2012. Strata fee includes gas & city utility. Measurements are approximate, buyers to verify. Close to Lansdowne Mall, Skytrain Station, Kwantlen University. Easy to rent for investment or live-in! [LR_remarks33] => Spacious 2 bedrooms and 2 bathrooms with gorgeous North East corner view to the mountains. This bright 1,032 sq ft corner unit offers a great & open floor plan with a computer nook. Stainless steel appliances with granite countertop. Laminated floor, clothes washer, and dryer installed in 2012. Strata fee includes gas & city utility. Measurements are approximate, buyers to verify. Close to Lansdowne Mall, Skytrain Station, Kwantlen University. Easy to rent for investment or live-in! [LV_vow_address] => Yes [LV_vow_include] => Yes [L_Address] => 1501 8288 LANSDOWNE ROAD [L_AddressNumber] => 8288 [L_AddressStreet] => LANSDOWNE [L_AddressUnit] => 1501 [L_Area] => Richmond [L_AskingPrice] => 818000 [L_CDOM] => 1 [L_City] => Richmond [L_DisplayId] => R2470127 [L_DOM] => 1 [L_ExpirationDate] => 2020-12-31 [L_IdxInclude] => Yes [L_InputDate] => 2020-06-29T17:40:57 [L_Last_Photo_updt] => 2020-06-30T01:17:18 [L_ListAgent1] => 33421 [L_ListingDate] => 2020-06-29 [L_ListingID] => 262491754 [L_ListOffice1] => 4507 [L_OriginalPrice] => 818000 [L_PictureCount] => 17 [L_PricePerSQFT] => 792.64 [L_Remarks] => STRATA LOT 159, BLOCK 4N, PLAN BCS3043, SECTION 4, RANGE 6W, 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] => ROAD [L_Type_] => Apartment/Condo [L_UpdateDate] => 2020-07-01T02:11:40 [L_Zip] => V6X 0B3 [Section] => mls ) ) ) ) [previous:Exception:private] => )