What cars are hot in Victoria?

I just got back from a month abroad, and I wonder if I’ve forgotten how to code. I ask around the office, how has it been? Did anything break while I was away?

Not only did nothing break, my boss was so bored that he’s been bothering the office manager and taking extra days off. I should probably investigate and find out what his deal is, but first I have a burning question.

What cars sell quickly on the used car market in Victoria, and what do they sell for?

This info is available through UsedVictoria – kind of. They have an RSS feed. So you can enter some search terms and they’ll show you the last 25 items posted with those criteria. You can’t page through the results, so that doesn’t give me any historical data. Any info I gather will start from today. But I can scrape the feed and save it in my own database, and graph it later once I have a body of data. Ok, here we go.

What’s going on: we ask UsedVic’s server for all the car ads they have with the following criteria: private sales only, priced between $400 and $6000. This returns a few hundred results, but the RSS feed will only give us 25. Oh well. I save each item in my database – the title, description, search criteria, date it was posted, and price.

The price, mind you, is in no way accurate. When I buy a car on UsedVic, I haggle. People who buy from me usually try to haggle as well. So the actual selling price is likely a couple hundred lower than what’s listed, in most cases. However, it does give you a little information. The listed price is the starting point of negotiation, so people generally won’t go see a car unless the listed price is at least in the realm of reality and their budget. If someone has set the price of a vehicle unrealistically high, the car will sit on the market for a long time.

This happened in the case of a rather spectacular Suzuki DRZ400SM that was posted last winter. It had several fancy racing upgrades, combined with an expensive but utterly tasteless metallic pink paint job. If I could have had that bike for $2000, I would have done so in a second even it was covered in swastikas and cocks. Paint is cheap. But the guy wanted $6500 for it, and the ad stayed up for something like 3-4 months. (Ask me how I know. Yes, I was checking every week. I have a problem. Don’t worry about me, mow your own lawn.)

So how to deal with the fact that we only get 25 items returned? Easy – check back every 2 hours. Usually 2-6 items are posted per hour. So I add a check to see if each item is already in my database, and if it isn’t, add it. This code is kind of inefficient. If any of the real programming nerds get hold of it, I will be embarrassed. But it’s good enough for my purposes, for now, probably.

So I wrote a cronjob to run this every 2 hours and report back to me when it’s done. Okay, cool.

Now how do we track items that are sold? It’s tough to count something that isn’t there. Not too tough though. More code:

You can also search for an ad using the exact title, and you’ll generally get back only that one exact result. Since I have the titles saved, I can do that. In my database, I have a column labelled “sold”. When the item is entered, that column is set to false.

This script gets a list of all items in my database that have “sold” set as false, and searches for them. If an item is not found, “sold” gets set to true, and the current date is recorded as well.

Listings expire after thirty days, which should help keep this script from getting out of control as it hits the UsedVictoria servers over and over again. After a few weeks, I’ll have hundreds of unsold listings in my database, and once a day, the script will request every single one of them. I may end up blocked by UsedVic pretty soon if the numbers get too high. But no worries for now.

Finally, I want the data in a manageable, bite-sized format. You can see the results at rocketships.ca/srs/scraper.

The table lists all cars that were posted and sold within the last thirty days, the number of days each was on the market, and the price requested. It’s still not as fine grained as I would like, but I think this will give me at least a vague answer to my question – which cars are hot in Victoria?

My theory: Miatas. I await hard data.

Next step is to decide what to do with the data. I had an idea about buying cars from the mainland, where they’re a bit cheaper, and flipping them locally. I feel like I could make a small profit doing this. However, to make it worth my time, I need a profit of at least $300 – that’s what I pay myself for working on the weekends.

So let’s say I bought a 1990 Miata for $1800 on the mainland and sold it for $2300 here. Those numbers are realistic, based on my experience to date.

I have to go the mainland ($18 there, $74 back), get my pedestrian ass to the seller’s house somehow (unless they’re kind enough to meet me at the ferry), check the car to make sure it isn’t shit (Honestly, what do I know? Not much, man. I’m a writer, not a mechanic.), and then the really fun part – figuring out insurance.

If I transfer my own car insurance to the new car, I will have to pay GST on the car. 12% of 1800 is $216. Big chunk of my profit gone right there. I can maybe get a temp permit, which is only $30 or so, but then I really have to get home smartly on the next boat, I don’t get to joyride the car while I’m waiting for a seller, and I can’t allow buyers to take a test drive. The insurance costs some money, so does registration, so does the plate if I haven’t organized that properly, and you have to pay a fee if you insure for less than a full year or if you want to pay monthly. Costs maybe $1200 for the full year? depending on the car and whether my points have expired yet.

