Ref # DZ18402
Need to Hire Ag Equipment? in Port macquarie
Find reputable suppliers near you
For assistance call 1300 156 789 | Click here for detailed quote request
Agricultural Equipment Hire Hire Port Macquarie NSW 2444
Do you need to hire agricultural equipment and are looking for a few quick and easy quotes? If yes, Dry Hire Online can help you! Agricultural Equipment includes a large variety of machines including tractors, ploughs, cultivators, and more.
These machines all help maintain or prepare land and/or crops for agricultural and farming work. To get quotes contact the suppliers listed below to get direct quotes, alternatively you can fill out this form or call DHO on 1300 156 789
SELECT cl.id,cl.user_id, cl.suspended_id, cl.deleted,cl.loc_suburbtown,cl.loc_state, cl.title, cl.title_url, cl.featured,cl.description, cl.safetyfeatures, cl.units, cl.images, cl.actual_machine, cl.noimagefolder, cl.noimagesaved, cl.show_machine, cl.image_order, cl.images, cl.phone1, cl.phone2, cl.email,cl.attachments, cl.contractor, cl.url,pd.suburb,pd.state, pd.id as postcodeid, ll.id as listinglocid, (
6371 *
acos(
cos(radians(152.908481)) *
cos(radians(pd.lon)) *
cos(radians(-31.434259) - radians(pd.lat)) +
sin(radians(152.908481)) *
sin(radians(pd.lon))
)) as distanceSort , CONVERT( 6371 *
acos(
cos(radians(152.908481)) *
cos(radians(pd.lon)) *
cos(radians(-31.434259) - radians(pd.lat)) +
sin(radians(152.908481)) *
sin(radians(pd.lon))
) , UNSIGNED INTEGER) as distInt FROM directory_listing cl JOIN framework_user fu ON cl.user_id = fu.id AND fu.deleteduser = 0 JOIN listings_locations ll ON cl.id = ll.listing_id JOIN postcode_db pd ON ll.location_id = pd.id JOIN directory_listing_category clc ON clc.category_id IN (1) AND clc.listing_id = cl.id WHERE cl.wantedadd is null AND cl.contractor = 0 AND (cl.approved = 1 AND cl.deleted = 0) ORDER BY (case when cl.featured > 0 AND cl.deleted = 0 and DistanceSort < 100
then distInt else 100
end),
distInt, fu.suspended, fu.paid DESC LIMIT 0, 20
Ref # DZ18905
Ref # DZ18402
Ref # DZ18905
Ref # DZ28498
Ref # DZ12699
Ref # DZ06812
Ref # DZ06877
Ref # DZ27037
Ref # DZ18402
Ref # DZ18905
Ref # DZ26053
Ref # DZ29844
Ref # DZ29795
Ref # DZ15821
Ref # DZ07340
Ref # DZ19232
Ref # DZ19233
Ref # DZ15821
Ref # DZ22768
