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 ('R2470439') 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 = 'Brighouse' ) 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_13.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 ('R2470439') 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 = 'Brighouse' ) 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 ('R2470439') 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 = 'Brighouse' ) 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] => Apartment/Condo [BedRange] => 2-2 [MinFloorArea] => 750 [MaxFloorArea] => 1000 [CityName] => Richmond [Subdivision] => Array ( [0] => Brighouse ) [State] => BC [MLSP_ID] => 1 [NOT_MLS_NUM] => Array ( [0] => R2470439 ) [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] => R2470439 [MLSP_ID] => 1 [listing_key] => R2470439-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] => Apartment/Condo [PropertyStyle] => [ListingStatus] => Active [SubType] => Apartment/Condo [OwnershipType] => Freehold Strata [OwnershipTypeNew] => Freehold Strata [Zoning] => [BathsFull] => 2 [BathsHalf] => 0 [Baths] => 2 [Beds] => 2 [TotalAcreage] => 0 [ListPrice] => 959000 [ListMarketPercentage] => 0 [ListMarketPercentageCity] => 0 [OriginalListPrice] => 959000 [SQFT] => 0 [FloorArea] => 964 [YearBuilt] => 2015 [TotalPhotos] => 24 [Main_Photo] => 1 [Description] => Carreara By Polygon ! LOCATION LOCATION LOCATION! Richmond Top school catachment Most convenient condo beside Richmond Centre. very well keep condition, This corner South East facing unit provide lot of sunlight all year along. Central A/C and Heating include in strata fee. 8'6 ceilings, quartz counter top, bosch appliances, 2 large balcony. Walking distances to shopping mall and public transportation. Easy to show [Description2] => [Stories] => 1 [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 380.00 [Tax] => 2300.00 [TaxYear] => 2017 [Region] => [ListingDate] => 2020-06-29 [LastUpdateDate] => 2020-06-30T20:58:30 [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 16:20:03 [is_price_reduced] => N [price_reduced_date] => [cartodb_id_ele_sch] => 303 [cartodb_id_ele_sch_process] => Yes [cartodb_id_mid_sch] => 0 [cartodb_id_mid_sch_process] => Yes [cartodb_id_sec_sch] => 78 [cartodb_id_sec_sch_process] => Yes [cartodb_id_crime] => 28 [cartodb_id_crime_process] => Yes [cartodb_id_demographic1] => 297 [cartodb_id_demographic1_process] => Yes [cartodb_id_demographic2] => 394 [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] => 107 [cartodb_id_subdivision_process] => Yes [DeletedDate] => 0000-00-00 00:00:00 [rets_system_key] => 262492066 [display_on_website] => Yes [display_on_website_datetime] => 1593475808 [created_datetime] => 2020-06-29 16:20:03 [updated_datetime] => 2020-06-30 14:20:06 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2020-06-30 15:10:48 [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] => R2470439-1 [Area] => Richmond [StreetName] => GOLLNER [StreetNumber] => 7338 [StreetType] => AVENUE [UnitNo] => 615 [StreetDirection] => [ZipCode] => V6Y 0H8 [CityName] => Richmond [County] => [State] => BC [Subdivision] => Brighouse [Latitude] => 49.168524300000000 [Longitude] => -123.141260300000000 [DayOnMarket] => 7 [Pic_Path] => https://static.estateblock.com/pictures/property/R2470439-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] => Kelvin Ho [LA2_Email] => kelvin403@hotmail.com [LA2_LoginName] => V66371 [LA2_PhoneNumber1] => 604-781-6870 [LFD_Amenities_56] => Air Cond./Central,Bike Room,Club House,Exercise Centre,In Suite Laundry,Swirlpool/Hot Tub [LFD_BasementArea_37] => None [LFD_BylawRestrictions_58] => Pets Allowed w/Rest.,Rentals Allwd w/Restrctns [LFD_Construction_41] => Concrete,Concrete Block,Concrete Frame [LFD_ExteriorFinish_42] => Aluminum,Concrete,Glass [LFD_FireplaceFueledby_49] => None [LFD_FuelHeating_48] => Heat Pump [LFD_MaintFeeIncludes_57] => Garbage Pickup,Gardening,Management,Snow removal [LFD_OutdoorArea_47] => Balcony(s) [LFD_Parking_44] => Garage; Underground [LFD_Roof_43] => Asphalt,Other,Tar & Gravel [LFD_ServicesConnected_38] => Electricity,Natural Gas [LFD_StyleofHome_32] => 1 Storey [LFD_Suite_36] => None [LFD_WaterSupply_39] => City/Municipal [LM_char100_1] => 029-608-406 [LM_char100_3] => CITY [LM_Char10_10] => Attached [LM_Char10_11] => Apartment/Condo [LM_Char10_12] => Freehold Strata [LM_Char10_13] => Yes [LM_Char10_15] => No [LM_Char10_16] => No [LM_Char10_17] => ZHR11 [LM_Char10_18] => Concrete Block [LM_Char10_23] => Yes [LM_Char10_25] => Living Room [LM_Char10_4] => Greater Vancouver [LM_Char10_5] => Brighouse [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_36] => Residential Attached [LM_Char1_9] => No [LM_char255_1] => 3.22% ON FIRST $100,000 AND 1.15% ON BAL. [LM_Char25_16] => Main [LM_Char25_17] => Main [LM_char5_10] => Main [LM_char5_11] => Kitchen [LM_char5_12] => 9'6 [LM_char5_13] => 9'0 [LM_char5_14] => Main [LM_char5_15] => Master Bedroom [LM_char5_16] => 10'6 [LM_char5_17] => 10'6 [LM_char5_18] => Main [LM_char5_19] => Bedroom [LM_char5_20] => 10'0 [LM_char5_21] => 6'0 [LM_char5_22] => Main [LM_char5_23] => Flex Room [LM_char5_24] => 7'0 [LM_char5_25] => 5'0 [LM_char5_6] => Feet [LM_char5_7] => Main [LM_char5_8] => 19'0 [LM_char5_9] => 13'0 [LM_Dec_1] => 964 [LM_Dec_11] => 0.00 [LM_Dec_12] => 0.00 [LM_Dec_13] => 0.00 [LM_Dec_14] => 0.00 [LM_Dec_16] => 2300.00 [LM_Dec_22] => 380.00 [LM_Dec_5] => 964 [LM_Dec_7] => 964 [LM_Dec_8] => 0.00 [LM_Int1_1] => 1 [LM_Int1_10] => 4 [LM_Int1_18] => 2 [LM_Int1_19] => 2 [LM_Int1_20] => 4 [LM_Int1_4] => 2 [LM_Int1_6] => 2 [LM_Int1_7] => 5 [LM_Int1_8] => 1 [LM_Int1_9] => 4 [LM_Int2_2] => 2015 [LM_Int2_3] => 5 [LM_Int2_5] => 2017 [LM_Int2_6] => 1 [LM_Int2_7] => 1 [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] => Carreara By Polygon ! LOCATION LOCATION LOCATION! Richmond Top school catachment Most convenient condo beside Richmond Centre. very well keep condition, This corner South East facing unit provide lot of sunlight all year along. Central A/C and Heating include in strata fee. 8'6 ceilings, quartz counter top, bosch appliances, 2 large balcony. Walking distances to shopping mall and public transportation. Easy to show [LV_vow_address] => Yes [LV_vow_include] => Yes [L_Address] => 615 7338 GOLLNER AVENUE [L_AddressNumber] => 7338 [L_AddressStreet] => GOLLNER [L_AddressUnit] => 615 [L_Area] => Richmond [L_AskingPrice] => 959000 [L_CDOM] => 1 [L_City] => Richmond [L_DisplayId] => R2470439 [L_DOM] => 1 [L_ExpirationDate] => 2020-12-01 [L_IdxInclude] => Yes [L_InputDate] => 2020-06-29T22:55:07 [L_Last_Photo_updt] => 2020-06-29T23:52:46 [L_ListAgent1] => 44706 [L_ListAgent2] => 49414 [L_ListingDate] => 2020-06-29 [L_ListingID] => 262492066 [L_ListOffice1] => 4059 [L_ListOffice2] => 4059 [L_OriginalPrice] => 959000 [L_PictureCount] => 24 [L_PricePerSQFT] => 994.81 [L_Remarks] => STRATA LOT 47, BLOCK 4N, PLAN EPS2876, SECTION 8, 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] => AVENUE [L_Type_] => Apartment/Condo [L_UpdateDate] => 2020-06-30T20:58:30 [L_Zip] => V6Y 0H8 [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] => )