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 = '111' AND A.StreetName = '13TH' AND A.StreetType = 'STREET' AND A.StreetDirection = 'E' AND A.State = 'BC' AND A.CityName = 'North Vancouver' AND M.MLS_NUM NOT IN ('R2348254') AND M.MLSP_ID IN (1) AND PropertyTypeNew = 'Apartment/Condo' AND M.Beds >= '1' AND M.Beds <= '1' AND M.FloorArea >= 500 AND M.FloorArea <= 750 AND ( Subdivision = 'Central Lonsdale' ) 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 = '111' AND A.StreetName = '13TH' AND A.StreetType = 'STREET' AND A.StreetDirection = 'E' AND A.State = 'BC' AND A.CityName = 'North Vancouver' AND M.MLS_NUM NOT IN ('R2348254') AND M.MLSP_ID IN (1) AND PropertyTypeNew = 'Apartment/Condo' AND M.Beds >= '1' AND M.Beds <= '1' AND M.FloorArea >= 500 AND M.FloorArea <= 750 AND ( Subdivision = 'Central Lonsdale' ) 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 = '111' AND A.StreetName = '13TH' AND A.StreetType = 'STREET' AND A.StreetDirection = 'E' AND A.State = 'BC' AND A.CityName = 'North Vancouver' AND M.MLS_NUM NOT IN ('R2348254') AND M.MLSP_ID IN (1) AND PropertyTypeNew = 'Apartment/Condo' AND M.Beds >= '1' AND M.Beds <= '1' AND M.FloorArea >= 500 AND M.FloorArea <= 750 AND ( Subdivision = 'Central Lonsdale' ) 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] => 111 [StreetName2] => 13TH [StreetType] => STREET [StreetDirection] => E [CityName] => North Vancouver [State] => BC [NOT_MLS_NUM] => Array ( [0] => R2348254 ) [BedRange] => 1-1 [MinFloorArea] => 500 [MaxFloorArea] => 750 [Subdivision] => Array ( [0] => Central Lonsdale ) [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] => R2348254 [MLSP_ID] => 1 [listing_key] => R2348254-1 [resource] => Property [class] => RA_2 [mls_board_name] => Real Estate Board of Greater Vancouver [agent_code] => V32276 [agent_key] => V32276-1 [agent_name] => Kathy Major [office_code] => V004763 [office_key] => V004763-1 [office_name] => Royal LePage Sussex [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] => 1 [TotalAcreage] => 0 [ListPrice] => 585000 [ListMarketPercentage] => 11.45 [ListMarketPercentageCity] => 2.39 [OriginalListPrice] => 0 [SQFT] => 0 [FloorArea] => 552 [YearBuilt] => 2014 [TotalPhotos] => 11 [Main_Photo] => 1 [Description] => WELCOME TO THE PRESCOTT, a North Vancouver Landmark building. An elegant & bright 1 Bedroom home; an end unit with wrap around windows and a large 125 SF balcony. The kitchen, the appliances, the flooring, the bathroom, is all high end. Sunrise Kitchen cabinets, Kitchen-Aid Architect Series appliances, Quartz kitchen counters, Kentwood Walnut Hardwood floors, Grohe fixtures and Marble bathroom counter. The apartment is immaculate and in NEW CONDITION. Includes PARKING STALL, STORAGE LOCKER AND SECURED BIKE STORAGE. The building is NON SMOKING. It is well established with great management. There is a gym, visitor parking and even a dog wash. Pets are welcome and rentals are allowed. Fantastic central location steps to shopping, restaurants, and transit. [Description2] => [Stories] => 1 [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 260.74 [Tax] => 1440.00 [TaxYear] => 2018 [Region] => [ListingDate] => 2019-03-12 [LastUpdateDate] => 2019-05-13T15:38:16 [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] => 9 [cartodb_id_ele_sch_process] => Yes [cartodb_id_mid_sch] => 0 [cartodb_id_mid_sch_process] => Yes [cartodb_id_sec_sch] => 21 [cartodb_id_sec_sch_process] => Yes [cartodb_id_crime] => 8 [cartodb_id_crime_process] => Yes [cartodb_id_demographic1] => 246 [cartodb_id_demographic1_process] => Yes [cartodb_id_demographic2] => 371 [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] => 923 [cartodb_id_subdivision_process] => Yes [DeletedDate] => 0000-00-00 00:00:00 [rets_system_key] => 262369881 [display_on_website] => Yes [display_on_website_datetime] => 1552615442 [created_datetime] => 2019-03-14 15:40:16 [updated_datetime] => 2019-05-13 09:00:03 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2019-05-13 09:02:50 [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] => R2348254-1 [Area] => North Vancouver [StreetName] => 13TH [StreetNumber] => 111 [StreetType] => STREET [UnitNo] => 607 [StreetDirection] => E [ZipCode] => V7L 0C7 [CityName] => North Vancouver [County] => [State] => BC [Subdivision] => Central Lonsdale [Latitude] => 49.319800100000000 [Longitude] => -123.071566200000000 [DayOnMarket] => 68 [Pic_Path] => https://static.estateblock.com/pictures/property/R2348254-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] => V7L 0C7 [L_UpdateDate] => 2019-05-13T15:38:16 [L_StreetDesignationId] => STREET [L_State] => BC [L_Status] => Active [L_ListingID] => 262369881 [L_PictureCount] => 11 [L_ListingDate] => 2019-03-12 [L_ListOffice1] => 2777 [L_ListAgent1] => 33202 [L_Last_Photo_updt] => 2019-05-13T15:38:12 [L_City] => North Vancouver [L_DisplayId] => R2348254 [L_AskingPrice] => 585000 [L_Area] => North Vancouver [L_AddressUnit] => 607 [L_AddressStreet] => 13TH [L_Address] => 607 111 E 13TH STREET [L_AddressNumber] => 111 [L_AddressDirection] => E [LV_vow_include] => Yes [LV_vow_address] => Yes [LR_remarks22] => WELCOME TO THE PRESCOTT, a North Vancouver Landmark building. An elegant & bright 1 Bedroom home; an end unit with wrap around windows and a large 125 SF balcony. The kitchen, the appliances, the flooring, the bathroom, is all high end. Sunrise Kitchen cabinets, Kitchen-Aid Architect Series appliances, Quartz kitchen counters, Kentwood Walnut Hardwood floors, Grohe fixtures and Marble bathroom counter. The apartment is immaculate and in NEW CONDITION. Includes PARKING STALL, STORAGE LOCKER AND SECURED BIKE STORAGE. The building is NON SMOKING. It is well established with great management. There is a gym, visitor parking and even a dog wash. Pets are welcome and rentals are allowed. Fantastic central location steps to shopping, restaurants, and transit. [LO1_ShortName] => V004763 [LO1_PhoneNumber1] => 604-984-9711 [LO1_OrganizationName] => Royal LePage Sussex [LM_char1_36] => Residential Attached [LM_Int2_5] => 2018 [LM_Int2_8] => 15 [LM_Int2_3] => 5 [LM_Int2_2] => 2014 [LM_Int1_4] => 1 [LM_Int1_19] => 1 [LM_Int1_18] => 1 [LM_Int1_1] => 1 [LM_Dec_7] => 552 [LM_Dec_16] => 1440.00 [LM_Dec_22] => 260.74 [LM_Dec_1] => 552 [LM_Char10_5] => Central Lonsdale [LM_Char10_6] => Real Estate Board of Greater Vancouver [LM_Char10_23] => No [LM_Char10_11] => Apartment/Condo [LFD_StyleofHome_32] => 1 Storey,End Unit [LM_Char10_12] => Freehold Strata [LFD_SiteInfluences_46] => Central Location,Recreation Nearby,Shopping Nearby [LFD_FeaturesIncluded_55] => Clothes Washer/Dryer,Dishwasher,Drapes/Window Coverings,Microwave,Oven - Built In,Range Top,Refrigerator,Security - Roughed In [LFD_Amenities_56] => Bike Room,Elevator,Exercise Centre,In Suite Laundry,Storage,Wheelchair Access [LA1_WebPage] => http://www.kathymajor.com [LA1_PhoneNumber1] => 604-671-5140 [LA1_Char100_1] => Kathy Major [LA1_LoginName] => V32276 [LM_Dec_14] => 0.00 [LM_Dec_13] => 0.00 [LM_Dec_12] => 0.00 [LM_Dec_11] => 0.00 [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] => )