The side of the house can be good, so long as it's not the north side. A few roses will grow in shade but none will bloom well. Also, try not to plant too close to the house, underneath the eaves can be too dry unless the rose gets supplemental water from the downspout.
Sand can be difficult for many roses. I'd recommend making up nearly 1/3 the soil with good mulch or some other organic material (coir, compost, etc.) and adding a few cups of clay (cat litter) Then mulch the top of the soil so it retains water in hot, sunny weather.
