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 = '256')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 = '256') 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 = '256')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 = '256') 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 = '256')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 = '256') 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] => 256 ) ) ) [3] => Array ( [file] => /home/estatebl/public_html/listing.php [line] => 521 [function] => buildUniqueTextData [class] => IDXListingComponent [type] => -> [args] => Array ( [0] => Array ( [MLS_NUM] => R2348241 [MLSP_ID] => 1 [listing_key] => R2348241-1 [resource] => Property [class] => RA_2 [mls_board_name] => Real Estate Board of Greater Vancouver [agent_code] => V15639 [agent_key] => V15639-1 [agent_name] => Jeff Donohoe PREC* [office_code] => V000757 [office_key] => V000757-1 [office_name] => RE/MAX Crest Realty [ListingKey] => 0 [PropertyType] => Residential Attached [PropertyTypeNew] => Townhouse [PropertyStyle] => [ListingStatus] => Active [SubType] => Townhouse [OwnershipType] => Freehold Strata [OwnershipTypeNew] => Freehold Strata [Zoning] => [BathsFull] => 1 [BathsHalf] => 1 [Baths] => 2 [Beds] => 3 [TotalAcreage] => 0 [ListPrice] => 899000 [ListMarketPercentage] => 4.73 [ListMarketPercentageCity] => -6.67 [OriginalListPrice] => 0 [SQFT] => 0 [FloorArea] => 1852 [YearBuilt] => 1970 [TotalPhotos] => 20 [Main_Photo] => 1 [Description] => A Great Townhouse in a Great Area. Located in the highly sought after Yorkwood Hills Complex (extremely well run); this quiet, family friendly townhome in Upper Lynn Valley offers 3 bdrm plus den, 1.5 baths & 1,852 sq ft on 3 levels. Features include: tastefully updated kitchen & baths; attractive wood laminate floors thruout (& carpeted bdrms); off the living rm is a deck & a fully fenced level back yard; a large bdrm on the lower level can easily be converted to a rec room & offers a great space for older children/young adults; a full size laundry rm; & finally the master bdrm boasts a walk out balcony & a well-appointed walk-in-closet. The complex boasts outdoor pool, playground, sauna & just a short walk to great schools (Upper Lynn/Argyle); pets/rentals w/restrictions. [Description2] => A Great Townhouse in a Great Area. Located in the highly sought after Yorkwood Hills Complex (extremely well run); this quiet, family friendly townhome in Upper Lynn Valley offers 3 bdrm plus den, 1.5 baths & 1,852 sq ft on 3 levels. Features include: tastefully updated kitchen & baths; attractive wood laminate floors thruout (& carpeted bedrooms); off the living rm is a deck & a fully fenced level back yard which offers a safe space for small children to play in while still being under a watchful eye; a large bdrm on the lower level can easily be converted to a rec room & offers a great space for older children/young adults; a full size laundry rm; & finally the master bedrm boasts a walk out balcony & a well-appointed walk-in-closet. The complex boasts outdoor pool, playground, sauna and just a short walk to great schools (Upper Lynn & Argyle); an added bonus is that you are close to shopping (Lynn Valley Ctr/Village), transit, and some of the best hiking/biking trails on the Northshore. [Stories] => 3 [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 488.58 [Tax] => 2866.20 [TaxYear] => 2018 [Region] => [ListingDate] => 2019-03-12 [LastUpdateDate] => 2019-05-02T15:11:14 [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] => 207 [cartodb_id_ele_sch_process] => Yes [cartodb_id_mid_sch] => 0 [cartodb_id_mid_sch_process] => Yes [cartodb_id_sec_sch] => 22 [cartodb_id_sec_sch_process] => Yes [cartodb_id_crime] => 23 [cartodb_id_crime_process] => Yes [cartodb_id_demographic1] => 256 [cartodb_id_demographic1_process] => Yes [cartodb_id_demographic2] => 462 [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] => 10 [cartodb_id_city_process] => Yes [cartodb_id_area] => 10 [cartodb_id_area_process] => Yes [cartodb_id_subdivision] => 916 [cartodb_id_subdivision_process] => Yes [DeletedDate] => 0000-00-00 00:00:00 [rets_system_key] => 262369868 [display_on_website] => Yes [display_on_website_datetime] => 1552624142 [created_datetime] => 2019-03-14 15:40:27 [updated_datetime] => 2019-05-02 08:40:08 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2019-05-02 08:42:00 [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] => R2348241-1 [Area] => North Vancouver [StreetName] => HOSKINS [StreetNumber] => 4703 [StreetType] => ROAD [UnitNo] => [StreetDirection] => [ZipCode] => V7K 2R3 [CityName] => North Vancouver [County] => [State] => BC [Subdivision] => Lynn Valley [Latitude] => 49.353493900000000 [Longitude] => -123.027788700000000 [DayOnMarket] => 68 [Pic_Path] => https://static.estateblock.com/pictures/property/R2348241-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] => Jeff Donohoe PREC* [LA1_LoginName] => V15639 [LA1_PhoneNumber1] => 604-340-8588 [LA1_WebPage] => www.JeffDonohoe.com [LFD_Amenities_56] => In Suite Laundry,Playground,Pool; Outdoor,Sauna/Steam Room [LFD_SiteInfluences_46] => Central Location,Greenbelt,Marina Nearby,Recreation Nearby,Shopping Nearby,Ski Hill Nearby [LFD_StyleofHome_32] => 2 Storey w/Bsmt. [LM_Char10_11] => Townhouse [LM_Char10_5] => Lynn Valley [LM_Char10_6] => Real Estate Board of Greater Vancouver [LM_Dec_1] => 600 [LM_Dec_16] => 2866.20 [LM_Dec_22] => 488.58 [LM_Dec_7] => 1852 [LM_Int1_1] => 3 [LM_Int1_17] => 1 [LM_Int1_18] => 1 [LM_Int1_19] => 2 [LM_Int1_2] => 1 [LM_Int1_4] => 3 [LM_Int2_2] => 1970 [LM_Int2_3] => 49 [LM_Int2_5] => 2018 [LM_Int2_8] => 2 [LM_char1_36] => Residential Attached [LO1_OrganizationName] => RE/MAX Crest Realty [LO1_PhoneNumber1] => 604-988-8000 [LO1_ShortName] => V000757 [LR_remarks22] => A Great Townhouse in a Great Area. Located in the highly sought after Yorkwood Hills Complex (extremely well run); this quiet, family friendly townhome in Upper Lynn Valley offers 3 bdrm plus den, 1.5 baths & 1,852 sq ft on 3 levels. Features include: tastefully updated kitchen & baths; attractive wood laminate floors thruout (& carpeted bdrms); off the living rm is a deck & a fully fenced level back yard; a large bdrm on the lower level can easily be converted to a rec room & offers a great space for older children/young adults; a full size laundry rm; & finally the master bdrm boasts a walk out balcony & a well-appointed walk-in-closet. The complex boasts outdoor pool, playground, sauna & just a short walk to great schools (Upper Lynn/Argyle); pets/rentals w/restrictions. [LR_remarks33] => A Great Townhouse in a Great Area. Located in the highly sought after Yorkwood Hills Complex (extremely well run); this quiet, family friendly townhome in Upper Lynn Valley offers 3 bdrm plus den, 1.5 baths & 1,852 sq ft on 3 levels. Features include: tastefully updated kitchen & baths; attractive wood laminate floors thruout (& carpeted bedrooms); off the living rm is a deck & a fully fenced level back yard which offers a safe space for small children to play in while still being under a watchful eye; a large bdrm on the lower level can easily be converted to a rec room & offers a great space for older children/young adults; a full size laundry rm; & finally the master bedrm boasts a walk out balcony & a well-appointed walk-in-closet. The complex boasts outdoor pool, playground, sauna and just a short walk to great schools (Upper Lynn & Argyle); an added bonus is that you are close to shopping (Lynn Valley Ctr/Village), transit, and some of the best hiking/biking trails on the Northshore. [LV_vow_address] => Yes [LV_vow_include] => Yes [L_Address] => 4703 HOSKINS ROAD [L_AddressNumber] => 4703 [L_AddressStreet] => HOSKINS [L_Area] => North Vancouver [L_AskingPrice] => 899000 [L_City] => North Vancouver [L_DisplayId] => R2348241 [L_Last_Photo_updt] => 2019-03-13T06:14:26 [L_ListAgent1] => 20102 [L_ListOffice1] => 2124 [L_ListingDate] => 2019-03-12 [L_ListingID] => 262369868 [L_PictureCount] => 20 [L_State] => BC [L_Status] => Active [L_StreetDesignationId] => ROAD [L_UpdateDate] => 2019-05-02T15:11:14 [L_Zip] => V7K 2R3 [VT_VTourURL] => https://my.matterport.com/show/?m=ezKiV6JdKka&brand=0 [LM_Char10_12] => Freehold Strata [Section] => mls ) ) ) ) [previous:Exception:private] => )