You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by s.PRICE asc ) a left join REI_DB_PROPERTY b on b.ID = a.NEIGHBORHOODID' at line 3 - Execute Query False! select a.*,b.NAME_EN as BEDROOMSIZE from (select a.*,b.NAME_EN as NEIGHBORHOODNAME from (select p.* from REI_OP_PROPERTY p,REI_OP_STATISTICS s,users u where s.PROPERTYID = p.PROPERTYID and u.username = s.AGENTID and s.RENATALORSALE = 's' and u.id = order by s.PRICE asc ) a left join REI_DB_PROPERTY b on b.ID = a.NEIGHBORHOODID) a left join REI_DB_PROPERTY b on b.ID = a.BEDROOMS

Error Track

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by s.PRICE asc ) a left join REI_DB_PROPERTY b on b.ID = a.NEIGHBORHOODID' at line 3 - Execute Query False! select a.*,b.NAME_EN as BEDROOMSIZE from (select a.*,b.NAME_EN as NEIGHBORHOODNAME from (select p.* from REI_OP_PROPERTY p,REI_OP_STATISTICS s,users u where s.PROPERTYID = p.PROPERTYID and u.username = s.AGENTID and s.RENATALORSALE = 'r' and u.id = order by s.PRICE asc ) a left join REI_DB_PROPERTY b on b.ID = a.NEIGHBORHOODID) a left join REI_DB_PROPERTY b on b.ID = a.BEDROOMS

REIG | Our Company
Name  : 
Office  : 
Cell  : 
Fax  : 
Email  : 
Gramercy /
BACK

large image

Web ID: W10448
Price: $ 4,495
Bedrooms: 1 BR/Conv 2
Bathrooms: 1.0
SQ Ft:850
Era: New Development
Access: Doorman
Pets: Yes
Sublets: Yes
Amenities: Pets Allowed, Terrace, Roof Deck / Sundeck, Laundry Facilities
Stunning Park Ave luxury rental in a new fulltime doorman building. The renovations are beautiful condo quality. Gorgeous new kitchen and bath. The space in the living room is large enough to convert into a second bedroom. There is a private roofdeck that adds an outdoor paradise to this already amazing apartment.