query("SELECT * FROM cars WHERE status = 'approved' AND badge = 'Hot Deal' LIMIT 3"); $hotDeals = $stmt->fetchAll(); // Get 6 recent approved cars $stmt = $pdo->query("SELECT * FROM cars WHERE status = 'approved' ORDER BY created_at DESC LIMIT 6"); $recentCars = $stmt->fetchAll(); ?>
ESTABLISHED 2026 | ENTERPRISE EDITION

Your Trusted Automotive Partner in Afghanistan.

Experience the next generation of car buying. Verified listings, secure digital payments simulation, and national support.

Explore Market Sell Your Car

🔥 Hot Deals

Unbeatable prices on premium vehicles.

...
HOT DEAL
$
View Deal

Recently Added

Stay updated with the latest arrivals in our market.

View All
...
Location: km
$ Details