Ming Tree, Realtors
707-445-4500   Email  

795 Underwood Drive, Trinidad, CA 95570 - Single Family Home

Sold Save to FavoritesSaved      


Description:

Fantastic Trinidad Ocean view home that also has a view of Trinidad Head. Great location in a cul-de-sac. Great Price. Won't last long. House does need some TLC.

All 28 Photos



Virtual Tour
Open Virtual Tour
Virtual Tour
Open Virtual Tour

Quick Facts

Bedrooms:
2
Baths:
1.5
Total Rooms:
6
Area:
1216 sq ft
Condition:
Fair
Year Built:
1975
Lot Size:
0.19 acres
Garage:
Attached 2 car
Asking Price:
Sold
Days on Market:
97
Listing Office:
Castle Realty
Listing Agent:
Craig Wanek
Contact:
Ming Tree, Realtors
707-445-4500

Have questions? Not finding what you want? Ask us and we'll find it for you!


    Interior Features:

  • Levels: 2 Story
  • Heating: Baseboard, Electric

    • Exterior Features:

  • Condition: Fair
  • Garage: 2, Attached
  • RV Parking: No

    • Lot Features:

  • Zoning: Single Family
  • Walk Score®: 46 Car-Dependent - Most errands require a car
  • Transit Score®: 23 Minimal Transit - It is possible to get on a bus
Coming Soon.

Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver]Connection reset by peer: socket write error
 
The error occurred in C:/inetpub/agent/listing_i_neighborhood.cfm: line 14
Called from C:/inetpub/agent/listing_i_neighborhood.cfm: line 1
Called from C:/inetpub/agent/listing_i_neighborhood.cfm: line 1
Called from C:/inetpub/agent/listing.cfm: line 362
Called from C:/inetpub/agent/listing.cfm: line 109
Called from C:/inetpub/agent/listing.cfm: line 1
Called from C:/inetpub/agent/listing_i_neighborhood.cfm: line 14
Called from C:/inetpub/agent/listing_i_neighborhood.cfm: line 1
Called from C:/inetpub/agent/listing_i_neighborhood.cfm: line 1
Called from C:/inetpub/agent/listing.cfm: line 362
Called from C:/inetpub/agent/listing.cfm: line 109
Called from C:/inetpub/agent/listing.cfm: line 1
 
12 : 		SELECT Name,CommunityID
13 : 		FROM Tbl_Blockgroups
14 : 		WHERE GID = #FK_BlockGroupID# AND Status=1
15 : 	</CFQUERY>
16 : 	<CFSET thisBlockGroupCommunityID = GetBlockGroupBoundary.CommunityID>
SQLSTATE   08S01
DATASOURCE   geo
SQL    SELECT Name,CommunityID FROM Tbl_Blockgroups WHERE GID = 33261 AND Status=1
Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   18.191.228.88
Referrer  
Date/Time   24-Apr-24 09:46 AM
Stack Trace
at cflisting_i_neighborhood2ecfm225324900._factor0(C:/inetpub/agent/listing_i_neighborhood.cfm:14) at cflisting_i_neighborhood2ecfm225324900._factor13(C:/inetpub/agent/listing_i_neighborhood.cfm:1) at cflisting_i_neighborhood2ecfm225324900.runPage(C:/inetpub/agent/listing_i_neighborhood.cfm:1) at cflisting2ecfm250739840._factor6(C:/inetpub/agent/listing.cfm:362) at cflisting2ecfm250739840._factor7(C:/inetpub/agent/listing.cfm:109) at cflisting2ecfm250739840.runPage(C:/inetpub/agent/listing.cfm:1) at cflisting_i_neighborhood2ecfm225324900._factor0(C:/inetpub/agent/listing_i_neighborhood.cfm:14) at cflisting_i_neighborhood2ecfm225324900._factor13(C:/inetpub/agent/listing_i_neighborhood.cfm:1) at cflisting_i_neighborhood2ecfm225324900.runPage(C:/inetpub/agent/listing_i_neighborhood.cfm:1) at cflisting2ecfm250739840._factor6(C:/inetpub/agent/listing.cfm:362) at cflisting2ecfm250739840._factor7(C:/inetpub/agent/listing.cfm:109) at cflisting2ecfm250739840.runPage(C:/inetpub/agent/listing.cfm:1) 

java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Connection reset by peer: socket write error
	at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddg.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.dda4.h(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1567)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1317)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1247)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794)
	at cflisting_i_neighborhood2ecfm225324900._factor0(C:\inetpub\agent\listing_i_neighborhood.cfm:14)
	at cflisting_i_neighborhood2ecfm225324900._factor13(C:\inetpub\agent\listing_i_neighborhood.cfm:1)
	at cflisting_i_neighborhood2ecfm225324900.runPage(C:\inetpub\agent\listing_i_neighborhood.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329)
	at cflisting2ecfm250739840._factor6(C:\inetpub\agent\listing.cfm:362)
	at cflisting2ecfm250739840._factor7(C:\inetpub\agent\listing.cfm:109)
	at cflisting2ecfm250739840.runPage(C:\inetpub\agent\listing.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:595)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	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:226)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:835)