struct
Cause
struct
ErrorCode 0
Message Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation NearbyNoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00û 003-669-12219744NoNoûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081YesûûûûûApartment/Condo15970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, renovated large 970 sqft condo, comes with a PRIVATE YARD downtown, large patio attached a private fenced yard approx. 77 x 22 ft. A must for dog owners . This unit has two large bedrooms, 1 1/2 baths, open concept, completely renovated. This CORNER ground unit does not share any walls with any other units, complete privacy, updates include custom wood kitchen cabinets, S/S appliances, Corian and quartz countertop, custom sink, hardwood floors , bathrooms, jetted chromatherapy deep tub; Wood burning F/p, newly updated shared laundry. Steps to Sea Wall & English Bay beach. Newer roof, repiped 2002 and roof 2008. Pets allowed, Parking. 18 age restriction.ûûûûColdwell Banker Westburn Rlty. 604-437-1123V001473ûColdwell Banker - Perra Realty 604-970-9920V002960Wolfgang Isachsen 604-437-1123V13039wolfisachsen@hotmail.comwww.realtorwolf.com/ Kevin Perra 604-970-9920V18422email@kevinperra.comhttp://www.kevinperra.comûûûû-Garbage Pickup,Gardening,Hot Water,Management470.920.Pets Allowed w/Rest.,Rentals Allwd w/RestrctnsûûSouth2018-11-27 22:08:302018-09-10 18:55:032018-09-10 11:09:092018-12-02 20:44:322018-09-10 11:09:09Freehold Strataûûûûûû2211û4NoMain2YesMainûûûûûûûûûûûûûûûûûû1None21612'86'MainKitchen13'610'7MainMaster Bedroom13'911'10Main Living Room12'86'6Main Dining Room12'812'1MainBedroom18'14'MainPatioûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûretsrets' can not be represented as java.sql.Timestamp
SQLState S1009
StackTrace java.sql.SQLException: Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation NearbyNoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00û 003-669-12219744NoNoûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081YesûûûûûApartment/Condo15970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, renovated large 970 sqft condo, comes with a PRIVATE YARD downtown, large patio attached a private fenced yard approx. 77 x 22 ft. A must for dog owners . This unit has two large bedrooms, 1 1/2 baths, open concept, completely renovated. This CORNER ground unit does not share any walls with any other units, complete privacy, updates include custom wood kitchen cabinets, S/S appliances, Corian and quartz countertop, custom sink, hardwood floors , bathrooms, jetted chromatherapy deep tub; Wood burning F/p, newly updated shared laundry. Steps to Sea Wall & English Bay beach. Newer roof, repiped 2002 and roof 2008. Pets allowed, Parking. 18 age restriction.ûûûûColdwell Banker Westburn Rlty. 604-437-1123V001473ûColdwell Banker - Perra Realty 604-970-9920V002960Wolfgang Isachsen 604-437-1123V13039wolfisachsen@hotmail.comwww.realtorwolf.com/ Kevin Perra 604-970-9920V18422email@kevinperra.comhttp://www.kevinperra.comûûûû-Garbage Pickup,Gardening,Hot Water,Management470.920.Pets Allowed w/Rest.,Rentals Allwd w/RestrctnsûûSouth2018-11-27 22:08:302018-09-10 18:55:032018-09-10 11:09:092018-12-02 20:44:322018-09-10 11:09:09Freehold Strataûûûûûû2211û4NoMain2YesMainûûûûûûûûûûûûûûûûûû1None21612'86'MainKitchen13'610'7MainMaster Bedroom13'911'10Main Living Room12'86'6Main Dining Room12'812'1MainBedroom18'14'MainPatioûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûretsrets' can not be represented as java.sql.Timestamp at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870) at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:928) at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:555) at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:5943) at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5609) at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4582) at coldfusion.sql.QueryTable.populate(QueryTable.java:380) at coldfusion.sql.QueryTable.populate(QueryTable.java:245) at coldfusion.sql.Executive.getRowSet(Executive.java:641) at coldfusion.sql.Executive.executeQuery(Executive.java:1439) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor5(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:435) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor6(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:299) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor7(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:208) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor9(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:203) at cfV2HomeSearchMLXLiveSearch2ecfm332591143.runPage(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2ListingDetail2ecfm1514563670.runPage(C:\data\CustomTags\REVAV2\V2ListingDetail.cfm:21) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cflistingdetail2ehtm2052688168.runPage(C:\data\www\REVA\kperra\listingdetail.htm:4) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2StaticPagePartLoader2ecfm1320803414.runPage(C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm:20) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2application2ecfm1515464149._factor10(C:\data\www\REVA\V2application.cfm:591) at cfV2application2ecfm1515464149._factor12(C:\data\www\REVA\V2application.cfm:577) at cfV2application2ecfm1515464149._factor27(C:\data\www\REVA\V2application.cfm:555) at cfV2application2ecfm1515464149.runPage(C:\data\www\REVA\V2application.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfApplication2ecfm571229905.runPage(C:\data\www\REVA\Application.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 435
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor5(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:435)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 299
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor6(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:299)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 208
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor7(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:208)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 203
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor9(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:203)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
5
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 1
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143.runPage(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:1)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
6
struct
COLUMN 0
ID CFMODULE
LINE 21
RAW_TRACE at cfV2ListingDetail2ecfm1514563670.runPage(C:\data\CustomTags\REVAV2\V2ListingDetail.cfm:21)
TEMPLATE C:\data\CustomTags\REVAV2\V2ListingDetail.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFMODULE
LINE 4
RAW_TRACE at cflistingdetail2ehtm2052688168.runPage(C:\data\www\REVA\kperra\listingdetail.htm:4)
TEMPLATE C:\data\www\REVA\kperra\listingdetail.htm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 20
RAW_TRACE at cfV2StaticPagePartLoader2ecfm1320803414.runPage(C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm:20)
TEMPLATE C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFMODULE
LINE 591
RAW_TRACE at cfV2application2ecfm1515464149._factor10(C:\data\www\REVA\V2application.cfm:591)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
10
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 577
RAW_TRACE at cfV2application2ecfm1515464149._factor12(C:\data\www\REVA\V2application.cfm:577)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
11
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 555
RAW_TRACE at cfV2application2ecfm1515464149._factor27(C:\data\www\REVA\V2application.cfm:555)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
12
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 1
RAW_TRACE at cfV2application2ecfm1515464149.runPage(C:\data\www\REVA\V2application.cfm:1)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
13
struct
COLUMN 0
ID CFMODULE
LINE 1
RAW_TRACE at cfApplication2ecfm571229905.runPage(C:\data\www\REVA\Application.cfm:1)
TEMPLATE C:\data\www\REVA\Application.cfm
TYPE CFML
Type java.sql.SQLException
DataSource sb_listingsdb_1
Detail Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation Nearby NoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00 û 003-669-12219744No Noûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081Yesûûûû ûApartment/Condo15 970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, ren...
ErrorCode S1009
Message Error Executing Database Query.
NativeErrorCode 0
RootCause
struct
ErrorCode 0
Message Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation NearbyNoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00û 003-669-12219744NoNoûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081YesûûûûûApartment/Condo15970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, renovated large 970 sqft condo, comes with a PRIVATE YARD downtown, large patio attached a private fenced yard approx. 77 x 22 ft. A must for dog owners . This unit has two large bedrooms, 1 1/2 baths, open concept, completely renovated. This CORNER ground unit does not share any walls with any other units, complete privacy, updates include custom wood kitchen cabinets, S/S appliances, Corian and quartz countertop, custom sink, hardwood floors , bathrooms, jetted chromatherapy deep tub; Wood burning F/p, newly updated shared laundry. Steps to Sea Wall & English Bay beach. Newer roof, repiped 2002 and roof 2008. Pets allowed, Parking. 18 age restriction.ûûûûColdwell Banker Westburn Rlty. 604-437-1123V001473ûColdwell Banker - Perra Realty 604-970-9920V002960Wolfgang Isachsen 604-437-1123V13039wolfisachsen@hotmail.comwww.realtorwolf.com/ Kevin Perra 604-970-9920V18422email@kevinperra.comhttp://www.kevinperra.comûûûû-Garbage Pickup,Gardening,Hot Water,Management470.920.Pets Allowed w/Rest.,Rentals Allwd w/RestrctnsûûSouth2018-11-27 22:08:302018-09-10 18:55:032018-09-10 11:09:092018-12-02 20:44:322018-09-10 11:09:09Freehold Strataûûûûûû2211û4NoMain2YesMainûûûûûûûûûûûûûûûûûû1None21612'86'MainKitchen13'610'7MainMaster Bedroom13'911'10Main Living Room12'86'6Main Dining Room12'812'1MainBedroom18'14'MainPatioûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûretsrets' can not be represented as java.sql.Timestamp
SQLState S1009
StackTrace java.sql.SQLException: Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation NearbyNoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00û 003-669-12219744NoNoûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081YesûûûûûApartment/Condo15970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, renovated large 970 sqft condo, comes with a PRIVATE YARD downtown, large patio attached a private fenced yard approx. 77 x 22 ft. A must for dog owners . This unit has two large bedrooms, 1 1/2 baths, open concept, completely renovated. This CORNER ground unit does not share any walls with any other units, complete privacy, updates include custom wood kitchen cabinets, S/S appliances, Corian and quartz countertop, custom sink, hardwood floors , bathrooms, jetted chromatherapy deep tub; Wood burning F/p, newly updated shared laundry. Steps to Sea Wall & English Bay beach. Newer roof, repiped 2002 and roof 2008. Pets allowed, Parking. 18 age restriction.ûûûûColdwell Banker Westburn Rlty. 604-437-1123V001473ûColdwell Banker - Perra Realty 604-970-9920V002960Wolfgang Isachsen 604-437-1123V13039wolfisachsen@hotmail.comwww.realtorwolf.com/ Kevin Perra 604-970-9920V18422email@kevinperra.comhttp://www.kevinperra.comûûûû-Garbage Pickup,Gardening,Hot Water,Management470.920.Pets Allowed w/Rest.,Rentals Allwd w/RestrctnsûûSouth2018-11-27 22:08:302018-09-10 18:55:032018-09-10 11:09:092018-12-02 20:44:322018-09-10 11:09:09Freehold Strataûûûûûû2211û4NoMain2YesMainûûûûûûûûûûûûûûûûûû1None21612'86'MainKitchen13'610'7MainMaster Bedroom13'911'10Main Living Room12'86'6Main Dining Room12'812'1MainBedroom18'14'MainPatioûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûretsrets' can not be represented as java.sql.Timestamp at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870) at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:928) at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:555) at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:5943) at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5609) at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4582) at coldfusion.sql.QueryTable.populate(QueryTable.java:380) at coldfusion.sql.QueryTable.populate(QueryTable.java:245) at coldfusion.sql.Executive.getRowSet(Executive.java:641) at coldfusion.sql.Executive.executeQuery(Executive.java:1439) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor5(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:435) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor6(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:299) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor7(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:208) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor9(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:203) at cfV2HomeSearchMLXLiveSearch2ecfm332591143.runPage(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2ListingDetail2ecfm1514563670.runPage(C:\data\CustomTags\REVAV2\V2ListingDetail.cfm:21) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cflistingdetail2ehtm2052688168.runPage(C:\data\www\REVA\kperra\listingdetail.htm:4) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2StaticPagePartLoader2ecfm1320803414.runPage(C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm:20) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2application2ecfm1515464149._factor10(C:\data\www\REVA\V2application.cfm:591) at cfV2application2ecfm1515464149._factor12(C:\data\www\REVA\V2application.cfm:577) at cfV2application2ecfm1515464149._factor27(C:\data\www\REVA\V2application.cfm:555) at cfV2application2ecfm1515464149.runPage(C:\data\www\REVA\V2application.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfApplication2ecfm571229905.runPage(C:\data\www\REVA\Application.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 435
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor5(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:435)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 299
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor6(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:299)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 208
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor7(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:208)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 203
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor9(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:203)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
5
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 1
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143.runPage(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:1)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
6
struct
COLUMN 0
ID CFMODULE
LINE 21
RAW_TRACE at cfV2ListingDetail2ecfm1514563670.runPage(C:\data\CustomTags\REVAV2\V2ListingDetail.cfm:21)
TEMPLATE C:\data\CustomTags\REVAV2\V2ListingDetail.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFMODULE
LINE 4
RAW_TRACE at cflistingdetail2ehtm2052688168.runPage(C:\data\www\REVA\kperra\listingdetail.htm:4)
TEMPLATE C:\data\www\REVA\kperra\listingdetail.htm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 20
RAW_TRACE at cfV2StaticPagePartLoader2ecfm1320803414.runPage(C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm:20)
TEMPLATE C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFMODULE
LINE 591
RAW_TRACE at cfV2application2ecfm1515464149._factor10(C:\data\www\REVA\V2application.cfm:591)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
10
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 577
RAW_TRACE at cfV2application2ecfm1515464149._factor12(C:\data\www\REVA\V2application.cfm:577)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
11
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 555
RAW_TRACE at cfV2application2ecfm1515464149._factor27(C:\data\www\REVA\V2application.cfm:555)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
12
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 1
RAW_TRACE at cfV2application2ecfm1515464149.runPage(C:\data\www\REVA\V2application.cfm:1)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
13
struct
COLUMN 0
ID CFMODULE
LINE 1
RAW_TRACE at cfApplication2ecfm571229905.runPage(C:\data\www\REVA\Application.cfm:1)
TEMPLATE C:\data\www\REVA\Application.cfm
TYPE CFML
Type java.sql.SQLException
SQLState S1009
Sql SELECT MLS,sysid,Status,Bedrooms,Age,Images,city, PriceList,PriceOriginal,PriceSale, Occupancy,reciprocity,AreaOutdoor, AreaLotSize,MeasureUnitsLand as MeasureUnits,LotDepth as AreaRemaining, LegalDescription1,LegalDescription2, CONCAT(Address,', ',AreaDesc) AS AddressFull, Address,AddrStName,AddrStNumber,AddrStType,AddrStUnitNumber as UnitNum,AddrDirection, AddrLowNum,PostalCode, AreaCode as Area,SubAreaDesc as subarea,SubAreaCode,AreaDesc, StyleofHome as Style, Construction,ExteriorFinish as Exterior,Foundation,Remodelled,YearRenov as YrRenov,Roof, FloorFinish as Flooring,WaterSupply as Water, FireplaceFueledby as FireplaceFuel,Fireplaces,FireRoughIn as FireRough,HeatFuel, TaxAmount,TaxYear,Zoning,Amenities,SiteInfluences, '' as FixturesRemovedDesc,FixturesRemoved,SmokeDetectors, ParkingAccess,ParkingCovered,ParkingFacilities,ParkingTotal, DateExpire,DateListed,DateSale,'' as DaysOnMarket,'' as DateBackOnMarket, '' as zPics,'' as zVT,'' as zCustomer,'' as zHost,'' as TypeID, ComplexSubdivision as complexnam,PropertyID as PID,YearBuilt as YRBLT,StoreysinBuilding as Storeys, fixturesremoved,'' as fixturesremoveddesc,view,ViewSpecify as viewspecif, RainScreen as rainscr,UnitsinDevelopment as unitsindev, TotalUnitsinStrataPlan as unitsinstr,locker, PropertyDisclosure as propdisclosure, FeaturesIncluded as featuresin,cats,dogs,petcount,rentalcountallowed, suite,MgmtCosName as mgtcosname,MgmtCosPhoneNum as mgtcosph,DisplayAddressonInternet,InternetRemarks, FullHeight as fullht,CrawlHeight as crawlht,PartHeight as partht, '' as DatePrevExpire, LotFrontage as FrontageSize, TypeofDwelling as Type,Images as Img,'' as GSTSold,'' as PricePrevious, FloorAreaFinGrandTotal as AreaFinished, FloorAreaUnfinished as AreaUnfinished, (FloorAreaFinGrandTotal+FloorAreaUnfinished) as AreaTotal2, FloorAreaGrandTotal as AreaTotal, FloorAreaFinBasement as AreaBasement, FloorAreaFinBelowMain as AreaDown, FloorAreaFinMainFloor as AreaMain, FloorAreaFinAboveMain as AreaUp, StyleofHome as Style, YearRenov as YrRenov, PublicRemarks1 as Remarks1, PublicRemarks2 as remarks2, '' as remarks3, DistanceToTransit as TransitDist,DistanceToSchool as SchoolDist,ListBroker1Fax as Broker1Fax,ListBroker1Name as Broker1Name,ListBroker1Phone as Broker1Phone, ListBroker1ID as Broker1Code,ListBroker2Fax as Broker2Fax,ListBroker2Name as Broker2Name,ListBroker2Phone as Broker2Phone,ListBroker2ID as Broker2Code, ListRealtor1Name as LS1Name,ListRealtor1Phone as LS1Phone,ListRealtor1ID as LS1Code,ListRealtor1Email as LS1Email, ListRealtor1URL as LS1URL,ListRealtor2Name as LS2Name, ListRealtor2Phone as LS2Phone,ListRealtor2ID as LS2Code,ListRealtor2Email as LS2Email,ListRealtor2URL as LS2URL,ListRealtor3Name as LS3Name,ListRealtor3Phone as LS3Phone,ListRealtor3ID as LS3Code, '' as PrkngStall,'' as PkgOwned, Den, MaintFeeIncludes as MaintChrgDesc,MaintChrgAmount,ByLawRestrictions as ByLawRestr,RestrictedAge as RestrAge, DirectionalExpFaces as DirExpFace,DirectionalExpRearYard as DirExpRear, '' as LastTransC,LastTransDate as LastTransD,LastImgTransDate as LastImgTra,X_InsertDate as createdon,X_UpdateDate as lastmodified, X_InsertDate as importdate,'' as importflag, TitleToLand,Possession,'' as RemarksPrivate,'' as RltrRemar1, '' as Appointments,'' as ApptCall,'' as AppointmentsPhone, '' as Buyer,'' as Commission, '' as SellingBroker1Name, SellingBroker1ID as SellingBroker1Code, SellingRealtor1ID as SellingLS1Code, '' as SellingLS1Name, '' as SellingBroker2Name, SellingBroker2ID as SellingBroker2Code, SellingRealtor2ID as SellingLS2Code, '' as SellingLS2Name, '' as SellingLS3Code, '' as SellingLS3Name, '' as OwnerPhone,'' as OwnerPhone2,'' as OwnerInterest,OwnerName, '' as MORTGAGE1INFOID, BathEnsuitePieces as BathEnsPcs,(BathroomsFull+BathroomsHalf) as BathroomsTotal,BathroomsFull,BathroomsHalf,PlumbingRoughin, Bath1NumPieces as Bath1,Bath1Ensuite as Bath1En,Bath1Level as Bath1Lev, Bath2NumPieces as Bath2,Bath2Ensuite as Bath2En,Bath2Level as Bath2Lev, Bath3NumPieces as Bath3,Bath3Ensuite as Bath3En,Bath3Level as Bath3Lev, Bath4NumPieces as Bath4,Bath4Ensuite as Bath4En,Bath4Level as Bath4Lev, Bath5NumPieces as Bath5,Bath5Ensuite as Bath5En,Bath5Level as Bath5Lev, Bath6NumPieces as Bath6,Bath6Ensuite as Bath6En,Bath6Level as Bath6Lev, Bath7NumPieces as Bath7,Bath7Ensuite as Bath7En,Bath7Level as Bath7Lev, Bath8NumPieces as Bath8,Bath8Ensuite as Bath8En,Bath8Level as Bath8Lev, kitchens, BasementDev,BedroomsUp, FloorLevels as Levels,RoomsTotal, Room1Dimension1 as Room1Dim1,Room1Dimension2 as Room1Dim2,Room1Level,Room1Type, Room2Dimension1 as Room2Dim1,Room2Dimension2 as Room2Dim2,Room2Level,Room2Type, Room3Dimension1 as Room3Dim1,Room3Dimension2 as Room3Dim2,Room3Level,Room3Type, Room4Dimension1 as Room4Dim1,Room4Dimension2 as Room4Dim2,Room4Level,Room4Type, Room5Dimension1 as Room5Dim1,Room5Dimension2 as Room5Dim2,Room5Level,Room5Type, Room6Dimension1 as Room6Dim1,Room6Dimension2 as Room6Dim2,Room6Level,Room6Type, Room7Dimension1 as Room7Dim1,Room7Dimension2 as Room7Dim2,Room7Level,Room7Type, Room8Dimension1 as Room8Dim1,Room8Dimension2 as Room8Dim2,Room8Level,Room8Type, Room9Dimension1 as Room9Dim1,Room9Dimension2 as Room9Dim2,Room9Level,Room9Type, Room10Dimension1 as Room10Dim1,Room10Dimension2 as Room10Dim2,Room10Level,Room10Type, Room11Dimension1 as Room11Dim1,Room11Dimension2 as Room11Dim2,Room11Level,Room11Type, Room12Dimension1 as Room12Dim1,Room12Dimension2 as Room12Dim2,Room12Level,Room12Type, Room13Dimension1 as Room13Dim1,Room13Dimension2 as Room13Dim2,Room13Level,Room13Type, Room14Dimension1 as Room14Dim1,Room14Dimension2 as Room14Dim2,Room14Level,Room14Type, Room15Dimension1 as Room15Dim1,Room15Dimension2 as Room15Dim2,Room15Level,Room15Type, Room16Dimension1 as Room16Dim1,Room16Dimension2 as Room16Dim2,Room16Level,Room16Type, Room17Dimension1 as Room17Dim1,Room17Dimension2 as Room17Dim2,Room17Level,Room17Type, Room18Dimension1 as Room18Dim1,Room18Dimension2 as Room18Dim2,Room18Level,Room18Type, Room19Dimension1 as Room19Dim1,Room19Dimension2 as Room19Dim2,Room19Level,Room19Type, Room20Dimension1 as Room20Dim1,Room20Dimension2 as Room20Dim2,Room20Level,Room20Type, Room21Dimension1 as Room21Dim1,Room21Dimension2 as Room21Dim2,Room21Level,Room21Type, Room22Dimension1 as Room22Dim1,Room22Dimension2 as Room22Dim2,Room22Level,Room22Type, Room23Dimension1 as Room23Dim1,Room23Dimension2 as Room23Dim2,Room23Level,Room23Type, Room24Dimension1 as Room24Dim1,Room24Dimension2 as Room24Dim2,Room24Level,Room24Type, Room25Dimension1 as Room25Dim1,Room25Dimension2 as Room25Dim2,Room25Level,Room25Type, Room26Dimension1 as Room26Dim1,Room26Dimension2 as Room26Dim2,Room26Level,Room26Type, Room27Dimension1 as Room27Dim1,Room27Dimension2 as Room27Dim2,Room27Level,Room27Type, Room28Dimension1 as Room28Dim1,Room28Dimension2 as Room28Dim2,Room28Level,Room28Type, 'rets' AS TableType,'rets' AS NewTableType FROM rets_2 WHERE (Internetok='Y' or Internetok='YES') and (reciprocity='Y' or reciprocity='Yes') AND MLS = (param 1) ORDER BY Status,DateSale DESC,PriceList limit 300
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:641) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor5(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:435) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor6(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:299) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor7(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:208) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor9(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:203) at cfV2HomeSearchMLXLiveSearch2ecfm332591143.runPage(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2ListingDetail2ecfm1514563670.runPage(C:\data\CustomTags\REVAV2\V2ListingDetail.cfm:21) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cflistingdetail2ehtm2052688168.runPage(C:\data\www\REVA\kperra\listingdetail.htm:4) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2StaticPagePartLoader2ecfm1320803414.runPage(C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm:20) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2application2ecfm1515464149._factor10(C:\data\www\REVA\V2application.cfm:591) at cfV2application2ecfm1515464149._factor12(C:\data\www\REVA\V2application.cfm:577) at cfV2application2ecfm1515464149._factor27(C:\data\www\REVA\V2application.cfm:555) at cfV2application2ecfm1515464149.runPage(C:\data\www\REVA\V2application.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfApplication2ecfm571229905.runPage(C:\data\www\REVA\Application.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: java.sql.SQLException: Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation NearbyNoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00û 003-669-12219744NoNoûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081YesûûûûûApartment/Condo15970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, renovated large 970 sqft condo, comes with a PRIVATE YARD downtown, large patio attached a private fenced yard approx. 77 x 22 ft. A must for dog owners . This unit has two large bedrooms, 1 1/2 baths, open concept, completely renovated. This CORNER ground unit does not share any walls with any other units, complete privacy, updates include custom wood kitchen cabinets, S/S appliances, Corian and quartz countertop, custom sink, hardwood floors , bathrooms, jetted chromatherapy deep tub; Wood burning F/p, newly updated shared laundry. Steps to Sea Wall & English Bay beach. Newer roof, repiped 2002 and roof 2008. Pets allowed, Parking. 18 age restriction.ûûûûColdwell Banker Westburn Rlty. 604-437-1123V001473ûColdwell Banker - Perra Realty 604-970-9920V002960Wolfgang Isachsen 604-437-1123V13039wolfisachsen@hotmail.comwww.realtorwolf.com/ Kevin Perra 604-970-9920V18422email@kevinperra.comhttp://www.kevinperra.comûûûû-Garbage Pickup,Gardening,Hot Water,Management470.920.Pets Allowed w/Rest.,Rentals Allwd w/RestrctnsûûSouth2018-11-27 22:08:302018-09-10 18:55:032018-09-10 11:09:092018-12-02 20:44:322018-09-10 11:09:09Freehold Strataûûûûûû2211û4NoMain2YesMainûûûûûûûûûûûûûûûûûû1None21612'86'MainKitchen13'610'7MainMaster Bedroom13'911'10Main Living Room12'86'6Main Dining Room12'812'1MainBedroom18'14'MainPatioûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûretsrets' can not be represented as java.sql.Timestamp at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870) at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:928) at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:555) at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:5943) at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5609) at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4582) at coldfusion.sql.QueryTable.populate(QueryTable.java:380) at coldfusion.sql.QueryTable.populate(QueryTable.java:245) at coldfusion.sql.Executive.getRowSet(Executive.java:641) at coldfusion.sql.Executive.executeQuery(Executive.java:1439) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) ... 62 more
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 435
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor5(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:435)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 299
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor6(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:299)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 208
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor7(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:208)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 203
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor9(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:203)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
5
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 1
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143.runPage(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:1)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
6
struct
COLUMN 0
ID CFMODULE
LINE 21
RAW_TRACE at cfV2ListingDetail2ecfm1514563670.runPage(C:\data\CustomTags\REVAV2\V2ListingDetail.cfm:21)
TEMPLATE C:\data\CustomTags\REVAV2\V2ListingDetail.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFMODULE
LINE 4
RAW_TRACE at cflistingdetail2ehtm2052688168.runPage(C:\data\www\REVA\kperra\listingdetail.htm:4)
TEMPLATE C:\data\www\REVA\kperra\listingdetail.htm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 20
RAW_TRACE at cfV2StaticPagePartLoader2ecfm1320803414.runPage(C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm:20)
TEMPLATE C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFMODULE
LINE 591
RAW_TRACE at cfV2application2ecfm1515464149._factor10(C:\data\www\REVA\V2application.cfm:591)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
10
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 577
RAW_TRACE at cfV2application2ecfm1515464149._factor12(C:\data\www\REVA\V2application.cfm:577)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
11
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 555
RAW_TRACE at cfV2application2ecfm1515464149._factor27(C:\data\www\REVA\V2application.cfm:555)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
12
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 1
RAW_TRACE at cfV2application2ecfm1515464149.runPage(C:\data\www\REVA\V2application.cfm:1)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
13
struct
COLUMN 0
ID CFMODULE
LINE 1
RAW_TRACE at cfApplication2ecfm571229905.runPage(C:\data\www\REVA\Application.cfm:1)
TEMPLATE C:\data\www\REVA\Application.cfm
TYPE CFML
Type Database
queryError Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation NearbyNoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00û 003-669-12219744NoNoûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081YesûûûûûApartment/Condo15970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, renovated large 970 sqft condo, comes with a PRIVATE YARD downtown, large patio attached a private fenced yard approx. 77 x 22 ft. A must for dog owners . This unit has two large bedrooms, 1 1/2 baths, open concept, completely renovated. This CORNER ground unit does not share any walls with any other units, complete privacy, updates include custom wood kitchen cabinets, S/S appliances, Corian and quartz countertop, custom sink, hardwood floors , bathrooms, jetted chromatherapy deep tub; Wood burning F/p, newly updated shared laundry. Steps to Sea Wall & English Bay beach. Newer roof, repiped 2002 and roof 2008. Pets allowed, Parking. 18 age restriction.ûûûûColdwell Banker Westburn Rlty. 604-437-1123V001473ûColdwell Banker - Perra Realty 604-970-9920V002960Wolfgang Isachsen 604-437-1123V13039wolfisachsen@hotmail.comwww.realtorwolf.com/ Kevin Perra 604-970-9920V18422email@kevinperra.comhttp://www.kevinperra.comûûûû-Garbage Pickup,Gardening,Hot Water,Management470.920.Pets Allowed w/Rest.,Rentals Allwd w/RestrctnsûûSouth2018-11-27 22:08:302018-09-10 18:55:032018-09-10 11:09:092018-12-02 20:44:322018-09-10 11:09:09Freehold Strataûûûûûû2211û4NoMain2YesMainûûûûûûûûûûûûûûûûûû1None21612'86'MainKitchen13'610'7MainMaster Bedroom13'911'10Main Living Room12'86'6Main Dining Room12'812'1MainBedroom18'14'MainPatioûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûretsrets' can not be represented as java.sql.Timestamp
where (param 1) = [type='IN', class='java.lang.String', value='R2304516', sqltype='cf_sql_varchar']
struct
Cause
struct
ErrorCode 0
Message Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation NearbyNoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00û 003-669-12219744NoNoûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081YesûûûûûApartment/Condo15970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, renovated large 970 sqft condo, comes with a PRIVATE YARD downtown, large patio attached a private fenced yard approx. 77 x 22 ft. A must for dog owners . This unit has two large bedrooms, 1 1/2 baths, open concept, completely renovated. This CORNER ground unit does not share any walls with any other units, complete privacy, updates include custom wood kitchen cabinets, S/S appliances, Corian and quartz countertop, custom sink, hardwood floors , bathrooms, jetted chromatherapy deep tub; Wood burning F/p, newly updated shared laundry. Steps to Sea Wall & English Bay beach. Newer roof, repiped 2002 and roof 2008. Pets allowed, Parking. 18 age restriction.ûûûûColdwell Banker Westburn Rlty. 604-437-1123V001473ûColdwell Banker - Perra Realty 604-970-9920V002960Wolfgang Isachsen 604-437-1123V13039wolfisachsen@hotmail.comwww.realtorwolf.com/ Kevin Perra 604-970-9920V18422email@kevinperra.comhttp://www.kevinperra.comûûûû-Garbage Pickup,Gardening,Hot Water,Management470.920.Pets Allowed w/Rest.,Rentals Allwd w/RestrctnsûûSouth2018-11-27 22:08:302018-09-10 18:55:032018-09-10 11:09:092018-12-02 20:44:322018-09-10 11:09:09Freehold Strataûûûûûû2211û4NoMain2YesMainûûûûûûûûûûûûûûûûûû1None21612'86'MainKitchen13'610'7MainMaster Bedroom13'911'10Main Living Room12'86'6Main Dining Room12'812'1MainBedroom18'14'MainPatioûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûretsrets' can not be represented as java.sql.Timestamp
SQLState S1009
StackTrace java.sql.SQLException: Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation NearbyNoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00û 003-669-12219744NoNoûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081YesûûûûûApartment/Condo15970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, renovated large 970 sqft condo, comes with a PRIVATE YARD downtown, large patio attached a private fenced yard approx. 77 x 22 ft. A must for dog owners . This unit has two large bedrooms, 1 1/2 baths, open concept, completely renovated. This CORNER ground unit does not share any walls with any other units, complete privacy, updates include custom wood kitchen cabinets, S/S appliances, Corian and quartz countertop, custom sink, hardwood floors , bathrooms, jetted chromatherapy deep tub; Wood burning F/p, newly updated shared laundry. Steps to Sea Wall & English Bay beach. Newer roof, repiped 2002 and roof 2008. Pets allowed, Parking. 18 age restriction.ûûûûColdwell Banker Westburn Rlty. 604-437-1123V001473ûColdwell Banker - Perra Realty 604-970-9920V002960Wolfgang Isachsen 604-437-1123V13039wolfisachsen@hotmail.comwww.realtorwolf.com/ Kevin Perra 604-970-9920V18422email@kevinperra.comhttp://www.kevinperra.comûûûû-Garbage Pickup,Gardening,Hot Water,Management470.920.Pets Allowed w/Rest.,Rentals Allwd w/RestrctnsûûSouth2018-11-27 22:08:302018-09-10 18:55:032018-09-10 11:09:092018-12-02 20:44:322018-09-10 11:09:09Freehold Strataûûûûûû2211û4NoMain2YesMainûûûûûûûûûûûûûûûûûû1None21612'86'MainKitchen13'610'7MainMaster Bedroom13'911'10Main Living Room12'86'6Main Dining Room12'812'1MainBedroom18'14'MainPatioûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûretsrets' can not be represented as java.sql.Timestamp at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870) at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:928) at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:555) at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:5943) at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5609) at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4582) at coldfusion.sql.QueryTable.populate(QueryTable.java:380) at coldfusion.sql.QueryTable.populate(QueryTable.java:245) at coldfusion.sql.Executive.getRowSet(Executive.java:641) at coldfusion.sql.Executive.executeQuery(Executive.java:1439) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor5(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:435) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor6(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:299) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor7(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:208) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor9(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:203) at cfV2HomeSearchMLXLiveSearch2ecfm332591143.runPage(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2ListingDetail2ecfm1514563670.runPage(C:\data\CustomTags\REVAV2\V2ListingDetail.cfm:21) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cflistingdetail2ehtm2052688168.runPage(C:\data\www\REVA\kperra\listingdetail.htm:4) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2StaticPagePartLoader2ecfm1320803414.runPage(C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm:20) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2application2ecfm1515464149._factor10(C:\data\www\REVA\V2application.cfm:591) at cfV2application2ecfm1515464149._factor12(C:\data\www\REVA\V2application.cfm:577) at cfV2application2ecfm1515464149._factor27(C:\data\www\REVA\V2application.cfm:555) at cfV2application2ecfm1515464149.runPage(C:\data\www\REVA\V2application.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfApplication2ecfm571229905.runPage(C:\data\www\REVA\Application.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 435
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor5(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:435)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 299
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor6(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:299)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 208
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor7(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:208)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 203
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor9(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:203)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
5
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 1
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143.runPage(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:1)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
6
struct
COLUMN 0
ID CFMODULE
LINE 21
RAW_TRACE at cfV2ListingDetail2ecfm1514563670.runPage(C:\data\CustomTags\REVAV2\V2ListingDetail.cfm:21)
TEMPLATE C:\data\CustomTags\REVAV2\V2ListingDetail.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFMODULE
LINE 4
RAW_TRACE at cflistingdetail2ehtm2052688168.runPage(C:\data\www\REVA\kperra\listingdetail.htm:4)
TEMPLATE C:\data\www\REVA\kperra\listingdetail.htm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 20
RAW_TRACE at cfV2StaticPagePartLoader2ecfm1320803414.runPage(C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm:20)
TEMPLATE C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFMODULE
LINE 591
RAW_TRACE at cfV2application2ecfm1515464149._factor10(C:\data\www\REVA\V2application.cfm:591)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
10
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 577
RAW_TRACE at cfV2application2ecfm1515464149._factor12(C:\data\www\REVA\V2application.cfm:577)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
11
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 555
RAW_TRACE at cfV2application2ecfm1515464149._factor27(C:\data\www\REVA\V2application.cfm:555)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
12
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 1
RAW_TRACE at cfV2application2ecfm1515464149.runPage(C:\data\www\REVA\V2application.cfm:1)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
13
struct
COLUMN 0
ID CFMODULE
LINE 1
RAW_TRACE at cfApplication2ecfm571229905.runPage(C:\data\www\REVA\Application.cfm:1)
TEMPLATE C:\data\www\REVA\Application.cfm
TYPE CFML
Type java.sql.SQLException
DataSource sb_listingsdb_1
Detail Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation Nearby NoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00 û 003-669-12219744No Noûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081Yesûûûû ûApartment/Condo15 970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, ren...
ErrorCode S1009
Message Error Executing Database Query.
NativeErrorCode 0
RootCause
struct
ErrorCode 0
Message Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation NearbyNoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00û 003-669-12219744NoNoûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081YesûûûûûApartment/Condo15970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, renovated large 970 sqft condo, comes with a PRIVATE YARD downtown, large patio attached a private fenced yard approx. 77 x 22 ft. A must for dog owners . This unit has two large bedrooms, 1 1/2 baths, open concept, completely renovated. This CORNER ground unit does not share any walls with any other units, complete privacy, updates include custom wood kitchen cabinets, S/S appliances, Corian and quartz countertop, custom sink, hardwood floors , bathrooms, jetted chromatherapy deep tub; Wood burning F/p, newly updated shared laundry. Steps to Sea Wall & English Bay beach. Newer roof, repiped 2002 and roof 2008. Pets allowed, Parking. 18 age restriction.ûûûûColdwell Banker Westburn Rlty. 604-437-1123V001473ûColdwell Banker - Perra Realty 604-970-9920V002960Wolfgang Isachsen 604-437-1123V13039wolfisachsen@hotmail.comwww.realtorwolf.com/ Kevin Perra 604-970-9920V18422email@kevinperra.comhttp://www.kevinperra.comûûûû-Garbage Pickup,Gardening,Hot Water,Management470.920.Pets Allowed w/Rest.,Rentals Allwd w/RestrctnsûûSouth2018-11-27 22:08:302018-09-10 18:55:032018-09-10 11:09:092018-12-02 20:44:322018-09-10 11:09:09Freehold Strataûûûûûû2211û4NoMain2YesMainûûûûûûûûûûûûûûûûûû1None21612'86'MainKitchen13'610'7MainMaster Bedroom13'911'10Main Living Room12'86'6Main Dining Room12'812'1MainBedroom18'14'MainPatioûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûretsrets' can not be represented as java.sql.Timestamp
SQLState S1009
StackTrace java.sql.SQLException: Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation NearbyNoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00û 003-669-12219744NoNoûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081YesûûûûûApartment/Condo15970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, renovated large 970 sqft condo, comes with a PRIVATE YARD downtown, large patio attached a private fenced yard approx. 77 x 22 ft. A must for dog owners . This unit has two large bedrooms, 1 1/2 baths, open concept, completely renovated. This CORNER ground unit does not share any walls with any other units, complete privacy, updates include custom wood kitchen cabinets, S/S appliances, Corian and quartz countertop, custom sink, hardwood floors , bathrooms, jetted chromatherapy deep tub; Wood burning F/p, newly updated shared laundry. Steps to Sea Wall & English Bay beach. Newer roof, repiped 2002 and roof 2008. Pets allowed, Parking. 18 age restriction.ûûûûColdwell Banker Westburn Rlty. 604-437-1123V001473ûColdwell Banker - Perra Realty 604-970-9920V002960Wolfgang Isachsen 604-437-1123V13039wolfisachsen@hotmail.comwww.realtorwolf.com/ Kevin Perra 604-970-9920V18422email@kevinperra.comhttp://www.kevinperra.comûûûû-Garbage Pickup,Gardening,Hot Water,Management470.920.Pets Allowed w/Rest.,Rentals Allwd w/RestrctnsûûSouth2018-11-27 22:08:302018-09-10 18:55:032018-09-10 11:09:092018-12-02 20:44:322018-09-10 11:09:09Freehold Strataûûûûûû2211û4NoMain2YesMainûûûûûûûûûûûûûûûûûû1None21612'86'MainKitchen13'610'7MainMaster Bedroom13'911'10Main Living Room12'86'6Main Dining Room12'812'1MainBedroom18'14'MainPatioûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûretsrets' can not be represented as java.sql.Timestamp at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870) at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:928) at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:555) at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:5943) at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5609) at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4582) at coldfusion.sql.QueryTable.populate(QueryTable.java:380) at coldfusion.sql.QueryTable.populate(QueryTable.java:245) at coldfusion.sql.Executive.getRowSet(Executive.java:641) at coldfusion.sql.Executive.executeQuery(Executive.java:1439) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor5(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:435) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor6(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:299) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor7(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:208) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor9(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:203) at cfV2HomeSearchMLXLiveSearch2ecfm332591143.runPage(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2ListingDetail2ecfm1514563670.runPage(C:\data\CustomTags\REVAV2\V2ListingDetail.cfm:21) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cflistingdetail2ehtm2052688168.runPage(C:\data\www\REVA\kperra\listingdetail.htm:4) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2StaticPagePartLoader2ecfm1320803414.runPage(C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm:20) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2application2ecfm1515464149._factor10(C:\data\www\REVA\V2application.cfm:591) at cfV2application2ecfm1515464149._factor12(C:\data\www\REVA\V2application.cfm:577) at cfV2application2ecfm1515464149._factor27(C:\data\www\REVA\V2application.cfm:555) at cfV2application2ecfm1515464149.runPage(C:\data\www\REVA\V2application.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfApplication2ecfm571229905.runPage(C:\data\www\REVA\Application.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 435
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor5(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:435)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 299
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor6(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:299)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 208
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor7(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:208)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 203
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor9(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:203)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
5
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 1
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143.runPage(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:1)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
6
struct
COLUMN 0
ID CFMODULE
LINE 21
RAW_TRACE at cfV2ListingDetail2ecfm1514563670.runPage(C:\data\CustomTags\REVAV2\V2ListingDetail.cfm:21)
TEMPLATE C:\data\CustomTags\REVAV2\V2ListingDetail.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFMODULE
LINE 4
RAW_TRACE at cflistingdetail2ehtm2052688168.runPage(C:\data\www\REVA\kperra\listingdetail.htm:4)
TEMPLATE C:\data\www\REVA\kperra\listingdetail.htm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 20
RAW_TRACE at cfV2StaticPagePartLoader2ecfm1320803414.runPage(C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm:20)
TEMPLATE C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFMODULE
LINE 591
RAW_TRACE at cfV2application2ecfm1515464149._factor10(C:\data\www\REVA\V2application.cfm:591)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
10
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 577
RAW_TRACE at cfV2application2ecfm1515464149._factor12(C:\data\www\REVA\V2application.cfm:577)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
11
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 555
RAW_TRACE at cfV2application2ecfm1515464149._factor27(C:\data\www\REVA\V2application.cfm:555)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
12
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 1
RAW_TRACE at cfV2application2ecfm1515464149.runPage(C:\data\www\REVA\V2application.cfm:1)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
13
struct
COLUMN 0
ID CFMODULE
LINE 1
RAW_TRACE at cfApplication2ecfm571229905.runPage(C:\data\www\REVA\Application.cfm:1)
TEMPLATE C:\data\www\REVA\Application.cfm
TYPE CFML
Type java.sql.SQLException
SQLState S1009
Sql SELECT MLS,sysid,Status,Bedrooms,Age,Images,city, PriceList,PriceOriginal,PriceSale, Occupancy,reciprocity,AreaOutdoor, AreaLotSize,MeasureUnitsLand as MeasureUnits,LotDepth as AreaRemaining, LegalDescription1,LegalDescription2, CONCAT(Address,', ',AreaDesc) AS AddressFull, Address,AddrStName,AddrStNumber,AddrStType,AddrStUnitNumber as UnitNum,AddrDirection, AddrLowNum,PostalCode, AreaCode as Area,SubAreaDesc as subarea,SubAreaCode,AreaDesc, StyleofHome as Style, Construction,ExteriorFinish as Exterior,Foundation,Remodelled,YearRenov as YrRenov,Roof, FloorFinish as Flooring,WaterSupply as Water, FireplaceFueledby as FireplaceFuel,Fireplaces,FireRoughIn as FireRough,HeatFuel, TaxAmount,TaxYear,Zoning,Amenities,SiteInfluences, '' as FixturesRemovedDesc,FixturesRemoved,SmokeDetectors, ParkingAccess,ParkingCovered,ParkingFacilities,ParkingTotal, DateExpire,DateListed,DateSale,'' as DaysOnMarket,'' as DateBackOnMarket, '' as zPics,'' as zVT,'' as zCustomer,'' as zHost,'' as TypeID, ComplexSubdivision as complexnam,PropertyID as PID,YearBuilt as YRBLT,StoreysinBuilding as Storeys, fixturesremoved,'' as fixturesremoveddesc,view,ViewSpecify as viewspecif, RainScreen as rainscr,UnitsinDevelopment as unitsindev, TotalUnitsinStrataPlan as unitsinstr,locker, PropertyDisclosure as propdisclosure, FeaturesIncluded as featuresin,cats,dogs,petcount,rentalcountallowed, suite,MgmtCosName as mgtcosname,MgmtCosPhoneNum as mgtcosph,DisplayAddressonInternet,InternetRemarks, FullHeight as fullht,CrawlHeight as crawlht,PartHeight as partht, '' as DatePrevExpire, LotFrontage as FrontageSize, TypeofDwelling as Type,Images as Img,'' as GSTSold,'' as PricePrevious, FloorAreaFinGrandTotal as AreaFinished, FloorAreaUnfinished as AreaUnfinished, (FloorAreaFinGrandTotal+FloorAreaUnfinished) as AreaTotal2, FloorAreaGrandTotal as AreaTotal, FloorAreaFinBasement as AreaBasement, FloorAreaFinBelowMain as AreaDown, FloorAreaFinMainFloor as AreaMain, FloorAreaFinAboveMain as AreaUp, StyleofHome as Style, YearRenov as YrRenov, PublicRemarks1 as Remarks1, PublicRemarks2 as remarks2, '' as remarks3, DistanceToTransit as TransitDist,DistanceToSchool as SchoolDist,ListBroker1Fax as Broker1Fax,ListBroker1Name as Broker1Name,ListBroker1Phone as Broker1Phone, ListBroker1ID as Broker1Code,ListBroker2Fax as Broker2Fax,ListBroker2Name as Broker2Name,ListBroker2Phone as Broker2Phone,ListBroker2ID as Broker2Code, ListRealtor1Name as LS1Name,ListRealtor1Phone as LS1Phone,ListRealtor1ID as LS1Code,ListRealtor1Email as LS1Email, ListRealtor1URL as LS1URL,ListRealtor2Name as LS2Name, ListRealtor2Phone as LS2Phone,ListRealtor2ID as LS2Code,ListRealtor2Email as LS2Email,ListRealtor2URL as LS2URL,ListRealtor3Name as LS3Name,ListRealtor3Phone as LS3Phone,ListRealtor3ID as LS3Code, '' as PrkngStall,'' as PkgOwned, Den, MaintFeeIncludes as MaintChrgDesc,MaintChrgAmount,ByLawRestrictions as ByLawRestr,RestrictedAge as RestrAge, DirectionalExpFaces as DirExpFace,DirectionalExpRearYard as DirExpRear, '' as LastTransC,LastTransDate as LastTransD,LastImgTransDate as LastImgTra,X_InsertDate as createdon,X_UpdateDate as lastmodified, X_InsertDate as importdate,'' as importflag, TitleToLand,Possession,'' as RemarksPrivate,'' as RltrRemar1, '' as Appointments,'' as ApptCall,'' as AppointmentsPhone, '' as Buyer,'' as Commission, '' as SellingBroker1Name, SellingBroker1ID as SellingBroker1Code, SellingRealtor1ID as SellingLS1Code, '' as SellingLS1Name, '' as SellingBroker2Name, SellingBroker2ID as SellingBroker2Code, SellingRealtor2ID as SellingLS2Code, '' as SellingLS2Name, '' as SellingLS3Code, '' as SellingLS3Name, '' as OwnerPhone,'' as OwnerPhone2,'' as OwnerInterest,OwnerName, '' as MORTGAGE1INFOID, BathEnsuitePieces as BathEnsPcs,(BathroomsFull+BathroomsHalf) as BathroomsTotal,BathroomsFull,BathroomsHalf,PlumbingRoughin, Bath1NumPieces as Bath1,Bath1Ensuite as Bath1En,Bath1Level as Bath1Lev, Bath2NumPieces as Bath2,Bath2Ensuite as Bath2En,Bath2Level as Bath2Lev, Bath3NumPieces as Bath3,Bath3Ensuite as Bath3En,Bath3Level as Bath3Lev, Bath4NumPieces as Bath4,Bath4Ensuite as Bath4En,Bath4Level as Bath4Lev, Bath5NumPieces as Bath5,Bath5Ensuite as Bath5En,Bath5Level as Bath5Lev, Bath6NumPieces as Bath6,Bath6Ensuite as Bath6En,Bath6Level as Bath6Lev, Bath7NumPieces as Bath7,Bath7Ensuite as Bath7En,Bath7Level as Bath7Lev, Bath8NumPieces as Bath8,Bath8Ensuite as Bath8En,Bath8Level as Bath8Lev, kitchens, BasementDev,BedroomsUp, FloorLevels as Levels,RoomsTotal, Room1Dimension1 as Room1Dim1,Room1Dimension2 as Room1Dim2,Room1Level,Room1Type, Room2Dimension1 as Room2Dim1,Room2Dimension2 as Room2Dim2,Room2Level,Room2Type, Room3Dimension1 as Room3Dim1,Room3Dimension2 as Room3Dim2,Room3Level,Room3Type, Room4Dimension1 as Room4Dim1,Room4Dimension2 as Room4Dim2,Room4Level,Room4Type, Room5Dimension1 as Room5Dim1,Room5Dimension2 as Room5Dim2,Room5Level,Room5Type, Room6Dimension1 as Room6Dim1,Room6Dimension2 as Room6Dim2,Room6Level,Room6Type, Room7Dimension1 as Room7Dim1,Room7Dimension2 as Room7Dim2,Room7Level,Room7Type, Room8Dimension1 as Room8Dim1,Room8Dimension2 as Room8Dim2,Room8Level,Room8Type, Room9Dimension1 as Room9Dim1,Room9Dimension2 as Room9Dim2,Room9Level,Room9Type, Room10Dimension1 as Room10Dim1,Room10Dimension2 as Room10Dim2,Room10Level,Room10Type, Room11Dimension1 as Room11Dim1,Room11Dimension2 as Room11Dim2,Room11Level,Room11Type, Room12Dimension1 as Room12Dim1,Room12Dimension2 as Room12Dim2,Room12Level,Room12Type, Room13Dimension1 as Room13Dim1,Room13Dimension2 as Room13Dim2,Room13Level,Room13Type, Room14Dimension1 as Room14Dim1,Room14Dimension2 as Room14Dim2,Room14Level,Room14Type, Room15Dimension1 as Room15Dim1,Room15Dimension2 as Room15Dim2,Room15Level,Room15Type, Room16Dimension1 as Room16Dim1,Room16Dimension2 as Room16Dim2,Room16Level,Room16Type, Room17Dimension1 as Room17Dim1,Room17Dimension2 as Room17Dim2,Room17Level,Room17Type, Room18Dimension1 as Room18Dim1,Room18Dimension2 as Room18Dim2,Room18Level,Room18Type, Room19Dimension1 as Room19Dim1,Room19Dimension2 as Room19Dim2,Room19Level,Room19Type, Room20Dimension1 as Room20Dim1,Room20Dimension2 as Room20Dim2,Room20Level,Room20Type, Room21Dimension1 as Room21Dim1,Room21Dimension2 as Room21Dim2,Room21Level,Room21Type, Room22Dimension1 as Room22Dim1,Room22Dimension2 as Room22Dim2,Room22Level,Room22Type, Room23Dimension1 as Room23Dim1,Room23Dimension2 as Room23Dim2,Room23Level,Room23Type, Room24Dimension1 as Room24Dim1,Room24Dimension2 as Room24Dim2,Room24Level,Room24Type, Room25Dimension1 as Room25Dim1,Room25Dimension2 as Room25Dim2,Room25Level,Room25Type, Room26Dimension1 as Room26Dim1,Room26Dimension2 as Room26Dim2,Room26Level,Room26Type, Room27Dimension1 as Room27Dim1,Room27Dimension2 as Room27Dim2,Room27Level,Room27Type, Room28Dimension1 as Room28Dim1,Room28Dimension2 as Room28Dim2,Room28Level,Room28Type, 'rets' AS TableType,'rets' AS NewTableType FROM rets_2 WHERE (Internetok='Y' or Internetok='YES') and (reciprocity='Y' or reciprocity='Yes') AND MLS = (param 1) ORDER BY Status,DateSale DESC,PriceList limit 300
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:641) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor5(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:435) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor6(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:299) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor7(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:208) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor9(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:203) at cfV2HomeSearchMLXLiveSearch2ecfm332591143.runPage(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2ListingDetail2ecfm1514563670.runPage(C:\data\CustomTags\REVAV2\V2ListingDetail.cfm:21) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cflistingdetail2ehtm2052688168.runPage(C:\data\www\REVA\kperra\listingdetail.htm:4) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2StaticPagePartLoader2ecfm1320803414.runPage(C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm:20) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2application2ecfm1515464149._factor10(C:\data\www\REVA\V2application.cfm:591) at cfV2application2ecfm1515464149._factor12(C:\data\www\REVA\V2application.cfm:577) at cfV2application2ecfm1515464149._factor27(C:\data\www\REVA\V2application.cfm:555) at cfV2application2ecfm1515464149.runPage(C:\data\www\REVA\V2application.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfApplication2ecfm571229905.runPage(C:\data\www\REVA\Application.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: java.sql.SQLException: Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation NearbyNoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00û 003-669-12219744NoNoûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081YesûûûûûApartment/Condo15970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, renovated large 970 sqft condo, comes with a PRIVATE YARD downtown, large patio attached a private fenced yard approx. 77 x 22 ft. A must for dog owners . This unit has two large bedrooms, 1 1/2 baths, open concept, completely renovated. This CORNER ground unit does not share any walls with any other units, complete privacy, updates include custom wood kitchen cabinets, S/S appliances, Corian and quartz countertop, custom sink, hardwood floors , bathrooms, jetted chromatherapy deep tub; Wood burning F/p, newly updated shared laundry. Steps to Sea Wall & English Bay beach. Newer roof, repiped 2002 and roof 2008. Pets allowed, Parking. 18 age restriction.ûûûûColdwell Banker Westburn Rlty. 604-437-1123V001473ûColdwell Banker - Perra Realty 604-970-9920V002960Wolfgang Isachsen 604-437-1123V13039wolfisachsen@hotmail.comwww.realtorwolf.com/ Kevin Perra 604-970-9920V18422email@kevinperra.comhttp://www.kevinperra.comûûûû-Garbage Pickup,Gardening,Hot Water,Management470.920.Pets Allowed w/Rest.,Rentals Allwd w/RestrctnsûûSouth2018-11-27 22:08:302018-09-10 18:55:032018-09-10 11:09:092018-12-02 20:44:322018-09-10 11:09:09Freehold Strataûûûûûû2211û4NoMain2YesMainûûûûûûûûûûûûûûûûûû1None21612'86'MainKitchen13'610'7MainMaster Bedroom13'911'10Main Living Room12'86'6Main Dining Room12'812'1MainBedroom18'14'MainPatioûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûretsrets' can not be represented as java.sql.Timestamp at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870) at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:928) at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:555) at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:5943) at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5609) at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4582) at coldfusion.sql.QueryTable.populate(QueryTable.java:380) at coldfusion.sql.QueryTable.populate(QueryTable.java:245) at coldfusion.sql.Executive.getRowSet(Executive.java:641) at coldfusion.sql.Executive.executeQuery(Executive.java:1439) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) ... 62 more
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 435
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor5(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:435)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 299
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor6(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:299)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 208
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor7(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:208)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 203
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor9(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:203)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
5
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 1
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143.runPage(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:1)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
6
struct
COLUMN 0
ID CFMODULE
LINE 21
RAW_TRACE at cfV2ListingDetail2ecfm1514563670.runPage(C:\data\CustomTags\REVAV2\V2ListingDetail.cfm:21)
TEMPLATE C:\data\CustomTags\REVAV2\V2ListingDetail.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFMODULE
LINE 4
RAW_TRACE at cflistingdetail2ehtm2052688168.runPage(C:\data\www\REVA\kperra\listingdetail.htm:4)
TEMPLATE C:\data\www\REVA\kperra\listingdetail.htm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 20
RAW_TRACE at cfV2StaticPagePartLoader2ecfm1320803414.runPage(C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm:20)
TEMPLATE C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFMODULE
LINE 591
RAW_TRACE at cfV2application2ecfm1515464149._factor10(C:\data\www\REVA\V2application.cfm:591)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
10
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 577
RAW_TRACE at cfV2application2ecfm1515464149._factor12(C:\data\www\REVA\V2application.cfm:577)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
11
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 555
RAW_TRACE at cfV2application2ecfm1515464149._factor27(C:\data\www\REVA\V2application.cfm:555)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
12
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 1
RAW_TRACE at cfV2application2ecfm1515464149.runPage(C:\data\www\REVA\V2application.cfm:1)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
13
struct
COLUMN 0
ID CFMODULE
LINE 1
RAW_TRACE at cfApplication2ecfm571229905.runPage(C:\data\www\REVA\Application.cfm:1)
TEMPLATE C:\data\www\REVA\Application.cfm
TYPE CFML
Type Database
queryError Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation NearbyNoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00û 003-669-12219744NoNoûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081YesûûûûûApartment/Condo15970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, renovated large 970 sqft condo, comes with a PRIVATE YARD downtown, large patio attached a private fenced yard approx. 77 x 22 ft. A must for dog owners . This unit has two large bedrooms, 1 1/2 baths, open concept, completely renovated. This CORNER ground unit does not share any walls with any other units, complete privacy, updates include custom wood kitchen cabinets, S/S appliances, Corian and quartz countertop, custom sink, hardwood floors , bathrooms, jetted chromatherapy deep tub; Wood burning F/p, newly updated shared laundry. Steps to Sea Wall & English Bay beach. Newer roof, repiped 2002 and roof 2008. Pets allowed, Parking. 18 age restriction.ûûûûColdwell Banker Westburn Rlty. 604-437-1123V001473ûColdwell Banker - Perra Realty 604-970-9920V002960Wolfgang Isachsen 604-437-1123V13039wolfisachsen@hotmail.comwww.realtorwolf.com/ Kevin Perra 604-970-9920V18422email@kevinperra.comhttp://www.kevinperra.comûûûû-Garbage Pickup,Gardening,Hot Water,Management470.920.Pets Allowed w/Rest.,Rentals Allwd w/RestrctnsûûSouth2018-11-27 22:08:302018-09-10 18:55:032018-09-10 11:09:092018-12-02 20:44:322018-09-10 11:09:09Freehold Strataûûûûûû2211û4NoMain2YesMainûûûûûûûûûûûûûûûûûû1None21612'86'MainKitchen13'610'7MainMaster Bedroom13'911'10Main Living Room12'86'6Main Dining Room12'812'1MainBedroom18'14'MainPatioûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûretsrets' can not be represented as java.sql.Timestamp
where (param 1) = [type='IN', class='java.lang.String', value='R2304516', sqltype='cf_sql_varchar']
struct
Cause
struct
ErrorCode 0
Message Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation NearbyNoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00û 003-669-12219744NoNoûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081YesûûûûûApartment/Condo15970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, renovated large 970 sqft condo, comes with a PRIVATE YARD downtown, large patio attached a private fenced yard approx. 77 x 22 ft. A must for dog owners . This unit has two large bedrooms, 1 1/2 baths, open concept, completely renovated. This CORNER ground unit does not share any walls with any other units, complete privacy, updates include custom wood kitchen cabinets, S/S appliances, Corian and quartz countertop, custom sink, hardwood floors , bathrooms, jetted chromatherapy deep tub; Wood burning F/p, newly updated shared laundry. Steps to Sea Wall & English Bay beach. Newer roof, repiped 2002 and roof 2008. Pets allowed, Parking. 18 age restriction.ûûûûColdwell Banker Westburn Rlty. 604-437-1123V001473ûColdwell Banker - Perra Realty 604-970-9920V002960Wolfgang Isachsen 604-437-1123V13039wolfisachsen@hotmail.comwww.realtorwolf.com/ Kevin Perra 604-970-9920V18422email@kevinperra.comhttp://www.kevinperra.comûûûû-Garbage Pickup,Gardening,Hot Water,Management470.920.Pets Allowed w/Rest.,Rentals Allwd w/RestrctnsûûSouth2018-11-27 22:08:302018-09-10 18:55:032018-09-10 11:09:092018-12-02 20:44:322018-09-10 11:09:09Freehold Strataûûûûûû2211û4NoMain2YesMainûûûûûûûûûûûûûûûûûû1None21612'86'MainKitchen13'610'7MainMaster Bedroom13'911'10Main Living Room12'86'6Main Dining Room12'812'1MainBedroom18'14'MainPatioûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûretsrets' can not be represented as java.sql.Timestamp
SQLState S1009
StackTrace java.sql.SQLException: Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation NearbyNoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00û 003-669-12219744NoNoûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081YesûûûûûApartment/Condo15970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, renovated large 970 sqft condo, comes with a PRIVATE YARD downtown, large patio attached a private fenced yard approx. 77 x 22 ft. A must for dog owners . This unit has two large bedrooms, 1 1/2 baths, open concept, completely renovated. This CORNER ground unit does not share any walls with any other units, complete privacy, updates include custom wood kitchen cabinets, S/S appliances, Corian and quartz countertop, custom sink, hardwood floors , bathrooms, jetted chromatherapy deep tub; Wood burning F/p, newly updated shared laundry. Steps to Sea Wall & English Bay beach. Newer roof, repiped 2002 and roof 2008. Pets allowed, Parking. 18 age restriction.ûûûûColdwell Banker Westburn Rlty. 604-437-1123V001473ûColdwell Banker - Perra Realty 604-970-9920V002960Wolfgang Isachsen 604-437-1123V13039wolfisachsen@hotmail.comwww.realtorwolf.com/ Kevin Perra 604-970-9920V18422email@kevinperra.comhttp://www.kevinperra.comûûûû-Garbage Pickup,Gardening,Hot Water,Management470.920.Pets Allowed w/Rest.,Rentals Allwd w/RestrctnsûûSouth2018-11-27 22:08:302018-09-10 18:55:032018-09-10 11:09:092018-12-02 20:44:322018-09-10 11:09:09Freehold Strataûûûûûû2211û4NoMain2YesMainûûûûûûûûûûûûûûûûûû1None21612'86'MainKitchen13'610'7MainMaster Bedroom13'911'10Main Living Room12'86'6Main Dining Room12'812'1MainBedroom18'14'MainPatioûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûretsrets' can not be represented as java.sql.Timestamp at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870) at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:928) at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:555) at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:5943) at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5609) at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4582) at coldfusion.sql.QueryTable.populate(QueryTable.java:380) at coldfusion.sql.QueryTable.populate(QueryTable.java:245) at coldfusion.sql.Executive.getRowSet(Executive.java:641) at coldfusion.sql.Executive.executeQuery(Executive.java:1439) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor5(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:435) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor6(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:299) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor7(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:208) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor9(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:203) at cfV2HomeSearchMLXLiveSearch2ecfm332591143.runPage(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2ListingDetail2ecfm1514563670.runPage(C:\data\CustomTags\REVAV2\V2ListingDetail.cfm:21) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cflistingdetail2ehtm2052688168.runPage(C:\data\www\REVA\kperra\listingdetail.htm:4) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2StaticPagePartLoader2ecfm1320803414.runPage(C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm:20) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2application2ecfm1515464149._factor10(C:\data\www\REVA\V2application.cfm:591) at cfV2application2ecfm1515464149._factor12(C:\data\www\REVA\V2application.cfm:577) at cfV2application2ecfm1515464149._factor27(C:\data\www\REVA\V2application.cfm:555) at cfV2application2ecfm1515464149.runPage(C:\data\www\REVA\V2application.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfApplication2ecfm571229905.runPage(C:\data\www\REVA\Application.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 435
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor5(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:435)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 299
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor6(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:299)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 208
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor7(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:208)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 203
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor9(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:203)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
5
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 1
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143.runPage(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:1)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
6
struct
COLUMN 0
ID CFMODULE
LINE 21
RAW_TRACE at cfV2ListingDetail2ecfm1514563670.runPage(C:\data\CustomTags\REVAV2\V2ListingDetail.cfm:21)
TEMPLATE C:\data\CustomTags\REVAV2\V2ListingDetail.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFMODULE
LINE 4
RAW_TRACE at cflistingdetail2ehtm2052688168.runPage(C:\data\www\REVA\kperra\listingdetail.htm:4)
TEMPLATE C:\data\www\REVA\kperra\listingdetail.htm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 20
RAW_TRACE at cfV2StaticPagePartLoader2ecfm1320803414.runPage(C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm:20)
TEMPLATE C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFMODULE
LINE 591
RAW_TRACE at cfV2application2ecfm1515464149._factor10(C:\data\www\REVA\V2application.cfm:591)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
10
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 577
RAW_TRACE at cfV2application2ecfm1515464149._factor12(C:\data\www\REVA\V2application.cfm:577)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
11
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 555
RAW_TRACE at cfV2application2ecfm1515464149._factor27(C:\data\www\REVA\V2application.cfm:555)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
12
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 1
RAW_TRACE at cfV2application2ecfm1515464149.runPage(C:\data\www\REVA\V2application.cfm:1)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
13
struct
COLUMN 0
ID CFMODULE
LINE 1
RAW_TRACE at cfApplication2ecfm571229905.runPage(C:\data\www\REVA\Application.cfm:1)
TEMPLATE C:\data\www\REVA\Application.cfm
TYPE CFML
Type java.sql.SQLException
DataSource sb_listingsdb_1
Detail Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation Nearby NoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00 û 003-669-12219744No Noûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081Yesûûûû ûApartment/Condo15 970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, ren...
ErrorCode S1009
Message Error Executing Database Query.
NativeErrorCode 0
RootCause
struct
ErrorCode 0
Message Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation NearbyNoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00û 003-669-12219744NoNoûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081YesûûûûûApartment/Condo15970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, renovated large 970 sqft condo, comes with a PRIVATE YARD downtown, large patio attached a private fenced yard approx. 77 x 22 ft. A must for dog owners . This unit has two large bedrooms, 1 1/2 baths, open concept, completely renovated. This CORNER ground unit does not share any walls with any other units, complete privacy, updates include custom wood kitchen cabinets, S/S appliances, Corian and quartz countertop, custom sink, hardwood floors , bathrooms, jetted chromatherapy deep tub; Wood burning F/p, newly updated shared laundry. Steps to Sea Wall & English Bay beach. Newer roof, repiped 2002 and roof 2008. Pets allowed, Parking. 18 age restriction.ûûûûColdwell Banker Westburn Rlty. 604-437-1123V001473ûColdwell Banker - Perra Realty 604-970-9920V002960Wolfgang Isachsen 604-437-1123V13039wolfisachsen@hotmail.comwww.realtorwolf.com/ Kevin Perra 604-970-9920V18422email@kevinperra.comhttp://www.kevinperra.comûûûû-Garbage Pickup,Gardening,Hot Water,Management470.920.Pets Allowed w/Rest.,Rentals Allwd w/RestrctnsûûSouth2018-11-27 22:08:302018-09-10 18:55:032018-09-10 11:09:092018-12-02 20:44:322018-09-10 11:09:09Freehold Strataûûûûûû2211û4NoMain2YesMainûûûûûûûûûûûûûûûûûû1None21612'86'MainKitchen13'610'7MainMaster Bedroom13'911'10Main Living Room12'86'6Main Dining Room12'812'1MainBedroom18'14'MainPatioûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûretsrets' can not be represented as java.sql.Timestamp
SQLState S1009
StackTrace java.sql.SQLException: Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation NearbyNoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00û 003-669-12219744NoNoûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081YesûûûûûApartment/Condo15970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, renovated large 970 sqft condo, comes with a PRIVATE YARD downtown, large patio attached a private fenced yard approx. 77 x 22 ft. A must for dog owners . This unit has two large bedrooms, 1 1/2 baths, open concept, completely renovated. This CORNER ground unit does not share any walls with any other units, complete privacy, updates include custom wood kitchen cabinets, S/S appliances, Corian and quartz countertop, custom sink, hardwood floors , bathrooms, jetted chromatherapy deep tub; Wood burning F/p, newly updated shared laundry. Steps to Sea Wall & English Bay beach. Newer roof, repiped 2002 and roof 2008. Pets allowed, Parking. 18 age restriction.ûûûûColdwell Banker Westburn Rlty. 604-437-1123V001473ûColdwell Banker - Perra Realty 604-970-9920V002960Wolfgang Isachsen 604-437-1123V13039wolfisachsen@hotmail.comwww.realtorwolf.com/ Kevin Perra 604-970-9920V18422email@kevinperra.comhttp://www.kevinperra.comûûûû-Garbage Pickup,Gardening,Hot Water,Management470.920.Pets Allowed w/Rest.,Rentals Allwd w/RestrctnsûûSouth2018-11-27 22:08:302018-09-10 18:55:032018-09-10 11:09:092018-12-02 20:44:322018-09-10 11:09:09Freehold Strataûûûûûû2211û4NoMain2YesMainûûûûûûûûûûûûûûûûûû1None21612'86'MainKitchen13'610'7MainMaster Bedroom13'911'10Main Living Room12'86'6Main Dining Room12'812'1MainBedroom18'14'MainPatioûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûretsrets' can not be represented as java.sql.Timestamp at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870) at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:928) at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:555) at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:5943) at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5609) at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4582) at coldfusion.sql.QueryTable.populate(QueryTable.java:380) at coldfusion.sql.QueryTable.populate(QueryTable.java:245) at coldfusion.sql.Executive.getRowSet(Executive.java:641) at coldfusion.sql.Executive.executeQuery(Executive.java:1439) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor5(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:435) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor6(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:299) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor7(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:208) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor9(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:203) at cfV2HomeSearchMLXLiveSearch2ecfm332591143.runPage(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2ListingDetail2ecfm1514563670.runPage(C:\data\CustomTags\REVAV2\V2ListingDetail.cfm:21) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cflistingdetail2ehtm2052688168.runPage(C:\data\www\REVA\kperra\listingdetail.htm:4) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2StaticPagePartLoader2ecfm1320803414.runPage(C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm:20) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2application2ecfm1515464149._factor10(C:\data\www\REVA\V2application.cfm:591) at cfV2application2ecfm1515464149._factor12(C:\data\www\REVA\V2application.cfm:577) at cfV2application2ecfm1515464149._factor27(C:\data\www\REVA\V2application.cfm:555) at cfV2application2ecfm1515464149.runPage(C:\data\www\REVA\V2application.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfApplication2ecfm571229905.runPage(C:\data\www\REVA\Application.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 435
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor5(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:435)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 299
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor6(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:299)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 208
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor7(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:208)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 203
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor9(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:203)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
5
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 1
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143.runPage(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:1)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
6
struct
COLUMN 0
ID CFMODULE
LINE 21
RAW_TRACE at cfV2ListingDetail2ecfm1514563670.runPage(C:\data\CustomTags\REVAV2\V2ListingDetail.cfm:21)
TEMPLATE C:\data\CustomTags\REVAV2\V2ListingDetail.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFMODULE
LINE 4
RAW_TRACE at cflistingdetail2ehtm2052688168.runPage(C:\data\www\REVA\kperra\listingdetail.htm:4)
TEMPLATE C:\data\www\REVA\kperra\listingdetail.htm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 20
RAW_TRACE at cfV2StaticPagePartLoader2ecfm1320803414.runPage(C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm:20)
TEMPLATE C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFMODULE
LINE 591
RAW_TRACE at cfV2application2ecfm1515464149._factor10(C:\data\www\REVA\V2application.cfm:591)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
10
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 577
RAW_TRACE at cfV2application2ecfm1515464149._factor12(C:\data\www\REVA\V2application.cfm:577)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
11
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 555
RAW_TRACE at cfV2application2ecfm1515464149._factor27(C:\data\www\REVA\V2application.cfm:555)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
12
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 1
RAW_TRACE at cfV2application2ecfm1515464149.runPage(C:\data\www\REVA\V2application.cfm:1)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
13
struct
COLUMN 0
ID CFMODULE
LINE 1
RAW_TRACE at cfApplication2ecfm571229905.runPage(C:\data\www\REVA\Application.cfm:1)
TEMPLATE C:\data\www\REVA\Application.cfm
TYPE CFML
Type java.sql.SQLException
SQLState S1009
Sql SELECT MLS,sysid,Status,Bedrooms,Age,Images,city, PriceList,PriceOriginal,PriceSale, Occupancy,reciprocity,AreaOutdoor, AreaLotSize,MeasureUnitsLand as MeasureUnits,LotDepth as AreaRemaining, LegalDescription1,LegalDescription2, CONCAT(Address,', ',AreaDesc) AS AddressFull, Address,AddrStName,AddrStNumber,AddrStType,AddrStUnitNumber as UnitNum,AddrDirection, AddrLowNum,PostalCode, AreaCode as Area,SubAreaDesc as subarea,SubAreaCode,AreaDesc, StyleofHome as Style, Construction,ExteriorFinish as Exterior,Foundation,Remodelled,YearRenov as YrRenov,Roof, FloorFinish as Flooring,WaterSupply as Water, FireplaceFueledby as FireplaceFuel,Fireplaces,FireRoughIn as FireRough,HeatFuel, TaxAmount,TaxYear,Zoning,Amenities,SiteInfluences, '' as FixturesRemovedDesc,FixturesRemoved,SmokeDetectors, ParkingAccess,ParkingCovered,ParkingFacilities,ParkingTotal, DateExpire,DateListed,DateSale,'' as DaysOnMarket,'' as DateBackOnMarket, '' as zPics,'' as zVT,'' as zCustomer,'' as zHost,'' as TypeID, ComplexSubdivision as complexnam,PropertyID as PID,YearBuilt as YRBLT,StoreysinBuilding as Storeys, fixturesremoved,'' as fixturesremoveddesc,view,ViewSpecify as viewspecif, RainScreen as rainscr,UnitsinDevelopment as unitsindev, TotalUnitsinStrataPlan as unitsinstr,locker, PropertyDisclosure as propdisclosure, FeaturesIncluded as featuresin,cats,dogs,petcount,rentalcountallowed, suite,MgmtCosName as mgtcosname,MgmtCosPhoneNum as mgtcosph,DisplayAddressonInternet,InternetRemarks, FullHeight as fullht,CrawlHeight as crawlht,PartHeight as partht, '' as DatePrevExpire, LotFrontage as FrontageSize, TypeofDwelling as Type,Images as Img,'' as GSTSold,'' as PricePrevious, FloorAreaFinGrandTotal as AreaFinished, FloorAreaUnfinished as AreaUnfinished, (FloorAreaFinGrandTotal+FloorAreaUnfinished) as AreaTotal2, FloorAreaGrandTotal as AreaTotal, FloorAreaFinBasement as AreaBasement, FloorAreaFinBelowMain as AreaDown, FloorAreaFinMainFloor as AreaMain, FloorAreaFinAboveMain as AreaUp, StyleofHome as Style, YearRenov as YrRenov, PublicRemarks1 as Remarks1, PublicRemarks2 as remarks2, '' as remarks3, DistanceToTransit as TransitDist,DistanceToSchool as SchoolDist,ListBroker1Fax as Broker1Fax,ListBroker1Name as Broker1Name,ListBroker1Phone as Broker1Phone, ListBroker1ID as Broker1Code,ListBroker2Fax as Broker2Fax,ListBroker2Name as Broker2Name,ListBroker2Phone as Broker2Phone,ListBroker2ID as Broker2Code, ListRealtor1Name as LS1Name,ListRealtor1Phone as LS1Phone,ListRealtor1ID as LS1Code,ListRealtor1Email as LS1Email, ListRealtor1URL as LS1URL,ListRealtor2Name as LS2Name, ListRealtor2Phone as LS2Phone,ListRealtor2ID as LS2Code,ListRealtor2Email as LS2Email,ListRealtor2URL as LS2URL,ListRealtor3Name as LS3Name,ListRealtor3Phone as LS3Phone,ListRealtor3ID as LS3Code, '' as PrkngStall,'' as PkgOwned, Den, MaintFeeIncludes as MaintChrgDesc,MaintChrgAmount,ByLawRestrictions as ByLawRestr,RestrictedAge as RestrAge, DirectionalExpFaces as DirExpFace,DirectionalExpRearYard as DirExpRear, '' as LastTransC,LastTransDate as LastTransD,LastImgTransDate as LastImgTra,X_InsertDate as createdon,X_UpdateDate as lastmodified, X_InsertDate as importdate,'' as importflag, TitleToLand,Possession,'' as RemarksPrivate,'' as RltrRemar1, '' as Appointments,'' as ApptCall,'' as AppointmentsPhone, '' as Buyer,'' as Commission, '' as SellingBroker1Name, SellingBroker1ID as SellingBroker1Code, SellingRealtor1ID as SellingLS1Code, '' as SellingLS1Name, '' as SellingBroker2Name, SellingBroker2ID as SellingBroker2Code, SellingRealtor2ID as SellingLS2Code, '' as SellingLS2Name, '' as SellingLS3Code, '' as SellingLS3Name, '' as OwnerPhone,'' as OwnerPhone2,'' as OwnerInterest,OwnerName, '' as MORTGAGE1INFOID, BathEnsuitePieces as BathEnsPcs,(BathroomsFull+BathroomsHalf) as BathroomsTotal,BathroomsFull,BathroomsHalf,PlumbingRoughin, Bath1NumPieces as Bath1,Bath1Ensuite as Bath1En,Bath1Level as Bath1Lev, Bath2NumPieces as Bath2,Bath2Ensuite as Bath2En,Bath2Level as Bath2Lev, Bath3NumPieces as Bath3,Bath3Ensuite as Bath3En,Bath3Level as Bath3Lev, Bath4NumPieces as Bath4,Bath4Ensuite as Bath4En,Bath4Level as Bath4Lev, Bath5NumPieces as Bath5,Bath5Ensuite as Bath5En,Bath5Level as Bath5Lev, Bath6NumPieces as Bath6,Bath6Ensuite as Bath6En,Bath6Level as Bath6Lev, Bath7NumPieces as Bath7,Bath7Ensuite as Bath7En,Bath7Level as Bath7Lev, Bath8NumPieces as Bath8,Bath8Ensuite as Bath8En,Bath8Level as Bath8Lev, kitchens, BasementDev,BedroomsUp, FloorLevels as Levels,RoomsTotal, Room1Dimension1 as Room1Dim1,Room1Dimension2 as Room1Dim2,Room1Level,Room1Type, Room2Dimension1 as Room2Dim1,Room2Dimension2 as Room2Dim2,Room2Level,Room2Type, Room3Dimension1 as Room3Dim1,Room3Dimension2 as Room3Dim2,Room3Level,Room3Type, Room4Dimension1 as Room4Dim1,Room4Dimension2 as Room4Dim2,Room4Level,Room4Type, Room5Dimension1 as Room5Dim1,Room5Dimension2 as Room5Dim2,Room5Level,Room5Type, Room6Dimension1 as Room6Dim1,Room6Dimension2 as Room6Dim2,Room6Level,Room6Type, Room7Dimension1 as Room7Dim1,Room7Dimension2 as Room7Dim2,Room7Level,Room7Type, Room8Dimension1 as Room8Dim1,Room8Dimension2 as Room8Dim2,Room8Level,Room8Type, Room9Dimension1 as Room9Dim1,Room9Dimension2 as Room9Dim2,Room9Level,Room9Type, Room10Dimension1 as Room10Dim1,Room10Dimension2 as Room10Dim2,Room10Level,Room10Type, Room11Dimension1 as Room11Dim1,Room11Dimension2 as Room11Dim2,Room11Level,Room11Type, Room12Dimension1 as Room12Dim1,Room12Dimension2 as Room12Dim2,Room12Level,Room12Type, Room13Dimension1 as Room13Dim1,Room13Dimension2 as Room13Dim2,Room13Level,Room13Type, Room14Dimension1 as Room14Dim1,Room14Dimension2 as Room14Dim2,Room14Level,Room14Type, Room15Dimension1 as Room15Dim1,Room15Dimension2 as Room15Dim2,Room15Level,Room15Type, Room16Dimension1 as Room16Dim1,Room16Dimension2 as Room16Dim2,Room16Level,Room16Type, Room17Dimension1 as Room17Dim1,Room17Dimension2 as Room17Dim2,Room17Level,Room17Type, Room18Dimension1 as Room18Dim1,Room18Dimension2 as Room18Dim2,Room18Level,Room18Type, Room19Dimension1 as Room19Dim1,Room19Dimension2 as Room19Dim2,Room19Level,Room19Type, Room20Dimension1 as Room20Dim1,Room20Dimension2 as Room20Dim2,Room20Level,Room20Type, Room21Dimension1 as Room21Dim1,Room21Dimension2 as Room21Dim2,Room21Level,Room21Type, Room22Dimension1 as Room22Dim1,Room22Dimension2 as Room22Dim2,Room22Level,Room22Type, Room23Dimension1 as Room23Dim1,Room23Dimension2 as Room23Dim2,Room23Level,Room23Type, Room24Dimension1 as Room24Dim1,Room24Dimension2 as Room24Dim2,Room24Level,Room24Type, Room25Dimension1 as Room25Dim1,Room25Dimension2 as Room25Dim2,Room25Level,Room25Type, Room26Dimension1 as Room26Dim1,Room26Dimension2 as Room26Dim2,Room26Level,Room26Type, Room27Dimension1 as Room27Dim1,Room27Dimension2 as Room27Dim2,Room27Level,Room27Type, Room28Dimension1 as Room28Dim1,Room28Dimension2 as Room28Dim2,Room28Level,Room28Type, 'rets' AS TableType,'rets' AS NewTableType FROM rets_2 WHERE (Internetok='Y' or Internetok='YES') and (reciprocity='Y' or reciprocity='Yes') AND MLS = (param 1) ORDER BY Status,DateSale DESC,PriceList limit 300
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:641) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor5(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:435) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor6(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:299) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor7(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:208) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor9(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:203) at cfV2HomeSearchMLXLiveSearch2ecfm332591143.runPage(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2ListingDetail2ecfm1514563670.runPage(C:\data\CustomTags\REVAV2\V2ListingDetail.cfm:21) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cflistingdetail2ehtm2052688168.runPage(C:\data\www\REVA\kperra\listingdetail.htm:4) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2StaticPagePartLoader2ecfm1320803414.runPage(C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm:20) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2application2ecfm1515464149._factor10(C:\data\www\REVA\V2application.cfm:591) at cfV2application2ecfm1515464149._factor12(C:\data\www\REVA\V2application.cfm:577) at cfV2application2ecfm1515464149._factor27(C:\data\www\REVA\V2application.cfm:555) at cfV2application2ecfm1515464149.runPage(C:\data\www\REVA\V2application.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfApplication2ecfm571229905.runPage(C:\data\www\REVA\Application.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: java.sql.SQLException: Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation NearbyNoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00û 003-669-12219744NoNoûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081YesûûûûûApartment/Condo15970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, renovated large 970 sqft condo, comes with a PRIVATE YARD downtown, large patio attached a private fenced yard approx. 77 x 22 ft. A must for dog owners . This unit has two large bedrooms, 1 1/2 baths, open concept, completely renovated. This CORNER ground unit does not share any walls with any other units, complete privacy, updates include custom wood kitchen cabinets, S/S appliances, Corian and quartz countertop, custom sink, hardwood floors , bathrooms, jetted chromatherapy deep tub; Wood burning F/p, newly updated shared laundry. Steps to Sea Wall & English Bay beach. Newer roof, repiped 2002 and roof 2008. Pets allowed, Parking. 18 age restriction.ûûûûColdwell Banker Westburn Rlty. 604-437-1123V001473ûColdwell Banker - Perra Realty 604-970-9920V002960Wolfgang Isachsen 604-437-1123V13039wolfisachsen@hotmail.comwww.realtorwolf.com/ Kevin Perra 604-970-9920V18422email@kevinperra.comhttp://www.kevinperra.comûûûû-Garbage Pickup,Gardening,Hot Water,Management470.920.Pets Allowed w/Rest.,Rentals Allwd w/RestrctnsûûSouth2018-11-27 22:08:302018-09-10 18:55:032018-09-10 11:09:092018-12-02 20:44:322018-09-10 11:09:09Freehold Strataûûûûûû2211û4NoMain2YesMainûûûûûûûûûûûûûûûûûû1None21612'86'MainKitchen13'610'7MainMaster Bedroom13'911'10Main Living Room12'86'6Main Dining Room12'812'1MainBedroom18'14'MainPatioûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûretsrets' can not be represented as java.sql.Timestamp at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870) at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:928) at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:555) at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:5943) at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5609) at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4582) at coldfusion.sql.QueryTable.populate(QueryTable.java:380) at coldfusion.sql.QueryTable.populate(QueryTable.java:245) at coldfusion.sql.Executive.getRowSet(Executive.java:641) at coldfusion.sql.Executive.executeQuery(Executive.java:1439) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) ... 62 more
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 435
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor5(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:435)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 299
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor6(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:299)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 208
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor7(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:208)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 203
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor9(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:203)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
5
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 1
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143.runPage(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:1)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
6
struct
COLUMN 0
ID CFMODULE
LINE 21
RAW_TRACE at cfV2ListingDetail2ecfm1514563670.runPage(C:\data\CustomTags\REVAV2\V2ListingDetail.cfm:21)
TEMPLATE C:\data\CustomTags\REVAV2\V2ListingDetail.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFMODULE
LINE 4
RAW_TRACE at cflistingdetail2ehtm2052688168.runPage(C:\data\www\REVA\kperra\listingdetail.htm:4)
TEMPLATE C:\data\www\REVA\kperra\listingdetail.htm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 20
RAW_TRACE at cfV2StaticPagePartLoader2ecfm1320803414.runPage(C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm:20)
TEMPLATE C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFMODULE
LINE 591
RAW_TRACE at cfV2application2ecfm1515464149._factor10(C:\data\www\REVA\V2application.cfm:591)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
10
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 577
RAW_TRACE at cfV2application2ecfm1515464149._factor12(C:\data\www\REVA\V2application.cfm:577)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
11
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 555
RAW_TRACE at cfV2application2ecfm1515464149._factor27(C:\data\www\REVA\V2application.cfm:555)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
12
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 1
RAW_TRACE at cfV2application2ecfm1515464149.runPage(C:\data\www\REVA\V2application.cfm:1)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
13
struct
COLUMN 0
ID CFMODULE
LINE 1
RAW_TRACE at cfApplication2ecfm571229905.runPage(C:\data\www\REVA\Application.cfm:1)
TEMPLATE C:\data\www\REVA\Application.cfm
TYPE CFML
Type Database
queryError Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation NearbyNoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00û 003-669-12219744NoNoûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081YesûûûûûApartment/Condo15970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, renovated large 970 sqft condo, comes with a PRIVATE YARD downtown, large patio attached a private fenced yard approx. 77 x 22 ft. A must for dog owners . This unit has two large bedrooms, 1 1/2 baths, open concept, completely renovated. This CORNER ground unit does not share any walls with any other units, complete privacy, updates include custom wood kitchen cabinets, S/S appliances, Corian and quartz countertop, custom sink, hardwood floors , bathrooms, jetted chromatherapy deep tub; Wood burning F/p, newly updated shared laundry. Steps to Sea Wall & English Bay beach. Newer roof, repiped 2002 and roof 2008. Pets allowed, Parking. 18 age restriction.ûûûûColdwell Banker Westburn Rlty. 604-437-1123V001473ûColdwell Banker - Perra Realty 604-970-9920V002960Wolfgang Isachsen 604-437-1123V13039wolfisachsen@hotmail.comwww.realtorwolf.com/ Kevin Perra 604-970-9920V18422email@kevinperra.comhttp://www.kevinperra.comûûûû-Garbage Pickup,Gardening,Hot Water,Management470.920.Pets Allowed w/Rest.,Rentals Allwd w/RestrctnsûûSouth2018-11-27 22:08:302018-09-10 18:55:032018-09-10 11:09:092018-12-02 20:44:322018-09-10 11:09:09Freehold Strataûûûûûû2211û4NoMain2YesMainûûûûûûûûûûûûûûûûûû1None21612'86'MainKitchen13'610'7MainMaster Bedroom13'911'10Main Living Room12'86'6Main Dining Room12'812'1MainBedroom18'14'MainPatioûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûretsrets' can not be represented as java.sql.Timestamp
where (param 1) = [type='IN', class='java.lang.String', value='R2304516', sqltype='cf_sql_varchar']
struct
Cause
struct
ErrorCode 0
Message Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation NearbyNoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00û 003-669-12219744NoNoûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081YesûûûûûApartment/Condo15970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, renovated large 970 sqft condo, comes with a PRIVATE YARD downtown, large patio attached a private fenced yard approx. 77 x 22 ft. A must for dog owners . This unit has two large bedrooms, 1 1/2 baths, open concept, completely renovated. This CORNER ground unit does not share any walls with any other units, complete privacy, updates include custom wood kitchen cabinets, S/S appliances, Corian and quartz countertop, custom sink, hardwood floors , bathrooms, jetted chromatherapy deep tub; Wood burning F/p, newly updated shared laundry. Steps to Sea Wall & English Bay beach. Newer roof, repiped 2002 and roof 2008. Pets allowed, Parking. 18 age restriction.ûûûûColdwell Banker Westburn Rlty. 604-437-1123V001473ûColdwell Banker - Perra Realty 604-970-9920V002960Wolfgang Isachsen 604-437-1123V13039wolfisachsen@hotmail.comwww.realtorwolf.com/ Kevin Perra 604-970-9920V18422email@kevinperra.comhttp://www.kevinperra.comûûûû-Garbage Pickup,Gardening,Hot Water,Management470.920.Pets Allowed w/Rest.,Rentals Allwd w/RestrctnsûûSouth2018-11-27 22:08:302018-09-10 18:55:032018-09-10 11:09:092018-12-02 20:44:322018-09-10 11:09:09Freehold Strataûûûûûû2211û4NoMain2YesMainûûûûûûûûûûûûûûûûûû1None21612'86'MainKitchen13'610'7MainMaster Bedroom13'911'10Main Living Room12'86'6Main Dining Room12'812'1MainBedroom18'14'MainPatioûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûretsrets' can not be represented as java.sql.Timestamp
SQLState S1009
StackTrace java.sql.SQLException: Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation NearbyNoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00û 003-669-12219744NoNoûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081YesûûûûûApartment/Condo15970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, renovated large 970 sqft condo, comes with a PRIVATE YARD downtown, large patio attached a private fenced yard approx. 77 x 22 ft. A must for dog owners . This unit has two large bedrooms, 1 1/2 baths, open concept, completely renovated. This CORNER ground unit does not share any walls with any other units, complete privacy, updates include custom wood kitchen cabinets, S/S appliances, Corian and quartz countertop, custom sink, hardwood floors , bathrooms, jetted chromatherapy deep tub; Wood burning F/p, newly updated shared laundry. Steps to Sea Wall & English Bay beach. Newer roof, repiped 2002 and roof 2008. Pets allowed, Parking. 18 age restriction.ûûûûColdwell Banker Westburn Rlty. 604-437-1123V001473ûColdwell Banker - Perra Realty 604-970-9920V002960Wolfgang Isachsen 604-437-1123V13039wolfisachsen@hotmail.comwww.realtorwolf.com/ Kevin Perra 604-970-9920V18422email@kevinperra.comhttp://www.kevinperra.comûûûû-Garbage Pickup,Gardening,Hot Water,Management470.920.Pets Allowed w/Rest.,Rentals Allwd w/RestrctnsûûSouth2018-11-27 22:08:302018-09-10 18:55:032018-09-10 11:09:092018-12-02 20:44:322018-09-10 11:09:09Freehold Strataûûûûûû2211û4NoMain2YesMainûûûûûûûûûûûûûûûûûû1None21612'86'MainKitchen13'610'7MainMaster Bedroom13'911'10Main Living Room12'86'6Main Dining Room12'812'1MainBedroom18'14'MainPatioûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûretsrets' can not be represented as java.sql.Timestamp at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870) at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:928) at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:555) at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:5943) at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5609) at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4582) at coldfusion.sql.QueryTable.populate(QueryTable.java:380) at coldfusion.sql.QueryTable.populate(QueryTable.java:245) at coldfusion.sql.Executive.getRowSet(Executive.java:641) at coldfusion.sql.Executive.executeQuery(Executive.java:1439) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor5(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:435) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor6(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:299) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor7(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:208) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor9(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:203) at cfV2HomeSearchMLXLiveSearch2ecfm332591143.runPage(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2ListingDetail2ecfm1514563670.runPage(C:\data\CustomTags\REVAV2\V2ListingDetail.cfm:21) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cflistingdetail2ehtm2052688168.runPage(C:\data\www\REVA\kperra\listingdetail.htm:4) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2StaticPagePartLoader2ecfm1320803414.runPage(C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm:20) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2application2ecfm1515464149._factor10(C:\data\www\REVA\V2application.cfm:591) at cfV2application2ecfm1515464149._factor12(C:\data\www\REVA\V2application.cfm:577) at cfV2application2ecfm1515464149._factor27(C:\data\www\REVA\V2application.cfm:555) at cfV2application2ecfm1515464149.runPage(C:\data\www\REVA\V2application.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfApplication2ecfm571229905.runPage(C:\data\www\REVA\Application.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 435
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor5(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:435)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 299
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor6(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:299)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 208
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor7(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:208)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 203
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor9(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:203)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
5
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 1
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143.runPage(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:1)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
6
struct
COLUMN 0
ID CFMODULE
LINE 21
RAW_TRACE at cfV2ListingDetail2ecfm1514563670.runPage(C:\data\CustomTags\REVAV2\V2ListingDetail.cfm:21)
TEMPLATE C:\data\CustomTags\REVAV2\V2ListingDetail.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFMODULE
LINE 4
RAW_TRACE at cflistingdetail2ehtm2052688168.runPage(C:\data\www\REVA\kperra\listingdetail.htm:4)
TEMPLATE C:\data\www\REVA\kperra\listingdetail.htm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 20
RAW_TRACE at cfV2StaticPagePartLoader2ecfm1320803414.runPage(C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm:20)
TEMPLATE C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFMODULE
LINE 591
RAW_TRACE at cfV2application2ecfm1515464149._factor10(C:\data\www\REVA\V2application.cfm:591)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
10
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 577
RAW_TRACE at cfV2application2ecfm1515464149._factor12(C:\data\www\REVA\V2application.cfm:577)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
11
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 555
RAW_TRACE at cfV2application2ecfm1515464149._factor27(C:\data\www\REVA\V2application.cfm:555)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
12
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 1
RAW_TRACE at cfV2application2ecfm1515464149.runPage(C:\data\www\REVA\V2application.cfm:1)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
13
struct
COLUMN 0
ID CFMODULE
LINE 1
RAW_TRACE at cfApplication2ecfm571229905.runPage(C:\data\www\REVA\Application.cfm:1)
TEMPLATE C:\data\www\REVA\Application.cfm
TYPE CFML
Type java.sql.SQLException
DataSource sb_listingsdb_1
Detail Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation Nearby NoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00 û 003-669-12219744No Noûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081Yesûûûû ûApartment/Condo15 970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, ren...
ErrorCode S1009
Message Error Executing Database Query.
NativeErrorCode 0
RootCause
struct
ErrorCode 0
Message Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation NearbyNoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00û 003-669-12219744NoNoûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081YesûûûûûApartment/Condo15970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, renovated large 970 sqft condo, comes with a PRIVATE YARD downtown, large patio attached a private fenced yard approx. 77 x 22 ft. A must for dog owners . This unit has two large bedrooms, 1 1/2 baths, open concept, completely renovated. This CORNER ground unit does not share any walls with any other units, complete privacy, updates include custom wood kitchen cabinets, S/S appliances, Corian and quartz countertop, custom sink, hardwood floors , bathrooms, jetted chromatherapy deep tub; Wood burning F/p, newly updated shared laundry. Steps to Sea Wall & English Bay beach. Newer roof, repiped 2002 and roof 2008. Pets allowed, Parking. 18 age restriction.ûûûûColdwell Banker Westburn Rlty. 604-437-1123V001473ûColdwell Banker - Perra Realty 604-970-9920V002960Wolfgang Isachsen 604-437-1123V13039wolfisachsen@hotmail.comwww.realtorwolf.com/ Kevin Perra 604-970-9920V18422email@kevinperra.comhttp://www.kevinperra.comûûûû-Garbage Pickup,Gardening,Hot Water,Management470.920.Pets Allowed w/Rest.,Rentals Allwd w/RestrctnsûûSouth2018-11-27 22:08:302018-09-10 18:55:032018-09-10 11:09:092018-12-02 20:44:322018-09-10 11:09:09Freehold Strataûûûûûû2211û4NoMain2YesMainûûûûûûûûûûûûûûûûûû1None21612'86'MainKitchen13'610'7MainMaster Bedroom13'911'10Main Living Room12'86'6Main Dining Room12'812'1MainBedroom18'14'MainPatioûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûretsrets' can not be represented as java.sql.Timestamp
SQLState S1009
StackTrace java.sql.SQLException: Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation NearbyNoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00û 003-669-12219744NoNoûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081YesûûûûûApartment/Condo15970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, renovated large 970 sqft condo, comes with a PRIVATE YARD downtown, large patio attached a private fenced yard approx. 77 x 22 ft. A must for dog owners . This unit has two large bedrooms, 1 1/2 baths, open concept, completely renovated. This CORNER ground unit does not share any walls with any other units, complete privacy, updates include custom wood kitchen cabinets, S/S appliances, Corian and quartz countertop, custom sink, hardwood floors , bathrooms, jetted chromatherapy deep tub; Wood burning F/p, newly updated shared laundry. Steps to Sea Wall & English Bay beach. Newer roof, repiped 2002 and roof 2008. Pets allowed, Parking. 18 age restriction.ûûûûColdwell Banker Westburn Rlty. 604-437-1123V001473ûColdwell Banker - Perra Realty 604-970-9920V002960Wolfgang Isachsen 604-437-1123V13039wolfisachsen@hotmail.comwww.realtorwolf.com/ Kevin Perra 604-970-9920V18422email@kevinperra.comhttp://www.kevinperra.comûûûû-Garbage Pickup,Gardening,Hot Water,Management470.920.Pets Allowed w/Rest.,Rentals Allwd w/RestrctnsûûSouth2018-11-27 22:08:302018-09-10 18:55:032018-09-10 11:09:092018-12-02 20:44:322018-09-10 11:09:09Freehold Strataûûûûûû2211û4NoMain2YesMainûûûûûûûûûûûûûûûûûû1None21612'86'MainKitchen13'610'7MainMaster Bedroom13'911'10Main Living Room12'86'6Main Dining Room12'812'1MainBedroom18'14'MainPatioûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûretsrets' can not be represented as java.sql.Timestamp at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870) at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:928) at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:555) at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:5943) at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5609) at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4582) at coldfusion.sql.QueryTable.populate(QueryTable.java:380) at coldfusion.sql.QueryTable.populate(QueryTable.java:245) at coldfusion.sql.Executive.getRowSet(Executive.java:641) at coldfusion.sql.Executive.executeQuery(Executive.java:1439) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor5(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:435) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor6(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:299) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor7(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:208) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor9(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:203) at cfV2HomeSearchMLXLiveSearch2ecfm332591143.runPage(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2ListingDetail2ecfm1514563670.runPage(C:\data\CustomTags\REVAV2\V2ListingDetail.cfm:21) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cflistingdetail2ehtm2052688168.runPage(C:\data\www\REVA\kperra\listingdetail.htm:4) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2StaticPagePartLoader2ecfm1320803414.runPage(C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm:20) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2application2ecfm1515464149._factor10(C:\data\www\REVA\V2application.cfm:591) at cfV2application2ecfm1515464149._factor12(C:\data\www\REVA\V2application.cfm:577) at cfV2application2ecfm1515464149._factor27(C:\data\www\REVA\V2application.cfm:555) at cfV2application2ecfm1515464149.runPage(C:\data\www\REVA\V2application.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfApplication2ecfm571229905.runPage(C:\data\www\REVA\Application.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 435
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor5(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:435)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 299
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor6(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:299)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 208
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor7(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:208)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 203
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor9(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:203)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
5
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 1
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143.runPage(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:1)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
6
struct
COLUMN 0
ID CFMODULE
LINE 21
RAW_TRACE at cfV2ListingDetail2ecfm1514563670.runPage(C:\data\CustomTags\REVAV2\V2ListingDetail.cfm:21)
TEMPLATE C:\data\CustomTags\REVAV2\V2ListingDetail.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFMODULE
LINE 4
RAW_TRACE at cflistingdetail2ehtm2052688168.runPage(C:\data\www\REVA\kperra\listingdetail.htm:4)
TEMPLATE C:\data\www\REVA\kperra\listingdetail.htm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 20
RAW_TRACE at cfV2StaticPagePartLoader2ecfm1320803414.runPage(C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm:20)
TEMPLATE C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFMODULE
LINE 591
RAW_TRACE at cfV2application2ecfm1515464149._factor10(C:\data\www\REVA\V2application.cfm:591)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
10
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 577
RAW_TRACE at cfV2application2ecfm1515464149._factor12(C:\data\www\REVA\V2application.cfm:577)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
11
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 555
RAW_TRACE at cfV2application2ecfm1515464149._factor27(C:\data\www\REVA\V2application.cfm:555)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
12
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 1
RAW_TRACE at cfV2application2ecfm1515464149.runPage(C:\data\www\REVA\V2application.cfm:1)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
13
struct
COLUMN 0
ID CFMODULE
LINE 1
RAW_TRACE at cfApplication2ecfm571229905.runPage(C:\data\www\REVA\Application.cfm:1)
TEMPLATE C:\data\www\REVA\Application.cfm
TYPE CFML
Type java.sql.SQLException
SQLState S1009
Sql SELECT MLS,sysid,Status,Bedrooms,Age,Images,city, PriceList,PriceOriginal,PriceSale, Occupancy,reciprocity,AreaOutdoor, AreaLotSize,MeasureUnitsLand as MeasureUnits,LotDepth as AreaRemaining, LegalDescription1,LegalDescription2, CONCAT(Address,', ',AreaDesc) AS AddressFull, Address,AddrStName,AddrStNumber,AddrStType,AddrStUnitNumber as UnitNum,AddrDirection, AddrLowNum,PostalCode, AreaCode as Area,SubAreaDesc as subarea,SubAreaCode,AreaDesc, StyleofHome as Style, Construction,ExteriorFinish as Exterior,Foundation,Remodelled,YearRenov as YrRenov,Roof, FloorFinish as Flooring,WaterSupply as Water, FireplaceFueledby as FireplaceFuel,Fireplaces,FireRoughIn as FireRough,HeatFuel, TaxAmount,TaxYear,Zoning,Amenities,SiteInfluences, '' as FixturesRemovedDesc,FixturesRemoved,SmokeDetectors, ParkingAccess,ParkingCovered,ParkingFacilities,ParkingTotal, DateExpire,DateListed,DateSale,'' as DaysOnMarket,'' as DateBackOnMarket, '' as zPics,'' as zVT,'' as zCustomer,'' as zHost,'' as TypeID, ComplexSubdivision as complexnam,PropertyID as PID,YearBuilt as YRBLT,StoreysinBuilding as Storeys, fixturesremoved,'' as fixturesremoveddesc,view,ViewSpecify as viewspecif, RainScreen as rainscr,UnitsinDevelopment as unitsindev, TotalUnitsinStrataPlan as unitsinstr,locker, PropertyDisclosure as propdisclosure, FeaturesIncluded as featuresin,cats,dogs,petcount,rentalcountallowed, suite,MgmtCosName as mgtcosname,MgmtCosPhoneNum as mgtcosph,DisplayAddressonInternet,InternetRemarks, FullHeight as fullht,CrawlHeight as crawlht,PartHeight as partht, '' as DatePrevExpire, LotFrontage as FrontageSize, TypeofDwelling as Type,Images as Img,'' as GSTSold,'' as PricePrevious, FloorAreaFinGrandTotal as AreaFinished, FloorAreaUnfinished as AreaUnfinished, (FloorAreaFinGrandTotal+FloorAreaUnfinished) as AreaTotal2, FloorAreaGrandTotal as AreaTotal, FloorAreaFinBasement as AreaBasement, FloorAreaFinBelowMain as AreaDown, FloorAreaFinMainFloor as AreaMain, FloorAreaFinAboveMain as AreaUp, StyleofHome as Style, YearRenov as YrRenov, PublicRemarks1 as Remarks1, PublicRemarks2 as remarks2, '' as remarks3, DistanceToTransit as TransitDist,DistanceToSchool as SchoolDist,ListBroker1Fax as Broker1Fax,ListBroker1Name as Broker1Name,ListBroker1Phone as Broker1Phone, ListBroker1ID as Broker1Code,ListBroker2Fax as Broker2Fax,ListBroker2Name as Broker2Name,ListBroker2Phone as Broker2Phone,ListBroker2ID as Broker2Code, ListRealtor1Name as LS1Name,ListRealtor1Phone as LS1Phone,ListRealtor1ID as LS1Code,ListRealtor1Email as LS1Email, ListRealtor1URL as LS1URL,ListRealtor2Name as LS2Name, ListRealtor2Phone as LS2Phone,ListRealtor2ID as LS2Code,ListRealtor2Email as LS2Email,ListRealtor2URL as LS2URL,ListRealtor3Name as LS3Name,ListRealtor3Phone as LS3Phone,ListRealtor3ID as LS3Code, '' as PrkngStall,'' as PkgOwned, Den, MaintFeeIncludes as MaintChrgDesc,MaintChrgAmount,ByLawRestrictions as ByLawRestr,RestrictedAge as RestrAge, DirectionalExpFaces as DirExpFace,DirectionalExpRearYard as DirExpRear, '' as LastTransC,LastTransDate as LastTransD,LastImgTransDate as LastImgTra,X_InsertDate as createdon,X_UpdateDate as lastmodified, X_InsertDate as importdate,'' as importflag, TitleToLand,Possession,'' as RemarksPrivate,'' as RltrRemar1, '' as Appointments,'' as ApptCall,'' as AppointmentsPhone, '' as Buyer,'' as Commission, '' as SellingBroker1Name, SellingBroker1ID as SellingBroker1Code, SellingRealtor1ID as SellingLS1Code, '' as SellingLS1Name, '' as SellingBroker2Name, SellingBroker2ID as SellingBroker2Code, SellingRealtor2ID as SellingLS2Code, '' as SellingLS2Name, '' as SellingLS3Code, '' as SellingLS3Name, '' as OwnerPhone,'' as OwnerPhone2,'' as OwnerInterest,OwnerName, '' as MORTGAGE1INFOID, BathEnsuitePieces as BathEnsPcs,(BathroomsFull+BathroomsHalf) as BathroomsTotal,BathroomsFull,BathroomsHalf,PlumbingRoughin, Bath1NumPieces as Bath1,Bath1Ensuite as Bath1En,Bath1Level as Bath1Lev, Bath2NumPieces as Bath2,Bath2Ensuite as Bath2En,Bath2Level as Bath2Lev, Bath3NumPieces as Bath3,Bath3Ensuite as Bath3En,Bath3Level as Bath3Lev, Bath4NumPieces as Bath4,Bath4Ensuite as Bath4En,Bath4Level as Bath4Lev, Bath5NumPieces as Bath5,Bath5Ensuite as Bath5En,Bath5Level as Bath5Lev, Bath6NumPieces as Bath6,Bath6Ensuite as Bath6En,Bath6Level as Bath6Lev, Bath7NumPieces as Bath7,Bath7Ensuite as Bath7En,Bath7Level as Bath7Lev, Bath8NumPieces as Bath8,Bath8Ensuite as Bath8En,Bath8Level as Bath8Lev, kitchens, BasementDev,BedroomsUp, FloorLevels as Levels,RoomsTotal, Room1Dimension1 as Room1Dim1,Room1Dimension2 as Room1Dim2,Room1Level,Room1Type, Room2Dimension1 as Room2Dim1,Room2Dimension2 as Room2Dim2,Room2Level,Room2Type, Room3Dimension1 as Room3Dim1,Room3Dimension2 as Room3Dim2,Room3Level,Room3Type, Room4Dimension1 as Room4Dim1,Room4Dimension2 as Room4Dim2,Room4Level,Room4Type, Room5Dimension1 as Room5Dim1,Room5Dimension2 as Room5Dim2,Room5Level,Room5Type, Room6Dimension1 as Room6Dim1,Room6Dimension2 as Room6Dim2,Room6Level,Room6Type, Room7Dimension1 as Room7Dim1,Room7Dimension2 as Room7Dim2,Room7Level,Room7Type, Room8Dimension1 as Room8Dim1,Room8Dimension2 as Room8Dim2,Room8Level,Room8Type, Room9Dimension1 as Room9Dim1,Room9Dimension2 as Room9Dim2,Room9Level,Room9Type, Room10Dimension1 as Room10Dim1,Room10Dimension2 as Room10Dim2,Room10Level,Room10Type, Room11Dimension1 as Room11Dim1,Room11Dimension2 as Room11Dim2,Room11Level,Room11Type, Room12Dimension1 as Room12Dim1,Room12Dimension2 as Room12Dim2,Room12Level,Room12Type, Room13Dimension1 as Room13Dim1,Room13Dimension2 as Room13Dim2,Room13Level,Room13Type, Room14Dimension1 as Room14Dim1,Room14Dimension2 as Room14Dim2,Room14Level,Room14Type, Room15Dimension1 as Room15Dim1,Room15Dimension2 as Room15Dim2,Room15Level,Room15Type, Room16Dimension1 as Room16Dim1,Room16Dimension2 as Room16Dim2,Room16Level,Room16Type, Room17Dimension1 as Room17Dim1,Room17Dimension2 as Room17Dim2,Room17Level,Room17Type, Room18Dimension1 as Room18Dim1,Room18Dimension2 as Room18Dim2,Room18Level,Room18Type, Room19Dimension1 as Room19Dim1,Room19Dimension2 as Room19Dim2,Room19Level,Room19Type, Room20Dimension1 as Room20Dim1,Room20Dimension2 as Room20Dim2,Room20Level,Room20Type, Room21Dimension1 as Room21Dim1,Room21Dimension2 as Room21Dim2,Room21Level,Room21Type, Room22Dimension1 as Room22Dim1,Room22Dimension2 as Room22Dim2,Room22Level,Room22Type, Room23Dimension1 as Room23Dim1,Room23Dimension2 as Room23Dim2,Room23Level,Room23Type, Room24Dimension1 as Room24Dim1,Room24Dimension2 as Room24Dim2,Room24Level,Room24Type, Room25Dimension1 as Room25Dim1,Room25Dimension2 as Room25Dim2,Room25Level,Room25Type, Room26Dimension1 as Room26Dim1,Room26Dimension2 as Room26Dim2,Room26Level,Room26Type, Room27Dimension1 as Room27Dim1,Room27Dimension2 as Room27Dim2,Room27Level,Room27Type, Room28Dimension1 as Room28Dim1,Room28Dimension2 as Room28Dim2,Room28Level,Room28Type, 'rets' AS TableType,'rets' AS NewTableType FROM rets_2 WHERE (Internetok='Y' or Internetok='YES') and (reciprocity='Y' or reciprocity='Yes') AND MLS = (param 1) ORDER BY Status,DateSale DESC,PriceList limit 300
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:641) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor5(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:435) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor6(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:299) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor7(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:208) at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor9(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:203) at cfV2HomeSearchMLXLiveSearch2ecfm332591143.runPage(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2ListingDetail2ecfm1514563670.runPage(C:\data\CustomTags\REVAV2\V2ListingDetail.cfm:21) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cflistingdetail2ehtm2052688168.runPage(C:\data\www\REVA\kperra\listingdetail.htm:4) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2StaticPagePartLoader2ecfm1320803414.runPage(C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm:20) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfV2application2ecfm1515464149._factor10(C:\data\www\REVA\V2application.cfm:591) at cfV2application2ecfm1515464149._factor12(C:\data\www\REVA\V2application.cfm:577) at cfV2application2ecfm1515464149._factor27(C:\data\www\REVA\V2application.cfm:555) at cfV2application2ecfm1515464149.runPage(C:\data\www\REVA\V2application.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfApplication2ecfm571229905.runPage(C:\data\www\REVA\Application.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: java.sql.SQLException: Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation NearbyNoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00û 003-669-12219744NoNoûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081YesûûûûûApartment/Condo15970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, renovated large 970 sqft condo, comes with a PRIVATE YARD downtown, large patio attached a private fenced yard approx. 77 x 22 ft. A must for dog owners . This unit has two large bedrooms, 1 1/2 baths, open concept, completely renovated. This CORNER ground unit does not share any walls with any other units, complete privacy, updates include custom wood kitchen cabinets, S/S appliances, Corian and quartz countertop, custom sink, hardwood floors , bathrooms, jetted chromatherapy deep tub; Wood burning F/p, newly updated shared laundry. Steps to Sea Wall & English Bay beach. Newer roof, repiped 2002 and roof 2008. Pets allowed, Parking. 18 age restriction.ûûûûColdwell Banker Westburn Rlty. 604-437-1123V001473ûColdwell Banker - Perra Realty 604-970-9920V002960Wolfgang Isachsen 604-437-1123V13039wolfisachsen@hotmail.comwww.realtorwolf.com/ Kevin Perra 604-970-9920V18422email@kevinperra.comhttp://www.kevinperra.comûûûû-Garbage Pickup,Gardening,Hot Water,Management470.920.Pets Allowed w/Rest.,Rentals Allwd w/RestrctnsûûSouth2018-11-27 22:08:302018-09-10 18:55:032018-09-10 11:09:092018-12-02 20:44:322018-09-10 11:09:09Freehold Strataûûûûûû2211û4NoMain2YesMainûûûûûûûûûûûûûûûûûû1None21612'86'MainKitchen13'610'7MainMaster Bedroom13'911'10Main Living Room12'86'6Main Dining Room12'812'1MainBedroom18'14'MainPatioûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûretsrets' can not be represented as java.sql.Timestamp at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870) at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:928) at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:555) at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:5943) at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5609) at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4582) at coldfusion.sql.QueryTable.populate(QueryTable.java:380) at coldfusion.sql.QueryTable.populate(QueryTable.java:245) at coldfusion.sql.Executive.getRowSet(Executive.java:641) at coldfusion.sql.Executive.executeQuery(Executive.java:1439) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) ... 62 more
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 435
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor5(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:435)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 299
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor6(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:299)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 208
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor7(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:208)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 203
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143._factor9(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:203)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
5
struct
COLUMN 0
ID CF_V2HOMESEARCHMLXLIVESEARCH
LINE 1
RAW_TRACE at cfV2HomeSearchMLXLiveSearch2ecfm332591143.runPage(C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm:1)
TEMPLATE C:\data\CustomTags\REVAV2\V2HomeSearchMLXLiveSearch.cfm
TYPE CFML
6
struct
COLUMN 0
ID CFMODULE
LINE 21
RAW_TRACE at cfV2ListingDetail2ecfm1514563670.runPage(C:\data\CustomTags\REVAV2\V2ListingDetail.cfm:21)
TEMPLATE C:\data\CustomTags\REVAV2\V2ListingDetail.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFMODULE
LINE 4
RAW_TRACE at cflistingdetail2ehtm2052688168.runPage(C:\data\www\REVA\kperra\listingdetail.htm:4)
TEMPLATE C:\data\www\REVA\kperra\listingdetail.htm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 20
RAW_TRACE at cfV2StaticPagePartLoader2ecfm1320803414.runPage(C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm:20)
TEMPLATE C:\data\CustomTags\REVAV2\V2StaticPagePartLoader.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFMODULE
LINE 591
RAW_TRACE at cfV2application2ecfm1515464149._factor10(C:\data\www\REVA\V2application.cfm:591)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
10
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 577
RAW_TRACE at cfV2application2ecfm1515464149._factor12(C:\data\www\REVA\V2application.cfm:577)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
11
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 555
RAW_TRACE at cfV2application2ecfm1515464149._factor27(C:\data\www\REVA\V2application.cfm:555)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
12
struct
COLUMN 0
ID CF_V2APPLICATION
LINE 1
RAW_TRACE at cfV2application2ecfm1515464149.runPage(C:\data\www\REVA\V2application.cfm:1)
TEMPLATE C:\data\www\REVA\V2application.cfm
TYPE CFML
13
struct
COLUMN 0
ID CFMODULE
LINE 1
RAW_TRACE at cfApplication2ecfm571229905.runPage(C:\data\www\REVA\Application.cfm:1)
TEMPLATE C:\data\www\REVA\Application.cfm
TYPE CFML
Type Database
queryError Value 'R2304516 262326143S24415 Vancouver 690000.00û 672000.00ûYesFenced Yard,Patio(s)0.000ûû®PL VAS196 LT 1 DL 185 LD 36. TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM 1 OR V, AS APPROPRIATE.ûû101 1649 COMOX STREETCOMOX1649STREET101ûûV6G 1P4Vancouver Westû West End VWûCorner Unit,Ground Level Unit Frame - WoodMixedConcrete Perimeter Completely2010OtherHardwoodCity/MunicipalWood1ûBaseboard,Electric1722.002017RM-5AGarden,Shared Laundry,Storage8Gated Complex,Lane Access,Private Yard,Recreation NearbyNoûRear1Garage Underbuilding1û2018-09-10 00:00:000000-00-00 00:00:00û 003-669-12219744NoNoûûû14YesYes>Dishwasher,Jetted Bathtub,Microwave,Oven-Built In,RefrigeratorYesYes2ûûNAROD PROPERTIES 604-732-8081YesûûûûûApartment/Condo15970.0000.000970.0009700.0000.000970.0000.000Corner Unit,Ground Level Unit2010üÕFor those who want there condo to feel like a home .Very rare, renovated large 970 sqft condo, comes with a PRIVATE YARD downtown, large patio attached a private fenced yard approx. 77 x 22 ft. A must for dog owners . This unit has two large bedrooms, 1 1/2 baths, open concept, completely renovated. This CORNER ground unit does not share any walls with any other units, complete privacy, updates include custom wood kitchen cabinets, S/S appliances, Corian and quartz countertop, custom sink, hardwood floors , bathrooms, jetted chromatherapy deep tub; Wood burning F/p, newly updated shared laundry. Steps to Sea Wall & English Bay beach. Newer roof, repiped 2002 and roof 2008. Pets allowed, Parking. 18 age restriction.ûûûûColdwell Banker Westburn Rlty. 604-437-1123V001473ûColdwell Banker - Perra Realty 604-970-9920V002960Wolfgang Isachsen 604-437-1123V13039wolfisachsen@hotmail.comwww.realtorwolf.com/ Kevin Perra 604-970-9920V18422email@kevinperra.comhttp://www.kevinperra.comûûûû-Garbage Pickup,Gardening,Hot Water,Management470.920.Pets Allowed w/Rest.,Rentals Allwd w/RestrctnsûûSouth2018-11-27 22:08:302018-09-10 18:55:032018-09-10 11:09:092018-12-02 20:44:322018-09-10 11:09:09Freehold Strataûûûûûû2211û4NoMain2YesMainûûûûûûûûûûûûûûûûûû1None21612'86'MainKitchen13'610'7MainMaster Bedroom13'911'10Main Living Room12'86'6Main Dining Room12'812'1MainBedroom18'14'MainPatioûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûûretsrets' can not be represented as java.sql.Timestamp
where (param 1) = [type='IN', class='java.lang.String', value='R2304516', sqltype='cf_sql_varchar']
/ListingDetail.htm at {ts '2019-02-15 10:57:19'}. Loop error messages
Try 1 error: Error Executing Database Query.||
Try 2 error: Error Executing Database Query.||
Try 3 error: Error Executing Database Query.||
Try 4 error: Error Executing Database Query.||
Application
We are having a problem retrieving the MLS® data from the MLS® database at the moment.


15-Feb-19 10:57 AM