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 ('R2347274') AND M.MLSP_ID IN (1) AND PropertyTypeNew = 'House' AND M.Beds >= '4' AND M.Beds <= '4' AND M.FloorArea >= 4000 AND M.FloorArea <= 5000 AND M.SQFT >= 10890 AND M.SQFT <= 21780 AND ( Subdivision = 'Caulfeild' ) 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 ('R2347274') AND M.MLSP_ID IN (1) AND PropertyTypeNew = 'House' AND M.Beds >= '4' AND M.Beds <= '4' AND M.FloorArea >= 4000 AND M.FloorArea <= 5000 AND M.SQFT >= 10890 AND M.SQFT <= 21780 AND ( Subdivision = 'Caulfeild' ) 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 ('R2347274') AND M.MLSP_ID IN (1) AND PropertyTypeNew = 'House' AND M.Beds >= '4' AND M.Beds <= '4' AND M.FloorArea >= 4000 AND M.FloorArea <= 5000 AND M.SQFT >= 10890 AND M.SQFT <= 21780 AND ( Subdivision = 'Caulfeild' ) 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] => 4-4 [MinSQFT] => 10890 [MaxSQFT] => 21780 [MinFloorArea] => 4000 [MaxFloorArea] => 5000 [CityName] => West Vancouver [Subdivision] => Array ( [0] => Caulfeild ) [State] => BC [MLSP_ID] => 1 [NOT_MLS_NUM] => Array ( [0] => R2347274 ) [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] => R2347274 [MLSP_ID] => 1 [listing_key] => R2347274-1 [resource] => Property [class] => RD_1 [mls_board_name] => Real Estate Board of Greater Vancouver [agent_code] => V24910 [agent_key] => V24910-1 [agent_name] => Haneef Virani PREC* [office_code] => V003041 [office_key] => V003041-1 [office_name] => Virani Real Estate Advisors [ListingKey] => 0 [PropertyType] => Residential Detached [PropertyTypeNew] => House [PropertyStyle] => 2 Storey [ListingStatus] => Active [SubType] => House/Single Family [OwnershipType] => Freehold Strata [OwnershipTypeNew] => Freehold Strata [Zoning] => [BathsFull] => 4 [BathsHalf] => 2 [Baths] => 6 [Beds] => 4 [TotalAcreage] => 0.33 [ListPrice] => 5998000 [ListMarketPercentage] => 0 [ListMarketPercentageCity] => 0 [OriginalListPrice] => 0 [SQFT] => 14445 [FloorArea] => 4320 [YearBuilt] => 1996 [TotalPhotos] => 20 [Main_Photo] => 1 [Description] => Welcome to Seaside Place. A Waterfront enclave nestled into a quiet cul-de-sac. A true masterpiece of West Coast Arts and Craft designed by renowned Gordon Hlynsky with soaring ceilings and exposed beams allowing a great feeling of space and volume throughout the main level living areas. Enjoy the close intimate views of the ocean, passage & Bowen Island plus Eagle Harbour Marina throughout the practically designed 2 level floorplan with host of features including high-end Sub Zero, Viking & Miele appliances, extensive oak hardwood floors, media room, wet bar plus abundance of custom millwork including wainscoting & double crown mouldings. The home has been meticulously maintained by the current owners with close proximity to the Marina, Gleneagles Community Centre & Caulfeild shops. [Description2] => [Stories] => 2 [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 0.00 [Tax] => 10399.55 [TaxYear] => 2018 [Region] => [ListingDate] => 2019-03-11 [LastUpdateDate] => 2019-04-11T00:03:47 [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] => [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] => 198 [cartodb_id_ele_sch_process] => Yes [cartodb_id_mid_sch] => 0 [cartodb_id_mid_sch_process] => Yes [cartodb_id_sec_sch] => 51 [cartodb_id_sec_sch_process] => Yes [cartodb_id_crime] => 20 [cartodb_id_crime_process] => Yes [cartodb_id_demographic1] => 271 [cartodb_id_demographic1_process] => Yes [cartodb_id_demographic2] => 279 [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] => 1024 [cartodb_id_subdivision_process] => Yes [DeletedDate] => 0000-00-00 00:00:00 [rets_system_key] => 262368901 [display_on_website] => Yes [display_on_website_datetime] => 1552323421 [created_datetime] => 2019-03-11 09:40:06 [updated_datetime] => 2019-04-18 10:40:43 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2019-04-21 19:51: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] => R2347274-1 [Area] => West Vancouver [StreetName] => SEASIDE [StreetNumber] => 5330 [StreetType] => PLACE [UnitNo] => [StreetDirection] => [ZipCode] => V7W 3E2 [CityName] => West Vancouver [County] => [State] => BC [Subdivision] => Caulfeild [Latitude] => 49.347524000000000 [Longitude] => -123.270416000000000 [DayOnMarket] => 69 [Pic_Path] => https://static.estateblock.com/pictures/property/R2347274-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 ) [VT_VTourURL] => https://youtu.be/nuZeWPaOVgY [L_Zip] => V7W 3E2 [L_UpdateDate] => 2019-04-11T00:03:47 [L_StreetDesignationId] => PLACE [L_Status] => Active [L_State] => BC [L_PictureCount] => 20 [L_ListingID] => 262368901 [L_ListingDate] => 2019-03-11 [L_ListOffice1] => 2548 [L_ListAgent1] => 28140 [L_Last_Photo_updt] => 2019-03-11T16:32:15 [L_DisplayId] => R2347274 [L_City] => West Vancouver [L_AskingPrice] => 5998000 [L_Area] => West Vancouver [L_AddressStreet] => SEASIDE [L_AddressNumber] => 5330 [L_Address] => 5330 SEASIDE PLACE [LV_vow_include] => Yes [LV_vow_address] => Yes [LR_remarks22] => Welcome to Seaside Place. A Waterfront enclave nestled into a quiet cul-de-sac. A true masterpiece of West Coast Arts and Craft designed by renowned Gordon Hlynsky with soaring ceilings and exposed beams allowing a great feeling of space and volume throughout the main level living areas. Enjoy the close intimate views of the ocean, passage & Bowen Island plus Eagle Harbour Marina throughout the practically designed 2 level floorplan with host of features including high-end Sub Zero, Viking & Miele appliances, extensive oak hardwood floors, media room, wet bar plus abundance of custom millwork including wainscoting & double crown mouldings. The home has been meticulously maintained by the current owners with close proximity to the Marina, Gleneagles Community Centre & Caulfeild shops. [LO1_ShortName] => V003041 [LO1_PhoneNumber1] => 604-913-1000 [LO1_OrganizationName] => Virani Real Estate Advisors [LM_char30_28] => 160.7 [LM_char1_36] => Residential Detached [LM_char100_3] => Mountains and Ocean Views [LM_Int2_5] => 2018 [LM_Int2_3] => 23 [LM_Int2_2] => 1996 [LM_Int1_4] => 4 [LM_Int1_2] => 5 [LM_Int1_19] => 6 [LM_Int1_18] => 4 [LM_Int1_17] => 2 [LM_Int1_1] => 2 [LM_Dec_9] => 81.81 [LM_Dec_8] => 268.40 [LM_Dec_7] => 4320 [LM_Dec_16] => 10399.55 [LM_Dec_11] => 14445.00 [LM_Dec_14] => 0.13 [LM_Dec_13] => 1341.98 [LM_Dec_12] => 0.33 [LM_Dec_1] => 2425 [LM_Char10_6] => Real Estate Board of Greater Vancouver [LM_Char10_5] => Caulfeild [LM_Char10_23] => Yes [LM_Char10_12] => Freehold Strata [LM_Char10_11] => House/Single Family [LFD_StyleofHome_1] => 2 Storey [LFD_SiteInfluences_15] => Private Setting [LFD_FeaturesIncluded_24] => Air Conditioning,Clothes Washer/Dryer,Security System [LFD_BasementArea_6] => Crawl [LA1_WebPage] => www.virani.ca [LA1_PhoneNumber1] => 604-913-1000 [LA1_LoginName] => V24910 [LA1_Char100_1] => Haneef Virani PREC* [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] => )