Walk to Ryder Security Entrance (Property ID: 1771)



Event Leasing

Front of House

Event Leasing

Lounge


Event Leasing

Lounge

Event Leasing

Lounge Access to decked patio garden


Event Leasing

Master bedroom with ensuite shower room

Event Leasing

TV and DVD in all bedrooms


Event Leasing

Fully integrated kitchen

Event Leasing

Dining Area in Kitchen




SELECT PHOTO_ID,PHOTO,CAPTION FROM photos WHERE PHOTO!='' AND PROPERTY_ID='1771' AND STATUS='GO' ORDER BY MAINPHOTO DESC
SELECT properties.PROPERTY_ID,properties.ADVERT_TITLE,properties.EVENTLEASING_URL,properties.PROPERTY_CITY,properties.PROPERTY_COUNTY,properties.PROPERTY_COUNTRY,properties.ACCOUNT_TYPE,events.EVENT_TXTID FROM properties INNER JOIN events ON properties.EVENT_ID=events.EVENT_ID WHERE properties.STATUS='ONLINE' AND properties.EVENTLEASING_URL='walk-to-park-and-ride' AND properties.DATE_EXPIRATION>=CAST(NOW() as DATETIME) LIMIT 1