Unknown column \'p.agent\' in \'on clause\' SQL=SELECT p.*, a.id AS agentid, a.name AS agent, a.user AS user, c.name AS company, c.id AS companyid, t.name AS type, p.type AS typeid \n FROM jos_hp_properties AS p, jos_hp_companies AS c\n LEFT JOIN jos_hp_agents AS a ON p.agent = a.id\n LEFT JOIN jos_hp_prop_types AS t ON p.type = t.id\n LEFT JOIN jos_hp_featured AS f ON f.property = p.id\n WHERE p.published=\'1\' AND p.approved=\'1\' AND t.published=\'1\'\n AND a.company=c.id\n AND (publish_up = \'0000-00-00 00:00:00\' OR publish_up <= NOW())\n AND (publish_down = \'0000-00-00 00:00:00\' OR publish_down >= NOW())\nAND p.featured=\'1\'\nORDER BY f.ordering ASC\nLIMIT 0, 5

Property Type	All Types Class A office space Class B office space Class C office space Industrial / Warehouse Retail Flex space Multi Family Land
Town	-Please select town- Abington Acton Allston Amesbury Andover Arlington Ashby Ashland Avon Ayer Bedford Bellingham Belmont Beverly Billerica Boston  -Allston  -Back Bay  -Bay Village  -Beacon Hill  -Brighton  -Charlestown  -Chinatown  -Dorchester  -Downtown  -East Boston  -Fenway  -Fort Hill  -Hyde Park  -Jamaica Plain  -Leather District  -Mattapan  -Mission Hill  -North End  -Roslindale  -Roxbury  -Seaport District  -South Boston  -South End  -Waterfront  -West End  -West Roxbury Braintree Bridgewater Brighton Brockton Brookline Burlington Cambridge Canton Carlisle Carver Charlestown Chelmsford Chelsea Cohasset Concord Dalton Danvers Dedham Deerfield Dorchester Dover Dracut Dunstable Duxbury East Bridgewater Essex Everett Foxboro Framingham Franklin Freetown Georgetown Gloucester Goshen Gosnold Greenfield Groton Groveland Hadley Halifax Hamilton Haverhill Hingham Holbrook Holliston Hopkinton Hudson Hull Ipswich Kingston Lakeville Lawrence Lexington Leyden Lincoln Littleton Lowell Lynn Lynnfield Malden Manchester Marblehead Marion Marlborough Marshfield Mattapan Mattapoisett Maynard Medfield Medford Medway Melrose Mendon Merrimac Methuen Middleborough Middleton Milford Millbury Millis Milton Montgomery Nahant Natick Needham New Ashford New Bedford New Braintree Newbury Newburyport Newton Norfolk North Andover North Attleborough North Reading Norwell Norwood Peabody Pelham Pembroke Pepperell Plainville Plymouth Plympton Quincy Randolph Reading Revere Rochester Rockland Rockport Roslindale Rowley Roxbury Salem Salisbury Saugus Savoy Scituate Sharon Sherborn Shirley Somerville Stoneham Stoughton Stow Sudbury Swampscott Tewksbury Topsfield Townsend Tyngsborough Wakefield Walpole Waltham Wareham Watertown Wayland Wellesley Wenham West Bridgewater West Newbury West Roxbury Westford Westhampton Westminster Weston Westwood Whitman Wilmington Winthrop Woburn Wrentham Yarmouth

© 2012 Casten Associates

Casten Associates specializes in commercial real estate transaction services including lease negotiations, property sales, investment transactions, appraisals, market research, valuation and site selection. Our brokers focus on the unique nature of the Greater Boston and Eastern Massachusetts market. Casten Associates provides an extensive range of comprehensive services to the real estate user, specializing in Industrial, Retail, Warehouse and Commercial Properties. Contact us and discover how our realtors can assist you.