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 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 = 'Richmond' AND M.MLS_NUM NOT IN ('R2470895') AND M.MLSP_ID IN (1) AND PropertyTypeNew = 'Townhouse' AND M.Beds >= '3' AND M.Beds <= '3' AND M.FloorArea >= 1250 AND M.FloorArea <= 1500 AND ( Subdivision = 'McLennan North' ) AND M.is_mark_for_deletion = 'N' AND display_on_website = 'Yes' AND M.MLS_NUM NOT IN ( 'R2396748','R2324677','C8020260','R2228301','R2234336','R2246159','R2248911','R2268588','439164','R2334065','R2331824','C8021917','2433783','10186756','2441289','R2374891','R2424637','R2400629','R2383547','r2383547' ) ORDER BY listprice DESC LIMIT 0, 9
MySQL Error: 1021 (Disk full (/home/tmp/#sql_14bc_35.MAI); waiting for someone to free some space... (errno: 28 "No space left on device"))
[string:Exception:private] => [code:protected] => 0 [file:protected] => /home/estatebl/public_html/libs/mysql5i.php [line:protected] => 665 [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 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 = 'Richmond' AND M.MLS_NUM NOT IN ('R2470895') AND M.MLSP_ID IN (1) AND PropertyTypeNew = 'Townhouse' AND M.Beds >= '3' AND M.Beds <= '3' AND M.FloorArea >= 1250 AND M.FloorArea <= 1500 AND ( Subdivision = 'McLennan North' ) AND M.is_mark_for_deletion = 'N' AND display_on_website = 'Yes' AND M.MLS_NUM NOT IN ( 'R2396748','R2324677','C8020260','R2228301','R2234336','R2246159','R2248911','R2268588','439164','R2334065','R2331824','C8021917','2433783','10186756','2441289','R2374891','R2424637','R2400629','R2383547','r2383547' ) ORDER BY listprice DESC LIMIT 0, 9 ) ) [1] => Array ( [file] => /home/estatebl/public_html/db_access/IDXListing.php [line] => 2181 [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 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 = 'Richmond' AND M.MLS_NUM NOT IN ('R2470895') AND M.MLSP_ID IN (1) AND PropertyTypeNew = 'Townhouse' AND M.Beds >= '3' AND M.Beds <= '3' AND M.FloorArea >= 1250 AND M.FloorArea <= 1500 AND ( Subdivision = 'McLennan North' ) AND M.is_mark_for_deletion = 'N' AND display_on_website = 'Yes' AND M.MLS_NUM NOT IN ( 'R2396748','R2324677','C8020260','R2228301','R2234336','R2246159','R2248911','R2268588','439164','R2334065','R2331824','C8021917','2433783','10186756','2441289','R2374891','R2424637','R2400629','R2383547','r2383547' ) ORDER BY listprice DESC LIMIT 0, 9 ) ) [2] => Array ( [file] => /home/estatebl/public_html/component/IDXListingComponent.php [line] => 3491 [function] => getListingByParam [class] => IDXListing [type] => -> [args] => Array ( [0] => Array ( [PropertyType] => Townhouse [BedRange] => 3-3 [MinFloorArea] => 1250 [MaxFloorArea] => 1500 [CityName] => Richmond [Subdivision] => Array ( [0] => McLennan North ) [State] => BC [MLSP_ID] => 1 [NOT_MLS_NUM] => Array ( [0] => R2470895 ) [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] => 847 [function] => getSimilarAndBuildingMoreListingNew [class] => IDXListingComponent [type] => -> [args] => Array ( [0] => Array ( [MLS_NUM] => R2470895 [MLSP_ID] => 1 [listing_key] => R2470895-1 [resource] => Property [class] => RA_2 [mls_board_name] => Real Estate Board of Greater Vancouver [agent_code] => V74046 [agent_key] => V74046-1 [agent_name] => Albert Hui PREC* [office_code] => V001774 [office_key] => V001774-1 [office_name] => Sutton Group - 1st West Realty [ListingKey] => [PropertyType] => Residential Attached [PropertyTypeNew] => Townhouse [PropertyStyle] => [ListingStatus] => Active [SubType] => Townhouse [OwnershipType] => Freehold Strata [OwnershipTypeNew] => Freehold Strata [Zoning] => [BathsFull] => 2 [BathsHalf] => 1 [Baths] => 3 [Beds] => 3 [TotalAcreage] => 0 [ListPrice] => 948000 [ListMarketPercentage] => 0 [ListMarketPercentageCity] => 0 [OriginalListPrice] => 0 [SQFT] => 0 [FloorArea] => 1424 [YearBuilt] => 2012 [TotalPhotos] => 14 [Main_Photo] => 1 [Description] => Rare find ! ~Side by Side~ garage Townhouse with 3 Levels ! South Facing, corner unit. Spacious and very functional layout , just a gem in the centre of the City. No unit for sale for years at this complex, and this well kept CORNER unit is first time on market. Beautiful Dogwood tree surrounding, with beautiful planted sidewalk, Tennis court, Park, basketball court in this enjoyable quiet neighborhood. Walking distance to Anderson Elementary School and Macneil Secondary School. A side by side Garage 3 level Townhouse always get sold fast. Bonus *lots of storage sapce* Act now , and book for your private showing. Easy to show ! [Description2] => [Stories] => 3 [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 220.00 [Tax] => 2979.68 [TaxYear] => 2019 [Region] => [ListingDate] => 2020-06-30 [LastUpdateDate] => 2020-07-03T19:38:37 [LastPhotoDate] => [Pic_Download_Flag] => N [Pic_Updated_Date] => [Pic_Download_Try_Date] => [DisplayAddress] => Yes [PublishOnInternet] => Yes [business_type_major] => [business_type_minor] => [dom] => 6 [tag] => [is_openhouse] => No [vw_is_show_only_processed] => Yes [is_mark_for_deletion] => N [Listing_Created_Date] => 2020-06-30 15:20:03 [is_price_reduced] => N [price_reduced_date] => [cartodb_id_ele_sch] => 311 [cartodb_id_ele_sch_process] => Yes [cartodb_id_mid_sch] => 0 [cartodb_id_mid_sch_process] => Yes [cartodb_id_sec_sch] => 82 [cartodb_id_sec_sch_process] => Yes [cartodb_id_crime] => 28 [cartodb_id_crime_process] => Yes [cartodb_id_demographic1] => 291 [cartodb_id_demographic1_process] => Yes [cartodb_id_demographic2] => 174 [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] => 2 [cartodb_id_city_process] => Yes [cartodb_id_area] => 2 [cartodb_id_area_process] => Yes [cartodb_id_subdivision] => 104 [cartodb_id_subdivision_process] => Yes [DeletedDate] => 0000-00-00 00:00:00 [rets_system_key] => 262492522 [display_on_website] => Yes [display_on_website_datetime] => 1593557946 [created_datetime] => 2020-06-30 15:20:03 [updated_datetime] => 2020-07-03 13:00:03 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2020-07-03 13:04:55 [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] => R2470895-1 [Area] => Richmond [StreetName] => ALDER [StreetNumber] => 6180 [StreetType] => STREET [UnitNo] => 11 [StreetDirection] => [ZipCode] => V6Y 0C9 [CityName] => Richmond [County] => [State] => BC [Subdivision] => McLennan North [Latitude] => 49.169454000000000 [Longitude] => -123.118977500000000 [DayOnMarket] => 6 [Pic_Path] => https://static.estateblock.com/pictures/property/R2470895-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] => Albert Hui PREC* [LA1_Email] => mybchouse@gmail.com [LA1_LoginName] => V74046 [LA1_PhoneNumber1] => 604-353-2111 [LFD_Amenities_56] => In Suite Laundry,Playground,Storage,Tennis Court(s) [LFD_BasementArea_37] => Crawl [LFD_BylawRestrictions_58] => Pets Allowed w/Rest.,Rentals Allowed [LFD_Construction_41] => Frame - Wood [LFD_DirectionalExpRearYard_40] => North [LFD_ExteriorFinish_42] => Mixed,Vinyl [LFD_FeaturesIncluded_55] => ClthWsh/Dryr/Frdg/Stve/DW,Vacuum - Roughed In [LFD_FuelHeating_48] => Baseboard,Electric [LFD_MaintFeeIncludes_57] => Garbage Pickup,Gardening,Management [LFD_OutdoorArea_47] => Fenced Yard [LFD_Parking_44] => Garage; Double [LFD_Roof_43] => Asphalt [LFD_ServicesConnected_38] => Electricity,Sanitary Sewer,Water [LFD_StyleofHome_32] => 3 Storey,Corner Unit [LFD_WaterSupply_39] => City/Municipal [LM_char100_1] => 028-856-228 [LM_Char10_10] => Attached [LM_Char10_11] => Townhouse [LM_Char10_12] => Freehold Strata [LM_Char10_13] => No [LM_Char10_15] => No [LM_Char10_17] => ZT69 [LM_Char10_18] => Concrete Perimeter [LM_Char10_25] => Living Room [LM_Char10_4] => Greater Vancouver [LM_Char10_5] => McLennan North [LM_Char10_6] => Real Estate Board of Greater Vancouver [LM_char10_75] => City/Municipal [LM_Char1_1] => Yes [LM_Char1_2] => No [LM_Char1_3] => No [LM_char1_36] => Residential Attached [LM_char255_1] => 3.22% ON 1ST 100K, 1.15% AFTER [LM_Char25_16] => Above [LM_Char25_17] => Above [LM_Char25_18] => Main [LM_Char25_2] => 20X17 [LM_Char25_27] => 604-207-2002 [LM_char30_2] => aa property management [LM_Char50_4] => Seller'll provide on buyer request [LM_Char50_5] => Turnberry Lane [LM_char5_10] => Main [LM_char5_11] => Dining Room [LM_char5_12] => 13'8 [LM_char5_13] => 10' [LM_char5_14] => Main [LM_char5_15] => Kitchen [LM_char5_16] => 12' [LM_char5_17] => 10'8 [LM_char5_18] => Above [LM_char5_19] => Master Bedroom [LM_char5_20] => 13'6 [LM_char5_21] => 11'1 [LM_char5_22] => Above [LM_char5_23] => Bedroom [LM_char5_24] => 10'9 [LM_char5_25] => 8'6 [LM_char5_26] => Above [LM_char5_27] => Bedroom [LM_char5_28] => 9'5' [LM_char5_29] => 9'2 [LM_char5_30] => Below [LM_char5_31] => Den [LM_char5_32] => 9'9 [LM_char5_33] => 9'6 [LM_char5_7] => Main [LM_char5_8] => 15'8 [LM_char5_9] => 12'1 [LM_Dec_1] => 646 [LM_Dec_11] => 0.00 [LM_Dec_12] => 0.00 [LM_Dec_13] => 0.00 [LM_Dec_14] => 0.00 [LM_Dec_16] => 2979.68 [LM_Dec_2] => 678 [LM_Dec_22] => 220.00 [LM_Dec_3] => 100 [LM_Dec_5] => 1424 [LM_Dec_7] => 1424 [LM_Int1_1] => 3 [LM_Int1_10] => 3 [LM_Int1_11] => 2 [LM_Int1_17] => 1 [LM_Int1_18] => 2 [LM_Int1_19] => 3 [LM_Int1_20] => 4 [LM_Int1_4] => 3 [LM_Int1_6] => 3 [LM_Int1_7] => 7 [LM_Int1_8] => 1 [LM_Int1_9] => 4 [LM_Int2_2] => 2012 [LM_Int2_3] => 8 [LM_Int2_5] => 2019 [LM_Int2_6] => 2 [LM_Int2_7] => 2 [LM_Int4_1] => 20 [LM_Int4_2] => 20 [LO1_OrganizationName] => Sutton Group - 1st West Realty [LO1_PhoneNumber1] => 604-942-7211 [LO1_ShortName] => V001774 [LO1_WebPage] => http://www.sutton1stwest.com [LR_remarks22] => Rare find ! ~Side by Side~ garage Townhouse with 3 Levels ! South Facing, corner unit. Spacious and very functional layout , just a gem in the centre of the City. No unit for sale for years at this complex, and this well kept CORNER unit is first time on market. Beautiful Dogwood tree surrounding, with beautiful planted sidewalk, Tennis court, Park, basketball court in this enjoyable quiet neighborhood. Walking distance to Anderson Elementary School and Macneil Secondary School. A side by side Garage 3 level Townhouse always get sold fast. Bonus *lots of storage sapce* Act now , and book for your private showing. Easy to show ! [LV_vow_address] => Yes [LV_vow_include] => Yes [L_Address] => 11 6180 ALDER STREET [L_AddressNumber] => 6180 [L_AddressStreet] => ALDER [L_AddressUnit] => 11 [L_Area] => Richmond [L_AskingPrice] => 948000 [L_CDOM] => 3 [L_City] => Richmond [L_DisplayId] => R2470895 [L_DOM] => 3 [L_ExpirationDate] => 2020-12-31 [L_IdxInclude] => Yes [L_InputDate] => 2020-06-30T22:01:30 [L_Last_Photo_updt] => 2020-07-03T19:38:37 [L_ListAgent1] => 48605 [L_ListingDate] => 2020-06-30 [L_ListingID] => 262492522 [L_ListOffice1] => 3326 [L_OriginalPrice] => 948000 [L_PictureCount] => 14 [L_PricePerSQFT] => 665.73 [L_Remarks] => STRATA LOT 11, BLOCK 4N, PLAN BCS4463, SECTION 10, RANGE 6W, NEW WESTMINSTER LAND DISTRICT, TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM V [L_State] => BC [L_Status] => Active [L_StreetDesignationId] => STREET [L_Type_] => Townhouse [L_UpdateDate] => 2020-07-03T19:38:37 [L_Zip] => V6Y 0C9 [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] => )