Exception Object ( [message:protected] => Database error: Invalid SQL: (SELECT step1,step2,step3,step4,step5,step6, NHD.master_name AS neighborhood, NHD.master_area AS area_name, distance, median_age_of_the_population AS main_field, (CASE WHEN CAST(median_age_of_the_population AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(median_age_of_the_population AS DECIMAL) > Step1 AND CAST(median_age_of_the_population AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step2 AND CAST(median_age_of_the_population AS DECIMAL) < Step3 THEN 'green' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step3 AND CAST(median_age_of_the_population AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step4 AND CAST(median_age_of_the_population AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step5 AND CAST(median_age_of_the_population AS DECIMAL) < Step6 THEN 'red' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step6 THEN 'red' END) AS main_field_color FROM map_demographic_neighborhood2 AS NH LEFT JOIN map_demographic_details2 AS NHD ON NHD.cartodb_id = NH.neighbour_id LEFT JOIN map_demographic_data AS M ON M.Category = 'General' AND M.DB_FieldName = 'median_age_of_the_population' WHERE master_id = '622')UNION(SELECT step1,step2,step3,step4,step5,step6,NHD.master_name AS neighborhood, NHD.master_area AS area_name, '0', median_age_of_the_population AS main_field, (CASE WHEN CAST(median_age_of_the_population AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(median_age_of_the_population AS DECIMAL) > Step1 AND CAST(median_age_of_the_population AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step2 AND CAST(median_age_of_the_population AS DECIMAL) < Step3 THEN 'green' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step3 AND CAST(median_age_of_the_population AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step4 AND CAST(median_age_of_the_population AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step5 AND CAST(median_age_of_the_population AS DECIMAL) < Step6 THEN 'red' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step6 THEN 'red' END) AS main_field_color FROM map_demographic_details2 AS NHD LEFT JOIN map_demographic_data AS M ON M.Category = 'General' AND M.DB_FieldName = 'median_age_of_the_population' WHERE cartodb_id = '622') ORDER BY distance ASC
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 step1,step2,step3,step4,step5,step6, NHD.master_name AS neighborhood, NHD.master_area AS area_name, distance, median_age_of_the_population AS main_field, (CASE WHEN CAST(median_age_of_the_population AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(median_age_of_the_population AS DECIMAL) > Step1 AND CAST(median_age_of_the_population AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step2 AND CAST(median_age_of_the_population AS DECIMAL) < Step3 THEN 'green' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step3 AND CAST(median_age_of_the_population AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step4 AND CAST(median_age_of_the_population AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step5 AND CAST(median_age_of_the_population AS DECIMAL) < Step6 THEN 'red' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step6 THEN 'red' END) AS main_field_color FROM map_demographic_neighborhood2 AS NH LEFT JOIN map_demographic_details2 AS NHD ON NHD.cartodb_id = NH.neighbour_id LEFT JOIN map_demographic_data AS M ON M.Category = 'General' AND M.DB_FieldName = 'median_age_of_the_population' WHERE master_id = '622')UNION(SELECT step1,step2,step3,step4,step5,step6,NHD.master_name AS neighborhood, NHD.master_area AS area_name, '0', median_age_of_the_population AS main_field, (CASE WHEN CAST(median_age_of_the_population AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(median_age_of_the_population AS DECIMAL) > Step1 AND CAST(median_age_of_the_population AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step2 AND CAST(median_age_of_the_population AS DECIMAL) < Step3 THEN 'green' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step3 AND CAST(median_age_of_the_population AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step4 AND CAST(median_age_of_the_population AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step5 AND CAST(median_age_of_the_population AS DECIMAL) < Step6 THEN 'red' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step6 THEN 'red' END) AS main_field_color FROM map_demographic_details2 AS NHD LEFT JOIN map_demographic_data AS M ON M.Category = 'General' AND M.DB_FieldName = 'median_age_of_the_population' WHERE cartodb_id = '622') ORDER BY distance ASC ) ) [1] => Array ( [file] => /home/estatebl/public_html/db_access/Demographic.php [line] => 509 [function] => query [class] => DB_Sql [type] => -> [args] => Array ( [0] => (SELECT step1,step2,step3,step4,step5,step6, NHD.master_name AS neighborhood, NHD.master_area AS area_name, distance, median_age_of_the_population AS main_field, (CASE WHEN CAST(median_age_of_the_population AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(median_age_of_the_population AS DECIMAL) > Step1 AND CAST(median_age_of_the_population AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step2 AND CAST(median_age_of_the_population AS DECIMAL) < Step3 THEN 'green' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step3 AND CAST(median_age_of_the_population AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step4 AND CAST(median_age_of_the_population AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step5 AND CAST(median_age_of_the_population AS DECIMAL) < Step6 THEN 'red' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step6 THEN 'red' END) AS main_field_color FROM map_demographic_neighborhood2 AS NH LEFT JOIN map_demographic_details2 AS NHD ON NHD.cartodb_id = NH.neighbour_id LEFT JOIN map_demographic_data AS M ON M.Category = 'General' AND M.DB_FieldName = 'median_age_of_the_population' WHERE master_id = '622')UNION(SELECT step1,step2,step3,step4,step5,step6,NHD.master_name AS neighborhood, NHD.master_area AS area_name, '0', median_age_of_the_population AS main_field, (CASE WHEN CAST(median_age_of_the_population AS DECIMAL) <= Step1 THEN 'gray' WHEN CAST(median_age_of_the_population AS DECIMAL) > Step1 AND CAST(median_age_of_the_population AS DECIMAL) < Step2 THEN 'blue' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step2 AND CAST(median_age_of_the_population AS DECIMAL) < Step3 THEN 'green' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step3 AND CAST(median_age_of_the_population AS DECIMAL) < Step4 THEN 'yellow' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step4 AND CAST(median_age_of_the_population AS DECIMAL) < Step5 THEN 'orange' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step5 AND CAST(median_age_of_the_population AS DECIMAL) < Step6 THEN 'red' WHEN CAST(median_age_of_the_population AS DECIMAL) >= Step6 THEN 'red' END) AS main_field_color FROM map_demographic_details2 AS NHD LEFT JOIN map_demographic_data AS M ON M.Category = 'General' AND M.DB_FieldName = 'median_age_of_the_population' WHERE cartodb_id = '622') ORDER BY distance ASC ) ) [2] => Array ( [file] => /home/estatebl/public_html/component/IDXListingComponent.php [line] => 918 [function] => getNeighborhoodUniData [class] => Demographic [type] => -> [args] => Array ( [0] => Array ( [main_category] => General [sub_category] => Median Age [rel_field_name] => median_age_of_the_population [cartodb_id] => 622 ) ) ) [3] => Array ( [file] => /home/estatebl/public_html/listing.php [line] => 531 [function] => buildUniqueTextData [class] => IDXListingComponent [type] => -> [args] => Array ( [0] => Array ( [MLS_NUM] => R2470258 [MLSP_ID] => 1 [listing_key] => R2470258-1 [resource] => Property [class] => RA_2 [mls_board_name] => Real Estate Board of Greater Vancouver [agent_code] => V62671 [agent_key] => V62671-1 [agent_name] => Nancy Fong PREC* [office_code] => V001920 [office_key] => V001920-1 [office_name] => Macdonald Realty Westmar [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] => 1 [TotalAcreage] => 0 [ListPrice] => 460000 [ListMarketPercentage] => 0 [ListMarketPercentageCity] => 0 [OriginalListPrice] => 460000 [SQFT] => 0 [FloorArea] => 560 [YearBuilt] => 2014 [TotalPhotos] => 20 [Main_Photo] => 1 [Description] => Omega a modern and luxurious development by a well-known developer, Concord Pacific. Inspired by European Architecture Design to produce an exquisite 1 bed 1 bath 550 SF unit with 9 Ft ceilings. Enjoy comfortable living in high-end appliances, laminated hardwood floors, roller shades windows, stackable washer and dryer, and heat pump providing cooling and heating control year-round. A spectacular view of the courtyard and garden right at your back door with exclusive access to a 5000 Sqft clubhouse, fully equipped gym, and Concierge. In the highly sought West Cambie Neighbourhood, that is only minutes away from Aberdeen Centre and Garden City Centre. Major transit locations, restaurants and shops are all within walking distance. School Catchment: Tomsett Elementary; MacNeill Secondary. [Description2] => [Stories] => 1 [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 274.00 [Tax] => 1334.34 [TaxYear] => 2019 [Region] => [ListingDate] => 2020-06-29 [LastUpdateDate] => 2020-07-06T21:33:04 [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 13:00:04 [is_price_reduced] => N [price_reduced_date] => [cartodb_id_ele_sch] => 238 [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] => 303 [cartodb_id_demographic1_process] => Yes [cartodb_id_demographic2] => 622 [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] => 102 [cartodb_id_subdivision_process] => Yes [DeletedDate] => 2020-06-30 17:24:12 [rets_system_key] => 262491885 [display_on_website] => Yes [display_on_website_datetime] => 1593463566 [created_datetime] => 2020-06-29 13:00:04 [updated_datetime] => 2020-07-06 15:00:04 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2020-07-06 15:23:48 [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] => R2470258-1 [Area] => Richmond [StreetName] => TOMICKI [StreetNumber] => 9333 [StreetType] => AVENUE [UnitNo] => 120 [StreetDirection] => [ZipCode] => V6X 0L4 [CityName] => Richmond [County] => [State] => BC [Subdivision] => West Cambie [Latitude] => 49.180537200000000 [Longitude] => -123.120295100000000 [DayOnMarket] => 7 [Pic_Path] => https://static.estateblock.com/pictures/property/R2470258-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] => Nancy Fong PREC* [LA1_Email] => nancy@nancyfong.ca [LA1_LoginName] => V62671 [LA1_PhoneNumber1] => 778-839-9994 [LA1_WebPage] => http://www.nancyfong.ca [LFD_Amenities_56] => Club House,Exercise Centre,Garden,In Suite Laundry,Concierge [LFD_BasementArea_37] => None [LFD_BylawRestrictions_58] => Pets Allowed w/Rest.,Rentals Allowed [LFD_Construction_41] => Frame - Wood [LFD_ExteriorFinish_42] => Brick,Mixed [LFD_FeaturesIncluded_55] => Air Conditioning,ClthWsh/Dryr/Frdg/Stve/DW,Drapes/Window Coverings,Microwave,Smoke Alarm,Sprinkler - Fire [LFD_FloorFinish_50] => Hardwood,Laminate [LFD_FuelHeating_48] => Heat Pump [LFD_MaintFeeIncludes_57] => Caretaker,Garbage Pickup,Gardening,Hot Water,Management,Recreation Facility,Sewer,Snow removal,Water [LFD_OutdoorArea_47] => Patio(s) [LFD_ParkingAccess_45] => Side [LFD_Parking_44] => Garage Underbuilding,Visitor Parking [LFD_Roof_43] => Torch-On [LFD_ServicesConnected_38] => Electricity,Natural Gas,Sanitary Sewer,Storm Sewer,Water [LFD_SiteInfluences_46] => Central Location,Recreation Nearby,Shopping Nearby [LFD_StyleofHome_32] => Ground Level Unit,Inside Unit [LFD_WaterSupply_39] => City/Municipal [LM_char100_1] => 029-421-527 [LM_char100_3] => COURTYARD AND GARDEN [LM_Char10_10] => Attached [LM_Char10_11] => Apartment/Condo [LM_Char10_12] => Freehold Strata [LM_Char10_13] => Yes [LM_Char10_15] => Yes [LM_Char10_17] => ZLR24 [LM_Char10_18] => Concrete Perimeter [LM_Char10_23] => Yes [LM_Char10_25] => Living Room [LM_Char10_4] => Greater Vancouver [LM_Char10_5] => West Cambie [LM_Char10_6] => Real Estate Board of Greater Vancouver [LM_char10_75] => City/Municipal [LM_Char1_1] => Yes [LM_Char1_10] => No [LM_Char1_13] => No [LM_Char1_14] => No [LM_char1_36] => Residential Attached [LM_Char1_9] => No [LM_char255_1] => 3.22% ON 1ST 100K/1.16% ON BAL [LM_Char25_16] => Main [LM_Char25_27] => 604-684-4508 [LM_char30_2] => RANCHO MGMT SERVICES [LM_char50_11] => 2 BLKS [LM_char50_12] => 2 BLKS [LM_Char50_5] => OMEGA [LM_char5_10] => Main [LM_char5_11] => Dining Room [LM_char5_12] => 8'11 [LM_char5_13] => 6'3 [LM_char5_14] => Main [LM_char5_15] => Kitchen [LM_char5_16] => 12'4 [LM_char5_17] => 6'10 [LM_char5_18] => Main [LM_char5_19] => Bedroom [LM_char5_20] => 9'1 [LM_char5_21] => 10'11 [LM_char5_22] => Main [LM_char5_23] => Foyer [LM_char5_24] => 9'7 [LM_char5_25] => 5' [LM_char5_26] => Main [LM_char5_27] => Patio [LM_char5_28] => 12'3 [LM_char5_29] => 17'11 [LM_char5_7] => Main [LM_char5_8] => 9'10 [LM_char5_9] => 9'2 [LM_Dec_1] => 560 [LM_Dec_11] => 0.00 [LM_Dec_12] => 0.00 [LM_Dec_13] => 0.00 [LM_Dec_14] => 0.00 [LM_Dec_16] => 1334.34 [LM_Dec_22] => 274.00 [LM_Dec_5] => 560 [LM_Dec_7] => 560 [LM_Int1_1] => 1 [LM_Int1_18] => 1 [LM_Int1_19] => 1 [LM_Int1_20] => 4 [LM_Int1_4] => 1 [LM_Int1_6] => 1 [LM_Int1_7] => 6 [LM_Int1_8] => 1 [LM_Int1_9] => 4 [LM_Int2_2] => 2014 [LM_Int2_3] => 6 [LM_Int2_5] => 2019 [LM_Int2_6] => 1 [LM_Int2_7] => 1 [LM_Int2_8] => 4 [LM_Int4_1] => 245 [LM_Int4_2] => 134 [LO1_OrganizationName] => Macdonald Realty Westmar [LO1_PhoneNumber1] => 604-279-9822 [LO1_ShortName] => V001920 [LO1_WebPage] => http://www.westmar.ca [LR_remarks22] => Omega a modern and luxurious development by a well-known developer, Concord Pacific. Inspired by European Architecture Design to produce an exquisite 1 bed 1 bath 550 SF unit with 9 Ft ceilings. Enjoy comfortable living in high-end appliances, laminated hardwood floors, roller shades windows, stackable washer and dryer, and heat pump providing cooling and heating control year-round. A spectacular view of the courtyard and garden right at your back door with exclusive access to a 5000 Sqft clubhouse, fully equipped gym, and Concierge. In the highly sought West Cambie Neighbourhood, that is only minutes away from Aberdeen Centre and Garden City Centre. Major transit locations, restaurants and shops are all within walking distance. School Catchment: Tomsett Elementary; MacNeill Secondary. [LV_vow_address] => Yes [LV_vow_include] => Yes [L_Address] => 120 9333 TOMICKI AVENUE [L_AddressNumber] => 9333 [L_AddressStreet] => TOMICKI [L_AddressUnit] => 120 [L_Area] => Richmond [L_AskingPrice] => 460000 [L_CDOM] => 34 [L_City] => Richmond [L_DisplayId] => R2470258 [L_DOM] => 7 [L_ExpirationDate] => 2020-10-31 [L_IdxInclude] => Yes [L_InputDate] => 2020-06-29T19:38:04 [L_Last_Photo_updt] => 2020-06-29T19:38:06 [L_ListAgent1] => 49023 [L_ListingDate] => 2020-06-29 [L_ListingID] => 262491885 [L_ListOffice1] => 2812 [L_OriginalPrice] => 460000 [L_PictureCount] => 20 [L_PricePerSQFT] => 821.43 [L_Remarks] => STRATA LOT 18, BLOCK 5N, PLAN EPS2415, SECTION 34, 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] => AVENUE [L_Type_] => Apartment/Condo [L_UpdateDate] => 2020-07-06T21:33:04 [L_Zip] => V6X 0L4 [Section] => mls ) ) ) ) [previous:Exception:private] => )