SELECT property.* , address.street, address.city, address.county, address.state, address.zip, management.*, images.imgname, units.rent FROM property
LEFT OUTER JOIN address ON property.property_id = address.property_id
LEFT OUTER JOIN management ON property.property_id = management.property_id
LEFT OUTER JOIN images ON property.property_id = images.property_id
LEFT OUTER JOIN units ON property.property_id = units.property_id
WHERE status = '1' AND featured = '1' AND city = 'Woodbridge' AND state = 'NJ' AND (units.pos = '1' OR units.pos IS NULL) AND (images.pos='1' OR images.pos IS NULL)
SELECT * FROM property
LEFT OUTER JOIN (SELECT *,CONCAT(city,state) as citystate FROM address) a ON property.property_id = a.property_id
LEFT OUTER JOIN management ON property.property_id = management.property_id
LEFT OUTER JOIN amunit ON property.property_id = amunit.property_id
LEFT OUTER JOIN ambldng ON property.property_id = ambldng.property_id
LEFT OUTER JOIN amcomm ON property.property_id = amcomm.property_id
LEFT OUTER JOIN (SELECT * FROM images WHERE pos='1' OR pos IS NULL) images ON property.property_id = images.property_id
LEFT OUTER JOIN pets ON property.property_id = pets.property_id
WHERE status='1' AND featured='1' AND ((city IN ("Woodbridge","Fords","Iselin","Sewaren","Hopelawn","Perth Amboy","Avenel","Port Reading","Keasbey","Colonia","Metuchen","Rahway","Carteret","West Carteret","Menlo Park","Clark","South Amboy","Morgan","Laurence Harbor","Tremley Point","Winfield Park","Linden","Tremley","Edison","Scotch Plains","Parlin","South Plainfield","Garwood","Roselle","Westfield","Cranford","Sayreville","Fanwood","Roselle Park","Parkandbush","Bayway","Elmora","Highland Park","Cliffwood","Kenilworth","Elizabethport","South River","Piscataway","North Plainfield","Plainfield","Muhlenberg","North Elizabeth","New Brunswick","Mountainside","Keyport","Cliffwood Beach","Union Beach","Chestnut","Union Center","Union","Townley","Aberdeen","Matawan","Strathmore","Watchung","Betsytown","Peterstown","Elizabeth","Union Square","Springfield","Dunellen","Green Brook","Industrial Hillside","Hillside","Milltown","East Brunswick","Hazlet","Old Bridge","Middlesex","Berkeley Heights","Vauxhall","Keansburg","Ideal Beach","West Keansburg","East Keansburg","Murray Hill","New Providence","Weequahic","Millburn","Summit","Pamrapo","Bayonne","Bergen Point","Township of Irvington","Irvington","North Brunswick","South Bound Brook","Maplewood","Maplecrest","Warren","Cedar Beach","Port Monmouth","Spotswood","Zarepath","Somerset","East Millstone","Franklin Township","Middlebush","Morganville","Short Hills","Bound Brook","Newark","Stirling","Vailsburg","Chatham","Chatham Township","South Orange","Holmdel","Holmdel Village","Washington Park","Academy","Midtown","Helmetta","Wickatunk","Belford","Ironbound","Gillette","Millington","Martinsville","V A Hospital","Middletown","New Monmouth","North Middletown","Ellis Island","Greenville","Zarephath","Franklin Park","Harrison","East Newark","Green Village","Orange","Roseville","Leonardo","Manville","East Orange","Ampere","Doddtown","Madison","Monroe Township","Jamesburg","Monroe","South Brunswick","Dayton","New Vernon","Eatontown","Livingston","Bradevelt","Marlboro","Florham Park","West Orange","Town Center","Kendall Park","Jersey City","Arlington","South Kearny","West Arlington","Kearny","Basking Ridge","Five Corners","Liberty Corner","Lincroft","Atlantic Highlands","Navesink","Lyons","Tinton Falls","Westboro","Red Bank","Convent Station","Monmouth Junction","Bridgewater","Glen Ridge","Belleville","Millstone","Hillsborough","North Arlington","Montclair","Raritan","Roseland","Brookdale","Bloomfield","Grove","North Center","East Hanover","Fair Haven","Essex Fells","Gateway National Recreation","Sandy Hook","Highlands","Monmouth Hills","Tennent","Uptown","Washington Street","Castle Point","Hoboken","Pluckemin","Lyndhurst","Finderne","Somerville","Branchburg","South Branch","North Branch","Morristown","Englishtown","Manalapan","Belle Mead","Montgomery","Verona","Colts Neck","Vanderburg","Phalanx","Earle Naval Weapons Station","Nutley","Whippany","Secaucus","Bernardsville","West Caldwell","Caldwell","Shrewsbury") AND state='NJ') OR (city IN ("Staten Island","Fort Hamilton","Brooklyn","New York","Manhattan","Breezy Point","Rockaway Point","Far Rockaway") AND state='NY')) AND citystate!=CONCAT('Woodbridge','NJ')
Apartment Living Guide | Welcome
Featured Properties
Responsive Design
The Fast, Easy & Effective Way to Search
Now you can search for your new apartment faster and more efficient with Apartment Living Guide. Our new, completely redesigned website provides you an optimal viewing experience. We have incorporated the newest responsive web design technology to ensure our site is easy for you to use on all devices. Apartment Living Guide brings you the ideal solution for finding your next apartment...the way you want to search.
Property Type
+
Property Name
+
Location
+
Rent
+
Bedrooms
+
Pets
+
Amenities
+
Search
Favorites
