New Car Sales: 855-315-5241 Press 2
Pre-Owned Sales: 855-315-5241 Press 3
Service/Parts: 309-664-1222
query
RESULTSET
query
  BESTANDOR BESTCASH BESTRATE BESTTIME DTISTOPDATE LNGMODELYEAR LNGSPECIALCASH LNGTOTALCASH LNGTYPE PK_AUTSFINCENTIVEID PK_AUTSFINCENTIVESPECIALID TOTALREBATEOPPORTUNITY TXTMAKE TXTMODEL TXTSPECIALBODY TXTSPECIALQUALIFY TXTSPECIALRESTRICTIONS TXTSPECIALTITLE TXTVEHICLEHINTS TXTVEHICLEHINTSFOREXCLUSION
CACHED false
EXECUTIONTIME 16
SQL SELECT tblSFIncentives.PK_autSFIncentiveID, tblSFIncentives.txtMake, tblSFIncentives.txtModel, tblSFIncentives.lngModelYear, tblSFIncentives.lngTotalCash, tblSFIncentives.txtVehicleHints, tblSFIncentives.txtVehicleHintsForExclusion, tblSFIncentives.dtiStopDate, tblSFIncentiveSpecials.PK_autSFIncentiveSpecialID, tblSFIncentiveSpecials.txtSpecialTitle, tblSFIncentiveSpecials.lngSpecialCash, tblSFIncentiveSpecials.txtSpecialBody, tblSFIncentiveSpecials.txtSpecialQualify, tblSFIncentiveSpecials.txtSpecialRestrictions, tblSFIncentiveSpecials.lngType, tblSFIncentives.lngTotalCash + (SELECT SUM(S2.lngSpecialCash) FROM tblSFIncentiveSpecials S2 WHERE S2.FK_lngSFIncentiveID = tblSFIncentives.PK_autSFIncentiveID AND S2.ysnActive = 1 AND S2.lngType = 2) AS TotalRebateOpportunity, (SELECT TOP 1 tblSFIncentiveAPRs.lngTime FROM tblSFIncentiveAPRs WHERE tblSFIncentiveAPRs.FK_lngSFIncentiveID = tblSFIncentives.PK_autSFIncentiveID AND tblSFIncentiveAPRs.ysnActive = 1 ORDER BY tblSFIncentiveAPRs.txtValue, tblSFIncentiveAPRs.lngTime DESC) AS BestTime, (SELECT TOP 1 tblSFIncentiveAPRs.txtValue FROM tblSFIncentiveAPRs WHERE tblSFIncentiveAPRs.FK_lngSFIncentiveID = tblSFIncentives.PK_autSFIncentiveID AND tblSFIncentiveAPRs.ysnActive = 1 ORDER BY tblSFIncentiveAPRs.txtValue, tblSFIncentiveAPRs.lngTime DESC) AS BestRate, (SELECT TOP 1 tblSFIncentiveAPRs.lngCash FROM tblSFIncentiveAPRs WHERE tblSFIncentiveAPRs.FK_lngSFIncentiveID = tblSFIncentives.PK_autSFIncentiveID AND tblSFIncentiveAPRs.ysnActive = 1 ORDER BY tblSFIncentiveAPRs.txtValue, tblSFIncentiveAPRs.lngTime DESC) AS BestCash, (SELECT TOP 1 tblSFIncentiveAPRs.txtAndOR FROM tblSFIncentiveAPRs WHERE tblSFIncentiveAPRs.FK_lngSFIncentiveID = tblSFIncentives.PK_autSFIncentiveID AND tblSFIncentiveAPRs.ysnActive = 1 ORDER BY tblSFIncentiveAPRs.txtValue, tblSFIncentiveAPRs.lngTime DESC) AS BestAndOr FROM tblSFIncentives LEFT JOIN tblSFIncentiveSpecials ON tblSFIncentives.PK_autSFIncentiveID = tblSFIncentiveSpecials.FK_lngSFIncentiveID AND tblSFIncentiveSpecials.ysnActive = 1 AND tblSFIncentiveSpecials.lngType = 2 LEFT JOIN tblSFIncentiveCodeLink ON tblSFIncentives.PK_autSFIncentiveID = tblSFIncentiveCodeLink.FK_lngSFIncentiveID AND tblSFIncentiveCodeLink.txtStyleID = '0' WHERE tblSFIncentives.FK_lngDealerID = '27' AND tblSFIncentives.lngModelYear = '2009' AND tblSFIncentives.txtMake = 'Hyundai' AND (tblSFIncentiveCodeLink.txtStyleID IS NOT NULL OR ( tblSFIncentives.lngModelYear = '2009' AND tblSFIncentives.txtMake = 'Hyundai' AND ( tblSFIncentives.txtModel = 'Santa Fe' OR ( (tblSFIncentives.txtVehicleHints LIKE '%MODEL:Santa Fe,%' OR tblSFIncentives.txtVehicleHints LIKE '%MODEL:Santa Fe}%') AND ( tblSFIncentives.txtVehicleHints LIKE '%TRIM:%' OR ( tblSFIncentives.txtVehicleHints NOT LIKE '%TRIM:%' AND tblSFIncentives.txtVehicleHintsForExclusion NOT LIKE '%TRIM:%' ) ) ) ) ) ) AND tblSFIncentives.ysnActive = 1 AND tblSFIncentives.dtiStopDate >= Convert(DateTime, Floor(Convert(Float, getdate()))) ORDER BY tblSFIncentives.txtMake, tblSFIncentives.lngModelYear DESC, tblSFIncentives.txtModel

