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 = '2')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 = '2') 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 = '2')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 = '2') 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 = '2')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 = '2') 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] => 2 ) ) ) [3] => Array ( [file] => /home/estatebl/public_html/listing.php [line] => 521 [function] => buildUniqueTextData [class] => IDXListingComponent [type] => -> [args] => Array ( [0] => Array ( [MLS_NUM] => R2349048 [MLSP_ID] => 1 [listing_key] => R2349048-1 [resource] => Property [class] => RA_2 [mls_board_name] => Real Estate Board of Greater Vancouver [agent_code] => V77700 [agent_key] => V77700-1 [agent_name] => Amir Miri PREC* [office_code] => V005090 [office_key] => V005090-1 [office_name] => Royal Pacific Lions Gate Realty Ltd. [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] => 998880 [ListMarketPercentage] => -27.79 [ListMarketPercentageCity] => -15.96 [OriginalListPrice] => 998880 [SQFT] => 0 [FloorArea] => 974 [YearBuilt] => 2018 [TotalPhotos] => 20 [Main_Photo] => 1 [Description] => Welcome to the luxurious complex in North Van COMPASS! Enjoy breathtaking WATER, 2nd NARROW BRIDGE, CITY & MOUNTAIN VIEW from 126 sf balcony & through the floor-to-ceiling triple-ply windows! South-East facing bright 2-bed & 2-bath corner suite gives you all the space & comfort! A/C, Bosch appliances, Quartz countertops, double sink, gas range & gas hook-up on balcony. Building has party rm, concierge, bike storage & dog wash. Access to exclusive Denna Club's 14,000 sf amenity space incl. gym, 25m indoor infinity lap pool, hot tub, sauna/steam rms, grand party rm, spa, yoga/dance rm, etc.! PET & RENTAL FRIENDLY COMPLEX. Steps to amazing hiking, biking & dog friendly trails. Short drive to Capilano University, shopping centres, Mt. Seymour ski hills, Golf, Lonsdale Quay &Downtown Vancouver. [Description2] => Welcome to the newest & luxurious complex in North Vancouver COMPASS AT SEYLYNN VILLAGE! Enjoy breathtaking WATER, 2nd NARROW BRIDGE, CITY & MOUNTAIN VIEW from 126 sf balcony & through the floor-to-ceiling triple-ply windows! South-East facing bright 2-bedroom & 2-bathroom corner suite gives you all the space & comfort for year-around entertaining! Air conditioning, Bosch S/S appliances, Quartz countertops, double sink, gas range & gas hook-up on balcony. Amazing amenities incl. party room, concierge, visitor parking, bike storage & dog wash. Access to exclusive Denna Club's 14,000 sf amenity space incl. fully programmed & professionally managed gym, 25m indoor infinity lap pool, hot tub, sauna/steam rooms, grand party room, lounge, spa, meeting room, yoga/dance room & more! PET & RENTAL FRIENDLY COMPLEX. Steps to amazing hiking, biking & dog friendly trails. Short drive to Capilano University, shopping centres, Mt. Seymore Ski Resort, Seymour Golf & Country Club, Lonsdale Quay, Sea Bus & Downtown Vancouver. [Stories] => 1 [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 475.28 [Tax] => 0.00 [TaxYear] => 2019 [Region] => [ListingDate] => 2019-03-15 [LastUpdateDate] => 2019-04-24T23:15:01 [LastPhotoDate] => [Pic_Download_Flag] => N [Pic_Updated_Date] => [Pic_Download_Try_Date] => [DisplayAddress] => Yes [PublishOnInternet] => Yes [business_type_major] => [business_type_minor] => [dom] => 64 [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] => 11 [cartodb_id_ele_sch_process] => Yes [cartodb_id_mid_sch] => 0 [cartodb_id_mid_sch_process] => Yes [cartodb_id_sec_sch] => 23 [cartodb_id_sec_sch_process] => Yes [cartodb_id_crime] => 23 [cartodb_id_crime_process] => Yes [cartodb_id_demographic1] => 2 [cartodb_id_demographic1_process] => Yes [cartodb_id_demographic2] => 231 [cartodb_id_demographic2_process] => Yes [cartodb_id_flood] => 0 [cartodb_id_flood_process] => Yes [cartodb_id_roads2_bound] => Yes [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] => 911 [cartodb_id_subdivision_process] => Yes [DeletedDate] => 0000-00-00 00:00:00 [rets_system_key] => 262370675 [display_on_website] => Yes [display_on_website_datetime] => 1552665002 [created_datetime] => 2019-03-15 08:40:03 [updated_datetime] => 2019-04-30 11:01:38 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2019-04-30 15:11:58 [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] => R2349048-1 [Area] => North Vancouver [StreetName] => SEYLYNN [StreetNumber] => 680 [StreetType] => CRESCENT [UnitNo] => 2503 [StreetDirection] => [ZipCode] => V7J 0B5 [CityName] => North Vancouver [County] => [State] => BC [Subdivision] => Lynnmour [Latitude] => 49.311978700000000 [Longitude] => -123.031667300000000 [DayOnMarket] => 65 [Pic_Path] => https://static.estateblock.com/pictures/property/R2349048-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 ) [LM_Char10_12] => Freehold Strata [VT_VTourURL] => https://www.seevirtual360.com/39527 [L_StreetDesignationId] => CRESCENT [L_UpdateDate] => 2019-04-24T23:15:01 [L_Zip] => V7J 0B5 [L_Status] => Active [L_State] => BC [L_PictureCount] => 20 [L_ListingID] => 262370675 [L_ListingDate] => 2019-03-15 [L_ListOffice1] => 4200 [L_ListAgent1] => 54751 [L_Last_Photo_updt] => 2019-03-19T06:31:43 [L_DisplayId] => R2349048 [L_City] => North Vancouver [L_AskingPrice] => 998880 [L_Area] => North Vancouver [L_AddressUnit] => 2503 [L_AddressStreet] => SEYLYNN [L_AddressNumber] => 680 [L_Address] => 2503 680 SEYLYNN CRESCENT [LV_vow_address] => Yes [LV_vow_include] => Yes [LR_remarks33] => Welcome to the newest & luxurious complex in North Vancouver COMPASS AT SEYLYNN VILLAGE! Enjoy breathtaking WATER, 2nd NARROW BRIDGE, CITY & MOUNTAIN VIEW from 126 sf balcony & through the floor-to-ceiling triple-ply windows! South-East facing bright 2-bedroom & 2-bathroom corner suite gives you all the space & comfort for year-around entertaining! Air conditioning, Bosch S/S appliances, Quartz countertops, double sink, gas range & gas hook-up on balcony. Amazing amenities incl. party room, concierge, visitor parking, bike storage & dog wash. Access to exclusive Denna Club's 14,000 sf amenity space incl. fully programmed & professionally managed gym, 25m indoor infinity lap pool, hot tub, sauna/steam rooms, grand party room, lounge, spa, meeting room, yoga/dance room & more! PET & RENTAL FRIENDLY COMPLEX. Steps to amazing hiking, biking & dog friendly trails. Short drive to Capilano University, shopping centres, Mt. Seymore Ski Resort, Seymour Golf & Country Club, Lonsdale Quay, Sea Bus & Downtown Vancouver. [LR_remarks22] => Welcome to the luxurious complex in North Van COMPASS! Enjoy breathtaking WATER, 2nd NARROW BRIDGE, CITY & MOUNTAIN VIEW from 126 sf balcony & through the floor-to-ceiling triple-ply windows! South-East facing bright 2-bed & 2-bath corner suite gives you all the space & comfort! A/C, Bosch appliances, Quartz countertops, double sink, gas range & gas hook-up on balcony. Building has party rm, concierge, bike storage & dog wash. Access to exclusive Denna Club's 14,000 sf amenity space incl. gym, 25m indoor infinity lap pool, hot tub, sauna/steam rms, grand party rm, spa, yoga/dance rm, etc.! PET & RENTAL FRIENDLY COMPLEX. Steps to amazing hiking, biking & dog friendly trails. Short drive to Capilano University, shopping centres, Mt. Seymour ski hills, Golf, Lonsdale Quay &Downtown Vancouver. [LM_Int2_2] => 2018 [LO1_ShortName] => V005090 [LO1_PhoneNumber1] => 604-416-8888 [LO1_OrganizationName] => Royal Pacific Lions Gate Realty Ltd. [LM_char1_36] => Residential Attached [LM_char100_3] => AMAZING Water,City,Mountain [LM_Int2_8] => 27 [LM_Int2_5] => 2019 [LM_Int2_3] => 1 [LM_Int1_4] => 2 [LM_Int1_1] => 1 [LM_Int1_19] => 2 [LM_Int1_18] => 2 [LM_Dec_7] => 974 [LM_Dec_22] => 475.28 [LM_Dec_1] => 974 [LM_Char10_23] => Yes [LM_Char10_6] => Real Estate Board of Greater Vancouver [LM_Char10_5] => Lynnmour [LM_Char10_11] => Apartment/Condo [LFD_StyleofHome_32] => Corner Unit,Upper Unit [LFD_SiteInfluences_46] => Central Location,Golf Course Nearby,Marina Nearby,Recreation Nearby,Shopping Nearby,Ski Hill Nearby [LFD_FeaturesIncluded_55] => Air Conditioning,Clothes Washer/Dryer,Dishwasher,Drapes/Window Coverings,Garage Door Opener,Microwave,Range Top,Refrigerator,Smoke Alarm,Sprinkler - Fire [LFD_Amenities_56] => Exercise Centre,Guest Suite,In Suite Laundry,Pool; Indoor,Sauna/Steam Room,Swirlpool/Hot Tub [LA1_WebPage] => http://www.amirmiri.com [LA1_PhoneNumber1] => 604-657-5030 [LA1_LoginName] => V77700 [LA1_Char100_1] => Amir Miri PREC* [Section] => mls ) ) ) ) [previous:Exception:private] => )