[an error occurred while processing this directive] <% Set conn = Server.CreateObject("ADODB.Connection") conn.ConnectionString = "DRIVER=SQL Server;server=localhost;uid=rwsql;pwd=sql2tdst;database=realtyworks;" conn.Open %> Home page - Connecticut real estate from realty works, one of the leading real estate agencies in north western connecticut, realtors in connecticut and the farmington valley
Realty Works LLC

Serving and giving back to the area since the turn of the century

About Realty Works
Find A Home
Selling Your Home
Open House Schedule
Home Buyers Toolbox
Contact Us

Your Source for All Real Estate Needs

Collinsville Factory
Realty Works is the exclusive sales and marketing company for the Collinsville Factory. Find out more about this exciting retail, commercial, and residential opportunity.

Learn More


<% set rsd = conn.execute("select * from revised") %> Listings current as of: <%= rsd("thedate") %> <% rsd.close set rsd = nothing %>

Welcome

Click here to learn about a unique
real estate opportunity.
Learn More

What's Inside


Find a house easily with the world’s largest database of homes for sale.
Learn More


Learn about the home buying process with our informative Home Buyer Toolbox.
Learn More
Sign up to be automatically notified by e-mail the moment a property matching your needs is listed.
Learn More
See how Realty Works can sell your home quickly and at the maximum market price.
Learn More


Home of the Day

<% set rs = conn.execute("select * from listings where showable='y' and active='y' order by firstdate desc") sql = "select * from pictures where houseID = " & rs("id") & " order by [default] desc" set rspic = server.createobject("adodb.recordset") rspic.open sql,conn,3 if not rsPic.eof then %>

<% else %>
<% end if %>
<%= rs("city") %>, <%= rs("state") %>
<%= formatcurrency(rs("price"),0) %>

<%= rs("description") %>

Learn More
<% if rspic.recordcount > 1 then %>

&image=<%= rsPic("id") %>' ,'slide',300,340)"> &image=<%= rsPic("id") %>' ,'slide',300,340)" class=body>Click here to view slide show. <% end if %>







<% rs.close set rs = nothing rspic.close set rspic = nothing conn.close set conn = nothing %>