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 373
Home > Inventory > 2017 Nissan Frontier

2017 Nissan Frontier

VIN: 1N6AD0EV6HN750625
Stock: 26686

2017 Nissan Frontier

VIN: 1N6AD0EV6HN750625Stock: 26686

$14,995

$14,995

Images
9 Images

Vehicle Information

CONDITION
Pre-Owned

TRIM
SL Crew Cab 5AT 4WD

STOCK NUMBER
26686

MILEAGE
149,757 Miles

FUEL TYPE
Gasoline

TRANSMISSION
5A
Vehicle Features
  • ABS Brakes - Standard
  • AM/FM Radio - Standard
  • Air Conditioning - Standard
  • Alloy Wheels - Standard
  • Anti-Brake System - 4-Wheel ABS
  • Cargo Area Tiedowns - Standard
  • Child Safety Door Locks - Standard
  • Cruise Control - Standard
  • Dealer Invoice - $33,191
  • Destination Charge - $940
  • Driver Airbag - Standard
  • Driver Multi-Adjustable Power Seat - Standard
  • Electrochromic Interior Rearview Mirror - Standard
  • Fog Lights - Standard
  • Front Brake Type - Disc
  • Front Headroom - 39.90
  • Front Heated Seat - Standard
  • Front Hip Room - 55.60
  • Front Legroom - 42.40
  • Front Shoulder Room - 58.30
  • Front Side Airbag - Standard
  • Front Spring Type - Torsion Bar
  • Front Suspension - Ind
  • Ground Clearance - 8.90
  • Interval Wipers - Standard
  • Keyless Entry - Standard
  • Leather Steering Wheel - Standard
  • Manufactured in - UNITED STATES
  • Overall Height - 70.10
  • Overall Length - 205.50
  • Overall Width - 72.80
  • Passenger Airbag - Standard
  • Passenger Multi-Adjustable Power Seat - Standard
  • Power Door Locks - Standard
  • Power Sunroof - Opt.
  • Power Windows - Standard
  • Powertrain Duration - 60
  • Rear Brake Type - Disc
  • Rear Headroom - 38.60
  • Rear Hip Room - 58.00
  • Rear Legroom - 33.60
  • Rear Shoulder Room - 58.30
  • Rear Spring Type - Leaf
  • Rear Suspension - Live
  • Rear Window Defogger - Standard
  • Running Boards - Standard
  • Rust-distance - Unlimited
  • Rust-duration - 60
  • Separate Driver/Front Passenger Climate Controls - Standard
  • Side Head Curtain Airbag - Standard
  • Splash Guards - Opt.
  • Steering Type - Rack & Pinion
  • Steering Wheel Mounted Controls - Standard
  • Subwoofer - Standard
  • Tachometer - Standard
  • Tank - 21.10
  • Tilt Steering - Standard
  • Tire Pressure Monitor - Standard
  • Tires - P265/60R18
  • Traction Control - Standard
  • Trip Computer - Standard
  • Turning Diameter - 43.30
  • Vehicle Anti-Theft - Standard
  • Vehicle Stability Control System - Standard
  • Warranty Distance - 36,000
  • Warranty Distance - 60,000
  • Warranty Duration - 36
  • Wheelbase - 125.90
Dealer Information
Spa Auto Sales
2443 Albert Pike
Hot Springs, AR 71913
View Dealer Website
Vehicle Details
Pre-Owned 2017
Nissan Frontier

Internet Price:$14,995

VIN:1N6AD0EV6HN750625

Mileage:149,757 Miles

Stock Number:26686

Exterior Color:White

Transmission:5A

Engine:4.0L V6 DOHC 24V

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 373
Master
Philip
Luke

devserver.getbestusedcars.com
Master
Philip
Luke