SELECT i.*, t.tipologia, l.localita FROM immobili AS i, tipologia AS t, localita AS l WHERE t.id = i.tipologia AND l.id = i.localita AND i.id = '114'