2009 Hyundai Santa Fe $11,400

2009 Hyundai Santa Fe
Internet Price: $11,400
Style/Trim: 
Exterior: Pearl White
Interior: Gray
Mileage: 80,352 Miles
Engine: 3.3L V6 DOHC
Transmission: 5-Speed Automatic with Shiftronic
Drivetrain: AWD
Stock: H255496A
VIN: 5NMSH73EX9H267693
Request a Quote Schedule a Test Drive
O'Brien Hyundai of Normal
600 Greenbriar Drive
Normal, IL 61761

Steve Bowers
sbowers@obrienteam.com
Call 855-315-5241 option 3
Estimate Your Payment
CARFAX One-Owner. White 2009 Hyundai Santa Fe AWD 5-Speed Automatic with Shiftronic 3.3L V6 DOHC This car is dressed to impress with the following features: 4-Wheel Disc Brakes w/ABS, Automatic Headlights, Brake assist, Electronic Stability Control, Four wheel independent suspension, Heated Mirrors, Popular Equipment Package, Steering Wheel Audio Controls, Steering wheel mounted audio controls, Tire Pressure Monitoring System, Trip Computer.Recent Arrival! Odometer is 11249 miles below market average!
CITY MPG:
N/A
HWY MPG:
N/A
Actual rating will vary with options, driving conditions, habits and vehicle condition.
Apply for Credit Online
Leave this field empty
Request a Quote
Leave this field empty
Learn More About This Model
Leave this field empty
View Additional Photos and Color Options Print Vehicle Information » View Optional Features

Optional Features

Please contact dealer for equipment and details.
Gas Calculator

Schedule Test Drive
Leave this field empty
Request More Information
Leave this field empty
Email Vehicle Information Value Your Trade »

Our Pre-Owned Promise

Used cars inspected ... reconditioned ... certified and given our seal of approval

  • Great Price: Every used car we sell comes with our great price! We determine the price by reviewing online resources, such as KBB, surveying the used vehicle market and then we beat those prices.
  • Quality Vehicles: The majority of our pre-owned cars, trucks, vans and SUVs are fresh, local, trades from right here in our county -- no repos or auction clunkers, these are top quality vehicles.
  • Quality Inspection: Buy with confidence with our "No Exception Inspection." Every used car we sell goes through a comprehensive 72-point inspection with a certified ASE technician.
  • Extended Protection: Pre-Owned Vehicles are eligible for extended warranties of up to seven years or 100,000 miles
No Standard Feature information available for this vehilcle. Please contact the dealer for more information.

Prices

All advertised prices exclude government fees and taxes, any finance charges, any dealer document preparation charge, and any emission testing charge. All vehicles are subject to prior sale. We strive for accuracy, but this pricing information may be different from actual dealer price. Price includes VIP and Loyalty rebates in lieu of special financing. Please check with dealer for actual pricing and availability. Not responsible for typographical errors or other errors. We strive for accuracy, but the equipment and options shown may be different than what is actually on the vehicle. We are not responsible for missing equipment and options, incorrect prices or other errors.

Estimated Payment

Payments calculated at $3000 down, 72 month term at 3.9% APR. With approved Credit. Subject to qualification. Not all buyers will qualify. See dealer for details

Pictures

Graphics are representational only. All photos may not depict actual vehicles and may be a stock photo provided by manufacturer or other third party.

Rebates, Special Offers and Financing

Credit approval based on lender criteria, not all customers will qualify. The payment calculator is only to give you a comparison. The calculated payment may not be your actual payment. All terms and rates are subject to lender credit approval. Some rates and rebates are subject to Special offers are time sensitive and may be limited to specified vehicles and not all customer will qualify. All manufacturer rebates applied in lieu of special financing. Price includes VIP and Loyalty rebates in lieu of special financing. Not all customers will qualify. Check with dealer for verification.