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 ('R2470351') AND M.MLSP_ID IN (1) AND PropertyTypeNew = 'Townhouse' AND M.Beds >= '4' AND M.Beds <= '4' AND M.FloorArea >= 1500 AND M.FloorArea <= 1750 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_29.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 ('R2470351') AND M.MLSP_ID IN (1) AND PropertyTypeNew = 'Townhouse' AND M.Beds >= '4' AND M.Beds <= '4' AND M.FloorArea >= 1500 AND M.FloorArea <= 1750 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 ('R2470351') AND M.MLSP_ID IN (1) AND PropertyTypeNew = 'Townhouse' AND M.Beds >= '4' AND M.Beds <= '4' AND M.FloorArea >= 1500 AND M.FloorArea <= 1750 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] => 4-4 [MinFloorArea] => 1500 [MaxFloorArea] => 1750 [CityName] => Richmond [Subdivision] => Array ( [0] => McLennan North ) [State] => BC [MLSP_ID] => 1 [NOT_MLS_NUM] => Array ( [0] => R2470351 ) [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] => R2470351 [MLSP_ID] => 1 [listing_key] => R2470351-1 [resource] => Property [class] => RA_2 [mls_board_name] => Real Estate Board of Greater Vancouver [agent_code] => V60879 [agent_key] => V60879-1 [agent_name] => Ken Cui PREC* [office_code] => V004932 [office_key] => V004932-1 [office_name] => Nu Stream Realty Inc. [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] => 4 [TotalAcreage] => 0 [ListPrice] => 1098000 [ListMarketPercentage] => 0 [ListMarketPercentageCity] => 0 [OriginalListPrice] => 0 [SQFT] => 0 [FloorArea] => 1634 [YearBuilt] => 2006 [TotalPhotos] => 29 [Main_Photo] => 1 [Description] => Rarely find 2 level deluxe townhouse in Barrington Walk by Polygon. CORNER UNIT, centrally located at Garden City and Granville. This quiet, beautiful SOUTH facing unit offers bright & spacious floor plan with 4 bedrooms up and enclosed living room could be 5th bedroom for in laws or guest, 2.5 baths. Open kitchen with eating area, granite countertops & stainless steel appliances, spacious family room. Side by side double garage. Two visitor parking beside this unit. New interior paints. Walking distance to RC palmer secondary school, lake, park, shopping & transportation. [Description2] => [Stories] => 2 [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 209.30 [Tax] => 3157.18 [TaxYear] => 2019 [Region] => [ListingDate] => 2020-06-29 [LastUpdateDate] => 2020-06-30T18:22:29 [LastPhotoDate] => [Pic_Download_Flag] => N [Pic_Updated_Date] => [Pic_Download_Try_Date] => [DisplayAddress] => Yes [PublishOnInternet] => Yes [business_type_major] => [business_type_minor] => [dom] => 7 [tag] => [is_openhouse] => No [vw_is_show_only_processed] => Yes [is_mark_for_deletion] => N [Listing_Created_Date] => 2020-06-29 15:00:07 [is_price_reduced] => N [price_reduced_date] => [cartodb_id_ele_sch] => 308 [cartodb_id_ele_sch_process] => Yes [cartodb_id_mid_sch] => 0 [cartodb_id_mid_sch_process] => Yes [cartodb_id_sec_sch] => 81 [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] => 262491978 [display_on_website] => Yes [display_on_website_datetime] => 1593470766 [created_datetime] => 2020-06-29 15:00:07 [updated_datetime] => 2020-06-30 11:40:04 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2020-06-30 12:09:43 [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] => R2470351-1 [Area] => Richmond [StreetName] => HEATHER [StreetNumber] => 7288 [StreetType] => STREET [UnitNo] => 43 [StreetDirection] => [ZipCode] => V6Y 4L4 [CityName] => Richmond [County] => [State] => BC [Subdivision] => McLennan North [Latitude] => 49.161150900000000 [Longitude] => -123.122311200000000 [DayOnMarket] => 7 [Pic_Path] => https://static.estateblock.com/pictures/property/R2470351-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] => Ken Cui PREC* [LA1_Email] => kencuirealtor@gmail.com [LA1_LoginName] => V60879 [LA1_PhoneNumber1] => 778-987-5877 [LA2_Char100_1] => Jia Liu [LA2_Email] => liujia_james@hotmail.com [LA2_LoginName] => V62228 [LA2_PhoneNumber1] => 604-417-0067 [LFD_Amenities_56] => Exercise Centre,In Suite Laundry [LFD_BasementArea_37] => None [LFD_BylawRestrictions_58] => Pets Allowed w/Rest.,Rentals Allowed [LFD_Construction_41] => Frame - Wood [LFD_ExteriorFinish_42] => Vinyl [LFD_FireplaceFueledby_49] => Gas - Natural [LFD_FuelHeating_48] => Electric [LFD_MaintFeeIncludes_57] => Caretaker,Gardening,Management [LFD_OutdoorArea_47] => Fenced Yard [LFD_Parking_44] => Garage; Double [LFD_Roof_43] => Asphalt [LFD_ServicesConnected_38] => Electricity,Natural Gas,Water [LFD_StyleofHome_32] => 2 Storey [LFD_Suite_36] => None [LFD_WaterSupply_39] => City/Municipal [LM_char100_1] => 026-711-265 [LM_Char10_10] => Attached [LM_Char10_11] => Townhouse [LM_Char10_12] => Freehold Strata [LM_Char10_13] => Yes [LM_Char10_15] => No [LM_Char10_17] => VRI62 [LM_Char10_18] => Concrete Perimeter [LM_Char10_23] => No [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_10] => No [LM_Char1_2] => No [LM_Char1_3] => No [LM_char1_36] => Residential Attached [LM_Char1_9] => No [LM_char255_1] => 3.15% FIRST $100,000 AND 1.15% ON BALANCE [LM_Char25_16] => Above [LM_Char25_17] => Above [LM_Char25_18] => Main [LM_char5_10] => Above [LM_char5_11] => Dining Room [LM_char5_12] => 13'4 [LM_char5_13] => 9'7 [LM_char5_14] => Above [LM_char5_15] => Family Room [LM_char5_16] => 13'0 [LM_char5_17] => 11'9 [LM_char5_18] => Above [LM_char5_19] => Kitchen [LM_char5_20] => 10'10 [LM_char5_21] => 8'0 [LM_char5_22] => Above [LM_char5_23] => Nook [LM_char5_24] => 11'9 [LM_char5_25] => 6'0 [LM_char5_26] => Main [LM_char5_27] => Master Bedroom [LM_char5_28] => 12'9 [LM_char5_29] => 11'9 [LM_char5_30] => Main [LM_char5_31] => Bedroom [LM_char5_32] => 11'6 [LM_char5_33] => 10'10 [LM_char5_34] => Main [LM_char5_35] => Bedroom [LM_char5_36] => 9'0 [LM_char5_37] => 8'0 [LM_char5_38] => Main [LM_char5_39] => Bedroom [LM_char5_40] => 9'5 [LM_char5_41] => 9'4 [LM_char5_6] => Feet [LM_char5_7] => Above [LM_char5_8] => 13'0 [LM_char5_9] => 11'4 [LM_Dec_1] => 803 [LM_Dec_11] => 0.00 [LM_Dec_12] => 0.00 [LM_Dec_13] => 0.00 [LM_Dec_14] => 0.00 [LM_Dec_16] => 3157.18 [LM_Dec_2] => 831 [LM_Dec_22] => 209.30 [LM_Dec_5] => 1634 [LM_Dec_7] => 1634 [LM_Dec_8] => 0.00 [LM_Int1_1] => 2 [LM_Int1_10] => 3 [LM_Int1_11] => 2 [LM_Int1_17] => 1 [LM_Int1_18] => 2 [LM_Int1_19] => 3 [LM_Int1_2] => 1 [LM_Int1_20] => 3 [LM_Int1_4] => 4 [LM_Int1_6] => 4 [LM_Int1_7] => 9 [LM_Int1_8] => 1 [LM_Int1_9] => 3 [LM_Int2_2] => 2006 [LM_Int2_3] => 14 [LM_Int2_5] => 2019 [LM_Int2_6] => 2 [LM_Int2_7] => 2 [LO1_OrganizationName] => Nu Stream Realty Inc. [LO1_PhoneNumber1] => 778-379-7570 [LO1_ShortName] => V004932 [LO1_WebPage] => http://www.nustreamrealty.com [LO2_OrganizationName] => Nu Stream Realty Inc. [LO2_PhoneNumber1] => 778-379-7570 [LO2_ShortName] => V004932 [LO2_WebPage] => http://www.nustreamrealty.com [LR_remarks22] => Rarely find 2 level deluxe townhouse in Barrington Walk by Polygon. CORNER UNIT, centrally located at Garden City and Granville. This quiet, beautiful SOUTH facing unit offers bright & spacious floor plan with 4 bedrooms up and enclosed living room could be 5th bedroom for in laws or guest, 2.5 baths. Open kitchen with eating area, granite countertops & stainless steel appliances, spacious family room. Side by side double garage. Two visitor parking beside this unit. New interior paints. Walking distance to RC palmer secondary school, lake, park, shopping & transportation. [LV_vow_address] => Yes [LV_vow_include] => Yes [L_Address] => 43 7288 HEATHER STREET [L_AddressNumber] => 7288 [L_AddressStreet] => HEATHER [L_AddressUnit] => 43 [L_Area] => Richmond [L_AskingPrice] => 1098000 [L_CDOM] => 1 [L_City] => Richmond [L_DisplayId] => R2470351 [L_DOM] => 1 [L_ExpirationDate] => 2021-07-30 [L_IdxInclude] => Yes [L_InputDate] => 2020-06-29T21:40:42 [L_Last_Photo_updt] => 2020-06-30T00:09:43 [L_ListAgent1] => 44706 [L_ListAgent2] => 50619 [L_ListingDate] => 2020-06-29 [L_ListingID] => 262491978 [L_ListOffice1] => 4059 [L_ListOffice2] => 4059 [L_OriginalPrice] => 1098000 [L_PictureCount] => 29 [L_PricePerSQFT] => 671.97 [L_Remarks] => STRATA LOT 98, BLOCK 4N, PLAN BCS1512, SECTION 15, 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-06-30T18:22:29 [L_Zip] => V6Y 4L4 [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] => )