Thanks Jason.
It looks like Area is not carrying over to the query?
Here is the results:
SELECT InternationProps.intpropID, InternationProps.DateAdded, InternationProps.SearchType, InternationProps.PropertyTYPE, InternationProps.PROPERTYREFERENCE, InternationProps.Title, InternationProps.Country, InternationProps.Description, InternationProps.Area, PropTypeInternation.IntPropTypeID, PropTypeInternation.TypeName, InternationProps.Area, InternationProps.Kitchen, InternationProps.Bedrooms, InternationProps.Bathrooms, InternationProps.Office, InternationProps.Gararge, InternationProps.Rooms, InternationProps.Shower, InternationProps.LivingSpace, InternationProps.Price, InternationProps.RentalPrice, InternationProps.LivingArea, InternationProps.OtherRooms, InternationProps.KitchenEquipment, InternationProps.ElectricalEquipment, InternationProps.OtherEquipment, InternationProps.Windows, InternationProps.Flooring, InternationProps.Walls, InternationProps.Services, InternationProps.OtherServices, InternationProps.LanguageSopken, InternationProps.Ceiling, InternationProps.AgentContact, InternationProps.DisplayOnSite, InternationProps.OrderLabel, InternationProps.GoogleMap, InternationProps.MainPhoto FROM InternationProps INNER JOIN PropTypeInternation ON InternationProps.PropertyTYPE = PropTypeInternation.IntPropTypeID WHERE DisplayOnSite = '1' AND (Country = 'France') AND (SearchType = 'Rental') AND (Area = 0) ORDER BY OrderLabel DESC