There are ways around these issues, namely, lyin’ and breakin’ the law. I’ve bought and sold something like 20 vehicles over the years, and I will not claim perfect observance of the rules. But any business plan that relies on illegal behaviour is a bad idea, and out of the question according to my principles.

So out of $500 profit, I might get to keep $300, legally. But that’s not the main issue. You can only get away with buying and selling a certain number of cars per year before the government starts to get suspicious. I think it might be around 6. After that you have to get a dealer’s license, which is ex$pen$$ive. I’m not really prepared to go down that road – messing around with cars is alright for a hobby, but used car salesmen are considered the scum of the earth by most humans, and for good reasons. So I would have to find a way to respect myself for doing it, first. My friend Dylan does it by specializing in high end racecars. My friend Ben doesn’t do used cars – he’s an honest to god legit new car salesman who provides warranties. But there are others who are pretty slimy.

With that problem unsolved, I have made the data and the code publicly available. Enjoy.

How To Sell A Car

cherry blossoms toyota corona

Here’s how you sell a car. Pictures, pictures, pictures. But first, wash it. A clean car is magically worth $200 more than a dirty one, and you have a chance to sell it to people walking past your yard while you’re at it. As soon as the car is clean, you can start hustling to everyone you meet.

Then go somewhere picturesque on a sunny day. Take 10,000 photographs from every angle, distance, and vantage point you can think of. Get three of each shot. Sit in the driver’s seat and think about how much you love it. Shoot like you’re doing nudes of your lover who’s moving to the mainland without you.

apollo prestige road bike mount tolmie
Apollo Prestige at Mt Tolmie.

Favourite places of mine include:

  • The top of Mt Tolmie or Mt Doug
  • The oceanfront in Esquimalt
  • The Navy base also in Esquimalt
  • The lookout at the top of the Malahat
  • The middle of View St when the cherry blossoms are blooming
  • The middle of Blenkinsop road in late summer
  • The top of the mountain behind Interurban Campus
  • Saxe Point, Cattle Point, Beacon Hill Park

If the sun won’t cooperate, try an underground parking garage. Saturate the colours of the car and make the grey background greyer. Note: this only seems to work with Japanese and German vehicles. American cars must be photographed outside.

lexus sc400 interior shot
Lexus SC400 – An example of an informational, rather than a glamour shot.

If you’re lucky there’ll be curious passers-by, and if you’re more outgoing than I am, it’s another chance to hustle, hustle, hustle. But if that doesn’t work out, still make sure you get tons of pictures. The only difference between a photographer and an ordinary jackass with a point-and-shoot is thousands of discarded shots. Get the sexy glamour shots, and also get high-definition informational shots of the engine, interior and any damaged body work. Always shoot with the light behind you when you do informational shots, and make sure your shadow doesn’t fall across the thing you’re shooting.

Then open all your shots in Photoshop (Gimp if you’re poor and honest) and brutally discard the lousy ones. Leave your ego in your other jacket. This isn’t moderne arte, you’re just selling a car. Play with the levels, make the colours pop. Crop everything but the vehicle out of the shot. Narrow it down to 4 shots. More than that and you look like a tryhard.

red toyota corolla ae86 mount tolmie
Toyota Corolla at Mt Tolmie.

Finally, post it. If it’s a motorcycle, bicycle, or convertible, wait until a sunny day. If it’s 4wd and winter, consider waiting for a snowy day, but don’t wait forever.

In the ad, don’t tell your life story. No one likes reading. If the car has a good story behind it, tell it in one sentence or less in the first line of the ad, then get on with business. List the things that are new and good on the car. List the things that are broken. Don’t say why you’re selling – if you’re asked, “I need the money.” That’s the only good reason. Put the price you want, don’t play games like overpricing to leave room for negotiating.

honda silverwing gorge park
Honda Silverwing in Gorge Park.

A note about Craigslist – depending on your area, it’s not always the best option. In Victoria, everyone uses UsedVictoria.com. Ontario uses Kijiji, Australia has Gumtree.

 Look at the other ads in the same category. If someone is selling the exact same car as you at the exact same price, maybe knock 5 bucks off. Then sit back and wait for the emails.

kawasaki KZ305 esquimalt
KZ305 LTD in Esquimalt.

All the vehicles featured in this post are ones I’ve owned, loved, and sold. The better pictures were taken by more skilled photographers than myself. In the case of the Silverwing I actually hired a photographer to shoot the bike for me, since I didn’t have adequate equipment at the time.

dodge dakota victoria bc
My big brother’s Dodge Dakota in downtown Victoria.