this sql is right. its used for repeating properties.
SELECT Properties.PID, Properties.PName, Properties.PArea, Properties.PCategory, Properties.PPricepsqft, Properties.PMainimage, Properties.PPosition, Units.*
FROM Properties INNER JOIN Units ON Units.UnitPropertyID = Properties.PID GROUP BY Properties.PID ORDER BY Units.UnitName ASC, Units.UnitSize ASC