Error: SELECT c.*, f.aws_url, w.html, f.width, f.height, f.breakpoints FROM columns_breakdown `c` LEFT JOIN widgets `w` ON c.widget_id = w.id AND c.widget_type != 'none' LEFT JOIN files `f` ON c.widget_id = f.widget_id AND (c.widget_type = 'image' OR c.widget_type = 'video') WHERE c.endpoints_id = '1' AND c.access_level IN ('Everyone') AND c.active = 'Yes' ORDER BY c.parent_id, c.row_num, c.sort_order;
Table 'master_bigtime.columns_breakdown' doesn't exist

Warning: Attempt to read property "num_rows" on bool in /home/philip/public_html/modules/dynamic_pages/class.dynamic_pages.php on line 366

2007 Hummer H2

VIN: 5GRGN23U17H110429
Stock: 25012

2007 Hummer H2

VIN: 5GRGN23U17H110429Stock: 25012

$24,999

$24,999

Images

Vehicle Information

CONDITION
New

TRIM
Adventure

STOCK NUMBER
25012

MILEAGE
141,459 Miles

FUEL TYPE
Gasoline

TRANSMISSION
4-Speed Automatic Overdrive
Vehicle Description

New Tires, Rebuilt transmission w/ warranty. Above average condtion. Nice!!!

Vehicle Features
  • 4WD/AWD - Standard
  • ABS Brakes - Standard
  • AM/FM Radio - Standard
  • Air Conditioning - Standard
  • Alloy Wheels - Standard
  • Anti-Brake System - 4-Wheel ABS
  • Automatic Headlights - Standard
  • Automatic Load-Leveling - Standard
  • CD Changer - Standard
  • CD Player - Standard
  • Cargo Length - 37.30
  • Cassette Player - Standard
  • Child Safety Door Locks - Standard
  • Chrome Wheels - Opt.
  • Cruise Control - Standard
  • Curb Weight-automatic - 6400
  • DVD Player - Opt.
  • Daytime Running Lights - Standard
  • Dealer Invoice - $50,258
  • Deep Tinted Glass - Standard
  • Destination Charge - $900
  • Driver Airbag - Standard
  • Driver Multi-Adjustable Power Seat - Standard
  • Electrochromic Exterior Rearview Mirror - Standard
  • Electrochromic Interior Rearview Mirror - Standard
  • Electronic Parking Aid - Opt.
  • First Aid Kit - Standard
  • Fog Lights - Opt.
  • Front Brake Type - Disc
  • Front Headroom - 40.50
  • Front Heated Seat - Standard
  • Front Hip Room - 62.90
  • Front Legroom - 41.30
  • Front Power Lumbar Support - Standard
  • Front Power Memory Seat - Standard
  • Front Shoulder Room - 66.40
  • Front Spring Type - Torsion Bar
  • Front Suspension - Ind
  • Full Size Spare Tire - Standard
  • Ground Clearance - 9.90
  • Heated Exterior Mirror - Standard
  • Interior Trim - Wheat Leather Interior
  • Interval Wipers - Standard
  • Keyless Entry - Standard
  • Leather Seat - Standard
  • Leather Steering Wheel - Standard
  • Load Bearing Exterior Rack - Standard
  • Locking Differential - Standard
  • Manual Sunroof - Opt.
  • Manufactured in - UNITED STATES
  • Maximum GVWR - 8600
  • Maximum Payload - 2200
  • Maximum Towing - 6700
  • Navigation Aid - Opt.
  • Optional Seating - 6
  • Overall Height - 79.20
  • Overall Length - 189.80
  • Overall Width - 81.20
  • Passenger Airbag - Standard
  • Passenger Multi-Adjustable Power Seat - Standard
  • Power Adjustable Exterior Mirror - Standard
  • Power Door Locks - Standard
  • Power Sunroof - Opt.
  • Power Windows - Standard
  • Powertrain Duration - 60
  • Rear Brake Type - Disc
  • Rear Headroom - 39.70
  • Rear Hip Room - 62.00
  • Rear Legroom - 38.60
  • Rear Shoulder Room - 66.30
  • Rear Spring Type - Coil
  • Rear Suspension - Live
  • Rear Window Defogger - Standard
  • Rear Wiper - Standard
  • Running Boards - Opt.
  • Rust-distance - 100,000
  • Rust-duration - 72
  • Second Row Folding Seat - Standard
  • Second Row Heated Seat - Standard
  • Second Row Sound Controls - Standard
  • Separate Driver/Front Passenger Climate Controls - Standard
  • Skid Plate - Standard
  • Standard GVWR - 8600
  • Standard Payload - 2200
  • Standard Towing - 6700
  • Steel Wheels - Opt.
  • Steering Type - Recirc
  • Steering Wheel Mounted Controls - Standard
  • Tachometer - Standard
  • Tank - 32.00
  • Telematics System - Standard
  • Third Row Removable Seat - Opt.
  • Tilt Steering - Standard
  • Tilt Steering Column - Standard
  • Tires - 315/70R17
  • Tow Hitch Receiver - Standard
  • Towing Preparation Package - Opt.
  • Track Front - 69.40
  • Track Rear - 69.40
  • Traction Control - Standard
  • Trip Computer - Standard
  • Turning Diameter - 43.50
  • Vehicle Anti-Theft - Standard
  • Voice Activated Telephone - Standard
  • Warranty Distance - 100,000
  • Warranty Distance - 50,000
  • Warranty Duration - 48
  • Wheelbase - 122.80
  • Width at Wall - 67.60
  • Width at Wheelwell - 46.00
Dealer Information
Gerald Wetzel Motors

1030 S. 22nd St.
Bismarck, ND 58504

View Dealer Website
Vehicle Details
New 2007
Hummer H2

Internet Price:$24,999

VIN:5GRGN23U17H110429


Mileage:141,459 Miles


Stock Number:25012


Transmission:4-Speed Automatic Overdrive


Engine:6.0L V8 OHV 16V

Ask About This Vehicle
Error: SELECT c.*, f.aws_url, w.html, f.width, f.height, f.breakpoints FROM columns_breakdown `c` LEFT JOIN widgets `w` ON c.widget_id = w.id AND c.widget_type != 'none' LEFT JOIN files `f` ON c.widget_id = f.widget_id AND (c.widget_type = 'image' OR c.widget_type = 'video') WHERE c.endpoints_id = '2' AND c.access_level IN ('Everyone') AND c.active = 'Yes' ORDER BY c.parent_id, c.row_num, c.sort_order;
Table 'master_bigtime.columns_breakdown' doesn't exist

Warning: Attempt to read property "num_rows" on bool in /home/philip/public_html/modules/dynamic_pages/class.dynamic_pages.php on line 366
Master
Philip
Luke

devserver.getbestusedcars.com
Master
Philip
Luke