WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tandem reefer' AND TNT_vShared.did = '25' AND TNT_vShared.list != 'P' at line 15]
SELECT TNT_vShared.*, TNT_vShared.iid AS vid, TNT_vShared.vscseo as scseo, TNT_vShared.vscweb as scweb, TNT_vShared.vpl as pl, DATEDIFF(CURDATE(), TNT_vShared.edate) AS ddif,dpcity,dpstate FROM (TNT_vShared) LEFT JOIN TNT_dealers ON TNT_dealers.did = TNT_vShared.did WHERE LOWER(make) = 'great dane' AND LOWER(model) = '48' tandem reefer' AND TNT_vShared.did = '25' AND TNT_vShared.list != 'Private' AND TNT_vShared.iid NOT IN('259081') AND TNT_vShared.photo = 1 AND dstatus='On' AND dplock!='Yes' AND dphide!='Yes' AND CURDATE() <= TNT_vShared.endate ORDER BY TNT_vShared.iid DESC LIMIT 0,8

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tandem reefer' AND TNT_vShared.list != 'Private' AND TNT_vShared' at line 15]
SELECT TNT_vShared.*, TNT_vShared.iid AS vid, TNT_vShared.vscseo as scseo, TNT_vShared.vscweb as scweb, TNT_vShared.vpl as pl, DATEDIFF(CURDATE(), TNT_vShared.edate) AS ddif,dpcity,dpstate FROM (TNT_vShared) LEFT JOIN TNT_dealers ON TNT_dealers.did = TNT_vShared.did WHERE LOWER(make) = 'great dane' AND LOWER(model) = '48' tandem reefer' AND TNT_vShared.list != 'Private' AND TNT_vShared.iid NOT IN('259081','632393','259165','259124','259110','258967','258803') AND TNT_vShared.photo = 1 AND dstatus='On' AND dplock!='Yes' AND dphide!='Yes' AND CURDATE() <= TNT_vShared.endate ORDER BY TNT_vShared.iid DESC LIMIT 0,8

2003 GREAT DANE 48' TANDEM REEFER REEFER TRAILER FOR SALE #259081 | NY
TRUCK 'N TRAILER MAGAZINE
SERVING THE TRUCKING, CONSTRUCTION AND RELATED INDUSTRIES SINCE 1966

2003 Great Dane 48' Tandem Reefer Reefer Trailer for sale in SPARROW BUSH, NY

2003 Great Dane 48' Tandem Reefer Suspension: 4 spring Tires: 22.5LP rubber Rims: 10 bolt hub pilot Length: 48' Width: 102" Height: 13'2" GVW: 68,000lbs Floor Composition: aluminum Trailer Composition: aluminum Doo... read more

TRAILER / REEFER TRAILER / GREAT DANE REEFER TRAILERS / 48' TANDEM REEFER / 2003 Great Dane 48' Tandem Reefer #259081
2003 GREAT DANE 48' TANDEM REEFER REEFER TRAILER #259081
2003 GREAT DANE 48' TANDEM REEFER REEFER TRAILER #259081-
2003 GREAT DANE 48' TANDEM REEFER REEFER TRAILER #259081-
2003 GREAT DANE 48' TANDEM REEFER REEFER TRAILER #259081-
2003 GREAT DANE 48' TANDEM REEFER REEFER TRAILER #259081-

2003 Great Dane 48' Tandem Reefer Description

Suspension: 4 spring
Tires: 22.5LP rubber
Rims: 10 bolt hub pilot
Length: 48'
Width: 102"
Height: 13'2"
GVW: 68,000lbs
Floor Composition: aluminum
Trailer Composition: aluminum
Door Type: swing
Reefer Details: Isuzu 4 cyl diesel mech - runs well
Added Details: air brakes, 3 driver side swing doors
Payment & Affordability Calculator

 Payment

 Length (Term)

 APR

 Financed

 Down

Specifications
Price$6,900
Stock #0227143
VIN/SerialVIN not Provided
AxlesTandem
SuspensionSpring Ride
Tires22.5LP
Dimensions102"W, 48.0'L
Rear Door TypeSwing
Side Door TypeSwing Roadsi
Floor TypeAluminum
Body TypeAluminum

Similar Units

$6,900
1997 GREAT DANE 7811TZ-1P 50.6 REEFER TRAILER #632393
Used 1997 Great Dane 7811TZ-1P 50.6
Great Dane Reefer Trailer
SPARROW BUSH, NY
$9,900
2004 GREAT DANE 7211 TZ-2B REEFER TRAILER #259165
Used 2004 Great Dane 7211 TZ-2B
Great Dane Reefer Trailer
SPARROW BUSH, NY
$7,900
2005 GREAT DANE 48' TANDEM REEFER REEFER TRAILER #259124
Used 2005 Great Dane 48' Tandem Reefer
Great Dane Reefer Trailer
SPARROW BUSH, NY
$7,900
2005 GREAT DANE 48' TANDEM REEFER REEFER TRAILER #259110
Used 2005 Great Dane 48' Tandem Reefer
Great Dane Reefer Trailer
SPARROW BUSH, NY
$7,900
2005 GREAT DANE 48' TANDEM REEFER REEFER TRAILER #258967
Used 2005 Great Dane 48' Tandem Reefer
Great Dane Reefer Trailer
SPARROW BUSH, NY
$6,900
1998 UTILITY TRAILER US2P REEFER TRAILER #258803
Used 1998 Utility Trailer US2P
Utility Trailer Reefer Trailer
SPARROW BUSH, NY
Call For Price
2017 GREAT DANE REEFER TRAILER #732761
Used 2017 GREAT DANE
GREAT DANE Reefer Trailer
ALLENTOWN, PA
Call For Price
2017 GREAT DANE REEFER TRAILER #732744
Used 2017 GREAT DANE
GREAT DANE Reefer Trailer
ALLENTOWN, PA
Call For Price
2017 GREAT DANE REEFER TRAILER #732473
Used 2017 GREAT DANE
GREAT DANE Reefer Trailer
ALLENTOWN, PA
Call For Price
2017 GREAT DANE REEFER TRAILER #732213
Used 2017 GREAT DANE
GREAT DANE Reefer Trailer
ALLENTOWN, PA
Call For Price
2004 GREAT DANE REEFER TRAILER #731999
2004 Great Dane
Great Dane Reefer Trailer
MANHATTAN, KS
Call For Price
2004 GREAT DANE 8711TZ-1A53 REEFER TRAILER #731994
2004 Great Dane 8711TZ-1A53
Great Dane Reefer Trailer
MANHATTAN, KS
Call For Price
2007 GREAT DANE REEFER TRAILER #728302
Used 2007 GREAT DANE
GREAT DANE Reefer Trailer
JESSUP, PA
Call For Price
2008 GREAT DANE REEFER TRAILER #724871
2008 Great Dane
Great Dane Reefer Trailer
MANHATTAN, KS
Call For Price
2017 UTILITY REEFER TRAILER #733844
Used 2017 UTILITY
UTILITY Reefer Trailer
VOORHEES, NJ
Call For Price
2017 UTILITY REEFER TRAILER #733843
Used 2017 UTILITY
UTILITY Reefer Trailer
ELKTON, MD