<%@ Language=VBScript %> <% Set DataConn = Server.CreateObject("ADODB.Connection") DataConn.Open Application("sr_ConnectionString"), Application("sr_RuntimeUserName"), Application("sr_RuntimePassword") Set cmdTemp = Server.CreateObject("ADODB.Command") Set dcomU = Server.CreateObject("ADODB.Recordset") cmdTemp.CommandText = "SELECT * From userreal WHERE statcont = 'Y' AND statuser = 'Y' ORDER BY sortcont DESC" cmdTemp.CommandType = 1 Set cmdTemp.ActiveConnection = DataConn dcomU.Open cmdTemp, , 1, 1 Set cmdTemp = Server.CreateObject("ADODB.Command") Set dcomR = Server.CreateObject("ADODB.Recordset") cmdTemp.CommandText = "SELECT * From contreal" cmdTemp.CommandType = 1 Set cmdTemp.ActiveConnection = DataConn dcomR.Open cmdTemp, , 0, 1 %>

	Since its establishment, SHOEN has been expanding its global network of investors, pre-qualified customers as well as exclusive landlords of various types of properties. SHOEN covers a wide range of areas throughout tristate New York and Fairfield County in Connecticut. Experienced brokers and agents can provide you extensive & quality listings through various multiple listing services. Please see Our Listings In search of Apartments, Condominiums, Co-ops, Townhouses, Single Family Houses, Multiple Family Houses, and Commercial Properties from temporary, short-term to long-term rental, lease and purchase properties. SHOEN provides various services in prior to an actual relocation including finding a temporary rental apartment in the most convenient location to your office while searching for your permanent "dream house" for either renting or purchasing. Please see Corporate Relocation Services We refer you a number of pre-qualified tenants from our global network. Including full consultation and assistance in selling your property and purchasing property with our mark-to-market real estate property analysis. Please feel free to fill out our Appraisal Request Form in the List Your Property.
(c) 2003 All rights reserved. Shoen Realty Inc.