Exception Object ( [message:protected] => Database error: Invalid SQL: SELECT M.*, mls_market_sef_url, mls_is_pic_url_supported, MML.mls_disclaimer_big, A.StreetNumber, A.StreetName, A.Area,A.Subdivision, A.CityName, A.County, A.State, A.ZipCode, A.StreetType, A.UnitNo, A.StreetDirection, M.Parking, M.YearBuilt, A.Latitude, A.Longitude , is_openhouse, CONCAT('https://static.estateblock.com/pictures/property/', CONCAT(M.MLS_NUM,'-',M.MLSP_ID), '/0') AS Pic_Path,is_mark_for_deletion,M.is_hotdeal,M.hotdeal_tag,M.hotdeal_description FROM listing_master AS M LEFT JOIN listing_address AS A ON M.MLS_NUM = A.MLS_NUM AND M.MLSP_ID = A.MLSP_ID LEFT JOIN listing_mls_deatils AS LM ON M.MLS_NUM = LM.MLS_NUM AND M.MLSP_ID = LM.MLSP_ID LEFT JOIN mls_master AS MM ON M.MLSP_ID = MM.MLSP_ID LEFT JOIN mls_master_lang AS MML ON M.MLSP_ID = MML.mlsp_master_id AND mlsp_lang_code = 'en' WHERE 1 AND A.State = 'BC' AND A.CityName = 'West Vancouver' AND M.MLS_NUM NOT IN ('R2348035') AND M.MLSP_ID IN (1) AND PropertyTypeNew = 'House' AND M.Beds >= '3' AND M.Beds <= '3' AND M.FloorArea >= 2000 AND M.FloorArea <= 2500 AND M.SQFT >= 10890 AND M.SQFT <= 21780 AND ( Subdivision = 'British Properties' ) AND M.is_mark_for_deletion = 'N' AND display_on_website = 'Yes' AND M.MLS_NUM NOT IN ( 'R2324677','C8020260','R2228301','R2234336','R2246159','R2248911','R2268588','439164','R2334065','R2331824','C8021917' ) ORDER BY listprice DESC LIMIT 0, 9
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 M.*, mls_market_sef_url, mls_is_pic_url_supported, MML.mls_disclaimer_big, A.StreetNumber, A.StreetName, A.Area,A.Subdivision, A.CityName, A.County, A.State, A.ZipCode, A.StreetType, A.UnitNo, A.StreetDirection, M.Parking, M.YearBuilt, A.Latitude, A.Longitude , is_openhouse, CONCAT('https://static.estateblock.com/pictures/property/', CONCAT(M.MLS_NUM,'-',M.MLSP_ID), '/0') AS Pic_Path,is_mark_for_deletion,M.is_hotdeal,M.hotdeal_tag,M.hotdeal_description FROM listing_master AS M LEFT JOIN listing_address AS A ON M.MLS_NUM = A.MLS_NUM AND M.MLSP_ID = A.MLSP_ID LEFT JOIN listing_mls_deatils AS LM ON M.MLS_NUM = LM.MLS_NUM AND M.MLSP_ID = LM.MLSP_ID LEFT JOIN mls_master AS MM ON M.MLSP_ID = MM.MLSP_ID LEFT JOIN mls_master_lang AS MML ON M.MLSP_ID = MML.mlsp_master_id AND mlsp_lang_code = 'en' WHERE 1 AND A.State = 'BC' AND A.CityName = 'West Vancouver' AND M.MLS_NUM NOT IN ('R2348035') AND M.MLSP_ID IN (1) AND PropertyTypeNew = 'House' AND M.Beds >= '3' AND M.Beds <= '3' AND M.FloorArea >= 2000 AND M.FloorArea <= 2500 AND M.SQFT >= 10890 AND M.SQFT <= 21780 AND ( Subdivision = 'British Properties' ) AND M.is_mark_for_deletion = 'N' AND display_on_website = 'Yes' AND M.MLS_NUM NOT IN ( 'R2324677','C8020260','R2228301','R2234336','R2246159','R2248911','R2268588','439164','R2334065','R2331824','C8021917' ) ORDER BY listprice DESC LIMIT 0, 9 ) ) [1] => Array ( [file] => /home/estatebl/public_html/db_access/IDXListing.php [line] => 2161 [function] => query [class] => DB_Sql [type] => -> [args] => Array ( [0] => SELECT M.*, mls_market_sef_url, mls_is_pic_url_supported, MML.mls_disclaimer_big, A.StreetNumber, A.StreetName, A.Area,A.Subdivision, A.CityName, A.County, A.State, A.ZipCode, A.StreetType, A.UnitNo, A.StreetDirection, M.Parking, M.YearBuilt, A.Latitude, A.Longitude , is_openhouse, CONCAT('https://static.estateblock.com/pictures/property/', CONCAT(M.MLS_NUM,'-',M.MLSP_ID), '/0') AS Pic_Path,is_mark_for_deletion,M.is_hotdeal,M.hotdeal_tag,M.hotdeal_description FROM listing_master AS M LEFT JOIN listing_address AS A ON M.MLS_NUM = A.MLS_NUM AND M.MLSP_ID = A.MLSP_ID LEFT JOIN listing_mls_deatils AS LM ON M.MLS_NUM = LM.MLS_NUM AND M.MLSP_ID = LM.MLSP_ID LEFT JOIN mls_master AS MM ON M.MLSP_ID = MM.MLSP_ID LEFT JOIN mls_master_lang AS MML ON M.MLSP_ID = MML.mlsp_master_id AND mlsp_lang_code = 'en' WHERE 1 AND A.State = 'BC' AND A.CityName = 'West Vancouver' AND M.MLS_NUM NOT IN ('R2348035') AND M.MLSP_ID IN (1) AND PropertyTypeNew = 'House' AND M.Beds >= '3' AND M.Beds <= '3' AND M.FloorArea >= 2000 AND M.FloorArea <= 2500 AND M.SQFT >= 10890 AND M.SQFT <= 21780 AND ( Subdivision = 'British Properties' ) AND M.is_mark_for_deletion = 'N' AND display_on_website = 'Yes' AND M.MLS_NUM NOT IN ( 'R2324677','C8020260','R2228301','R2234336','R2246159','R2248911','R2268588','439164','R2334065','R2331824','C8021917' ) ORDER BY listprice DESC LIMIT 0, 9 ) ) [2] => Array ( [file] => /home/estatebl/public_html/component/IDXListingComponent.php [line] => 3487 [function] => getListingByParam [class] => IDXListing [type] => -> [args] => Array ( [0] => Array ( [PropertyType] => House [BedRange] => 3-3 [MinSQFT] => 10890 [MaxSQFT] => 21780 [MinFloorArea] => 2000 [MaxFloorArea] => 2500 [CityName] => West Vancouver [Subdivision] => Array ( [0] => British Properties ) [State] => BC [MLSP_ID] => 1 [NOT_MLS_NUM] => Array ( [0] => R2348035 ) [is_api] => 1 [user_id] => [all_photos] => 1 [description] => [basic_details] => 1 [page_size] => 9 [start_record] => 0 ) ) ) [3] => Array ( [file] => /home/estatebl/public_html/listing.php [line] => 837 [function] => getSimilarAndBuildingMoreListingNew [class] => IDXListingComponent [type] => -> [args] => Array ( [0] => Array ( [MLS_NUM] => R2348035 [MLSP_ID] => 1 [listing_key] => R2348035-1 [resource] => Property [class] => RD_1 [mls_board_name] => Real Estate Board of Greater Vancouver [agent_code] => V81262 [agent_key] => V81262-1 [agent_name] => Alfie Yang PREC* [office_code] => V002321 [office_key] => V002321-1 [office_name] => Angell Hasman & Assoc.Rlty.Ltd [ListingKey] => 0 [PropertyType] => Residential Detached [PropertyTypeNew] => House [PropertyStyle] => 1 Storey [ListingStatus] => Active [SubType] => House/Single Family [OwnershipType] => Freehold NonStrata [OwnershipTypeNew] => Freehold [Zoning] => [BathsFull] => 2 [BathsHalf] => 1 [Baths] => 3 [Beds] => 3 [TotalAcreage] => 0.37 [ListPrice] => 4880000 [ListMarketPercentage] => 0 [ListMarketPercentageCity] => -50.84 [OriginalListPrice] => 0 [SQFT] => 15961 [FloorArea] => 2034 [YearBuilt] => 1967 [TotalPhotos] => 6 [Main_Photo] => 1 [Description] => A fabulous opportunity to purchase this 15,961 sq.ft. RARE VIEW lot in the most sought after BRITISH PROPERTIES with PANORAMIC VIEWS OF THE OCEAN, DOWNTOWN CITY & LIONS GATE BRIDGE. This home has been meticulously maintained and surrounded by beautifully landscaped grounds. Currently rented for $5000/month. Ideal for renovation/investment or hold and build your DREAM HOME! Level driveway with easy access in the lower British Properties and within close proximity to all catchments. [Description2] => [Stories] => 1 [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 0.00 [Tax] => 9407.44 [TaxYear] => 2018 [Region] => [ListingDate] => 2019-03-12 [LastUpdateDate] => 2019-03-22T21:10:42 [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] => 218 [cartodb_id_ele_sch_process] => Yes [cartodb_id_mid_sch] => 0 [cartodb_id_mid_sch_process] => Yes [cartodb_id_sec_sch] => 53 [cartodb_id_sec_sch_process] => Yes [cartodb_id_crime] => 20 [cartodb_id_crime_process] => Yes [cartodb_id_demographic1] => 273 [cartodb_id_demographic1_process] => Yes [cartodb_id_demographic2] => 326 [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] => 1004 [cartodb_id_subdivision_process] => Yes [DeletedDate] => 0000-00-00 00:00:00 [rets_system_key] => 262369662 [display_on_website] => Yes [display_on_website_datetime] => 1552427461 [created_datetime] => 2019-03-12 14:20:06 [updated_datetime] => 2019-04-18 10:40:37 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2019-04-21 21:41: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] => R2348035-1 [Area] => West Vancouver [StreetName] => HIGHLAND [StreetNumber] => 1102 [StreetType] => DRIVE [UnitNo] => [StreetDirection] => [ZipCode] => V7S 2H1 [CityName] => West Vancouver [County] => [State] => BC [Subdivision] => British Properties [Latitude] => 49.352292500000000 [Longitude] => -123.145247900000000 [DayOnMarket] => 68 [Pic_Path] => https://static.estateblock.com/pictures/property/R2348035-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_PictureCount] => 6 [L_Last_Photo_updt] => 2019-03-12T21:28:43 [LM_Dec_14] => 0.15 [LM_Dec_12] => 0.37 [L_Zip] => V7S 2H1 [L_StreetDesignationId] => DRIVE [L_UpdateDate] => 2019-03-22T21:10:42 [L_State] => BC [L_Status] => Active [L_ListingID] => 262369662 [L_ListingDate] => 2019-03-12 [L_ListOffice2] => 2739 [L_ListOffice1] => 2739 [L_ListAgent2] => 50397 [L_ListAgent1] => 57897 [L_DisplayId] => R2348035 [L_City] => West Vancouver [L_AskingPrice] => 4880000 [L_Area] => West Vancouver [L_AddressNumber] => 1102 [L_AddressStreet] => HIGHLAND [L_Address] => 1102 HIGHLAND DRIVE [LV_vow_address] => Yes [LV_vow_include] => Yes [LR_remarks22] => A fabulous opportunity to purchase this 15,961 sq.ft. RARE VIEW lot in the most sought after BRITISH PROPERTIES with PANORAMIC VIEWS OF THE OCEAN, DOWNTOWN CITY & LIONS GATE BRIDGE. This home has been meticulously maintained and surrounded by beautifully landscaped grounds. Currently rented for $5000/month. Ideal for renovation/investment or hold and build your DREAM HOME! Level driveway with easy access in the lower British Properties and within close proximity to all catchments. [LO2_ShortName] => V002321 [LO2_PhoneNumber1] => 604-921-1188 [LO1_ShortName] => V002321 [LO2_OrganizationName] => Angell Hasman & Assoc.Rlty.Ltd [LO1_PhoneNumber1] => 604-921-1188 [LO1_OrganizationName] => Angell Hasman & Assoc.Rlty.Ltd [LM_char30_28] => 150 [LM_char1_36] => Residential Detached [LM_char100_3] => PANORAMIC OCEAN, CITY, BRIDGE [LM_Int2_5] => 2018 [LM_Int2_3] => 52 [LM_Int2_2] => 1967 [LM_Int1_4] => 3 [LM_Int1_18] => 2 [LM_Int1_19] => 3 [LM_Int1_2] => 2 [LM_Int1_17] => 1 [LM_Int1_1] => 1 [LM_Dec_9] => 25.60 [LM_Dec_8] => 83.99 [LM_Dec_7] => 2034 [LM_Dec_16] => 9407.44 [LM_Dec_13] => 1482.83 [LM_Dec_1] => 2034 [LM_Dec_11] => 15961.00 [LM_Char10_6] => Real Estate Board of Greater Vancouver [LM_Char10_5] => British Properties [LM_Char10_23] => Yes [LFD_StyleofHome_1] => 1 Storey [LM_Char10_11] => House/Single Family [LFD_SiteInfluences_15] => Golf Course Nearby,Shopping Nearby,Ski Hill Nearby [LFD_FeaturesIncluded_24] => ClthWsh/Dryr/Frdg/Stve/DW [LFD_BasementArea_6] => Crawl [LA2_PhoneNumber1] => 604-345-4079 [LA2_LoginName] => V76179 [LA2_Char100_1] => Zach Chester [LA1_WebPage] => https://www.alfieyang.com [LA1_PhoneNumber1] => 778-680-6831 [LA1_LoginName] => V81262 [LA1_Char100_1] => Alfie Yang PREC* [LM_Char10_12] => Freehold NonStrata [Section] => mls ) [1] => Array ( [is_api] => 1 [user_id] => [all_photos] => 1 [description] => [basic_details] => 1 [page_size] => 9 [start_record] => 0 ) [2] => 9 ) ) ) [previous:Exception:private] => )