SELECT p.id, p.owner, p.title, p.featured, p.section, p.shortDescription, p.description, p.price, p.dateadded, p.expiration, p.display, p.pHighlighted, p.pBold, p.hitcount, p.url, u.username, u.state, u.city, u.country, u.extra, u.extra2, u.extra3 ,store.sTitle,store.sDescription,store.sImage FROM class_listings AS p LEFT JOIN class_users AS u ON p.owner = u.id LEFT JOIN class_store AS store ON (p.owner = store.sUserId) LEFT JOIN states on u.state = states.name LEFT JOIN suburbs ON (u.city=suburbs.name AND suburbs.state=states.id)  WHERE 1=1 AND p.price BETWEEN '0' AND '99999999999' AND p.expiration > NOW() AND p.display != "N" AND p.display != "S"AND suburbs.lat < -37.391308832254 AND suburbs.lat > -38.290629167746 AND suburbs.lng < 145.54443137946 AND suburbs.lng > 144.40564262054  GROUP BY p.id, p.owner, p.title, p.featured, p.section, p.description, p.dateadded, p.expiration, u.state, u.city, u.country ORDER BY featured desc, dateadded DESC
Free Stuff - Giveaway & Freecycle - Freebies Australia - Ziilch
FREE
Shelving units

Shelving units

Croydon, Victoria
FREE
IKEA round side table

IKEA round side table

Balwyn, Victoria
FREE
Moving interstate! Can't take it all

Moving interstate! Can't take it all

Seddon, Victoria
FREE
Alarm PIR sensors

Alarm PIR sensors

St Kilda East, Victoria
FREE
HP Laserjet 3100 multi function unit

HP Laserjet 3100 multi function unit

St Kilda East, Victoria
FREE
Three seater sofa

Three seater sofa

Fitzroy North, Victoria
FREE
Wooden bed (queen)

Wooden bed (queen)

Fitzroy North, Victoria
FREE
Silicon cake trays

Silicon cake trays

Melbourne, Victoria
NEEDED

TOP FOR SLOW COOKER

l have a 6L slow cooker
is a target brand, works fine, due to disability l have dropped the top and broken it, just...
TOP FOR SLOW COOKER

More Info

Mitcham, Victoria
FREE
Silicon cake trays

Silicon cake trays

Melbourne, Victoria
Stay up to date about FREE Stuff!