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 = 'West Vancouver' AND M.MLS_NUM NOT IN ('R2470140') AND M.MLSP_ID IN (1) AND PropertyTypeNew = 'House' AND M.Beds >= '4' AND M.Beds <= '4' AND M.FloorArea >= 4000 AND M.FloorArea <= 5000 AND M.SQFT >= 5000 AND M.SQFT <= 10890 AND ( Subdivision = 'Dundarave' ) 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_14bf_2.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 = 'West Vancouver' AND M.MLS_NUM NOT IN ('R2470140') AND M.MLSP_ID IN (1) AND PropertyTypeNew = 'House' AND M.Beds >= '4' AND M.Beds <= '4' AND M.FloorArea >= 4000 AND M.FloorArea <= 5000 AND M.SQFT >= 5000 AND M.SQFT <= 10890 AND ( Subdivision = 'Dundarave' ) 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 = 'West Vancouver' AND M.MLS_NUM NOT IN ('R2470140') AND M.MLSP_ID IN (1) AND PropertyTypeNew = 'House' AND M.Beds >= '4' AND M.Beds <= '4' AND M.FloorArea >= 4000 AND M.FloorArea <= 5000 AND M.SQFT >= 5000 AND M.SQFT <= 10890 AND ( Subdivision = 'Dundarave' ) 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] => House [BedRange] => 4-4 [MinSQFT] => 5000 [MaxSQFT] => 10890 [MinFloorArea] => 4000 [MaxFloorArea] => 5000 [CityName] => West Vancouver [Subdivision] => Array ( [0] => Dundarave ) [State] => BC [MLSP_ID] => 1 [NOT_MLS_NUM] => Array ( [0] => R2470140 ) [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] => R2470140 [MLSP_ID] => 1 [listing_key] => R2470140-1 [resource] => Property [class] => RD_1 [mls_board_name] => Real Estate Board of Greater Vancouver [agent_code] => V29846 [agent_key] => V29846-1 [agent_name] => Vivian Lin [office_code] => V003424 [office_key] => V003424-1 [office_name] => Sotheby's International Realty Canada [ListingKey] => [PropertyType] => Residential Detached [PropertyTypeNew] => House [PropertyStyle] => 3 Storey [ListingStatus] => Active [SubType] => House/Single Family [OwnershipType] => Freehold NonStrata [OwnershipTypeNew] => Freehold [Zoning] => [BathsFull] => 4 [BathsHalf] => 2 [Baths] => 6 [Beds] => 4 [TotalAcreage] => 0.18 [ListPrice] => 3880000 [ListMarketPercentage] => 0 [ListMarketPercentageCity] => 0 [OriginalListPrice] => 0 [SQFT] => 7946 [FloorArea] => 4026 [YearBuilt] => 2015 [TotalPhotos] => 20 [Main_Photo] => 1 [Description] => Stunning & luxurious 4 bdrm/6 bath 3-lvl home in prime Dundarave location in West Vancouver! This home features exceptional panoramic views of Ocean,City,Lion's Gate Bridge,UBC;60x132 lot;Massive South facing sun drenched decks/ensuite patios on both main & upper levels;Gourmet kitchen & Wet bar w/high-end Miele appliances,Sub-zero fridge,open island;A/C throughout; Radiate floor heating;Kenwood walnut flooring;Custom-built dumbwaiter/freight elevator for groceries,laundry,trash at one touch of button.Close to excellent public & private schools,Rec Centre,premier dining & shopping. Easy access to HWY,DT Vancouver,Skiing,Parks,Seawall,Parks. 2-5-10 New Home Warranty (started in March 31, 2016). Priced to Sell; 2020 BC Assessment at $3,842,000!Come to See & Appreciate its offering! [Description2] => Stunning & luxurious 4 bdrm/6 bath 3-lvl home in prime Dundarave location in West Vancouver! This home features exceptional panoramic views of Ocean,City,Lion's Gate Bridge,UBC;60x132 lot;Massive South facing sun drenched decks/ensuite patios on both main & upper levels;Gourmet kitchen & Wet bar w/high-end Miele appliances,Sub-zero fridge,open island;A/C throughout; Radiate floor heating;Kenwood walnut flooring;Custom-built dumbwaiter/freight elevator for groceries,laundry,trash at one touch of button.Close to excellent public & private schools,Rec Centre,premier dining & shopping. Easy access to HWY,DT Vancouver,Skiing,Parks,Seawall,Parks. 2-5-10 New Home Warranty (started in March 31, 2016). Priced to Sell; 2020 BC Assessment at $3,842,000! Come to See & Appreciate its offering! [Stories] => 3 [Parking] => [Levels] => [Elementary_School] => [High_School] => [Middle_School] => [School_District] => [MaintenanceFee] => 0.00 [Tax] => 15808.34 [TaxYear] => 2019 [Region] => [ListingDate] => 2020-06-28 [LastUpdateDate] => 2020-06-29T21:55:45 [LastPhotoDate] => [Pic_Download_Flag] => N [Pic_Updated_Date] => [Pic_Download_Try_Date] => [DisplayAddress] => Yes [PublishOnInternet] => Yes [business_type_major] => [business_type_minor] => [dom] => 5 [tag] => [is_openhouse] => No [vw_is_show_only_processed] => Yes [is_mark_for_deletion] => N [Listing_Created_Date] => 2020-06-29 11:00:07 [is_price_reduced] => N [price_reduced_date] => [cartodb_id_ele_sch] => 189 [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] => 20 [cartodb_id_crime_process] => Yes [cartodb_id_demographic1] => 272 [cartodb_id_demographic1_process] => Yes [cartodb_id_demographic2] => 592 [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] => 11 [cartodb_id_city_process] => Yes [cartodb_id_area] => 11 [cartodb_id_area_process] => Yes [cartodb_id_subdivision] => 1007 [cartodb_id_subdivision_process] => Yes [DeletedDate] => 0000-00-00 00:00:00 [rets_system_key] => 262491767 [display_on_website] => Yes [display_on_website_datetime] => 1593456066 [created_datetime] => 2020-06-29 11:00:07 [updated_datetime] => 2020-06-29 15:00:10 [vw_is_photo_downloaded] => Yes [vw_photo_download_try_datetime] => 2020-06-29 15:16:28 [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] => R2470140-1 [Area] => West Vancouver [StreetName] => 22ND [StreetNumber] => 1715 [StreetType] => STREET [UnitNo] => [StreetDirection] => [ZipCode] => V7V 4E4 [CityName] => West Vancouver [County] => [State] => BC [Subdivision] => Dundarave [Latitude] => 49.340313000000000 [Longitude] => -123.171055000000000 [DayOnMarket] => 7 [Pic_Path] => https://static.estateblock.com/pictures/property/R2470140-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] => Vivian Lin [LA1_Email] => vlin@sothebysrealty.ca [LA1_LoginName] => V29846 [LA1_PhoneNumber1] => 604-808-0136 [LA1_WebPage] => http://www.vivianlinrealty.com [LA2_Char100_1] => Zhi Yu Xiao [LA2_Email] => a.xiaoprorealtor@outlook.com [LA2_LoginName] => V79957 [LA2_PhoneNumber1] => 778-814-6606 [LFD_Amenities_25] => Air Cond./Central,Elevator,In Suite Laundry [LFD_BasementArea_6] => Full [LFD_Construction_10] => Frame - Wood [LFD_DirectionalExpRearYard_9] => West [LFD_ExteriorFinish_11] => Stucco [LFD_FeaturesIncluded_24] => Air Conditioning,ClthWsh/Dryr/Frdg/Stve/DW,Disposal - Waste,Drapes/Window Coverings,Garage Door Opener [LFD_FireplaceFueledby_18] => Natural Gas [LFD_FloorFinish_19] => Hardwood,Tile [LFD_FuelHeating_17] => Natural Gas,Radiant [LFD_OutdoorArea_16] => Balcny(s) Patio(s) Dck(s) [LFD_ParkingAccess_14] => Front [LFD_Parking_13] => Add. Parking Avail.,Garage; Double [LFD_Roof_12] => Torch-On [LFD_ServicesConnected_7] => Community,Natural Gas [LFD_SiteInfluences_15] => Central Location,Private Yard,Recreation Nearby [LFD_StyleofHome_1] => 3 Storey [LFD_WaterSupply_8] => City/Municipal [LM_char100_1] => 014-102-650 [LM_char100_3] => Lion's Gate, Ocean, City & UBC [LM_Char10_10] => Detached [LM_Char10_11] => House/Single Family [LM_Char10_12] => Freehold NonStrata [LM_Char10_13] => Yes [LM_Char10_15] => No [LM_Char10_17] => RSS [LM_Char10_18] => Concrete Perimeter [LM_Char10_23] => Yes [LM_Char10_25] => Living Room [LM_Char10_26] => 5'6 [LM_Char10_27] => Below [LM_Char10_28] => Laundry [LM_Char10_29] => 9' [LM_Char10_30] => 5'8 [LM_char10_31] => Below [LM_char10_32] => Storage [LM_char10_33] => 12'8 [LM_char10_34] => 6' [LM_char10_35] => Below [LM_char10_36] => Bedroom [LM_char10_37] => 14'5 [LM_char10_38] => 10'1 [LM_char10_39] => Below [LM_Char10_4] => Greater Vancouver [LM_char10_40] => Walk-In Closet [LM_char10_41] => 6' [LM_char10_42] => 4'2 [LM_Char10_5] => Dundarave [LM_Char10_6] => Real Estate Board of Greater Vancouver [LM_char10_75] => Other [LM_Char1_1] => No [LM_Char1_10] => No [LM_Char1_2] => Yes [LM_Char1_3] => Yes [LM_char1_36] => Residential Detached [LM_Char1_4] => Yes [LM_Char1_5] => Yes [LM_Char1_6] => No [LM_Char1_9] => No [LM_char255_1] => 3.22% ON THE FIRST $100,000 AND 1.15% ON THE BALANCE [LM_Char25_16] => Above [LM_Char25_17] => Main [LM_Char25_18] => Main [LM_Char25_19] => Main [LM_Char25_20] => Below [LM_Char25_21] => Below [LM_char30_28] => 132.0 [LM_char5_10] => Above [LM_char5_11] => Dining Room [LM_char5_12] => 16'6 [LM_char5_13] => 10' [LM_char5_14] => Above [LM_char5_15] => Kitchen [LM_char5_16] => 21'6 [LM_char5_17] => 10' [LM_char5_18] => Above [LM_char5_19] => Pantry [LM_char5_20] => 10'5 [LM_char5_21] => 4' [LM_char5_22] => Main [LM_char5_23] => Master Bedroom [LM_char5_24] => 17'2 [LM_char5_25] => 13'6 [LM_char5_26] => Main [LM_char5_27] => Walk-In Closet [LM_char5_28] => 13' [LM_char5_29] => 9' [LM_char5_30] => Main [LM_char5_31] => Bedroom [LM_char5_32] => 12' [LM_char5_33] => 10'8 [LM_char5_34] => Main [LM_char5_35] => Bedroom [LM_char5_36] => 14'9 [LM_char5_37] => 10'7 [LM_char5_38] => Main [LM_char5_39] => Walk-In Closet [LM_char5_40] => 6'6 [LM_char5_41] => 4'8 [LM_char5_42] => Main [LM_char5_43] => Foyer [LM_char5_44] => 13'8 [LM_char5_45] => 15' [LM_char5_46] => Below [LM_char5_47] => Living Room [LM_char5_48] => 14' [LM_char5_49] => 11'7 [LM_char5_50] => Below [LM_char5_51] => Dining Room [LM_char5_52] => 13'2 [LM_char5_53] => 13'1 [LM_char5_54] => Below [LM_char5_55] => Kitchen [LM_char5_56] => 13'2 [LM_char5_57] => 7'3 [LM_char5_58] => Below [LM_char5_59] => Mud Room [LM_char5_6] => Feet [LM_char5_60] => 7'9 [LM_char5_7] => Above [LM_char5_8] => 17'4 [LM_char5_9] => 16'6 [LM_Dec_1] => 1485 [LM_Dec_11] => 7946.00 [LM_Dec_12] => 0.18 [LM_Dec_13] => 738.21 [LM_Dec_14] => 0.07 [LM_Dec_16] => 15808.34 [LM_Dec_2] => 1122 [LM_Dec_3] => 1419 [LM_Dec_5] => 4026 [LM_Dec_7] => 4026 [LM_Dec_8] => 60.00 [LM_Dec_9] => 18.29 [LM_Int1_1] => 3 [LM_Int1_10] => 6 [LM_Int1_11] => 5 [LM_Int1_12] => 5 [LM_Int1_13] => 5 [LM_Int1_14] => 2 [LM_Int1_17] => 2 [LM_Int1_18] => 4 [LM_Int1_19] => 6 [LM_Int1_2] => 1 [LM_Int1_20] => 21 [LM_Int1_4] => 4 [LM_Int1_6] => 4 [LM_Int1_7] => 18 [LM_Int1_8] => 2 [LM_Int1_9] => 2 [LM_Int2_2] => 2015 [LM_Int2_3] => 5 [LM_Int2_5] => 2019 [LM_Int2_6] => 2 [LM_Int2_7] => 4 [LO1_OrganizationName] => Sotheby's International Realty Canada [LO1_PhoneNumber1] => 604-922-6995 [LO1_ShortName] => V003424 [LO1_WebPage] => http://www.sothebysrealty.ca [LO2_OrganizationName] => Royal Pacific Realty Corp. [LO2_PhoneNumber1] => 604-266-8989 [LO2_ShortName] => V002221 [LO2_WebPage] => http://www.royalpacific.com [LR_remarks22] => Stunning & luxurious 4 bdrm/6 bath 3-lvl home in prime Dundarave location in West Vancouver! This home features exceptional panoramic views of Ocean,City,Lion's Gate Bridge,UBC;60x132 lot;Massive South facing sun drenched decks/ensuite patios on both main & upper levels;Gourmet kitchen & Wet bar w/high-end Miele appliances,Sub-zero fridge,open island;A/C throughout; Radiate floor heating;Kenwood walnut flooring;Custom-built dumbwaiter/freight elevator for groceries,laundry,trash at one touch of button.Close to excellent public & private schools,Rec Centre,premier dining & shopping. Easy access to HWY,DT Vancouver,Skiing,Parks,Seawall,Parks. 2-5-10 New Home Warranty (started in March 31, 2016). Priced to Sell; 2020 BC Assessment at $3,842,000!Come to See & Appreciate its offering! [LR_remarks33] => Stunning & luxurious 4 bdrm/6 bath 3-lvl home in prime Dundarave location in West Vancouver! This home features exceptional panoramic views of Ocean,City,Lion's Gate Bridge,UBC;60x132 lot;Massive South facing sun drenched decks/ensuite patios on both main & upper levels;Gourmet kitchen & Wet bar w/high-end Miele appliances,Sub-zero fridge,open island;A/C throughout; Radiate floor heating;Kenwood walnut flooring;Custom-built dumbwaiter/freight elevator for groceries,laundry,trash at one touch of button.Close to excellent public & private schools,Rec Centre,premier dining & shopping. Easy access to HWY,DT Vancouver,Skiing,Parks,Seawall,Parks. 2-5-10 New Home Warranty (started in March 31, 2016). Priced to Sell; 2020 BC Assessment at $3,842,000! Come to See & Appreciate its offering! [LV_vow_address] => Yes [LV_vow_include] => Yes [L_Address] => 1715 22ND STREET [L_AddressNumber] => 1715 [L_AddressStreet] => 22ND [L_Area] => West Vancouver [L_AskingPrice] => 3880000 [L_CDOM] => 1 [L_City] => West Vancouver [L_DisplayId] => R2470140 [L_DOM] => 1 [L_ExpirationDate] => 2021-02-28 [L_IdxInclude] => Yes [L_InputDate] => 2020-06-29T17:47:52 [L_Last_Photo_updt] => 2020-06-29T17:47:54 [L_ListAgent1] => 32710 [L_ListAgent2] => 56598 [L_ListingDate] => 2020-06-28 [L_ListingID] => 262491767 [L_ListOffice1] => 2659 [L_ListOffice2] => 3336 [L_OriginalPrice] => 3880000 [L_PictureCount] => 20 [L_PricePerSQFT] => 963.74 [L_Remarks] => LOT 9, BLOCK 3, PLAN VAP2020, DISTRICT LOT 783 E 1/2, GROUP 1, NEW WESTMINSTER LAND DISTRICT, AMD [L_State] => BC [L_Status] => Active [L_StreetDesignationId] => STREET [L_Type_] => House/Single Family [L_UpdateDate] => 2020-06-29T21:55:45 [L_Zip] => V7V 4E4 [VT_VTourURL] => https://vimeo.com/365792928 [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] => )