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 ('R2347361') AND M.MLSP_ID IN (1) AND PropertyTypeNew = 'House' AND M.Beds >= '6' AND M.Beds <= '6' AND M.FloorArea >= 7500 AND M.FloorArea <= 10000 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 ('R2347361') AND M.MLSP_ID IN (1) AND PropertyTypeNew = 'House' AND M.Beds >= '6' AND M.Beds <= '6' AND M.FloorArea >= 7500 AND M.FloorArea <= 10000 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 ('R2347361') AND M.MLSP_ID IN (1) AND PropertyTypeNew = 'House' AND M.Beds >= '6' AND M.Beds <= '6' AND M.FloorArea >= 7500 AND M.FloorArea <= 10000 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] => 6-6 [MinSQFT] => 10890 [MaxSQFT] => 21780 [MinFloorArea] => 7500 [MaxFloorArea] => 10000 [CityName] => West Vancouver [Subdivision] => Array ( [0] => Caulfeild ) [State] => BC [MLSP_ID] => 1 [NOT_MLS_NUM] => Array ( [0] => R2347361 ) [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] => R2347361 [MLSP_ID] => 1 [listing_key] => R2347361-1 [resource] => Property [class] => RD_1 [mls_board_name] => Real Estate Board of Greater Vancouver [agent_code] => V53375 [agent_key] => V53375-1 [agent_name] => D.J. Denner [office_code] => V002321 [office_key] => V002321-1 [office_name] => Angell Hasman & Assoc.Rlty.Ltd [ListingKey] => 0 [PropertyType] => Residential Detached [PropertyTypeNew] => House [PropertyStyle] => 3 Storey [ListingStatus] => Active [SubType] => House/Single Family [OwnershipType] => Freehold NonStrata [OwnershipTypeNew] => Freehold [Zoning] => [BathsFull] => 6 [BathsHalf] => 2 [Baths] => 8 [Beds] => 6 [TotalAcreage] => 0.46 [ListPrice] => 7588000 [ListMarketPercentage] => 0 [ListMarketPercentageCity] => 4.45 [OriginalListPrice] => 7588000 [SQFT] => 20039 [FloorArea] => 8274 [YearBuilt] => 2019 [TotalPhotos] => 15 [Main_Photo] => 1 [Description] => Newly completed luxury residence situated on half acre property in prestigious Caulfield just a short walk to Stearman Beach. Six bdrms, eight bthrms, over eight thousand sq ft of formal & informal living on three expansive levels. Includes entertainment size formal living and dining rooms, private study, gourmet kitchen, adjoining second kitchen, family room all providing a indoor outdoor lifestyle with walk-out access to a private heated terrace, fireside lounge, infinity swimming pool and outdoor kitchen with BBQ. Lower level designed for entertaining with games room & home theatre. Lavish master suite with large walk-in dressing & gorgeous master bathroom. Additional features include elevator, smart home automation. elevator, smart home automation. [Description2] => [Stories] => 3 [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 0.00 [Tax] => 6368.43 [TaxYear] => 2018 [Region] => [ListingDate] => 2019-03-11 [LastUpdateDate] => 2019-05-14T17:45:24 [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] => 206 [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] => 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] => 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] => 262368988 [display_on_website] => Yes [display_on_website_datetime] => 1552330561 [created_datetime] => 2019-03-11 11:20:05 [updated_datetime] => 2019-05-14 11:00:34 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2019-05-14 11:05:52 [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] => R2347361-1 [Area] => West Vancouver [StreetName] => KEITH [StreetNumber] => 4485 [StreetType] => ROAD [UnitNo] => [StreetDirection] => [ZipCode] => V7W 2M7 [CityName] => West Vancouver [County] => [State] => BC [Subdivision] => Caulfeild [Latitude] => 49.345219000000000 [Longitude] => -123.245644000000000 [DayOnMarket] => 69 [Pic_Path] => https://static.estateblock.com/pictures/property/R2347361-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] => D.J. Denner [LA1_LoginName] => V53375 [LA1_PhoneNumber1] => 604-773-5204 [LA1_WebPage] => www.djdenner.ca [LA2_Char100_1] => Nick Neacsu PREC* [LA2_LoginName] => V64300 [LA2_PhoneNumber1] => 604-561-5363 [LA2_WebPage] => http://www.nickneacsu.com [LA3_Char100_1] => Malcolm Hasman [LA3_LoginName] => V6829 [LA3_PhoneNumber1] => 604-290-1679 [LA3_WebPage] => www.malcolmhasman.com [LFD_Amenities_25] => Air Cond./Central,Elevator,Garden,Pool; Outdoor,Sauna/Steam Room,Swirlpool/Hot Tub [LFD_BasementArea_6] => Fully Finished [LFD_SiteInfluences_15] => Central Location,Private Setting,Private Yard,Recreation Nearby,Shopping Nearby [LFD_StyleofHome_1] => 3 Storey [LM_Char10_11] => House/Single Family [LM_Char10_12] => Freehold NonStrata [LM_Char10_5] => Caulfeild [LM_Char10_6] => Real Estate Board of Greater Vancouver [LM_char1_36] => Residential Detached [LM_char30_28] => 200 [LM_Dec_1] => 3468 [LM_Dec_11] => 20039.00 [LM_Dec_12] => 0.46 [LM_Dec_13] => 1861.68 [LM_Dec_14] => 0.19 [LM_Dec_16] => 6368.43 [LM_Dec_7] => 8274 [LM_Dec_8] => 100.00 [LM_Dec_9] => 30.48 [LM_Int1_1] => 3 [LM_Int1_17] => 2 [LM_Int1_18] => 6 [LM_Int1_19] => 8 [LM_Int1_2] => 2 [LM_Int1_4] => 6 [LM_Int2_2] => 2019 [LM_Int2_5] => 2018 [LO1_OrganizationName] => Angell Hasman & Assoc.Rlty.Ltd [LO1_PhoneNumber1] => 604-921-1188 [LO1_ShortName] => V002321 [LO2_OrganizationName] => Angell Hasman & Assoc.Rlty.Ltd [LO2_PhoneNumber1] => 604-921-1188 [LO2_ShortName] => V002321 [LO3_OrganizationName] => Angell Hasman (Malcolm Hasman) [LO3_ShortName] => V002111 [LR_remarks22] => Newly completed luxury residence situated on half acre property in prestigious Caulfield just a short walk to Stearman Beach. Six bdrms, eight bthrms, over eight thousand sq ft of formal & informal living on three expansive levels. Includes entertainment size formal living and dining rooms, private study, gourmet kitchen, adjoining second kitchen, family room all providing a indoor outdoor lifestyle with walk-out access to a private heated terrace, fireside lounge, infinity swimming pool and outdoor kitchen with BBQ. Lower level designed for entertaining with games room & home theatre. Lavish master suite with large walk-in dressing & gorgeous master bathroom. Additional features include elevator, smart home automation. elevator, smart home automation. [LV_vow_address] => Yes [LV_vow_include] => Yes [L_Address] => 4485 KEITH ROAD [L_AddressNumber] => 4485 [L_AddressStreet] => KEITH [L_Area] => West Vancouver [L_AskingPrice] => 7588000 [L_City] => West Vancouver [L_DisplayId] => R2347361 [L_Last_Photo_updt] => 2019-04-16T23:09:54 [L_ListAgent1] => 42551 [L_ListAgent2] => 42110 [L_ListAgent3] => 13610 [L_ListingDate] => 2019-03-11 [L_ListingID] => 262368988 [L_ListOffice1] => 2739 [L_ListOffice2] => 2739 [L_ListOffice3] => 3245 [L_PictureCount] => 15 [L_State] => BC [L_Status] => Active [L_StreetDesignationId] => ROAD [L_UpdateDate] => 2019-05-14T17:45:24 [L_Zip] => V7W 2M7 [VT_VTourURL] => https://www.neacsudenner.com/showlisting/231941/4485-Keith-Road-Caulfeild-West-Vancouver/ [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] => )