Queen Size Mattress or Bed (Middlefield & San Antonio Road)

I'm looking for a queen size mattress or bed, and prefer something that really sinks in on the softer side, but dissipates heat, and doesn't get too hot.