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 = '272')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 = '272') 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 = '272')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 = '272') 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 = '272')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 = '272') 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] => 272 ) ) ) [3] => Array ( [file] => /home/estatebl/public_html/listing.php [line] => 521 [function] => buildUniqueTextData [class] => IDXListingComponent [type] => -> [args] => Array ( [0] => Array ( [MLS_NUM] => R2348665 [MLSP_ID] => 1 [listing_key] => R2348665-1 [resource] => Property [class] => RA_2 [mls_board_name] => Real Estate Board of Greater Vancouver [agent_code] => V3163 [agent_key] => V3163-1 [agent_name] => Penny Mitchell PREC* [office_code] => V002690 [office_key] => V002690-1 [office_name] => RE/MAX Masters Realty [ListingKey] => 0 [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] => 2085000 [ListMarketPercentage] => -38.23 [ListMarketPercentageCity] => -38.23 [OriginalListPrice] => 2085000 [SQFT] => 0 [FloorArea] => 1782 [YearBuilt] => 1977 [TotalPhotos] => 20 [Main_Photo] => 1 [Description] => Corner unit, 1 level living w/Exceptional & Spectacular Unobstructed 180 degree City, Water & Island VIEWS! Luxurious living space that suits downsizing from a large home, or just easy condo living. Spacious living/dining Great Room w/new gas fireplace opens out to 520 sq.ft.+ sunfilled covered patio to use all year round, overlooking views, acres of lawns and beautiful gardens. Sparkling, bright white chef's kitchen w/eating area and den/office.Huge Master w/good sized ensuite & large walk-in closet opens out to VIEWS & large patio. Second bedroom is perfectly situated w/built in Murphy Bed & nearby second bathroom. Large full sized laundry room with storage. Huge foyer with loads of storage. 2 side by side parking + 1 large locker. Rentals+pets. Amenities: gym, pool, jacuzzi, party room. [Description2] => Corner unit, 1 level living w/Exceptional & Spectacular Unobstructed 180 degree City, Water & Island VIEWS! Luxurious living space that would suit downsizing from a large home, or just easy living. Spacious living/dining Great Room w/new gas fireplace opens out to over 520 sq.ft. of sun filled covered patio to use all year round overlooking acres of lawns and beautiful gardens. Sparkling, bright white chef's kitchen w/eating area and den/office. Huge Master Suite w/good sized en-suite and large walk in closet opens out to VIEWS and large patio. Second bedroom is perfectly situated with built in Murphy Bed and nearby second bathroom. Large full sized laundry room with storage. Huge foyer with loads of storage. 2 side by side parking stalls & 1 large locker. Amenities: Panorama Club with large out door patio, party room w/kitchen, gym, indoor pool, racquetball courts and tennis courts. Rentals and pets allowed. Walking distance to famed Salmon House on The Hill Restaurant and local WV bus transportation. [Stories] => 1 [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 854.56 [Tax] => 3426.31 [TaxYear] => 2018 [Region] => [ListingDate] => 2019-03-12 [LastUpdateDate] => 2019-05-03T15:30:51 [LastPhotoDate] => [Pic_Download_Flag] => N [Pic_Updated_Date] => [Pic_Download_Try_Date] => [DisplayAddress] => Yes [PublishOnInternet] => Yes [business_type_major] => [business_type_minor] => [dom] => 67 [tag] => [is_openhouse] => No [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] => 189 [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] => 272 [cartodb_id_demographic1_process] => Yes [cartodb_id_demographic2] => 592 [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] => 1012 [cartodb_id_subdivision_process] => Yes [DeletedDate] => 0000-00-00 00:00:00 [rets_system_key] => 262370292 [display_on_website] => Yes [display_on_website_datetime] => 1552626122 [created_datetime] => 2019-03-14 15:40:27 [updated_datetime] => 2019-05-03 09:00:04 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2019-05-03 09:03: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] => R2348665-1 [Area] => West Vancouver [StreetName] => FOLKESTONE [StreetNumber] => 2242 [StreetType] => WAY [UnitNo] => 20 [StreetDirection] => [ZipCode] => V7S 2X7 [CityName] => West Vancouver [County] => [State] => BC [Subdivision] => Panorama Village [Latitude] => 49.345989000000000 [Longitude] => -123.172813000000000 [DayOnMarket] => 68 [Pic_Path] => https://static.estateblock.com/pictures/property/R2348665-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] => Penny Mitchell PREC* [LA1_LoginName] => V3163 [LA1_PhoneNumber1] => 604-816-7825 [LA1_WebPage] => http://www.pennymitchell.com [LFD_Amenities_56] => Exercise Centre,In Suite Laundry,Pool; Indoor,Sauna/Steam Room,Swirlpool/Hot Tub,Tennis Court(s) [LFD_FeaturesIncluded_55] => ClthWsh/Dryr/Frdg/Stve/DW,Drapes/Window Coverings,Garage Door Opener [LFD_SiteInfluences_46] => Central Location,Private Setting,Recreation Nearby,Shopping Nearby,Ski Hill Nearby [LFD_StyleofHome_32] => 1 Storey,Corner Unit [LM_Char10_11] => Apartment/Condo [LM_Char10_23] => Yes [LM_Char10_5] => Panorama Village [LM_Char10_6] => Real Estate Board of Greater Vancouver [LM_Dec_1] => 1782 [LM_Dec_16] => 3426.31 [LM_Dec_22] => 854.56 [LM_Dec_7] => 1782 [LM_Int1_1] => 1 [LM_Int1_18] => 2 [LM_Int1_19] => 2 [LM_Int1_2] => 1 [LM_Int1_4] => 2 [LM_Int2_2] => 1977 [LM_Int2_3] => 42 [LM_Int2_5] => 2018 [LM_Int2_8] => 5 [LM_char100_3] => Panoramic Ocean & City [LM_char1_36] => Residential Attached [LO1_OrganizationName] => RE/MAX Masters Realty [LO1_PhoneNumber1] => 604-926-6233 [LO1_ShortName] => V002690 [LR_remarks22] => Corner unit, 1 level living w/Exceptional & Spectacular Unobstructed 180 degree City, Water & Island VIEWS! Luxurious living space that suits downsizing from a large home, or just easy condo living. Spacious living/dining Great Room w/new gas fireplace opens out to 520 sq.ft.+ sunfilled covered patio to use all year round, overlooking views, acres of lawns and beautiful gardens. Sparkling, bright white chef's kitchen w/eating area and den/office.Huge Master w/good sized ensuite & large walk-in closet opens out to VIEWS & large patio. Second bedroom is perfectly situated w/built in Murphy Bed & nearby second bathroom. Large full sized laundry room with storage. Huge foyer with loads of storage. 2 side by side parking + 1 large locker. Rentals+pets. Amenities: gym, pool, jacuzzi, party room. [LR_remarks33] => Corner unit, 1 level living w/Exceptional & Spectacular Unobstructed 180 degree City, Water & Island VIEWS! Luxurious living space that would suit downsizing from a large home, or just easy living. Spacious living/dining Great Room w/new gas fireplace opens out to over 520 sq.ft. of sun filled covered patio to use all year round overlooking acres of lawns and beautiful gardens. Sparkling, bright white chef's kitchen w/eating area and den/office. Huge Master Suite w/good sized en-suite and large walk in closet opens out to VIEWS and large patio. Second bedroom is perfectly situated with built in Murphy Bed and nearby second bathroom. Large full sized laundry room with storage. Huge foyer with loads of storage. 2 side by side parking stalls & 1 large locker. Amenities: Panorama Club with large out door patio, party room w/kitchen, gym, indoor pool, racquetball courts and tennis courts. Rentals and pets allowed. Walking distance to famed Salmon House on The Hill Restaurant and local WV bus transportation. [LV_vow_address] => Yes [LV_vow_include] => Yes [L_Address] => 20 2242 FOLKESTONE WAY [L_AddressNumber] => 2242 [L_AddressStreet] => FOLKESTONE [L_AddressUnit] => 20 [L_Area] => West Vancouver [L_AskingPrice] => 2085000 [L_City] => West Vancouver [L_DisplayId] => R2348665 [L_Last_Photo_updt] => 2019-03-17T21:23:41 [L_ListAgent1] => 30207 [L_ListOffice1] => 2744 [L_ListingDate] => 2019-03-12 [L_ListingID] => 262370292 [L_PictureCount] => 20 [L_State] => BC [L_Status] => Active [L_StreetDesignationId] => WAY [L_UpdateDate] => 2019-05-03T15:30:51 [L_Zip] => V7S 2X7 [VT_VTourURL] => http://pennymitchell.ourubertor.com/ActiveListings.php/Details/591/20-2242-folkestone-way-panorama-gardens-panorama-village-west-vancouver-bc#viewdetail [LM_Char10_12] => Freehold Strata [Section] => mls ) ) ) ) [previous:Exception:private] => )