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.StreetNumber = '2004' AND A.StreetName = 'FULLERTON' AND A.StreetType = 'AVENUE' AND A.State = 'BC' AND A.CityName = 'North Vancouver' AND M.MLS_NUM NOT IN ('R2348003') AND M.MLSP_ID IN (1) AND PropertyTypeNew = 'Apartment/Condo' AND M.Beds >= '2' AND M.Beds <= '2' AND M.FloorArea >= 750 AND M.FloorArea <= 1000 AND ( Subdivision = 'Pemberton NV' ) 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.StreetNumber = '2004' AND A.StreetName = 'FULLERTON' AND A.StreetType = 'AVENUE' AND A.State = 'BC' AND A.CityName = 'North Vancouver' AND M.MLS_NUM NOT IN ('R2348003') AND M.MLSP_ID IN (1) AND PropertyTypeNew = 'Apartment/Condo' AND M.Beds >= '2' AND M.Beds <= '2' AND M.FloorArea >= 750 AND M.FloorArea <= 1000 AND ( Subdivision = 'Pemberton NV' ) 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.StreetNumber = '2004' AND A.StreetName = 'FULLERTON' AND A.StreetType = 'AVENUE' AND A.State = 'BC' AND A.CityName = 'North Vancouver' AND M.MLS_NUM NOT IN ('R2348003') AND M.MLSP_ID IN (1) AND PropertyTypeNew = 'Apartment/Condo' AND M.Beds >= '2' AND M.Beds <= '2' AND M.FloorArea >= 750 AND M.FloorArea <= 1000 AND ( Subdivision = 'Pemberton NV' ) 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] => 3433 [function] => getListingByParam [class] => IDXListing [type] => -> [args] => Array ( [0] => Array ( [PropertyType] => Apartment/Condo [StreetNumber] => 2004 [StreetName2] => FULLERTON [StreetType] => AVENUE [StreetDirection] => [CityName] => North Vancouver [State] => BC [NOT_MLS_NUM] => Array ( [0] => R2348003 ) [BedRange] => 2-2 [MinFloorArea] => 750 [MaxFloorArea] => 1000 [Subdivision] => Array ( [0] => Pemberton NV ) [MLSP_ID] => 1 [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] => R2348003 [MLSP_ID] => 1 [listing_key] => R2348003-1 [resource] => Property [class] => RA_2 [mls_board_name] => Real Estate Board of Greater Vancouver [agent_code] => V79485 [agent_key] => V79485-1 [agent_name] => Sam Mottei [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] => 1 [BathsHalf] => 0 [Baths] => 1 [Beds] => 2 [TotalAcreage] => 0 [ListPrice] => 575000 [ListMarketPercentage] => 6.08 [ListMarketPercentageCity] => 5.99 [OriginalListPrice] => 0 [SQFT] => 0 [FloorArea] => 864 [YearBuilt] => 1974 [TotalPhotos] => 14 [Main_Photo] => 1 [Description] => Welcome to the Whytcliff building located at the Woodcroft Residences, one of the safest, private and gated neighbourhood complexes in Greater Vancouver! Situated next to the famous Capilano River. This unit has been impeccably renovated, corner suit with NorthEast exposure.The common grounds are filled with lush and beautifully landscaped garden areas and maintained by a full time gardening staff. Woodcroft has onsite 24/7 security staff and each tower has a resident manager who works in conjunction with the onsite property management staff. There are also 3 separate recreation facilities including swimming pool, hot tub, exercise room, Table Tennis, Billiard room and workshop each shared by 2 buildings. Come see for yourself! Open House This Sunday March 24th 2-4 Pm [Description2] => Welcome to the Whytcliff building located at the Woodcroft Residences, one of the safest, private and gated neighbourhood complexes in Greater Vancouver! Situated next to the famous Capilano River. This unit has been impeccably renovated, corner suit with NorthEast exposure.The common grounds are filled with lush and beautifully landscaped garden areas and maintained by a full time gardening staff. Woodcroft has onsite 24/7 security staff and each tower has a resident manager who works in conjunction with the onsite property management staff. There are also 3 separate recreation facilities including swimming pool, hot tub, exercise room, Table Tennis, Billiard room and workshop each shared by 2 buildings. Come see for yourself! Open House This Sunday March 24th 2-4 Pm [Stories] => 1 [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 523.73 [Tax] => 1541.63 [TaxYear] => 2018 [Region] => [ListingDate] => 2019-03-12 [LastUpdateDate] => 2019-03-21T03:47:02 [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] => 212 [cartodb_id_ele_sch_process] => Yes [cartodb_id_mid_sch] => 0 [cartodb_id_mid_sch_process] => Yes [cartodb_id_sec_sch] => 52 [cartodb_id_sec_sch_process] => Yes [cartodb_id_crime] => 23 [cartodb_id_crime_process] => Yes [cartodb_id_demographic1] => 260 [cartodb_id_demographic1_process] => Yes [cartodb_id_demographic2] => 701 [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] => 927 [cartodb_id_subdivision_process] => Yes [DeletedDate] => 0000-00-00 00:00:00 [rets_system_key] => 262369630 [display_on_website] => Yes [display_on_website_datetime] => 1552429682 [created_datetime] => 2019-03-12 14:00:03 [updated_datetime] => 2019-04-30 11:01:47 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2019-05-02 03:27:42 [is_hotdeal] => No [hotdeal_tag] => [hotdeal_description] => [] [BasementArea] => [Features] => [Amenities] => [SiteInfluences] => [View] => [Frontage] => [mls_market_sef_url] => lower-mainland [mls_is_pic_url_supported] => No [ListingID_MLS] => R2348003-1 [Area] => North Vancouver [StreetName] => FULLERTON [StreetNumber] => 2004 [StreetType] => AVENUE [UnitNo] => 1408 [StreetDirection] => [ZipCode] => V7P 3G8 [CityName] => North Vancouver [County] => [State] => BC [Subdivision] => Pemberton NV [Latitude] => 49.330503400000000 [Longitude] => -123.120685400000000 [DayOnMarket] => 68 [Pic_Path] => https://static.estateblock.com/pictures/property/R2348003-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_Zip] => V7P 3G8 [L_UpdateDate] => 2019-03-21T03:47:02 [L_StreetDesignationId] => AVENUE [L_Status] => Active [L_State] => BC [L_ListingID] => 262369630 [L_ListingDate] => 2019-03-12 [L_ListOffice1] => 4200 [L_ListAgent1] => 56197 [L_DisplayId] => R2348003 [L_City] => North Vancouver [L_Area] => North Vancouver [L_AskingPrice] => 575000 [L_AddressUnit] => 1408 [L_AddressStreet] => FULLERTON [L_AddressNumber] => 2004 [L_Address] => 1408 2004 FULLERTON AVENUE [LV_vow_include] => Yes [LV_vow_address] => Yes [LO1_ShortName] => V005090 [LO1_PhoneNumber1] => 604-416-8888 [LO1_OrganizationName] => Royal Pacific Lions Gate Realty Ltd. [LM_char1_36] => Residential Attached [LM_char100_3] => MOUNTAIN [LM_Int2_3] => 45 [LM_Int2_8] => 17 [LM_Int2_5] => 2018 [LM_Int2_2] => 1974 [LM_Int1_4] => 2 [LM_Int1_19] => 1 [LM_Int1_18] => 1 [LM_Dec_7] => 864 [LM_Int1_1] => 1 [LM_Dec_22] => 523.73 [LM_Dec_16] => 1541.63 [LM_Dec_1] => 864 [LM_Char10_6] => Real Estate Board of Greater Vancouver [LM_Char10_5] => Pemberton NV [LM_Char10_23] => Yes [LFD_StyleofHome_32] => Corner Unit [LM_Char10_11] => Apartment/Condo [LFD_Amenities_56] => Pool; Indoor,Recreation Center,Sauna/Steam Room [LA1_PhoneNumber1] => 604-616-3239 [LA1_LoginName] => V79485 [LA1_Char100_1] => Sam Mottei [L_Last_Photo_updt] => 2019-03-14T19:41:14 [L_PictureCount] => 14 [LM_Char10_12] => Freehold Strata [LR_remarks33] => Welcome to the Whytcliff building located at the Woodcroft Residences, one of the safest, private and gated neighbourhood complexes in Greater Vancouver! Situated next to the famous Capilano River. This unit has been impeccably renovated, corner suit with NorthEast exposure.The common grounds are filled with lush and beautifully landscaped garden areas and maintained by a full time gardening staff. Woodcroft has onsite 24/7 security staff and each tower has a resident manager who works in conjunction with the onsite property management staff. There are also 3 separate recreation facilities including swimming pool, hot tub, exercise room, Table Tennis, Billiard room and workshop each shared by 2 buildings. Come see for yourself! Open House This Sunday March 24th 2-4 Pm [LR_remarks22] => Welcome to the Whytcliff building located at the Woodcroft Residences, one of the safest, private and gated neighbourhood complexes in Greater Vancouver! Situated next to the famous Capilano River. This unit has been impeccably renovated, corner suit with NorthEast exposure.The common grounds are filled with lush and beautifully landscaped garden areas and maintained by a full time gardening staff. Woodcroft has onsite 24/7 security staff and each tower has a resident manager who works in conjunction with the onsite property management staff. There are also 3 separate recreation facilities including swimming pool, hot tub, exercise room, Table Tennis, Billiard room and workshop each shared by 2 buildings. Come see for yourself! Open House This Sunday March 24th 2-4 Pm [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] => )