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 = '268')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 = '268') ORDER BY distance ASC LIMIT 1
MySQL Error: 1030 (Got error 28 from storage engine)
[string:Exception:private] => [code:protected] => 0 [file:protected] => /home/estatebl/public_html/libs/mysql5i.php [line:protected] => 670 [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 = '268')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 = '268') 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 = '268')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 = '268') ORDER BY distance ASC LIMIT 1 ) ) [2] => Array ( [file] => /home/estatebl/public_html/component/IDXListingComponent.php [line] => 812 [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] => 268 ) ) ) [3] => Array ( [file] => /home/estatebl/public_html/listing.php [line] => 521 [function] => buildUniqueTextData [class] => IDXListingComponent [type] => -> [args] => Array ( [0] => Array ( [MLS_NUM] => R2347659 [MLSP_ID] => 1 [listing_key] => R2347659-1 [resource] => Property [class] => RD_1 [mls_board_name] => Real Estate Board of Greater Vancouver [agent_code] => V53375 [agent_key] => V53375-1 [agent_name] => D.J. Denner [office_code] => V002321 [office_key] => V002321-1 [office_name] => Angell Hasman & Assoc.Rlty.Ltd [ListingKey] => 0 [PropertyType] => Residential Detached [PropertyTypeNew] => House [PropertyStyle] => 2 Storey w/Bsmt.,Corner Unit [ListingStatus] => Active [SubType] => House/Single Family [OwnershipType] => Freehold NonStrata [OwnershipTypeNew] => Freehold [Zoning] => [BathsFull] => 4 [BathsHalf] => 2 [Baths] => 6 [Beds] => 6 [TotalAcreage] => 0.19 [ListPrice] => 3900000 [ListMarketPercentage] => 0 [ListMarketPercentageCity] => -0.15 [OriginalListPrice] => 0 [SQFT] => 8138 [FloorArea] => 4431 [YearBuilt] => 2010 [TotalPhotos] => 20 [Main_Photo] => 1 [Description] => This graceful architectural masterpiece is located in the heart of Ambleside and affords exquisite water, city & Lions Gate Bridge views. Boasting 6 beds, 6 baths, over 3 levels and approx. 4400 sf, this is the perfect family home. Main floor features 10' ceilings, entertainment sized principal rooms and a gourmet chef's kitchen with granite counters and full Miele appliance package. Upstairs boasts 3 well-appointed and fully en-suited bedrooms. The spacious master features a large walk-through closet, spa-like ensuite, breathtaking mountain and water views. Downstairs features a media room and 2 bedroom suite. Solar Panels for energy Efficiency and CCTV security. By any measure, the location, exceptional craftsmanship and stunning views put this elegant home in a class of it's own! [Description2] => [Stories] => 3 [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 0.00 [Tax] => 9779.18 [TaxYear] => 2018 [Region] => [ListingDate] => 2019-03-11 [LastUpdateDate] => 2019-04-29T20:35:22 [LastPhotoDate] => [Pic_Download_Flag] => N [Pic_Updated_Date] => [Pic_Download_Try_Date] => [DisplayAddress] => Yes [PublishOnInternet] => Yes [business_type_major] => [business_type_minor] => [dom] => 68 [tag] => open_house [is_openhouse] => Yes [vw_is_show_only_processed] => Yes [is_mark_for_deletion] => N [Listing_Created_Date] => 0000-00-00 00:00:00 [is_price_reduced] => N [price_reduced_date] => [cartodb_id_ele_sch] => 289 [cartodb_id_ele_sch_process] => Yes [cartodb_id_mid_sch] => 0 [cartodb_id_mid_sch_process] => Yes [cartodb_id_sec_sch] => 52 [cartodb_id_sec_sch_process] => Yes [cartodb_id_crime] => 20 [cartodb_id_crime_process] => Yes [cartodb_id_demographic1] => 268 [cartodb_id_demographic1_process] => Yes [cartodb_id_demographic2] => 536 [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] => 11 [cartodb_id_city_process] => Yes [cartodb_id_area] => 11 [cartodb_id_area_process] => Yes [cartodb_id_subdivision] => 1006 [cartodb_id_subdivision_process] => Yes [DeletedDate] => 0000-00-00 00:00:00 [rets_system_key] => 262369286 [display_on_website] => Yes [display_on_website_datetime] => 1552348321 [created_datetime] => 2019-03-11 16:20:05 [updated_datetime] => 2019-04-29 13:40:18 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2019-04-29 20:51:56 [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] => R2347659-1 [Area] => West Vancouver [StreetName] => FULTON [StreetNumber] => 1205 [StreetType] => AVENUE [UnitNo] => [StreetDirection] => [ZipCode] => V7T 1N7 [CityName] => West Vancouver [County] => [State] => BC [Subdivision] => Ambleside [Latitude] => 49.331453900000000 [Longitude] => -123.148847900000000 [DayOnMarket] => 69 [Pic_Path] => https://static.estateblock.com/pictures/property/R2347659-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 ) [L_Zip] => V7T 1N7 [L_UpdateDate] => 2019-04-29T20:35:22 [L_StreetDesignationId] => AVENUE [L_Status] => Active [L_State] => BC [L_PictureCount] => 20 [L_ListingID] => 262369286 [L_ListingDate] => 2019-03-11 [L_ListOffice3] => 2739 [L_ListOffice2] => 2739 [L_ListAgent3] => 63842 [L_ListOffice1] => 2739 [L_ListAgent2] => 42110 [L_ListAgent1] => 42551 [L_Last_Photo_updt] => 2019-04-08T23:14:50 [L_City] => West Vancouver [L_DisplayId] => R2347659 [L_Area] => West Vancouver [L_AskingPrice] => 3900000 [L_AddressStreet] => FULTON [L_AddressNumber] => 1205 [L_Address] => 1205 FULTON AVENUE [LV_vow_include] => Yes [LV_vow_address] => Yes [LR_remarks22] => This graceful architectural masterpiece is located in the heart of Ambleside and affords exquisite water, city & Lions Gate Bridge views. Boasting 6 beds, 6 baths, over 3 levels and approx. 4400 sf, this is the perfect family home. Main floor features 10' ceilings, entertainment sized principal rooms and a gourmet chef's kitchen with granite counters and full Miele appliance package. Upstairs boasts 3 well-appointed and fully en-suited bedrooms. The spacious master features a large walk-through closet, spa-like ensuite, breathtaking mountain and water views. Downstairs features a media room and 2 bedroom suite. Solar Panels for energy Efficiency and CCTV security. By any measure, the location, exceptional craftsmanship and stunning views put this elegant home in a class of it's own! [LO3_ShortName] => V002321 [LO2_ShortName] => V002321 [LO3_OrganizationName] => Angell Hasman & Assoc.Rlty.Ltd [LO2_PhoneNumber1] => 604-921-1188 [LO2_OrganizationName] => Angell Hasman & Assoc.Rlty.Ltd [LO1_PhoneNumber1] => 604-921-1188 [LO1_ShortName] => V002321 [LO1_OrganizationName] => Angell Hasman & Assoc.Rlty.Ltd [LM_char1_36] => Residential Detached [LM_char100_3] => Water,City & Lions Gate Bridge [LM_Int2_3] => 9 [LM_Int2_5] => 2018 [LM_Int2_2] => 2010 [LM_Int1_4] => 6 [LM_Int1_2] => 4 [LM_Int1_19] => 6 [LM_Int1_18] => 4 [LM_Int1_17] => 2 [LM_Int1_1] => 3 [LM_Dec_9] => 18.10 [LM_Dec_8] => 59.38 [LM_Dec_7] => 4431 [LM_Dec_16] => 9779.18 [LM_Dec_14] => 0.08 [LM_Dec_13] => 756.04 [LM_Dec_12] => 0.19 [LM_Dec_11] => 8138.00 [LM_Dec_1] => 1543 [LM_Char10_6] => Real Estate Board of Greater Vancouver [LM_Char10_5] => Ambleside [LM_Char10_23] => Yes [LM_Char10_12] => Freehold NonStrata [LM_Char10_11] => House/Single Family [LFD_StyleofHome_1] => 2 Storey w/Bsmt.,Corner Unit [LFD_SiteInfluences_15] => Central Location,Lane Access,Private Yard,Recreation Nearby,Shopping Nearby,Ski Hill Nearby [LFD_FeaturesIncluded_24] => Air Conditioning,ClthWsh/Dryr/Frdg/Stve/DW,Drapes/Window Coverings,Garage Door Opener,Heat Recov. Vent.,Jetted Bathtub,Oven - Built In,Security System,Smoke Alarm,Vacuum - Built In [LFD_Amenities_25] => Air Cond./Central,Garden,In Suite Laundry [LFD_BasementArea_6] => Fully Finished,Separate Entry [LA3_WebPage] => http://www.chrislanglois.ca [LA3_PhoneNumber1] => 604-312-9322 [LA3_LoginName] => V87390 [LA3_Char100_1] => Chris Langlois [LA2_WebPage] => http://www.nickneacsu.com [LA2_PhoneNumber1] => 604-561-5363 [LA2_LoginName] => V64300 [LA2_Char100_1] => Nick Neacsu PREC* [LA1_PhoneNumber1] => 604-773-5204 [LA1_WebPage] => www.djdenner.ca [LA1_Char100_1] => D.J. Denner [LA1_LoginName] => V53375 [VT_VTourURL] => https://www.neacsudenner.com/showlisting/231942/1205-Fulton-Avenue-Ambleside-West-Vancouver/ [Section] => mls ) ) ) ) [previous:Exception:private] => )